(James Serra) I see a lot of confusion when it comes to Azure Data Factory (ADF) and how it compares to SSIS. It is not simply “SSIS in the cloud”. See What is Azure Data Factory? for an overview of ADF, and I’ll assume you know SSIS. So how are they different?
Tag: sql server
Using the SQL LCASE Function
(Hannes du Preez) The LCASE() function simply converts the value of a field to lowercase.
Deploying Multiple SSIS Projects via PowerShell
(Nat Sundar) When there are several SSIS projects with packages in a SQL Server Database or Data Warehouse development, automated deployments as part of Continuous Integration can get tricky.
ScriptDom parsing and NoViableAltExceptions
(Ed Elliott) If you have ever tried to debug a program that used the TSql Script Dom to parse some T-SQL you will know that the process is extremely slow and this is due to the volume of NoViableAltExceptions (and others) that are thrown and then caught.
Setting up Azure Disk Encryption for a Virtual Machine with PowerShell
(Melissa Coates) As I discussed in my previous blog post, I opted to use Azure Disk Encryption for my virtual machines in Azure, rather than Storage Service Encryption. Azure Disk Encryption utilizes Bitlocker inside of the VM. Enabling Azure Disk Encryption involves these Azure services:
Applicability Of Cross Apply with STRING_SPLIT in SQL Server
(Niladri Biswas) SQL Server 2016, has introduced the STRING_SPLIT function.This function splits the string using specified delimiter.
HOW TO: Solve General SQL Server Connectivity Issues
(Thomas LaRock) Recently, Microsoft published a page for solving general SQL Server connectivity issues. This page is perfect for you or anyone you know that has suffered from one of the following error messages in the past.
SQL Server vNext: sys.dm_db_stats_histogram
(Arun Sirpal) Since installing SQL Server vNext CTP 1.3 I found out that there is a new way to return statistics histogram for a specific stat which actually is also available with the latest Cumulative Update for SQL Server 2016 Service Pack 1.
Using an R Package within SQL Server with Real time analysis in Power BI
(Saurabh Desai) We all know how easy it is to run R, together with dependent packages, from SQL Server on order to do statistical analysis, and then turn the result into a real-time graph using Power BI; but can you actually do it?
SqlPackage Deploy Performance – IgnoreXX are not your friend!
(Ed Elliott) Following on from yesterdays blog I was wondering about the comparison of objects that were the same and how the IgnoreWhitespace, IgnoreComments, IgnoreKeywordCasing and IgnoreSemiColonsBetweenStatements flags affected the comparison. To be fair I was only interested in IgnoreWhitespac