SQL Server Replication
I can remember several years ago every time someone mentioned SQL Server replication you would hear a dull groan. It is one of those things… Read More »SQL Server Replication
SQL Server replication requires the actual server name to …
The more and more I work with replication the more and more I run into weird errors like this one. SQL Server replication requires the… Read More »SQL Server replication requires the actual server name to …
Cannot drop the database because it is being used for replication.
I have been doing more and more replication work lately, and when recently testing some replication work I needed to create and drop some test… Read More »Cannot drop the database because it is being used for replication.
Get a List of Tables That Are Compressed
Modern versions of SQL Server have the option for row or page level compression. Here is the script to find those tables that have compression… Read More »Get a List of Tables That Are Compressed
DBCC Shrink Fails with Error
Recently when shrinking a SQL Server data file, I ran into the following error: File ID 3 of database ID 15 cannot be shrunk as… Read More »DBCC Shrink Fails with Error
Configuring The Distributed Transaction Coordinator
When building out a new SQL Server to replace an existing SQL Server, the previous system may have been using DTC or the Distributed Transaction… Read More »Configuring The Distributed Transaction Coordinator
How many files are in your SQL Error log directory?
I was investigating a slow sever recently and discovered almost a million files in the sql server error log directory. This contained job history and… Read More »How many files are in your SQL Error log directory?
User objects in the master database
Recently when doing a database upgrade for a client, I was informed that we had missed some user procedures, tables and functions in the master… Read More »User objects in the master database
XML and JSON making simple changes
As part of the XML and JSON month of blog posts, this post is going to cover how to make changes to XML and JSON… Read More »XML and JSON making simple changes
Pass Summit 2020?
PASS Summit 2020? What are your thoughts on PASS Summit 2020 as a virtual conference? I am curious to see what you think. We certainly… Read More »Pass Summit 2020?