by Eric Isaacs | Jun 6, 2017 | Azure, Blog, Microsoft SQL Server
When scripting out SQL Server objects in earlier versions of SQL Server, you’ve historically had the option to do so with “CREATE”, “DROP and CREATE”, or as “ALTER” scripts. Each option has advantages over the others for…
by Eric Isaacs | Feb 20, 2017 | Azure, Microsoft SQL Server
In Transact-SQL (T-SQL) there are two ways to comment SQL code that are similar to comment options in many programming languages. First, there’s the “slash star” (/*) comment block that allows you to comment out multiple rows of SQL. Second,…
by Eric Isaacs | Dec 7, 2016 | Blog, Microsoft SQL Server
If you work in an environment where your SQL Server database procedures need to frequently reference data in other databases or on other servers, it can be difficult to implement development, test, and production environments while still maintaining a single code-base…
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 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…