Western Digital WD Red internal HDD sliced in half on pink surface

You can’t secure your network with spite

I wrote a post a couple weeks ago about not changing port 1433 for security reasons. I received this comment, which is not visible on that page because it warrants a lengthy response. I have redacted the name of the commenter. I disagree. Hundreds companies around the world were victims of ransomware attack even they
-> Continue reading You can’t secure your network with spite

SQL Server 2000 logo

Increasing the number of SQL Server Error Logs

Via Tim Radney, here’s a quick and easy way to increase the number of error logs from the default of six. The blog post also has a walkthrough in SQL Server Management Studio if you prefer using the GUI. Using TSQL you can execute the following statement to increase to 99 files, simply change 99
-> Continue reading Increasing the number of SQL Server Error Logs