
Understanding SQL Server LEFT_SHIFT and RIGHT_SHIFT Functions
Introduction SQL Server 2022 introduced the LEFT_SHIFT and RIGHT_SHIFT functions, which allow you to manipulate numbers by shifting […]
Introduction SQL Server 2022 introduced the LEFT_SHIFT and RIGHT_SHIFT functions, which allow you to manipulate numbers by shifting […]
Introduction In SQL Server 2022, developers often need to implement conditional logic within their queries. Whether it’s selecting […]
Geographic information systems (GIS) play a critical role in emergency response planning and risk assessment. One of the […]
Introduction SQL Server 2022 introduces powerful bit manipulation functions that allow for efficient handling of binary data. These […]
I don’t get it. I’ve given this feature one chance after another, and every time, it takes a […]
At Microsoft, we’re seeing firsthand how data is powering incredible innovation and accelerating more than just a platform […]
Batch execution mode is a new optimization feature in SQL Server. In this article, we’ll explore how batch […]
SQL Server has brought reliability and security to mission-critical workloads for 30 years. SQL Server 2022, released November […]
I wrote about query store hints before when they were first released in Azure SQL databases. However, […]
Microsoft SQL Server Machine Learning Services is a feature that allows you to run Python, R, Java, and […]
Six months ago today, Microsoft announced that SQL Server 2022 was ready. Except it wasn’t. And it still […]
It’s May 2023, and believe it or not, some of the flagship features in Microsoft’s latest version still […]
You’re planning to migrate to SQL Server 2022, and you want your databases to be faster after the […]
I have come across a lot of use cases for manufacturing rows on the fly, aside from […]
Part of the SQL Server 2022 blog series. We are excited to share that there are several Accelerated Database […]
For most people that are reading this post, I’d venture to guess that you have no idea what […]
Did you know that there is a limit to the number of actions you can add to a […]
Have you ever wondered if Extended Events is affecting the performance of your workload? I have written a […]
Microsoft Azure knows SQL Server best and will support your cloud migration at no cost for qualifying scenarios. […]
To follow along, you’ll need: An Apple Mac with an Apple Silicon processor (M1, M2, etc – not an […]
Part of the SQL Server 2022 blog series. Time series data is a set of values organized in the […]
SQL Server 2022 is in preview and I wrote a previous article on the T-SQL language changes. This […]
Auto-Create statistics is a well-known feature critical for the database performance. When one statistic is auto created, […]
The post SQL Server 2022 Paid Editions Require a Licensing Key appeared first on SQLServerCentral.
Part of theSQL Server 2022 blog series. Cardinality estimation (CE) is a process used by the query optimizer […]
SQL Server 2022 is finally GA and one of the features I was most expecting is finally […]
Part of the SQL Server 2022 blog series. In the face of changing market conditions and pressure to accelerate […]
For the final release of SQL Server 2022, Microsoft popped a surprise that wasn’t in the release candidates: […]
Microsoft released SQL Server 2022 today, November 16, 2022. The footnotes indicate: SQL Server 2022 free editions (Developer […]
Part of theSQL Server 2022 blog series. Today, we announced the general availability of SQL Server 2022, the […]
Part of the SQL Server 2022 blog series. Memory grant feedback (MGF) is an existing feature in SQL […]
SQL Server 2022, Updates Part of the SQL Server 2022 blog series. DOP inefficiencies are a constant challenge; […]