T-SQL Gotcha
I came across an interesting issue a few days ago that I thought I would blog about. The issue is...
2013-02-15
1,608 reads
Backup not starting for Database with Full Text Catalog…………..Failed to change the status to RESUME for full-text catalog in database. Error: 0×80043607
Issue :-
One of our Database with Full Text Catalog is not getting backed up. When I checked, backup keeps pending...
2013-02-14
760 reads
Connect PerfMon to a Remote Server
It seems to be a simple & easy thing to connect Perfmon to a remote server.
GO TO RUN > Perfmon > Right Click...
2013-02-14
1,257 reads
Hardware 301 Presentation
I had the opportunity to present the latest version of Hardware 301: Diving Deeper into Database Server Hardware two times...
2013-02-14
1,127 reads
SQL Server Podcasts
Photo credit: Digitalnative
About a year ago, I came across an online deal for a car stereo system with a USB...
2013-02-14
1,571 reads
Home Power – Generators
A slightly off topic post, but since I was asked recently, I thought I’d take my reply, make a post...
2013-02-22 (first published: 2013-02-14)
2,679 reads
“DBA: Transitioning to a BI Role” Presentation Slides
Thanks to everyone who attended my presentation “DBA: Transitioning to a BI Role” at the PASS Professional Development Virtual Chapter. The recording...
2013-02-14
1,770 reads
Start Getting Ready for PASS Summit 2013
Seems so early in the year, but it’s already time to start getting ready for this year’s PASS Summit. There...
2013-02-14
692 reads
A Month of PowerShell – Day 14 (Databases: Altering Tables)
Welcome to Day 14 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-14
2,145 reads
Script Replication with PowerShell
I promised you some PowerShell scripts this year and this post is the first one. I can see the value...
2013-02-14
6,832 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