Understanding Triggers
A trigger is a specialized stored procedure that activates (executes) in response to an event. There are two basic trigger...
2013-12-14
701 reads
Blog Posts
Android Annoyances
I wrote last week that I had switched back from Android to iOS, but I didn’t list out specific gripes...
2013-12-13
893 reads
Don’t Bring a Tank to a Prison Fight – #TSQL2SDAY #49
A couple of weeks ago I gave you some scripts to collect wait stats from your SQL Server instance over...
2013-12-13 (first published: 2013-12-10)
2,344 reads
Enabling High Performance Power Plan via PowerShell
One of the projects I’ve been working on recently was to automate our production SQL Server installs including our standard...
2013-12-13
1,967 reads
Friday Followup For December 13, 2013
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2013-12-13
463 reads
Keeping Up With Training: Day 5
Let's keep this talk going about what you can do. We know I'm rather big on user groups and SQL...
2013-12-13
447 reads
Reblog: December 6 to December 12
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-12-13
487 reads
Testing labs
What sort of testing lab do you setup when you're testing things out? I hear see the world adventureworks almost...
2013-12-13 (first published: 2013-12-03)
1,265 reads
Exploring Excel 2013 for BI Tip #12: Icon Sets
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2013-12-12 (first published: 2013-12-03)
2,353 reads
Power BI for Office 365 FAQ
As I have been giving demos on Power BI for Office 365, I have received a tremendous amount of positive feedback,...
2013-12-12
1,798 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers