Staff Contributor 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)?
Naming conventions are a very subjective thing, of course. Just like coding styles, they can often lead to anything from minor debates to full-blown religious arguments. Upper case vs. lower case keywords, tabs vs. spaces, and where to put commas come to mind. Heck, these same people even get into sub-arguments about whether the terms “upper … Read more Subjectivity: Naming Standards
Recently I have spoken with a number of people about the key things that they monitor when it comes to SQL Server, with the key metrics CPU, Memory, and I/O mentioned. Some others set up alerts for specific errors or severity of errors, however one thing that comes up very rarely is monitoring for Suspect … Read more Monitoring for Suspect Pages
Let’s forget about performance for a moment, or even user-facing processes at all. A lot of tasks are admin-related and require at least the concept of looping, if not an explicit loop or cursor (or multiple). Think about how you would do these things in T-SQL otherwise: The search ultimately needs to check every string column in … Read more 4 Practical Use Cases for Grouped Concatenation
What Prompted This Post? As lots of you know already, Kevin Kline has joined us here at SQL Sentry. I’ve followed Kevin myself for a good while, so I’m really excited to have him here with us. One of the first things Kevin asked of me was to list the top 5 technical issues we … Read more The Top 5 Most Common SQL Server Performance Problems