Who Owns SQL Backups?
I was asked by Idera to take a look at the things that could cost a DBA their job. This...
2014-01-10
1,066 reads
Applied SQL: Find and replace using regular expressions in SSMS
Regular expressions are searches on steroids, the wildcats of the wildcard world*. Even if you never ever write CLR, regex...
2014-01-10
1,249 reads
T-SQL – Monitoring DiskSpace of Multiple Servers
This post talks about step by step approach to capture the disk space using T-SQL. This is a request from...
2014-01-10
765 reads
The DBA That Practices Database Restores
We are often told that we need to practice our restores. And it might not be obvious, but the reason...
2014-01-10
433 reads
Reblog: January 3 to January 9
Photo credit – JStove
Old posts are like unicorns. You might see them just once, but it’d sure be nice to have...
2014-01-10
366 reads
The SQLSaturday Wiki–Revisited
I saw a discussion on Twitter yesterday where Kendal Van Dyke referenced the SQLSaturday wiki as a resource, I thought...
2014-01-10
390 reads
Schedule Time To Review Your Passwords & Using a Password Manager
I use a password manager and it currently has more than 150 accounts in it, ranging from my checking account...
2014-01-17 (first published: 2014-01-10)
1,813 reads
SSRS – Identify a scheduled SSRS Report
Initiating subscription is a tedious task in SQL Server Reporting Services. Each subscription in Reporting Services is setup as a...
2014-01-10
696 reads
How To Campaign For the PASS Board
Let’s say you’ve decided to run, good! What do you do next? I’m not going to give you a blueprint...
2014-01-10
393 reads
Friday Followup For January 10, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-01-10
506 reads
Blogs
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
Demo Tracking Dropped Objects
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Randomly Selecting Columns and Rows from a Table or View
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
How Can SQL Server Detect Application Errors When Developers Can’t?
Comments posted to this topic are about the item How Can SQL Server Detect...
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers