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.
Msg 15153: xp_cmdshell Proxy Account Cannot Be Retrieved
Msg 15153 is the second error a non-sysadmin user hits when running xp_cmdshell. A retail team with about 1,500 databases saw it right after Msg 229. A proxy account plus an EXECUTE grant fixed it.
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?
Explain GO T-SQL confusion with batch boundaries, GO repetition, variable scope, semicolon errors, and a procedure creation example.
Time Zone Name in MySQL: How to Detect the Current One
Need the current time zone of the MySQL server you are connected to? One simple query with @@system_time_zone returns the time zone name.