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
110 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
511 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
49 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
644 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
709 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,634 reads
Blogs
Understanding Zonal Redundancy in Azure SQL MI
By Arun Sirpal
Do you know what happens when you enable zonal redundancy for your SQL managed...
SQL Server Database Compatibility Levels
By Kevin3NF
Why You Shouldn’t Overlook This Quiet but Critical SQL Server Setting If you’ve...
The PASS Summit on Tour in the Netherlands
By Steve Jones
The PASS Summit goes on tour this year, with the final date the first...
Forums
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
Comments posted to this topic are about the item How a Legacy Logic Choked...
Top Quality Boomerang Booth Rental for Corporate Events
Make your corporate events more engaging with a fun twist. Our booths capture energetic...
How do I make this one row per id
I've written this code, but it is showing right now as 2 rows per...
Question of the Day
The Updated Columns List
I have this table in SQL Server 2022:
CREATE TABLE CustomerLarge (CustomerID INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) ) GOIf I check the columns_updated() function return in a trigger, what is the data returned? See possible answers