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
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 …
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
July is JSON and XML month
I have decided that for the month of July I will post 31 blog entries for the month about JSON and XML. Every post will… Read More »July is JSON and XML month
SQL 2019 Page and Row Compression with XML and JSON
On a week long theme on XML and JSON in SQL Server, this is the second post. After the first post of just showing how… Read More »SQL 2019 Page and Row Compression with XML and JSON
Switching Compatibility Levels on Multiple Databases
Recently as part of an upgrade to SQL Server 2019, I needed to set the compatibility levels for a database to 150 (for 2019). You… Read More »Switching Compatibility Levels on Multiple Databases
Ransomware on SQL Server
What does ransomware do to a SQL Server? Ransomware The way that ransomware generally does their thing it encrypts files and then leaves some clues… Read More »Ransomware on SQL Server
Script to bulk add SysAdmins to SQL Server
Recently I had a project where I needed to add a number of logins as SQL Server sysadmin users to several SQL Server instances. Rather… Read More »Script to bulk add SysAdmins to SQL Server
Confusion with Database Corruption
When working with clients on fixing their corrupt SQL Server databases we run into some common beliefs about corruption that are not quite true, such… Read More »Confusion with Database Corruption
Who does SQL Server run xp_cmdshell command as?
When you execute xp_cmdshell SQL Server runs a command at the operating system level similar to the old DOS prompt, or CMD shell. There are… Read More »Who does SQL Server run xp_cmdshell command as?