In a previous article, I talked about getting started with managing SQL server using PowerShell and the Server Management Objects (SMO). While that was mostly spent making the connection and doing ...

A reader has prompted Microsoft to launch a vast new resource for easing the SQL Server set-up process. Okay, just maybe it's a coincidence. Anyway, reader Brian M.'s complaint about the difficulties ...

SQL Server accomplishes this with SQL Server logins. Everyone who wants access to a database has to have a server login, whether they use a SQL Server account, a Windows account, or a Windows group as ...

A step-by-step guide to deploying, configuring, and testing a multi-AZ, multi-region SQL Server FCI in the Azure cloud, complete with a PowerShell script that handles the networking configuration.