Volunteer Strategy for SQLSaturday Orlando
I’ve been busy with other stuff lately and haven’t been able to put much time into this yet, but capturing...
2015-05-19
362 reads
Blog Posts
Database In Recovery Update
Many moons ago, I published a post that contained a script to aid in easing the anxiety that comes when a database is “In Recovery”. When I pulled that...
2015-05-18
5 reads
Database In Recovery Update
Many moons ago, I published a post that contained a script to aid in easing the anxiety that comes when...
2015-05-18
484 reads
Debug Managed Code and Stored Procedures Seamlessly
Visual Studio is a great tool for developers, and it offers so many great features, such as IntelliSense, unit testing...
2015-05-18 (first published: 2015-05-06)
6,226 reads
Fresh New Horror: PK on a Float Data Type
Here's a new thing to be scared about in the night, as if you weren't already terrified of floats after...
2015-05-18 (first published: 2015-05-11)
679 reads
How to Move MSDB & Model SQL Server system Databases ?
Steps of Moving MSDB & Model SQL Server system Database to new locaation:-
1) Check current location of MSDB & Model Databases by...
2015-05-18
3,281 reads
I’m Speaking at OPASS on May 28, 2015
I’ll be presenting Avoiding, Detecting, and Repairing Database Corruption and probably talking a little bit about career development during the...
2015-05-18
330 reads
Monday Morning SQL Break – May 18, 2015
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2015-05-18
521 reads
Precon this week! The Enterprise Scripting Workshop #SQLSaturdayBR
You are cordially invited to a fantastic precon event before SQL Saturday Baton Rouge! The Enterprise Scripting Workshop is on Friday,...
2015-05-18
567 reads
Still More Notes on the SQLSaturday Web Site–Registration
I’ll start by saying the intent of the notes isn’t to complain, at least too much. I’m looking for opportunities....
2015-05-18
371 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