Querying the Management Data Warehouse for Disk Usage over time (Data Collector)
A part of every DBA’s job is to justify all those disk space requests. The phrases “I just need it”...
2012-08-13
544 reads
High Availability Lingo
You have got to love the way the SQL Server team change the lingo in all of their high availability...
2012-08-13
1,129 reads
SQL Audit 301 – Using Powershell to Manage Audits
Today we’re going to go over some very basic scripts to create, drop, and copy SQL Audit objects using Powershell...
2012-08-20 (first published: 2012-08-13)
3,229 reads
Schedule Announced for SQLSaturday #151 in Orlando
We had 45 speakers submit sessions this year. Sticking to our tradition here in Orlando, we accepted as many speakers...
2012-08-13
351 reads
Audit Yourself Regularly
Around April this year, my men's accountability group was talking about a shared pain: income taxes. We were all worried...
2012-08-13
1,716 reads
Bloggers–Don’t Make It Hard to Comment
Lately I’ve hit a couple blogs that wanted me to enter some kind of credentials before I could post a...
2012-08-13
379 reads
Database Corruption, Transparent Data Encryption, and Trace Flag 5004
This one comes straight from the email bag. A friend recently had a problem, they were placing TDE on a...
2012-08-17 (first published: 2012-08-13)
5,752 reads
Find AD user detail - PowerShell Script
I developed the below script to find the details of a AD user and the AD groups he is associated...
2012-08-13
7,923 reads
Find Members of AD Group - PowerShell Script
This is one of the powershell script I have been using quite regularly from the day I developed. Most of SQL...
2012-08-13
2,166 reads
Monitor Deadlock in SQL 2012
Do you still use trace flag 1204 and 1222 to monitor Deadlock? or using profile to capture deadlock? Now we...
2012-08-16 (first published: 2012-08-12)
18,090 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Trigger isn't working
Hi, I have a trigger, that works fine elsewhere but is not working at...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers