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...]

PASS Summit 2018 Day Two Keynote—Two Decades of Data Innovation with Raghu Ramakrishnan

Kevin Kline shares highlights from the PASS Summit 2018 keynote with Raghu Ramakrishnan. Click HERE to read more … [Read more...]

PASS Summit 2018 Day One Keynote—SQL Server and Azure Data Services with Rohan Kumar

Kevin Kline shares highlights from Rohan Kumar's PASS Summit 2018 keynote, "SQL Server and Azure Data Services: Harness the future with the ultimate hybrid platform for data and AI." Click HERE to read more … [Read more...]