(Jason Brimhall) Quality data is a goal we all strive to attain. Nobody wants to have bad data. Yet, despite our best efforts, the problem of bad data has its way of presenting itself over and over again.

(Erin Stellato) I have been making the same recommendations about tempdb since I started working with SQL Server over 15 years ago, when I was working with customers running version 2000.

(Pinal Dave) Some questions never got old and today’s we are going to discuss a similar question which was asked to me during Comprehensive Database Performance Health Check. The question was about how to swap column values in a table.

(Jack Vamvas) To get the total table count of all databases in either one or more SQL Server Instances use this powershell script.

(Denny Cherry) We’ve been using Azure for several years now at DCAC. Back when we started in Azure their were no PaaS services for MySQL (there was but it was stupid expensive, and from a third party).

(Greg Robidoux) One design aspect that all tables should have is a primary key. The primary key is the main entry way into your dataset, so that when you access your data you are guaranteed to only affect one row of data.

(blobeater) Quite a simple requirement (when I needed it a few months ago). Study my Azure SQL database environment below.

(Rajendra Gupta) SQL Server Always On Availability Groups provides HADR solutions for the SQL databases. Here HA refers to high availability and DR refers to disaster recovery.

(Gregory Larsen) Suppose you are a new DBA in an environment. You are tasked with restoring a database, but you don’t have a single clue as to what is in any of the database backup files.

(Pinal Dave) Some concepts are so good in SQL Server, they keep on coming back to me one way or another way. After reading my recent blog posts about DBCC DROPCLEANBUFFERS lots of people wanted to see the demonstration of the same.