SQL Server Wait Types Library – UPGRADED!
Have you heard of SQLskills? Have you heard of the waits library? If not then where have you been hiding?...
2017-05-11
362 reads
All About SQL
Extended Events – I am dangerous (sometimes)
I did a dangerous thing, and I want to make sure that YOU DO NOT do the same. I was...
2017-05-09
347 reads
SQL Server Recovering Data via a Hex Editor
I got bored (really bored) one weekend I decided to challenge myself. I had corruption within a specific table (localised...
2017-05-08
404 reads
Comparing Plans via Query Store
A small but nice little feature I have been using recently can be found within Query Store. Let’s say you...
2017-05-04
313 reads
Adaptive Query Processing – Interleaved Execution
A quick blog post to start the day, If you remember a few months ago I blogged about SQL Server...
2017-05-02
477 reads
SQLBits Review
I promised a recap/review on my first SQLBits event so I finally got around to it, hopefully you will find...
2017-04-26
497 reads
Redgate: SQL Search
I seriously finding searching for objects within SQL Server Management Studio (SSMS) via object explorer slow, manual and fiddly especially...
2017-04-25
444 reads
I Escaped from a SQL Server Service Pack Nightmare
I hope you take backups or have a recovery plan in place before a SQL Server service pack upgrade, if...
2017-04-24
352 reads
Getting intimate with Brent Ozar (The First Responder Kit)
Imagine this scenario, you are a database professional at your place of business and you look after a mountain of SQL...
2017-04-12
511 reads
Microsoft Data Platform is changing – so am I
This month’s T-SQL Tuesday entry hosted by Koen Verbeeck (http://sqlkover.com/t-sql-tuesday-89-invitation-the-times-they-are-a-changing/), a blog post about how we feel about the ever...
2017-04-11
316 reads
Blogs
Why Optimize CPU for RDS SQL Server is a game changer
One feature that I have been waiting for years! The new announcement around optimize...
Performance tuning KubeVirt for SQL Server
Following on from my last post about Getting Started With KubeVirt & SQL Server,...
T-SQL Tuesday #193 – A Note to Your Past, and a Warning from Your Future
By DesertDBA
I haven’t posted in a while (well, not here at least since I’ve been...
Forums
Change Tracking – Troubleshooting
I have change tracking configured in several databases, in QA and production environments, and...
is there a no code way to limit an ssis extract from excel to the 1st 21 rows?
is there a no code way to limit an ssis extract from excel to...
Pivot but preserve all rows on Aggregate column
Hello Need help in pivoting this data set, the Pivot takes MIN/MAX on a...
Question of the Day
What is the PRODUCT
In SQL Server 2025, what does this return?
CREATE TABLE Numbers ( n INT) GO INSERT dbo.Numbers ( n ) VALUES (1), (2), (3) GO SELECT PRODUCT(n) FROM dbo.NumbersSee possible answers