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