Lost in Big Data, perhaps Small Data could help
(2017-Nov-19) I don't remember how I actually found this book "Small Data: The Tiny Clues that Uncover Huge Trends". Most...
2017-11-19
1,302 reads
How to Calculate Running Totals in SQL Server
In show #84 of the SQL Server Radio Hebrew Edition, Matan and I talked about how to calculate running totals in SQL...
2017-12-01 (first published: 2017-11-19)
2,907 reads
Customer Satisfaction Survey Results
In the last couple of months, we sent our first customer satisfaction survey to all our customers. We collected the...
2017-11-18
525 reads
What is the Role of the UPDATE Lock in SQL Server?
The most common types of locks in SQL Server are the SHARED (S) lock and the EXCLUSIVE (X) lock. The...
2017-11-18
1,422 reads
One Line of Code Is All It Takes
This tweet showed up in the dbatools Slack channel Friday afternoon.
Just did my first Pull Request to "contribute" to @psdbatools. Granted, the code change was a single line of...
2017-11-18
12 reads
One More Trip and Down for the Count
The last month has been a rough one for me, with lots of travel. I was on trips for 4...
2017-11-17
1,010 reads
New Session: Data Types Do Matter
I started speaking on a semi-regular basis this year after many years of trepidation. You can read about my first...
2017-11-17
313 reads
Geek Sync Recording: Taking Control of Your SQL Server Sprawl
Back in July, I gave a webcast for Idera’s Geek Sync. They’ve published the recording. You can find it here:
Take...
2017-11-17
450 reads
Incorrect Syntax – What?
Intuitive errors are very helpful when trying to troubleshoot a problem. On the other hand, when we receive an error that is vague, we sometimes find ourselves wanting to...
2017-11-17
45 reads
Incorrect Syntax – What?
Intuitive errors are very helpful when trying to troubleshoot a problem. On the other hand, when we receive an error...
2017-11-17
339 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Hyperscale Replicas IV
Comments posted to this topic are about the item Hyperscale Replicas IV
The SQL Server Date Magic: When CAST and CONVERT Keep Your Index Seek
Comments posted to this topic are about the item The SQL Server Date Magic:...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers