Figure 2. Successful Azure PowerShell Connection Output. Although this next step might have been set for other reasons, you must have a server firewall rule setup to allow incoming SQL connections ...

Customizing PowerShell for SQL Server To wrap up this series of PowerShell articles, let's take a look at a few tips and tricks for working with PowerShell in SQL Server on a regular basis.

Microsoft's premade templates allows for the deployment of SQL databases without having to use complex PowerShell commands.

When you need a SQL database fast, the cloud is the best way to go. Azure provides a SQL database as a PaaS that eliminates the need to get an entire SQL Server deployment up and running.

Use PowerShell to script objects on a schedule or in a special order. Use PowerShell if you need to switch between windows and SQL commands or even share data between the two.

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

Does anyone know how, once terminal'd into a Unix box (I know very little about navigating Unix), I can execute a sql statement against the informix database installed on the system?SQL Server has ...