The SQL in the City Tour is Almost Here
Five days. That’s how long I’m in Denver after my last trip before I head back to the airport for...
2013-10-04
724 reads
Blog Posts
DevConnections Slides and Code
I had a great time at DevConnections this week, It was a fairly quick trip for me, with lots of...
2013-10-03
596 reads
Does Business Intelligence equal Data Warehousing?
I have seen many times at clients where the terms business intelligence and data warehousing are used interchangeably. In reality, these...
2013-10-03
949 reads
Farewell Tom Clancy
Tom Clancy died yesterday. I’ve been reading his books for a long time and I think I’ve read them all...
2013-10-03
488 reads
Generating a unique identifier outside of SQL and persisting it…
I’ve been thinking about a question from a application developer regarding generating a unique identifier outside of SQL and persisting...
2013-10-03
502 reads
Get The Backup History for Databases
Below is a script that I use to find the backup history for all the databases on a single instance. There is an inline ‘WHERE’ clause that is currently...
2013-10-03
18 reads
MDX+SSRS #31– Query Designer in SSRS only allows the Measures dimension in the first axis
In Chapter 1 of the book MDX with SSAS 2012 Cookbook, in the first recipe “Putting data on x and...
2013-10-03 (first published: 2013-09-28)
4,142 reads
Networking at the PASS Summit: First timers
The PASS Summit is just over a week away, and one again Andy Warren and I are hosting a networking...
2013-10-03
671 reads
SQL Server – Restoring a TDE Encrypted Database to a Different Server
In this article I will show you how to restore a database that is encrypted with Transparent Data Encryption (TDE)...
2013-10-03
998 reads
SQL Server –Encrypting and Securing Native Backups Using Transparent Data Encryption (TDE)
Being part of the database engineering team, we were given a task to setup disaster recovery program for some of...
2013-10-03
762 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers