What I’ve Read and Recommend to Others – General Database and Theory by C.J. Date
Date on Database: Writings 2000-2006
This is a collection of writings by C.J. Date, one of the fathers of the relational...
2010-02-26
1,886 reads
More Snapshot Backups
I got some more feedback from my Connect item on allowing snapshot backups. They took notice, but I heard the...
2010-02-26
1,560 reads
Suncoast Technology Forum Tech Fest Event 2010
I presented a 30 minute session at Suncoast Technology Forum Tech Fest on Windows Scripting Automation with Powershell: "This session will...
2010-02-26
1,758 reads
Speaking in Cambridge, England March 24, 2010
If you are near Cambridge, England, I will be speaking at the Cambridge SQL Server Users Group on Wednesday, March...
2010-02-25
1,544 reads
SQLBits 6 to Be Held in London, April 16, 2010
The upcoming SQLBits 6, to be held Friday, April 16, 2010, will be held at the Church House Conference Centre...
2010-02-25
1,618 reads
Why Do My SQL 2008 Compressed Backups Shrink?
Introduction
Recently a coworker was doing some research with SQL 2008 Backup Compression on a very large database. During the testing...
2010-02-25
424 reads
Editorial - “Dude, Your Fly Is Open”
In case you don’t subscribe to the SQL Server Central daily newsletter, check out the editorial I wrote entitled “Dude,...
2010-02-25
600 reads
Renaming a Standalone Instance of SQL Server
I needed to upgrade the underlying IO subsystem of one of my IO intensive SQL Servers. After some discussion with...
2010-02-25
2,210 reads
I’m Attending the South Florida Code Camp on February 27, 2010
I’m driving down tomorrow for the sixth annual South Florida Code Camp. This will be my third time attending and...
2010-02-25
526 reads
Day 4 - Pragmatic Works Webinar Series
Hey gang !
I’m presenting today at 1pm on Zero to Cube in 60 minutes. We’re going to build an analysis...
2010-02-25
419 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