Rules of Holes #5: Seek Help to Get Out of the Hole
You are moving along, doing good work, maintaining a steady pace. All seems to be going well for you. Then BAM!, a Hole just grabbed you. How the heck...
2012-11-19
7 reads
Restoring a SQL Server 2005 Full-Text Catalog to SQL Server 2012
Upgrading fulltext data from a SQL Server 2005 database to SQL Server 2012 is to restore a full database backup...
2012-11-19
2,622 reads
SQL Availability Groups VM Sandbox Step By Step
In this post I am going to walk you through creating a virtual environment from the ground up to play...
2012-11-19
54 reads
DBCC CheckTable, Spatial Indexes and incorrect compatibility mode…..
Just a very quick blog today regarding an issue that has arisen with one of my clients. During Integration it...
2012-11-19
1,259 reads
Lost in Translation – Deprecated System Tables – sysmessages
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-19
706 reads
Rules of Holes #5: Seek Help to Get Out of the Hole
You are moving along, doing good work, maintaining a steady pace. All seems to be going well for you. Then...
2012-11-19
667 reads
Quick Tip: SSIS and SAP BW Round 2
Again, frustration.
After almost breaking my arm patting myself on the back getting past my last SAP BW issue I found that...
2012-11-19
1,186 reads
Last Weeks Top 10 “Reading” Links #7
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2012-11-19
566 reads
Top 5 SQL Server 2008 DBA Books
I’m often asked about what books I would recommend for learning more about SQL Server 2008 and I always respond...
2012-11-19
1,037 reads
Living with the Surface, Maybe
No major updates at the moment. I still haven’t played with remoting through PowerShell. I’m just living with it.
Had an...
2012-11-19
993 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