MSSQL

You Need Three Heads To Read This Post Properly

You Need Three Heads To Read This Post Properly

I have a handful of things to share today. As a DBA it is my nature to be both driven and lazy so instead of three posts I am just going to combine them into one. You’re welcome. Here’s the first item for you: Recently Grant Fritchey (blog | @gfritchey) wrote an article titled “Be Cautious Offering Guidance”. The point(…)

Administering SQL Server 2012 Running On Windows Server Core

Administering SQL Server 2012 Running On Windows Server Core

Are you afraid of deploying (or supporting) an instance of Windows Server Core? Are you telling others to “stay away” because of your own fears of doing something new? Then I am here to tell you that you’re doing it wrong. Last month I decided that it was time to get down and dirty with(…)

Rebuilding Indexes Will Reset Index Usage Statistics in SQL Server 2012

Rebuilding Indexes Will Reset Index Usage Statistics in SQL Server 2012

We all know that statistics get updated when you rebuild your indexes, right? OK, for those of you that are not aware of such things here is a blog post from Benjamin Nevarez (blog | @BenjaminNevarez) on the topic. He does a great job of explaining the subtle differences involved with various index and statistics(…)

Predictive Analysis: I Bet You Didn’t Know I Would Blog This Today

Predictive Analysis: I Bet You Didn’t Know I Would Blog This Today

Quick question: Where would you go to find some basil in your local grocery store? Did you say “by the other herbs?” Or did you say “by the tomatoes?” If you are like me, then you would go looking for basil by the other herbs because, well, that is a natural, logical grouping of products.(…)

The 3 DBA Mistakes You Don’t Know You Are Making

The 3 DBA Mistakes You Don’t Know You Are Making

You have no idea that what you are not doing is causing you pain. Then again, how could you know this? I mean, if you are not doing it, why would you ever think that your inaction could be the very thing that is causing you heartache every time your phone rings in the middle(…)

Load More