(K. Brian Kelley) Recently, the security folks in my organization have pushed for all of us to have two accounts: one for normal use and one for when we are doing any sort of administrative work, such as the typical DBA tasks for Microsoft SQL Server. Is this really necessary?

(Jon Gallant) You will likely want to run the Azure IoT Edge Runtime from your own Azure Container Registry (ACR). While this will be officially supported eventually, right now it is not, but there is a workaround.

(Arun Sirpal) Let’s start off with a quick overview of SQL Server versions and compatibility levels.

(Pinal Dave) Sometimes I do get some quick questions from my existing clients. I try to help them as much as possible. Most of the time, I provide them link to my blog or someone else’s blog. If there is no relevant information based on my search, then I provide them relevant information and write a

(Marcin Policht) One of the most commonly requested Azure SQL Database features has been support for more granular control of server-level firewall settings. While it is possible to restrict their scope down to individual IP addresses for traffic routed via public Internet, the mechanism to manage i

(Grant Fritchey) I have a real infatuation with Azure. I’m especially interested in the Platform as a Service (PaaS) offerings in and around the Data Platform. I truly believe that these are the subversive elements that are going to change how a lot of us get our jobs done with data.

(Melissa Coates) Did you know there are two ways to do federated queries with Azure Data Lake Analytics (ADLA)? By federated queries, I mean a query that combines (federates) data from multiple sources — in this case, from within Azure Data Lake and another data store.

(David McGahey) SQL queries with parameters, also known as SQL templates, are a flexible and efficient solution for repetitive data reporting requirements, for instance allowing users to easily execute complex join statements with multiple sets of values.

(Bhavesh Patel) I needed to restore a database backup that was around 24 GB. I was trying to figure out how to make the restore run faster and I found some additional restore parameters that could be used. I tested these out and was able to make the restore complete faster and I will cover what I

(Brian Farnhill) One of the things that I’ve come up against recently is a limitation with managed disks. Today it was specifically when it comes to moving virtual machines that use them into a new subscription