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
722 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
595 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
946 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
484 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
486 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
13 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,141 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
667 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
997 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
760 reads
Blogs
Excellent article on securing msdb
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
T-SQL Tuesday #201: Temp Tables
By Steve Jones
This month we have a new host, which I am grateful for. So many...
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than...
Forums
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers