How Can the SQL Server Resource Governor Help You?

MANAGING ‘NOISY NEIGHBORS’ IN SQL SERVER If you've been managing databases for any length of time, you've probably had to contend with the "noisy neighbors" scenario. In this scenario, you have several applications, each with their own database residing on a single instance of SQL Server, which don't share the resources of the server nicely. To deal with this issue, you might want to investigate Resource Governor as an alternative. READ MORE... Originally Posted in DBTA Magazine in June 09, 2015 … [Read more...]

My Best Blog Posts from 2015

ALWAYS LEARNING About mid-way into August of 2015, I learned some important new factors in Search Engine Optimization (SEO) that caused me to make some big changes to the way in which I blogged. Namely - simply reposting a slight variant of a given blog post could hurt your overall SEO rankings for any of the given posts. Now you might be saying to me "Kevin, those aren't new factors. They've been around for a long time, you idgit". And I would say in response "Ok then. But I had other things on my mind". (Of course, if you have other recommendations for improving one's blog performance, … [Read more...]

DBTA – StretchDB, a Cool New Feature in vNext SQL Server

Originally appearing in my monthly column at Database Trends & Applications magazine. When it comes to cloud-based database management, there are really only two players: Amazon, the value leader, and Microsoft, the innovation leader. Amazon has carved out a niche as the value leader in cloud-based database management, supporting not only its own implementations of various database platforms such as MySQL and Hadoop, but also supporting premier commercial DBMSs such as Microsoft SQL Server and Oracle. Meanwhile, Microsoft has, in my mind, carved out a very strong niche as the innovation … [Read more...]

DBTA – IT Employers Must Adapt to the Looming DBA Shortage

Originally appearing in my monthly column at Database Trends & Applications magazine. In the first of this three-part series, I described some of the findings contained in an intriguing new survey published by Unisphere Research, a division of Information Today, Inc. In that article, I covered the macroeconomic and general trends that pointed to a looming shortage of DBA talent. In part 2 of the series, I described some of the issues and opportunities these trends offer to current and up-and-coming DBAs. Today, let’s talk about what this trend means from perspective of IT … [Read more...]

DBTA – Does the Looming Shortage in DBAs Spell Opportunity?

Originally appearing in my monthly column at Database Trends & Applications magazine. In my last column, available HERE, I described some of the findings contained in an intriguing new survey sponsored by Ntirety, a remote database administration service provider, and published by Unisphere Research. You can read the full survey with analysis at HERE. One of the most startling and significant responses in the survey showed that 41% of data professionals intend to leave the field within the next 10 years. In that article, I also covered some of the broader industry growth and hiring … [Read more...]

DBTA – Delayed Durability—The SQL Server 2014 Transaction Log Hack!

Originally appearing in my monthly column at Database Trends & Applications magazine. Delayed durability was announced late in the SQL Server 2014 development cycle, but offers something that many SQL Server professionals have wanted for years—the ability to disable transaction logging. Why turn off the transaction log? It is the main guarantor of transactional consistency in SQL Server and is critical for highly recoverable applications, after all. That answer, in itself, tells you about situations where you might like to turn off the transaction log. That is, you can accelerate … [Read more...]

DBTA – For #SQLFamily, a Most Wonderful Time of the Year!

Originally appearing in my monthly column at Database Trends & Applications magazine. It’s the holiday season, a time for cheer and goodwill towards men. That got me thinking about the whole “most wonderful time of the year” tune playing in the background and how that has some special implications for the SQL Server world. Here’s a bit of context: I'm writing this article for you in the midst of the biggest gathering of SQL Server professions in any given year, the PASS Summit. One of the most visible activities when attendees get together for the very first time at the registration … [Read more...]