by Vatsana Kongtakane | Jun 22, 2017 | Azure, Blog, Microsoft SQL Server
As more users are starting to move their SQL workloads to the cloud, one of the common questions is how to setup user authentication with their Office 365/Azure Active Directory tenant. There is of course some limitations. At this time, Azure AD authentication can…
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 Terrance Zhou | Apr 4, 2017 | Blog, Microsoft SQL Server
Part 1. Know your report’s performance SQL Server Reporting Services (SSRS) is a powerful report building and deployment tool that is frequently used by a large number of institutions. However, a report that needs a lot of time to be rendered is useless as users lose…
by Abdul Hakim | Mar 29, 2017 | Microsoft Dynamics, Microsoft SQL Server
I was recently working on a WCF (Windows Communication Foundation) service to keep InsideView’s most recent data in a SQL database. This database served as a cache when updating accounts in Dynamics CRM Online. I used the cached database as a fail-safe option if…
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…