We’re frequently asked how many tempdb files a SQL Server should have, especially from those who have downloaded our free 5 Common SQL Server Configuration Issues PDF. That’s because there’s a lot of well-intended but incorrect information posted on the internet about tempdb. What Is tempdb? Let’s start with a very brief description of tempdb. When SQL…
Read more
Ding! Your desktop IM client chimes. “Any idea how long my SQL Server backup/restore will take to complete? I think it may be stuck.” Someone has started a database restore (or backup) using a T-SQL command. Now he wants to know how long the process will take to complete. He’s gone to the bathroom and…
Read more
T minus 7 days. One of the biggest events of the year for data professionals is just one week away. The PASS Summit in Seattle, Washington, kicks off on November 6, 2018. Each year the event draws thousands of attendees from around the globe for three days of intensive learning, engaging networking, and embracing camaraderie.…
Read more
“Should I install SQL Server 2017 now? Or wait until SQL Server 2019?” One of our Remote DBA clients recently asked me that question. They have a set of aging SQL Server 2008 R2 instances used for production, test, and development. SQL Server 2008 and 2008 R2 Extended Support ends July 9, 2019, and the…
Read more
Just when we thought that most cybersecurity attacks came via social engineering, we see this. Attacks on IIS, Microsoft’s web server, increased from 2,000 in Q1 2018 to over 1.7 million in Q2 2018. That’s a mind-boggling 782x increase! This is according to an esentire Security Advisory released last week. Hackers go-to tool of choice? PowerShell was the most commonly…
Read more
“The nice thing about standards is that you have so many to choose from,” quipped renown computer scientist Andrew Tanenbaum. In the SQL Server world, we have industry best practices. These are guidelines that most every knowledgeable database professional will agree is a good idea or a good baseline. Sure there are exceptions, specific tweaks…
Read more
Recent Comments