Announcing SQL Server 2016 CTP 2.3, Upgrade Advisor 2016 Preview 1.1 and Management Studio August Preview

The SQL Server 2016 CTP 2.3 release includes enhancements to the core SQL Server components and also addresses issues that were reported for CTP 2, CTP 2.1 and CTP 2.2. The full list of features and improvements can be found on SQL Server blog. Download CTP 2.3 here.

Read more »

Row-level Security Available for SQL Database

Earlier this week, Microsoft made Row-Level Security (RLS) available for SQL Database. This feature, which was released as a preview in January, allows the customer to control who has access to rows in their database table based on a user's characteristics such as identity, role and execution context.  The concept is similar to having  all the data is in one table and then using a query with predicates to decide what data is returned, the query doesn’t change only the values being used in the where clause changes.

Read more »

Dude, Where's my GUI - Windows Server 2012/R2

During one of my classes, a student encountered an issue with his virtual machine (VM) which was running Windows Server 2012. After attempting multiple solutions to fix the issue the VM restarted but all that came up was the command prompt, the Server Manager tool didn’t start, there was no task bar. Holy crap, we just lost our GUI!

Read more »

Clone Virtual Disk Image (VDI) as a Virtual Hard Disk (VHD) file

Due to some laptop issues I needed to move some virtual machines (VM) to my replacement machine but this time I decided to run them on Hyper-V. Instead of trying to convert the disk image files to VHD I decided that having a VDI and VHD copy for future would be best. Virtual Box has a command-line interface called VBoxManage that allows you to clone the hard disk image using the clonehd command.

Read more »

Attending TechEd Europe 2014!

This week I am at Microsoft TechEd Europe which is being held from October 28-31 at Fira Barcelona in Barcelona, Spain. In case you didn't know as yet, this is the last time Microsoft is holding the TechEd event and it will be replaced by another event called Microsoft Ignite which is being held May 4–8, 2015 in Chicago, Illinois.

Read more »

SQL Server 2014 RTM

Yesterday Microsoft officially released SQL Server 2014. 

Tweeted by @SQLServer
Some of features that had me excited about this release are:

Read more »

Significance of Square Brackets [] in T-SQL Code

After one of my T-SQL presentations, I was asked about the significance of square brackets around objects in T-SQL. I had an idea of their purpose but to confirm I asked T-SQL guru, Itzik Ben-Gan.

Read more »