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.
How to Add Date to Database Backup Filename? – Interview Question of the Week #109
A reader using Backup to URL asked how to add the date to a Database Backup Filename. Here is a script that builds the name for you.
SQL SERVER – Puzzle – Why does sp_spaceused Show No Values?
Why does sp_spaceused show no values for a table that clearly has rows? It stumped me for 10 minutes. Here is the puzzle, try it before reading on.
SQL SERVER – SQL Server: Getting OS information using DMV
Need the Windows version SQL Server runs on? Get OS information with the sys.dm_os_windows_info DMV, or read it from the ERRORLOG at startup.
How to Enable Auto Update Statistics and Auto Create Statistics with T-SQL – Interview Question of the Week #108
Question: How to Enable Auto Update Statistics and Auto Create Statistics? Let us learn how we can fix that in today’s blog post.
SQL SERVER – Script to Find and Monitoring TempDB Space Usage
Monitor tempdb space usage with separate data-file and log checks. Find task allocations and open transactions before choosing a remedy.




