Resource Manager Powershell Script to Enable SQL Server Managed Backup to Azure

The information in SQL Server Books Online about how to generate the Shared Access Signature key for SQL Server Managed Backup to Azure is (at the moment) out-of-date and also not very helpful. https://msdn.microsoft.com/en-us/library/dn449491.aspx So here’s a Powershell script that creates the SAS key, and also will create the Storage Account and Container if they…

0

Installing SQL Server Express and Restoring a Database With Powershell

Here’s a powershell script to install SQL Server Express Edition and restore a database from a commmandline.  It’s intended to be used as part of an installation script for an application that needs a local SQL Express instance.  But it also demonstrates several SQL Server and Powershell interop features like handling InfoMessages from the server,…

0

TransparentNetworkIPResolution in SQLClient for .NET 4.6.1

A new Connection String property has been added for SqlConnection in .NET 4.6.1.  See SqlConnection.ConnectionString But as of this writing the property has not been properly documented.  And the new property is set to true by default:             var con = new SqlConnection(“server=.;Integrated Security=true”); var cb = new SqlConnectionStringBuilder(con.ConnectionString); Console.WriteLine($”TransparentNetworkIPResolution= {cb.TransparentNetworkIPResolution}”); So this post is…

0