Checking job history log size with TSQL
One of the important settings on SQL Server is the job history log size and the maximum rows per job. Without these set accurately you… Read More »Checking job history log size with TSQL
2020 Blog Post Summary
Babelfish for Aurora PostgreSQLDecember 1, 2020Amazon goes after Microsoft’s SQL Server with Babelfish for Aurora PostgreSQL. What is interesting is that a direct port of… Read More »2020 Blog Post Summary
TSQL Query to find the user the SQL services run as
Occasionally I need to look up what user the SQL Server services are running as, and when this happens, you can either run a quick… Read More »TSQL Query to find the user the SQL services run as
Babelfish for Aurora PostgreSQL
Amazon goes after Microsoft’s SQL Server with Babelfish for Aurora PostgreSQL. What is interesting is that a direct port of SQL Server to PostgreSQL or… Read More »Babelfish for Aurora PostgreSQL
Sales To Aggressive?
When does a salesperson become too aggressive? In my business I try to not be too annoying or aggressive but sometimes not being assertive enough… Read More »Sales To Aggressive?
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