Enterprise wide Backup Audit
Enterprise wide Backup Audit that produces backup information in a csv format.
2010-08-06 (first published: 2009-11-10)
1,848 reads
Scripts
2010-08-05 (first published: 2009-11-25)
7,372 reads
Find botched constraints, idxs, fks
Shows awesome view of columns with constraints and indexes and foreign keys to spot errors fast.
2010-08-04 (first published: 2009-12-03)
1,495 reads
2010-07-27 (first published: 2010-07-09)
2,192 reads
Custom Logging in a transaction
Ever happened that your custom log got rolled back and you were left with nothing but an error_message()?
Try to log into a table variable.
2010-07-22 (first published: 2010-06-30)
1,184 reads
2010-07-20 (first published: 2010-06-23)
2,631 reads
2010-07-19 (first published: 2009-11-16)
2,584 reads
2010-07-15 (first published: 2010-06-16)
1,938 reads
Parsing / breaking character separated values in a table in one query
At times, we have situation to parse the character separated string in the table column.
2010-07-14 (first published: 2010-06-17)
2,255 reads
2010-07-08 (first published: 2010-06-17)
1,454 reads
Blogs
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
Forums
SQL Server 2025 Server-level Roles
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
Stairway to DAX and Power BI - Level 29: The DAX Combine & Aggregate Functions
Comments posted to this topic are about the item Stairway to DAX and Power...
AI Is Improving Security
Comments posted to this topic are about the item AI Is Improving Security
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers