The project uses SQL Server SMO and Powershell to extract objects from SQl Server and store then in a local file repository. Each object is stored in a seperate file Objects are stored under a Folder ...

This post was authored by Ayo Olubeko, Program Manager, Data Developer Group. The July update for SSMS includes the first substantial improvement in SQL PowerShell in many years. We owe a lot of ...

Some of these modules use what is called the SQL Management Object (SMO) which allows you to load some assemblies to be able to connect to a SQL server and then explore the server and its database and ...

Provisioning a New Microsoft Azure SQL Database Server. Configuring a firewall rule for a Microsoft Azure SQL Database Server. Connecting to a Microsoft Azure SQL Database Server using ADS.

PowerShell expert Chad Miller commented (on VisualStudioMagazine.com another site hosting my blog) that PowerShell is quite extensible and allows you to build your own object explorer and directed me ...

PowerShell expert Chad Miller commented (on VisualStudioMagazine.com another site hosting my blog) that PowerShell is quite extensible and allows you to build your own object explorer and directed me ...

Stuff in use: Windows Server 2008 R2 and a just-installed instance of SQL Server 2014. Now, when I installed it, it asked me if I wanted to use Windows Authentication only, to which I said, "sure ...

Learn how to use loops and dynamic object naming in PowerShell to build GUI settings interfaces that can adapt as new parameters are added.