SQLskills SQL101: The SQL Server ERRORLOG One of the most useful logs you can review when there’s a problem in SQL Server is the ERRORLOG. It may not always be the Explore
Instant File Initialization: Easier to Enable in SQL Server 2016 (and some updated numbers) The ability to have SQL Server data files skip zero initialization when they are created or grown has been available since SQL Server 2005. By Explore
SQL Server Setup Error: The directory name is invalid A few weeks ago I got an email from someone who had attended our Accidental DBA IE class last year, and this person was getting Explore