by Eric Isaacs | Dec 7, 2016 | Blog, Microsoft SQL Server
THROW replaces RAISERROR in SQL Server and it’s the preferred method going forward to raise error messages and push them to the calling code. THROW is actually a lot more intuitive than RAISERROR as far as how your code responds to it. THROW was created as a means to…
by Vatsana Kongtakane | Nov 30, 2016 | Azure, Blog, Microsoft SQL Server
In September, Microsoft finally announced Azure encryption support for data at rest, a long awaited feature by many companies which are bound by regulation and requirements. The great thing about this is you can easily enable encryption by toggling it to…
by Vatsana Kongtakane | Sep 30, 2016 | Azure, Blog, Microsoft SQL Server
In our last post – SQL Server Availability Groups in a Workgroup Failover Cluster inside Microsoft Azure, we created a domain-less Windows Server 2016 Technical Preview 5 Failover Cluster with SQL Server AlwaysOn Availabilty Groups. For anyone that has had to…
by Vatsana Kongtakane | Sep 14, 2016 | Azure, Blog, Microsoft SQL Server
With Windows Server 2016 just around the corner, one of the the new features is support for Windows Failover Cluster inside a Workgroup. In this blog post today, we will show you how to setup Windows Server 2016 Technical Preview with SQL Server 2014 AlwaysOn…
by Eric Isaacs | Jul 13, 2016 | Blog, Microsoft Dynamics, Microsoft SQL Server, Uncategorized
We were using KingswaySoft to import hundreds of thousands of Activities (Emails, Phone Calls, Tasks, Appointments) into Microsoft Dynamics CRM 2011. Importing that many rows can be time consuming, so we opted to utilize Microsoft’s Balanced Data Distributor within…
by Eric Isaacs | Mar 16, 2016 | Blog, Microsoft SQL Server
Occasionally I get questions about how to create a T-SQL result set with dynamic column names. Similarly I see people with issues creating temporary tables with dynamic column names. While it’s easy to create an entirely dynamic SQL statement that can display…