Azure SQL Elastic Pools
In this video tutorial David talks you through the benefits of Azure SQL Elastic pools. Elastic pools allow you to...
2018-02-21
737 reads
Indexing and Partitioning
Partitioning tables is a great tool to increase the manageability of your data. Being able to move large amounts of...
2018-02-21
3,859 reads
Activate Conference 2018: Three days of Tech Learning
Tomorrow I'll be giving two workshops at the super-slick-brandedActivate Conference 2018 in Baton Rouge at the Louisiana Technology Park, a...
2018-02-21
291 reads
Classifying Data with SSMS 17.5
I upgraded SSMS to 17.5 recently and found an interesting addition. This version has incorporated the ability to classify data....
2018-02-20
798 reads
Killing A Service Broker SPID
Killing a SPID shouldn’t be complicated. Execute the command KILL [SPID] and that should kill the session. But there are situations...
2018-03-06 (first published: 2018-02-20)
6,321 reads
OR vs UNION ALL – Is One Better For Performance?
Today I want to show you a trick that could make your queries run faster.
It won’t always work, but when...
2018-02-20
210 reads
OR vs UNION ALL - Is One Better For Performance?
Today I want to show you a trick that could make your queries run faster.
It won't always work, but when it does everyone will be impressed with your performance...
2018-02-20
9 reads
Capture SQL Server Reported Errors using Extended Events
In my introduction to Extended Events blog, I mentioned that the xEvent is my favorite toy for performance troubleshooting. This blog may...
2018-03-05 (first published: 2018-02-20)
11,142 reads
Getting started with the SQLUndercover Inspector
Here is a quick guide to getting started with the SQLUndercover Inspector.
Pre-requisites:
SQL 2012 or higherSQL Server AgentA database to store...
2018-02-19
370 reads
Summary of my Partitioning Series
Partitioning Basics – Part 1 – Creating Partitions
Partitioning Basics – Part 2 – Splitting/Merging Partitions
Partitioning Basics – Part 3 – Switching Data
Partitioning and filegroup restores
Update to...
2018-02-19
465 reads
Blogs
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...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
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...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers