(Kenneth Fisher) tl;dr; When doing an insert across a linked server you have to include the list of fields to be inserted into if there is an identity column involved.

(Tim Salch) DML operations can be resource intensive and harmful to CCI indexes in Azure SQL Data Warehouse. The main performance benefit comes from UPDATE & DELETE operations being fully logged and CTAS is minimally logged.

(Grant Fritchey) While SQL Server Management Studio (SSMS) provides a robust graphical user interface (GUI), the commands you’re going to use the most to control databases and the data within them in SQL Server are going to be done through T-SQL.

(Pinal Dave) In recent past, I was assisting a client in installing SQL Server clustered instance in a Windows Cluster. There were many errors encountered and I learned a lot from this experience. In this blog, we would learn about Microsoft Cluster Service (MSCS) cluster verification errors which m

(Jayendra Viswanathan) Functions are objects that return values after some process and SQL Server offers many system functions that are used internally and things that we can use as well. There are table-valued functions and scalar functions and in this tip we will take a look at a couple of these

(Pinal Dave) As most of you might know that my expert area in SQL Server in performance tuning. But, I also deal with almost every issue related to SQL Server engine. Many times, it so happens then clients call me for performance tuning and while fixing, we see some other problem.

(Jack Vamvas) Question: I need to create a SQL Server Linked Server connection from a SQL Server to a PostgreSQL database on Linux. The purpose is to check through a basic test from INSERT and SELECT statements for data insert and retrieval .

(Kenneth Fisher) Monday Grant Fritchey (b/t) put up a great post EXTENDED EVENTS, THE SYSTEM_HEALTH SESSION, AND WAITS that talks about how the system health extended event session pulls, among other things, queries that have to wait for more than 30 seconds for a resource.

(boB ‘The Tool Man’ Taylor) In this SQL Snacks we will examine the architecture of the Extended Events system in SQL Server.

(Scott Murray) How can I make use of Data Insights in Power BI?