The Code Freeze
Today Steve discusses code freezes, those times when you don't allow changes to be made by developers.
Today Steve discusses code freezes, those times when you don't allow changes to be made by developers.
Learn about the SQL Server plan cache and how SQL Server caches query plans, and the potential of plan cache bloat which could impact performance.
This is a list of the builds for SQL Server 2022. There are other build lists available here. A list of all the builds that I can find and install on my Build VM. If you find a build not listed here, please let the webmaster know (webmaster at sqlservercentral.com). All builds are listed in reverse […]
This article shows how you can use two Cosmos DB dataets in Azure Data Factory and join them on a common column.
Guy Glantser is an Israeli SQL Server guru with a ton of great presentations on YouTube. I’ve had the privilege of hanging out with him in person a bunch of times over the year, and I’ll always get excited to do it again. He’s not just smart, but he’s friendly and funny as hell.
I recently came back from a trip to Las Vegas. I was privileged to be able to take part in the very first Fabric Community Conference. It was a great event, well attended. BUT... It was in Las Vegas. I am not a fan. First of all, Vegas is just far too noisy for me. […]
In this article, learn how to use the PowerShell DSC to patch your SQL Server instances.
Steve asks the question today about when you might think about changing employers. He has some advice for you, whether you're happy or in need of a new position.
In this step-by-step article, learn how to quickly install Python and start writing Python code using Jupyter Notebooks or Visual Studio Code.
By Zikato
In SQL Server, using the KILL command to terminate a session results in an...
In today’s data-driven world, having the right tools to manage and process large datasets...
By Steve Jones
flichtish – adj. nervously aware how much of your self-image is based on untested...
I have few snapshot transactions , now my admin has informed me that put...
Comments posted to this topic are about the item Kubernetes is Cool, But ...
Comments posted to this topic are about the item Multiple Query Trace Flags
I want to enable two trace flags, 4199 and 4137, for a single query. How should I do this:
-- A SELECT a.AddressID , a.AddressLine1 , a.AddressLine2 , a.City , a.StateProvinceID , a.PostalCode , p.FirstName , p.LastName FROM Person.Address a INNER JOIN person.Person AS p ON p.rowguid = a.rowguid WHERE City = 'SEATTLE' AND PostalCode = 98104 OPTION (QUERYTRACEON 4199, 4137); -- B SELECT a.AddressID , a.AddressLine1 , a.AddressLine2 , a.City , a.StateProvinceID , a.PostalCode , p.FirstName , p.LastName FROM Person.Address a INNER JOIN person.Person AS p ON p.rowguid = a.rowguid WHERE City = 'SEATTLE' AND PostalCode = 98104 OPTION (QUERYTRACEON 4199, QUERYTRACEON 4137); -- C SELECT a.AddressID , a.AddressLine1 , a.AddressLine2 , a.City , a.StateProvinceID , a.PostalCode , p.FirstName , p.LastName FROM Person.Address a INNER JOIN person.Person AS p ON p.rowguid = a.rowguid WHERE City = 'SEATTLE' AND PostalCode = 98104 OPTION (QUERYTRACEON 4199), (QUERYTRACEON 4137);See possible answers