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

SQL Server Management Studio can help take the guesswork out of creating connection strings for PowerShell applications.

There are lots of ways to create MSSQL databases via PowerShell. We could invoke a T-SQL query using the CREATE DATABASE term, we could write some code to use the [Create() method with SMO] or, if ...

This book aims to update your DBA skills to cover SQL Server 2022, how does it fare? Each version of SQL Server offers both new functionality and builds on existing features. This book aims to help ...

This book aims to update your DBA skills to cover SQL Server 2019, how does it fare? Each version of SQL Server offers both new functionality and builds on existing features. This book aims to help ...