Blog

SQL Server Query: Querying the Instance and OS Level Details

If you need to query more than 100+ SQL Server instances, you will need to register all the instances into a group and run a multi-server query.

Scripting Out SQL Server Logins, Server Role Assignments, and Server Permissions

This blog reviews how you can generate scripts for SQL server logins, role assignments, and server permissions for a smooth migration.

RAID For SQL Server: What RAID Should You Use?

Which RAID should you use with SQL Server? Learn the differences between RAID 0, RAID 1, RAID 5, and RAID 10, along with best practices.

Move SPFILE from ASM to File System

The following is an example of how to move your SPFILE from ASM to your file system or vice versa.