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

Creating a SQL Server Login Using PowerShell and SMO

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

Java, JDBC and SQL Server tutorial

In this Microsoft SQL Server and JDBC tutorial, you'll learn how to connect to a Microsoft SQL Server in Java using JDBC. The steps are relatively straightforward: Each database is different, so ...
Redmond Magazine

How To Use .CSV Files with PowerShell, Part 1

Windows PowerShell is probably best-known for its ability to allow Windows admins to operate at scale. For instance, it would take forever to create a thousand user accounts through the GUI, but ...