Running SQL Server 2019 CTPs in Docker taught me something new: you can run a SQL Server image without the pull command first. Here is how that works.
SQL SERVER – Upgrade Error – Upgrading Subscription Settings and System Objects in Database [DBName].
A patch failed at “Upgrading subscription settings and system objects in database” with invalid object MSreplication_subscriptions. Here is the fix.
SQL SERVER – Puzzle – Strange Behavior With Extra Comma in Create Table Statement
My favorite icebreaker puzzle: a strange behavior with an extra comma in CREATE TABLE statement. Why does SQL Server accept it for temp and regular tables?
SQL SERVER – xp_cmdshell and Net Use ERROR: The Local Device Name is Already in Use
Mapping a share with net use through xp_cmdshell, I hit “The local device name is already in use”. Here is what causes this error and how to solve it.
SQL SERVER – Fix: The EXECUTE Permission was Denied on the Object ‘xp_cmdshell’, Database ‘mssqlsystemresource’,schema ‘sys’.
A retail team let non-sysadmin users run xp_cmdshell and got Msg 229: the EXECUTE permission was denied on the object. Here is the fix.
SQL SERVER – FIX: Msg 15281- SQL Server Blocked Access to Procedure ‘sys.xp_cmdshell’ of Component ‘xp_cmdshell’
Msg 15281: SQL Server blocked access to procedure ‘sys.xp_cmdshell’ because it is turned off. Here is how to turn xp_cmdshell on with sp_configure.
Interview Question of the Week #009 – Is GO T-SQL Statement?
I often get this question in the email – more frequently than I would like to get.
Question: “Is GO T-SQL statement?”