(Colleen M. Morrow) This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging and queueing technology built into the SQL Server Database Engine.

(Koen Verbeeck) I have a table with a couple of columns encrypted using the Always Encrypted feature. When I try to read the data with Integration Services (SSIS), I get an error. How can I solve this issue?

(Robert Sheldon) Azure SQL Data Warehouse uses SQL to query the data, but there are some differences to SQL Server’s dialect of TSQL, and queries don’t necessarily work in the same way. DBAs are also required to use SSDT to access Azure SQL Data Warehouse.

(Pinal Dave) As a SQL Server DBA you would know that sometimes it is possible to make mistakes with the database. Few of the time it can be corrected. Out of them, some are easy and some are difficult. I was running out of space on my VM and I started hunting for a bigger file on my machine.

(Jack Vamvas) If you’re not experienced in all the nuances of Service Broker, it can be tricky to diagnose or identify if there is an issue with Service Broker.

(Manoj Pandey) I got an email form one of my reader regarding issues while working with SQL Server 2016 and Polybase, and it is as follows:

(Marcin Policht) One of the challenges associated with running your workloads in Azure SQL Database is the limited level of management oversight (when compared with databases hosted on full-fledged SQL Server instances) over its resources.

(Darren Green) The Checksum Transformation computes a hash value, the checksum, across one or more columns, returning the result in the Checksum output column. The transformation provides functionality similar to the T-SQL CHECKSUM function, but is encapsulated within SQL Server Integration Services

(Prashanth Jayaram) This post is a continuation of Multiple DB refresh automation using PowerShell post . The OP requested me to automate the login transfer process as well. The script should generate an outfile and execute the file on the target server.

(Kenneth Fisher) I was reading a blog post from my friend Randolph West (b/t) on Best Practices and a thought struck me.