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…
Read More
The Latest from Ardalyst
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…
More
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,…
More
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…
More
"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…
More
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…
More
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…
More
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…
More
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…
More
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…
More