Last time, we discussed the different backup types available in SQL Server. Now, let's take a quick look at some best practices when it comes to configuring those backups. Although there is no one set ...

When working with my customers on SQL Server security, I constantly get the same question, “What are some best practices for hardening my SQL Server implementation?” Over the years, I have come up ...

SQL Server 2008 Installation Strategies and Best Practices Part 2 of 5 Greetings, last week I initiated this blog series which focuses on best practices and installation strategies when deploying SQL ...

I have 15 servers that make up my production network. All are on a Gigabit ethernet connection and also on the same switch. The majority are 2008, 2008 R2, and I do have a couple that are 2003 R2. I'm ...

The PowerShell community is a treasure trove of amazing modules and scripts that you can find online and use in your day-to-day operations. It doesn't matter the platform or the purpose, there is ...

Russell Smith is a technology consultant and trainer specializing in management and security of Microsoft server and client technologies. He is a Microsoft Certified Systems Engineer with more than 15 ...