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
485 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
494 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
14 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
668 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
761 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
852 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
523 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
advice on ssrs version control
Hi we're a bit behind on versioning ssrs. I think we have over 1600...
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers