Unique Column that Allows Null Value in SQL

Well its been quite sometime now since our last post, was so busy with lots of things now that I manage three teams, Development, Operations and Project Management.  My programming activity drastically went down as I do a lot of juggling between three roles plus managing them, imagine a portfolio of 63 projects last year… Read More »

Cannot load script for execution after migrating your SSIS Package to a new SQL Server version

You are migrating your SSIS Packages from an old version SQL Server to a new SQL Server version, it worked perfectly fine before but once it was deployed on the new environment you get an error similar to this one. Message Executed as user: YourDomainYourUser. Microsoft (R) SQL Server Execute Package Utility Version 13.0.1601.5 for… Read More »

Workaround for Adding Encrypted Databases by a Database Master Key on High Availability Groups without a password

Have you ever encountered this error when you are trying to add a database on your Always On Availability Groups? “This database is encrypted by database master key, you need to provide valid password when adding it to the availability group.” You get this on the Wizard after warning you that a Password is required… Read More »

Hololens from a Developers Perspective

I was quite lucky to have a try on this device last September when we scheduled a demo for our company at Microsoft Sydney office, to add to that when I had a first hand demo on this it was only me and the Regional manager for HoloLens at Microsoft covering Asia-Pacific, Japan and China,… Read More »