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.
New AD Domain: Moving an AlwaysOn Availability Group Node by Node
After an acquisition, my client had to move an AlwaysOn availability group to a new AD domain. These are the 12 steps I shared, moving one node at a time from DomainOld to DomainNew.
SQL SERVER Management Studio – Exception of type ‘System.OutOfMemoryException’ was thrown. (mscorlib)
Copying a huge result set from the SSMS grid threw ‘Exception of type System.OutOfMemoryException was thrown’. Why it happens and a better way to export.
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 – The header for file Path is not a valid database file header. The PageAudit property is incorrect
SQL Server would not start: model.mdf did not have a valid database file header and the PageAudit Property was incorrect. How I got it running again.
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.