Upcoming Speaking Engagements
In the next few months I will be speaking at some awesome events around Europe.
SQLBits – April 5-8
SQLBits is THE SQL...
2017-02-27
601 reads
SpaghettiDBA
Installing SQL Server 2016 Language Reference Help from disk
A couple of years ago I blogged about Installing the SQL Server 2014 Language Reference Help from disk.
With SQL Server 2016...
2016-10-27 (first published: 2016-10-17)
1,618 reads
ForumSurfer – a RSS reader for the SQL Server online community
Today I published the first release of ForumSurfer, a RSS reader designed explicitly to be a tool for the SQL...
2016-08-31
918 reads
SSMS is now High-DPI ready
One of the most popular posts on this bog describes how to enable bitmap scaling is SSMS on high DPI displays,...
2016-08-25 (first published: 2016-08-18)
4,037 reads
My Feedback on my PASS Abstracts Feedback
Brent Ozar recently published the feedback he got on his abstract submissions for PASS Summit 2016 and, as he often...
2016-06-30
877 reads
Upcoming Speaking Engagements
The next few months will be crazy for me. I will be travelling a lot around Europe, speaking about SQL Server topics.
Here is where...
2016-04-14
454 reads
Weird Things Happen with Windows Users
This will be no surprise to those who have been working with SQL Server for a long time, but it...
2016-03-18
727 reads
An annoying Bug in the Restore Dialog
Today, thanks to a customer, I discovered one of those annoying little things that can really drive you nuts.
Basically, they were...
2016-03-01 (first published: 2016-02-23)
2,305 reads
SSMS in High-DPI Displays: How to Stop the Madness
I spent the last few weeks travelling a lot compared to my usual routine and I got quickly fed up...
2015-10-14
41,038 reads
SQL Server Infernals – Circle 6: Environment Pollutors
Don’t tell me that you didn’t see it coming: at some point, Developers end up being put to hell by...
2015-07-31
1,227 reads
Blogs
AZ-900: Microsoft Azure Fundamentals – The Ultimate Beginner’s Guide to Cloud Mastery
By Rohit Garg
In an era where cloud computing drives innovation, understanding its fundamentals is no longer...
Moving to Rancher Desktop
By Steve Jones
I’ve been very happy with Docker Desktop for years, running it on both laptop...
Logging in Azure Data Factory data flows
By Rayis Imayev
(2025-June-15) Long gone are the days when a data engineer could simply focus on building...
Forums
SQL - Conditional merge join
I want to add a condition in the joining columns part of the merge...
Is there a way to implement ROWS between logic?
Hi everyone SUM function has the option to select ROWS BETWEEN parameter to allow...
Tracking changing prices and recalculating inventory value
I'm trying to figure out a how to do average costing over time in...
Question of the Day
What is Between?
I have a table of products in SQL Server 2022. There are sequential items in the table with ProductIDs of 1, 2, 3, 4, 5, 6, 7, 8, 9, 10. If I run this code, how many rows are returned?
SELECT * FROM dbo.Products WHERE ProductID BETWEEN 4 AND 7;See possible answers