Computer Weekly

SQL Server in Windows und Linux über die PowerShell steuern

Um Microsoft SQL Server mit der PowerShell zu verwalten, wird das SqlServer-Modul der PowerShell benötigt. Dieses muss auf zuvor auf den entsprechenden Rechnern installiert werden. Mit der PowerShell ...
MCPmag

Checking SQL Best Practices Using the DBATools Module

The PowerShell community is a treasure trove of amazing modules and scripts that you can find online and use in your day-to-day operations. It doesn't matter the platform or the purpose, there is ...
MCPmag

Connecting to an Azure SQL Database with PowerShell

One way that organizations are storing data in the cloud is by moving their databases to the cloud. What once meant building an entire physical server, patching it, installing software like Microsoft ...
Redmond Magazine

Creating Azure SQL Databases with PowerShell and Azure Resource Manager Templates

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 ...
Visual Studio Magazine

PowerShell vs. SQL Server Management Studio

When I (along with many other people) had a lot of trouble trying to install SQL Server Management Studio in an attempt to switch from the SQL Server 2008 R2 evaluation to the free Express version, I ...