2016-07

SQL Server 2016 Sample Databases Available

SQL Server 2016 is barely 6 weeks old, and so but the AdventureWorks sample databases have yet to be released. However, one thing that is available is the CTP3 databases from back in December 2015. The sample scripts cover many of the new features, including JSON objects, Row Level Security and StretchDB, amongst others. But Microsoft have released a new sample database called WorldWideImportersavailable on GitHub. There’s bacpacs for SQL Azure, an Ispac for SSIS, and baks for SQL Server 2016.

2016-07-18

July Musings

As we’re all aware, SQL Server will one day be available on Linux. But when? And is it soon? And what features will be available? If you’re looking for answers now…. you’re out of luck, other than the fact that it will be built on SQL Server 2016 and released sometime in 2017. But what you can do is sign up for an early preview of SQL Server on Linux. I’ve already signed up myself.

2016-07-15

2016-06

Import-Module SqlPs Takes Forever To Load

Hello! I’ve been working on some pre-deployment scripts to SQL Server using PowerShell, and I chose to use Invoke-Sqlcmd as opposed to creating a sql connection*, however the first time I ran the script on my local box to test, it seemed to hang. I thought it may be my local instance not running, but that was running fine. So I created the simplest command possible and tried it: Invoke-Sqlcmd -Query "SELECT GETDATE() AS TimeOfQuery;" -ServerInstance ".

2016-06-07

2015-08

SQL Server 2016 CTP 2.2 Build Has been Replaced

I received an email from the TechNet evaluation Centre this morning, stating that the CTP for SQL Server 2016 (v2.2) has been replaced as of yesterday. Apparently the previous release caused downtime with AlwaysOn Availability Groups during rolling upgrades. Though I have SQL Server 2016 installed on an Azure box, I’ve not played around with AlwaysOn in 2016. An upgrade is recommended for any users who wish to upgrade to SQL Server 2016 CTP 2.

2015-08-06