Month: November 2020

Let's count the number of SQL Server tempdb files I have

3 Ways to Find Your SQL Server tempdb Data Files

Checking the number of tempdb data files is straightforward. Here are three easy ways: one graphical, one T-SQL, and one PowerShell, so you can use your tools of choice.

Avoid working without a net; implement a SQL Server HADR option

High Availability and Disaster Recovery in SQL Server

We’re often asked about SQL Server High Availability and Disaster Recovery (HADR) options to help customers protect their data and improve their uptime. No surprise there. When a SQL Server provides a critical component of your daily operations you need those databases to be available. Simply put, when a user needs information from the database…
Read more