(Pinal Dave) There are many reasons to envy my job as SQL Server Performance Tuning Expert Consultant but the most important reason is that I get to work on quite often the latest version of SQL Server.

(Kenneth Fisher) When I decided to rip off of Brent Ozar’s (b/t) Bad Idea Jeans series (yes I asked) I decided that since I live in Texas it would be a cowboy hat (now I need to go buy one I guess).

(James Serra) The Common Data Model (CDM) is a shared data model that is a place to keep all common data to be shared between applications and data sources.

(Haroon Ashraf) As a SQL Server Business Intelligence Developer, I have been tasked to centralize information about the data sources including a deployed tabular data model and its underlying source database so that they become understandable, discoverable and consumable for data users.

(Rajendra Gupta) This article explores the SQL ISNULL function to replace NULL values in expressions or table records with examples.

(Grant Fritchey) I find that I’m using containers more and more to get things done with SQL Server. They’re so easy to set up for testing, spin ’em up, do stuff, turn ’em off, done.

(Pinal Dave) This feature works with SQL Server 2019 and onwards. If you are using an earlier version of SQL Server this feature will not work and will give you an error.

(Jason Brimhall) Migrating Extended Event Sessions from one server to another should be a simple task. So simple, one would think there was no need to give it a second thought, right?

(Chris Webb) One of the many big announcements at Build this week, and one that caused a lot of discussion on Twitter, was about Wrangling Data Flows in Azure Data Factory.

(Ray Barley) My company is starting a new project where we are designing and building an enterprise data warehouse. We have many SQL Server databases that are used by our various line of business applications.