Category Archives: #DBA

Mission Critical Performance Enhancements in SQL Server 2014 on

Microsoft has three major feature sets that they are advancing with SQL Server 2014 (SQL2014). One is called “Mission Critical Performance.” Microsoft wants to stake out this ground not only as performance enhancements in the relational engine, but also those features which support better data availability, performance, security, and data integration. Read the rest of my article at…(read more)

SQL Server 2014 Overview on

Haven’t upgraded late? Well, SQL Server 2014 is a great place to start! Perhaps this is your first time reading my column on or you don’t know much about SQL Server. If either of those are true, then it might be a surprise to you that Microsoft has accelerated the release cadence for SQL Server to around one new release every 18 to 24 months. Add in the fact that Microsoft goes to market with their beta releases, better known as Community Technology Preview (CTPs), several months before…(read more)

Third Party Applications and Other Acts of Violence Against Your SQL Server

I just got finished reading a great blog post from my buddy, Thomas LaRock ( t | b ), in which he describes a useful personal policy he used to track changes made to his SQL Servers when installing third-party products. Note that I’m talking about line-of-business applications here – your inventory management systems and help desk ticketing apps. I’m not talking about monitoring and tuning applications since they, by their very nature, need a different sort of access to your back-end server resources….(read more)

You Need a DBA

This post was inspired by a recent conversation with a DBA followed by reading The Curse of Relational Databases (especially the comments) posted at Grant Fritchey ’s SQL Server Central blog . I have two points to make: As of mid-2014 a physical person is required to properly administer a production relational database instance. The title of this post (and the second phrase of item 1) is a lie. You need two DBA’s (at least). You need two DBA’s in case your first DBA becomes unavailable. Having a…(read more)

Top 10 DBA Mistakes on SQL Server. (Now with Prizes for Participation!)

Microsoft SQL Server is easier to administrate than any other relational database on the market. But “easier than everyone else” doesn’t mean it’s easy. And it doesn’t mean that database administration on SQL Server is problem free. And since SQL Server is constantly growing from small, home-grown applications, many IT professionals end up encountering issues that others had tackled and solved years ago. Why not learn from those who first blazed the trails of database administration, so that we don’t make the same mistakes over and over again. In fact, wouldn’t you like to learn about those mistakes before they ever happen? Watch the video to learn more!…(read more)

Amazingly Useful SQL Server Articles on

Ever wonder which specific T-SQL pattern is best for splitting strings? There are lots of ways to calculate running totals, but which is optimal? What CPUs are best for SQL Server 2012? For SQL Server 2014? Find out more in this post from Kevin Kline….(read more)

Join Me on March 14 in Silicon Valley for a Full-Day of SQL Server Configuration Tuning Lessons

The secret ingredient in this full day seminar is using the benchmarking and load testing tools to visually see the performance impact of the various configuration choices that Kevin illustrates throughout the course….(read more)

Updated File & Wait Statistics Procedures

For many years I have been using a set of stored procedures to capture and report on both the file and wait statistics inside of SQL Server and I just recently did some minor modifications that I want others to be aware of. Since many of you have received copies of the past revisions via conferences or articles and such I would recommend taking a look at the newly modified ones as well. Most of the changes come in the form of optional parameters but three of them may not be drop in compatible and…(read more)

What Does a Good Mentor Do for You?

These would be good mentors – me plus Adam Machanic, and Klaus Aschenbrenner Not long ago, John Sansom ( Twitter | Blog ) kicked off a SQL Community Project #DBAJumpStart by asking 20 successful and experienced SQL Server professionals this exact question: “If you could give a DBA just one piece of advice, what would it be?” I wrote up my Advice for the Aspiring DBA post here , while John collected the entire set of responses here within the DBA JumpStart collection. Part of my advice, indeed of…(read more)