I’m Speaking at SQL Saturday #190 in Denver
One of my sessions was accepted for SQL Saturday #190 in Denver this year. Please come see my CTE presentation. Common Table Expressions –… Read More »I’m Speaking at SQL Saturday #190 in Denver
SQL Server Technical Debt
As Beta 7 of the Database Health Reports approaches is just three weeks, the big new feature that has been added is the SQL Technical… Read More »SQL Server Technical Debt
SQL Sunday Fun – Word Search with SQL Server Keywords
The following SQL Server keywords are hidden in the word search puzzle. Find them all! ALTER BETWEEN CLUSTERED COLUMN COMMIT CREATE DATABASE DEFAULT ELSE END… Read More »SQL Sunday Fun – Word Search with SQL Server Keywords
What is a Common Table Expression – Video
Related Common Table Expression Links Sample Database for Common Table Expressions Writing Your First Common Table Expression with SQL Server Video: Writing Your First… Read More »What is a Common Table Expression – Video
One Thousandth Download of Database Health Reports
Today marks the 1000th download of the Database Health Reports in the last 11 months since Beta 1 was released. I thought this would be… Read More »One Thousandth Download of Database Health Reports
Trust Me I’m An Engineer
Nice shirt I discovered at Amazon.com
SQL Server Crossword Puzzle
Across 2. Management Studio 5. The database that is used as a template when creating a new database 6. Using a backup 7. Reporting Services… Read More »SQL Server Crossword Puzzle
Enabling Transparent Data Encryption on SQL Server 2014
To start with for Transparent Data Encyrption (TDE) we will need to be using Enterprise (or Developer) edition of SQL Server 2014. I am using… Read More »Enabling Transparent Data Encryption on SQL Server 2014
What is Hekaton
Hekaton is also known as SQL Server In-Memory database, touted to accelerate transaction throughput up to 30x performance increases on existing hardware. With a new latch-free… Read More »What is Hekaton
Working on the T-SQL Technical Debt feature in the Database Health Reports
As part of my contribution back to the SQL Server community I am adding a new feature into the free Database Health Reports application. I am currently… Read More »Working on the T-SQL Technical Debt feature in the Database Health Reports