(Daniel Janik) SQL Server 2019 brings a lot of great new features. Many are introduced by the IQP (Intelligent Query Processing) features and greatly improve query performance.

(Grant Fritchey) If you have been reading through all my fundamentals posts and following along, you have built a small sample database, loaded it with data, and learned how to retrieve the data from it.

(Cate Murray) Your current position is coming to an end and you’re in the market for a new job. As you’re looking through online job postings, you notice some of the following:

(Itzik Ben-Gan) In Part 1 and Part 2 of this series, I covered the logical, or conceptual, aspects of named table expressions in general, and derived tables specifically.

(Kenneth Fisher) The other day I got this rather interesting error while connecting to an Azure SQL DB.

(Pinal Dave) One of the pre-requesting of Comprehensive Database Performance Health Check is to have access to the database which we are going to tune. You may find it surprising that quite a few times, I ended up in a situation where I have a client who wants me to help with their database performa

(Ron L’Esteve) In my last article, Load Data Lake files into Azure Synapse DW Using Azure Data Factory, I discussed how to load ADLS Gen2 files into Azure SQL DW using the COPY INTO command as one option.

(Pinal Dave) Today’s blog post is actually a follow-up blog post of SQL SERVER – Last Page Insert PAGELATCH_EX Contention Due to Identity Column.

(Mohammed Moinudheen) I see that I have constant issues with my Azure Windows based SQL Virtual Machine (VM). I am not able to start my Azure SQL VM or RDP to it. Is there any way I can redeploy the Azure VM and check if the issue gets resolved? Will there be any kind of data loss when we redeploy?

(James Serra) There are a number of options for monitoring Power BI that I wanted to mention: