DBTA – The Top 10 Mistakes Made by SQL Server DBAs

The SQL Server world has its own set of challenges when it comes to database administration. One of the biggest challenges is that there are never enough skilled DBAs. Consequently, many people who are not true DBAs are pressed into service, perhaps a Windows SysAdmin or the lead developer on an application using a SQL Server back end, so-called "accidental DBAs." That means that people doing DBA work on SQL Server frequently do not know the fundamental technical details or the processes and practices commonly used by experienced enterprise DBAs. What are the Top 10 Mistakes of SQL Server … [Read more...]

Data Pro, What’s Your Groundhog Day Flashback?

Kevin Kline asks data pros what their Groundhog Day moments are--the things in their career as a data professional that keep popping up over and over again, like a bad dream. Click HERE to read more … [Read more...]

DBTA – Managing ‘Noisy Neighbors’ in SQL Server 2014

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. Click HERE to read more … [Read more...]

Top 7 Things Every DBA Should Do Before They Go On Holiday

MS MVP Kevin Kline walks through two ways to prepare for a peaceful and uninterrupted holiday: technology and process. Click HERE to read more … [Read more...]

DBTA – Cool Features of SQL Server 2014: Improved Cardinality Estimates

With all the cheerleading and the steady drumbeat of new features being released to Azure, it's easy to lose track of the many cool and valuable new features released in the on-premises version of SQL Server. One of the crown jewels of SQL Server, the cardinality estimator (CE), underwent a large redesign for SQL Server 2014 to improve performance. Cardinality estimates are an extremely important part of query processing. In a nutshell, cardinality estimates are what the relation engine predicts for the number of rows affected by a given operation, including intermediate row sets like those … [Read more...]

Slides and Scripts: Architectural Choices That Impact Performance of Microsoft SQL Server

Want to download the slide deck and T-SQL scripts for the presentation "Architecture Choices that Impact Performance of Microsoft SQL Server?" Get them here! Click HERE to read more. … [Read more...]

SQL Vacation DownUnder 2019!

Together with support of Warwick Rudd and the team at SQLMasters Consulting, I will be appearing at nine events and venues in Australia and New Zealand. Let's meet in person and talk about SQL Server! Click HERE to read more … [Read more...]

Cross-Country Roadshows in the Nordics This Week!

Cross-Country Roadshows in the Nordics This Week! Click HERE to read more … [Read more...]

SentryOne Community Omnibus—December 6, 2018

In his inaugural SentryOne Community Omnibus post, Kevin Kline shares the latest SentryOne webinars, resources, blogs, and press releases. Click HERE to read more … [Read more...]

DBTA – Loads of Data and AI Announcements at Ignite 2018

The 2018 Microsoft Ignite conference was overflowing with attendees this year, as user enthusiasm continues to grow with the advent of CEO Satya Nadella. Click HERE to read more … [Read more...]