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
363 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
407 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
314 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
478 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
445 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
353 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
512 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
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers