Query tuning is often the fastest way to accelerate SQL Server performance. Most often system-level server performance (memory, processors, and so on) improvement measures are ineffective and expensive. Expert developers believe most performance issues can be traced to poorly written queries & inefficient indexing, not hardware constraints. In fact, some performance issues can only be … Read more SQL Server Performance Tuning Tips
A Database Administrator (DBA) is like a racecar technician. Building and optimizing a high-performance vehicle requires minuscule fine-tuning and attention to detail. A tweak here and an adjustment there could shave just a fraction of a second from your lap time. Of course, that fraction of a second could determine whether you win or lose … Read more SQL and Database Performance Tuning Guide and Checklist: Expert Tips
Whether you are preparing to enter the job market for the first time, or have been working for the majority of your life, now is an excellent time to begin a career as an IT professional. The tech market has been booming over the past few decades and shows no signs of slowing down with … Read more How to Get an IT Job: Succeeding in Your IT Career
Networks are growing in size and complexity. For many, this growth is being driven by the Internet of Things (IoT), mobile, Cloud, and even Software Defined Networking (SDN). As these trends, and the many changes they bring, impact your network, the big question you need to answer is this: Do I have the network configuration … Read more Best Free Network Configuration and Change Management Tools
Digital Experience Monitoring (DEM) is so business critical that it’s featured in a Gartner magic quadrant. At the same time, it is so new that even Wikipedia does not know what it is. (related read: What is Digital Experience Monitoring (and Why Should You Care)? Why is that? Monitoring as a practice is as old as dirt, … Read more The Evolution of the Web and Digital Experience Monitoring
Looking for an updated list of technology events? Check out our latest blog on virtual tech conferences to attend for 2022! Are you looking for the best conferences or events to attend to learn what’s new in the IT world? We’ve put together the top conferences and organized them according to topic to help you … Read more Best Tech Conferences for IT Professionals
Cisco Live is always a great place to check in on the latest developments in the networking world, and this year was no exception. There were 27,000 attendees and no shortage of booths, demonstrations, talks, and presentations from which to learn. If you were unable to attend, or just didn’t get to everything, here are … Read more Top 5 Developments at Cisco Live
People using our services would be very familiar with our basic HTTP Uptime check by now. After all, it’s our most used feature. Something a lot of our users might not know is that you can make the HTTP checks more advanced by using the Optional settings of the check. You find these settings under … Read more Make the most of your HTTP check: best practice for optional settings
You probably know someone with trust issues, but do you know if your database has trust issues? In other words, does your database have Check Constraints and Foreign Keys that are not trusted? If so, it’s important to realize that SQL Server may not be able to use them for query plans and optimization, which … Read more Does Your Database Have Trust Issues?
In a recent blog post entitled Is Logical Data Modeling Dead?, Karen Lopez (b | t) comments on the trends in the data modeling discipline and shares her own processes and preferences for logical data modeling (LDM). Her key point is that LDMs are on the decline primarily because they (and their creators) have failed to adapt to changing development … Read more What Happened to Logical Data Models (LDM)?