Understanding Bit Manipulation Functions: BIT_COUNT, GET_BIT, and SET_BIT in SQL ...
Introduction SQL Server 2022 introduces powerful bit manipulation functions that allow for efficient handling of binary data. These […]
SQL Server 2022
[Video] I Must Be an Idiot: Automatic Tuning Never Works ...
I don’t get it. I’ve given this feature one chance after another, and every time, it takes a […]
Power what’s next with limitless relational databases from Azure
At Microsoft, we’re seeing firsthand how data is powering incredible innovation and accelerating more than just a platform […]
Batch Execution Mode on a Rowstore in SQL Server 2022
Batch execution mode is a new optimization feature in SQL Server. In this article, we’ll explore how batch […]
Protect SQL Server 2014 workloads with Azure flexibility
SQL Server has brought reliability and security to mission-critical workloads for 30 years. SQL Server 2022, released November […]
Managing Query Store Hints
I wrote about query store hints before when they were first released in Azure SQL databases. However, […]
Secure your AI using SQL Server Machine Learning with Microsoft ...
Microsoft SQL Server Machine Learning Services is a feature that allows you to run Python, R, Java, and […]
It’s Been 6 Months. SQL Server 2022 Still Isn’t Ready ...
Six months ago today, Microsoft announced that SQL Server 2022 was ready. Except it wasn’t. And it still […]
Free Webcast Next Week! What’s New (and Actually Good) in ...
It’s May 2023, and believe it or not, some of the flagship features in Microsoft’s latest version still […]
How to Go Live on SQL Server 2022
You’re planning to migrate to SQL Server 2022, and you want your databases to be faster after the […]
GENERATE_SERIES: My new go-to to build sets
I have come across a lot of use cases for manufacturing rows on the fly, aside from […]
Accelerated Database Recovery enhancements in SQL Server 2022
Part of the SQL Server 2022 blog series. We are excited to share that there are several Accelerated Database […]
Do you need Trace Flag 460?
For most people that are reading this post, I’d venture to guess that you have no idea what […]
Event exceeds the number of allowable bound actions
Did you know that there is a limit to the number of actions you can add to a […]
SQL Server 2022: Measuring Extended Events Performance Impacts
Have you ever wondered if Extended Events is affecting the performance of your workload? I have written a […]
Easily migrate SQL Server applications to the cloud with Azure
Microsoft Azure knows SQL Server best and will support your cloud migration at no cost for qualifying scenarios. […]
How to Install SQL Server and the Stack Overflow Database ...
To follow along, you’ll need: An Apple Mac with an Apple Silicon processor (M1, M2, etc – not an […]
Working with time series data in SQL Server 2022 and ...
Part of the SQL Server 2022 blog series. Time series data is a set of values organized in the […]
T-SQL Language Changes in SQL Server 2022 Part 3
SQL Server 2022 is in preview and I wrote a previous article on the T-SQL language changes. This […]
SQL Server 2022: How Auto-Drop Statistics Work
Auto-Create statistics is a well-known feature critical for the database performance. When one statistic is auto created, […]
SQL Server 2022 Paid Editions Require a Licensing Key
The post SQL Server 2022 Paid Editions Require a Licensing Key appeared first on SQLServerCentral.
Cardinality Estimation Feedback in SQL Server 2022
Part of theSQL Server 2022 blog series. Cardinality estimation (CE) is a process used by the query optimizer […]
SQL Server 2022: Azure AD Authentication
SQL Server 2022 is finally GA and one of the features I was most expecting is finally […]
Manage, govern, and secure all your SQL Servers with new ...
Part of the SQL Server 2022 blog series. In the face of changing market conditions and pressure to accelerate […]
SQL Server 2022 Paid Editions Require a Licensing Key.
For the final release of SQL Server 2022, Microsoft popped a surprise that wasn’t in the release candidates: […]
SQL Server 2022 Release Date: November 16, 2022
Microsoft released SQL Server 2022 today, November 16, 2022. The footnotes indicate: SQL Server 2022 free editions (Developer […]
SQL Server 2022 is now generally available
Part of theSQL Server 2022 blog series. Today, we announced the general availability of SQL Server 2022, the […]
Memory Grant Feedback: Persistence and Percentile Grant
Part of the SQL Server 2022 blog series. Memory grant feedback (MGF) is an existing feature in SQL […]
Intelligent Query Processing: degree of parallelism feedback
SQL Server 2022, Updates Part of the SQL Server 2022 blog series. DOP inefficiencies are a constant challenge; […]
What’s New in SQL Server 2022: GENERATE_SERIES()
I’ve been doing a lot of work with SQL Server 2022 lately and one of my absolute favorite […]
Data Virtualization with PolyBase for SQL Server 2022
Part of the SQL Server 2022 blog series. Microsoft SQL Server 2022 introduces the newest version of PolyBase, and […]
Backup and restore to URL for S3-compatible object storage
Part of the SQL Server 2022 blog series. Backup and restore to simple storage service (S3)compatible object storage is […]
Azure Synapse Link for SQL
Near-real-time analytics for transactional workloads Part of the SQL Server 2022 blog series. Traditionally, data to serve analytical systems […]
Intelligent Query Processing: feature family additions
Part of the SQL Server 2022 blog series. SQL Server 2022 introduces a handful of new members to the […]
Query Store hints in SQL Server 2022
Part of the SQL Server 2022 blog series. Query Store is one of the most powerful database-scoped features […]
SQL Ledger: Protecting Data in Azure SQL
Here in Malta, there are many I-Gaming companies. The I-Gaming business creates an important movement for the Maltese […]