TSQL Recipes – 2014 Edition
Announcing…the book At long last the wait is over. After much blood, sweat and more blood and sweat, the next edition of the SQL Server Recipes book is finished....
2015-07-21
6 reads
Blog Posts
TSQL Recipes – 2014 Edition
Announcing…the book
At long last the wait is over. After much blood, sweat and more blood and sweat, the next edition...
2015-07-21
544 reads
TSQL Tuesday #68: What is my configuration?
It’s T-SQL Tuesday again and this month Andy Yun (b/t) is our host and he has asked us to “Just...
2015-07-21 (first published: 2015-07-14)
1,446 reads
8 Hours of Free Performance Training
How could you possibly argue with getting 8 straight hours of SQL Server Performance training for FREE?
You can’t! Go check...
2015-07-20 (first published: 2015-07-14)
3,830 reads
Azure SQL Database – Link User to Login
I’m writing this post as a way to help motivate the #SQLNewBloggers out there. Read the bottom for a few...
2015-07-20
917 reads
How to close all active database connections in one shot?
While trying to restore SQL Server database or do any other actions which require exclusive database access you may face...
2015-07-20
8,268 reads
I’m Speaking! Edmonton SQL Server User Group
I am honored to be speaking at the Edmonton SQL Server User Group. I always find it humbling to be...
2015-07-20
486 reads
Pre-Compare & Pre-Deployment Scripts to SSDT
When you use SSDT to deploy database changes you can include a pre/post deploy script which is run after the...
2015-07-20
123 reads
Pre-Compare & Pre-Deployment Scripts to SSDT
When you use SSDT to deploy database changes you can include a pre/post deploy script which is run after the...
2015-07-20
223 reads
Pre-Compare & Pre-Deployment Scripts to SSDT
When you use SSDT to deploy database changes you can include a pre/post deploy script which is run after the...
2015-07-20
88 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