Azure SQL Database – TDE

I work in the financial space so you can imagine that security is quite high on the agenda. TDE (Transparent...

PASS Speaker Idol 2016 – Todd Kleinhans

I am grateful and thankful I got selected to speak again at Speaker Idol. It has been a crazy and...

SQL Server 2016 Query Store - Gentle Introduction - 1

Query Store is perhaps one of the path breaking features to release in SQL Server 2016. This post will give...

Fixing non-deterministic error when creating indexed view

I discovered a bit of info on working with float values, while creating a hash value that contained a float...

Fixing non-deterministic error when creating indexed view

I discovered a bit of info on working with float values, while creating a hash value that contained a float...

Step by Step: WHERE, GROUP BY, and HAVING

People new to SQL often have trouble with the difference between WHERE, GROUP BY, and HAVING…three separate clauses in the...

Back for a Day

I hope everyone is well in Florida, but the hurricane caused a postponement of SQL Saturday Orlando. Fortunately I caught...

SQL Performance Dashboards – update

SQL Server Performance Dashboards – update The first article that I ever wrote (http://www.sqlservercentral.com/articles/SQL+Server/127992/) was last year where I wanted to...

Networking Dinner at the 2016 PASS Summit

Steve Jones & I are organizing our 7th annual networking dinner on Monday night, October 24th in Seattle. We’re changing the...

Synchronizing NOT NULL Columns

Applies to: xSQL Schema Compare v7.0.0 – v 9.0.0, xSQL Data
Compare v7.0.0 – v9.0.0

Description: Using
xSQL Schema Compare and xSQL Data Compare to keep the tables of two databases
in sync...