Sometimes people install Office onto a SQL Server to get the drivers for the ability to import data from Excel into SQL Server Tables. This should never be done on a production, or any, server because it can cause many other problems for SQL, one of which is the purpose of this blog. For example, … Read more
SQL Server migrations are a necessary and expected part of keeping a modern SQL Server deployment. We have worked with many clients on migration projects, and I have organized some considerations for you and your team before, during, and after your SQL Server migration. We recommend working with a SQL server DBA on these kinds … Read more
This presentation is aimed at the starting DBA, accidental DBA or developer having to wear a DBA hat occasionally. It was written to hopefully convey the important order of operations to a DBA just starting out and walk through the “itties” of Database Administration. This has been delivered at: SQL Saturday #34 in Waltham, MA … Read more