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

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

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

Today’s README file explains how to create connection strings to SQL Server databases using Visual Studio’s built-in tools. To provide an example using real source, I created a simple Winforms ...

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