Reblog: January 18 to January 24
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-01-25
1,056 reads
New Years Aspirations – Kevin Kline – Presenting
I’ve been very privileged to be able to work alongside Kevin on a few projects during our time together at...
2013-01-25
887 reads
Replication Latency
I've used Replication a lot over the years and contrary to the opinions of most DBA’s I know, I think it...
2013-01-25
2,093 reads
SQL Server Non Clustered Index Tutorial for Beginners
In the past I have come across comments like SQL Server is slow (small tables) or interviews where someone had...
2013-01-25
2,410 reads
Backup SQL database directly to Azure Storage
There is a new CU update for SQL 2012 SP1 and I noticed a very interesting new feature described in...
2013-01-25
1,521 reads
Day 20 of 31 Days of Disaster Recovery: The Case of the Backups That Wouldn’t Restore
I have decided to spend day 20 of my 31 Days of Disaster Recovery series by relating a true tale...
2013-01-25
1,140 reads
I'm an Administrator Why Can't I Copy Files
Hello Dear Reader! I've been working on setting up a virtual environment for quite some time. When last I wrote...
2013-01-31 (first published: 2013-01-24)
2,799 reads
Audit Configuration Changes
Do you know the last time a Server Property was changed on your instances of SQL Server? Are you wondering when the setting for max degree of parallelism was...
2013-01-24
11 reads
Audit Configuration Changes
Do you know the last time a Server Property was changed on your instances of SQL Server?
Are you wondering when...
2013-01-30 (first published: 2013-01-24)
4,246 reads
If You Need To Fix Database Filename Extensions
In a recent post I showed how the file extension for a database doesn’t matter. It can be confusing, however,...
2013-01-24
1,552 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