WideWorldImporters is the new sample database for SQL Server 2016. This SQL in Sixty Seconds video shows how to download and install it quickly.
Install SQL Server Management Studio 2016 – SQL in Sixty Seconds #080
SSMS no longer ships with SQL Server 2016 setup. In this SQL in Sixty Seconds video I show how to install SQL Server Management Studio 2016 on its own.
SQL SERVER – Error: 14258 – Cannot perform this operation while SQLServerAgent is starting. Try again later
A client could not run any job and got Error 14258: Cannot perform this operation while SQLServerAgent is starting. Here is what caused it and how we fixed it.
SQL SERVER – Event 17058 – initerrlog: Could not Open Error Log File
SQL Server would not start and there was no ERRORLOG. Event 17058, initerrlog: Could not open error log file, came from missing permissions on the Log folder.
SQL SERVER – Network Servers List is Empty in SQL Server Management Studio
A client clicked Browse for more in SSMS and the Network Servers tab was empty. Here is how we narrowed it down and what caused it.
How to Change Fill Factor in SQL Server – Interview Question of the Week #080
It is surprising to see that lots of people do not know that SQL Server Fill Factor 0 (which is the default value when SQL Server is installed) is equal to value as 100.
How to Attach MDF Data File Without LDF Log File – Interview Question of the Week #078
Lost or corrupted your log file? Learn how to attach an MDF data file without the LDF log file, using T-SQL or SQL Server Management Studio.