Query to Email….Well Formatted Email
When I get alerts from SQL Server I want it to do three things for me. Tell me what’s wrong, show me the data, then tell me how to...
2025-04-10
88 reads
Simple SQL Server
Powershell, when were my servers rebooted?
One of my servers wasn’t rebooted when it should have been and I never realized it until after the outage...
2016-06-01
510 reads
Powershell, when were my servers rebooted?
One of my servers wasn’t rebooted when it should have been and I never realized it until after the outage was over. The big deal wasn’t that it didn’t...
2016-06-01
48 reads
File Growths
I hinted at file growths in my previous posts about shrinking data and log files. Then I talked about growing...
2016-04-11 (first published: 2016-03-29)
1,842 reads
File Growths
I hinted at file growths in my previous posts about shrinking data and log files. Then I talked about growing log files in my post Database Log VLFs. However,...
2016-03-29
15 reads
Database Growth Trends – Idera Diagnostic Manager
How fast are your databases growing? Should I panic about a 1 TB database that has 100 GB free on...
2016-03-21
643 reads
Database Growth Trends – Idera Diagnostic Manager
How fast are your databases growing? Should I panic about a 1 TB database that has 100 GB free on disk? Am I safe with a 100 GB database...
2016-03-21
14 reads
Multiserver Queries
You can run queries against multiple servers at once, and it’s quite useful for a number of reasons. I use...
2016-03-14
708 reads
Multiserver Queries
Setting up registered servers and practical uses of multiserver queries in SSMS.
2016-03-14
13 reads
Recompile Monitoring using XEvents
Recompiles can be a hidden bottleneck on your server, and it may not be too obvious. I should know, it...
2016-03-17 (first published: 2016-03-07)
1,630 reads
Blogs
Starting Points for Quantum Computing Learning
By Brian Kelley
I didn't have these in my slides for the Techno Security & Digital Forensics...
SSMS 21 Fixes Irritating Problem
I have a proper blog post coming out tomorrow for T-SQL Tuesday, but today,...
Monday Monitor Tips: Customizing Data Retention
By Steve Jones
One of the biggest challenges with monitoring data is managing the volume over time....
Forums
Window Functions in a View
Is there a trick to get a where clause filter to push into a...
Modifying the fetch size for Linked Server
Hi, Problem: Pulling several million row table from Oracle DB into SQL server via...
How do I add all the values in the column considering it to be in hh:mm:ss:ms
How do I add all the values in the column considering it to be...
Question of the Day
Adding Lots of Dates
The second parameter for the EOMONTH() function is an integer. In June 2025, if I run this code, what is returned?
DECLARE @d DATE = GETDATE() SELECT EOMONTH(@d, 95695)See possible answers