(Prashanth Jayaram) This article will provide a deep dive into the SQL UNION operator, describing its many uses along with examples and explore some common questions like the differences between UNION vs UNION ALL.

(Allan Hirt) If you’ve been in hibernation, today you woke up to a world where Microsoft has embraced open source and Linux. What was once unthinkable is now happening. What is going on? Why am I even talking about this?

(Grant Fritchey) If you’re watching Microsoft Ignite or tracking the information coming out of it on social media, then you know that Azure SQL Studio has been changed to Azure Data Studio. I’ve got an early release on some of the bits. Let’s explore what’s going on.

(Raj pochiraju) The Data Migration Assistant (DMA) provides a comprehensive assessment by detecting compatibility and functionality issues prior to migrating to a specific version of SQL Server, Azure SQL Database, or Azure SQL Database Managed Instance.

(Pinal Dave) Let me answer the first question first – There is no way to backup and restore SQL Server 2017 to SQL Server 2005 with the help of any tools. In this blog post, we will learn about how we can generate scripts to achieve this task.

(Sergey Gigoyan) Have you ever used the SQL Server LIKE operator and were surprised with the results? Are you sure which strings you need to use to match to a specific pattern?

(Pinal Dave) In my very old post SQL SERVER – Query to Find First and Last Day of Current Month – Date Function, I had explained how to find the first day and last day of the current date.

(John Miner) A data lake is a repository of data stored in its raw format. Typical formats include structured data (rows and columns), semi-structured data (formatted files), unstructured data (documents) and binary data (images, audio, or video).

(James Serra) At Microsoft Ignite, one of the announcements was for Azure SQL Database Hyperscale, which was made available in public preview October 1st, 2018 in 12 different Azure regions.

(Pam Lahoud) Microsoft Ignite 2018 is fading away in the rearview mirror, but the excitement over all the new features and the vision shared there is just beginning.