This month I am asking you to not only write a post but to do a little homework – first. In other words, plan to do something, carry out that plan, and then write about the experience.
T-SQL Tuesday #081: Sharpen Something
Category: SSC
You Deserve to be an MVP
When you feel you deserve to be an MVP, are you prepared to do more work? Being an MVP is not just an award – it is a commitment to do more for the community!
Another Query to Help Find the Right Event
Finding the right event or combination of events to monitor may seem like quite a daunting task with so many events to explore and (frequently) too little familiarity with Extended Events.
Extended Event Help Queries
When working with Extended Events, there are times when a little more information is, well, helpful. You know you want to use extended events to try and monitor for a specific thing to happen.
SQL Server CTE – Back to Basics
Of all the fundamental concepts within SQL Server, this one drives me a bit batty from time to time. Think about that statement for just a moment.
SQL Server Desired Enhancements
SQL Server 2016 has come with a ton of cool features, bells, whistles and well cool stuff (yes redundant). That aside, what are some of the really cool features that I would love to see in SQL Server?
Awesome SQL Server Feature
There are a lot of cool features in SQL Server that ROCK! It is really hard to pick just one with so many cool features that can make life much easier as a DBA.
SQL Server Select – Back to Basics
Of all the fundamental concepts within SQL Server, nothing is potentially more basic and fundamental than the often overlooked Select statement.
SQL Agent Job Schedules
SQL Agent job schedules should be easy to read for humans if for nothing else than the fact that you have to provide this information to the auditors from time to time.
Index Cannot Be Reorganized…
Working diligently as any good DBA might, you have established maintenance routines for each of the SQL Servers under your purview. Then a small problem occurs: Index Cannot Be Reorganized…