The SQL Agents’ view of SQL Server
I recently came across a really odd issue with the SQL Agent, there were two agent jobs attached to one...
2018-10-11 (first published: 2018-10-02)
2,858 reads
Blog Posts
Which is faster? IN (list) or IN (SELECT FROM Temp)
If you’ve done much with IN (list) then you’ve realized that it basically translates out to
col=val1 OR col=val2 OR...
2018-10-11
2,484 reads
Adaptive Joins and Join Hints
At a recent all-day seminar on query performance tuning I was asked a question that I didn’t know the answer...
2018-10-10 (first published: 2018-10-01)
2,724 reads
CCI – Data Loading considerations with Partitioned Tables and CCI
Introduction
In this blog post, I would like to describe two case scenarios of bulk loading data, using SSIS, into a...
2018-10-10
272 reads
Changes to the SQL Server servicing model (Cumulative Updates)
On Monday of this week, Microsoft announced changes to the servicing model for SQL Server, starting with SQL Server 2017....
2018-10-10
320 reads
Checking Trace Flags with dbachecks, online docs and PSPowerHour
It’s been a few weeks since i have blogged as I have been busy with a lot of other things....
2018-10-10 (first published: 2018-09-29)
1,955 reads
Inspector V1.2 now available
It has been long overdue but finally V1.2 is now available on GitHub.
V1.2 brings a lot of changes, We put...
2018-10-10
367 reads
Inspector V1.2 revised installation guide
Pre-requisites:
SQL 2012 or higher
SQL Server Agent
A database to store the the data collected by the agent jobs (this can be...
2018-10-10
296 reads
T-SQL Tuesday #107 - Death March
This month’s T-SQL Tuesday is hosted by Jeff Mlakar and he asks us to write about a project that went horribly wrong. My story isn’t really worthy of the...
2018-10-10
4 reads
Veterans At PASS Summit ’18
Hello all!
This year at PASS Summit, I will be distributing the below ribbons once again to ANY and ALL Service...
2018-10-10
190 reads
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
How to Calculate Distance Between Coordinates in SQL Server
Comments posted to this topic are about the item How to Calculate Distance Between...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers