SpeedPASS Download Naming Convention
This was the first time in a long time that I managed the check-in process of SQLSaturday Orlando and was...
2017-10-18 (first published: 2017-10-09)
1,522 reads
SQLpassion Online Training about Availability Groups
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-10-16 (first published: 2017-10-09)
1,264 reads
What is DBCC CLONEDATABASE ?
DBCC CLONEDATABASE is new feature comes up with SQL Server 2014 Service Pack 2 and above. DBCC CLONEDATABASE is used...
2017-10-13 (first published: 2017-10-09)
2,440 reads
Extracting Deadlock information using SYSTEM_HEALTH Extended Events
Extended Events is a powerful feature that was introduced into SQL Server 2008 and onwards. It keeps historical system health...
2017-10-12 (first published: 2017-10-07)
13,686 reads
Simplified Networking with a Wsky USB NIC
I used to share an office with my wife. We both needed Internet connections, with both desktops needing Ethernet cables....
2017-10-06
448 reads
T-SQL Basics: MERGE Statement
One useful sentence when you need to add data to an existing table from an external source or database, and...
2017-10-06
411 reads
What’s new in SQL Server 2017 presentation
I just uploaded a new presentation called “What’s new in SQL Server 2017”. It covers all the new features in...
2017-10-06
745 reads
Introduction to SQL Server Always On
Today I'll write with one of the features I like the most and is Always On. There will be two post of this subject, this first one is an...
2017-10-06
25 reads
The Death of SQL Server Service Packs
SQL Server Service Packs are going away, starting with SQL Server 2017. I talk about why I think this is a good thing, and discuss Cumulative Updates, Service Packs,...
2017-10-06
14 reads
Introduction to SQL Server Always On
Today I'll write with one of the features I like the most and is Always On. There will be two...
2017-10-06
1,309 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
Massive Table Growth Issue – How to Set Up Filegroup Usage Alerts?
Hello We recently encountered an issue where a SQL table unexpectedly grew in size...
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers