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
483 reads
Blog Posts
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
483 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
12 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,139 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
666 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
994 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
759 reads
Wrapping Up the 2013 PASS Election–Part 1
Yesterday the results were announced, with Jen Stirrup, Tim Ford, and Amy Lewis winning seats for the two year term...
2013-10-03
392 reads
A Tainted PASS Elections
Another PASS Board of Directors election cycle has come and gone, and with the results now announced I'd like to...
2013-10-02
845 reads
DevConnections Deck & Demos Live!
Hello Dear Reader! Just a quick blog today. The Deck and Demo’s for my Presentations today at SQL DevConnections are...
2013-10-02
520 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers