Microsoft SQL Server

Featured

How to setup Azure Active Directory/Office 365 Authentication with Azure SQL database (PaaS)

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…

Use CREATE OR ALTER For New SQL Object Scripts

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…

Know, analyze and improve your SSRS report’s performance

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,…

Steps to have SSIS Package Call a WCF Voided Function

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-line Comment Block" Trick in SQL Server T-SQL

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…

How to TRUNCATE a SQL Server Table from a SYNONYM Name

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…

Azure Storage Performance Results with Encryption at Rest Enabled

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…

Testing SQL Server AlwaysOn Availability Groups

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…

SQL Server Availability Groups in a Workgroup Failover Cluster inside Microsoft Azure

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…

Resolving Deadlock Errors in SSIS when bulk loading data via KingswaySoft into Microsoft Dynamics CRM

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…