Quite a few to work with, but in this article, I will be solely focused on looking at the best practices commands that are available and see how my SQL server stacks up. [Click on image for larger ...

EOS might feel like a big hassle, but it actually represents an excellent opportunity to evaluate your SQL Server workloads to determine the best way forward with these systems. Learn about your ...

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 ...

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 ...

Many considerations go into evaluating whether it is time to implement an upgrade to a new version of SQL Server. You need to think about socket vs. core licensing ...

LINQ to SQL is an ORM (Object Relational Mapper ... In this post, I’ll highlight a few tips and best practices that can be adopted to optimize LINQ performance. You should turn ...

The main headache of any migration is figuring out how to get the data out of one server and into another. Here are some best practices for transferring data and tips for school districts that are ...