[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 […]
SQL Server 2022
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 […]
PSPO: How SQL Server 2022 Tries to Fix Parameter Sniffing
Parameter sniffing is a notorious problem for Microsoft SQL Server because it tries to reuse execution plans, which […]
Azure Data Studio August Release
Thank you to Erin Stellato (Program Manager, SQL Experiences) and Drew Skwiers-Koballa(Program Manager, SQL Experiences) for contributing to this blog. […]
What’s New in SQL Server 2022 Release Candidate 0: Undocumented ...
Microsoft has an official list of what’s new in 2022 overall, but here I’m specifically focusing on system […]
How to Install SQL Server 2022 Release Candidate 0
SQL Server 2014’s end of support date is coming in less than two years: July 9, 2024. I […]
Register today—Free Azure Data training at Data Platform Summit 2022
Data Platform Virtual Summit 2022 (DPS 2022) is just a few weeks away, running from September 1923. A […]
Establish digital trust in your data with ledger in SQL ...
Part of the SQL Server 2022 blog series. We are pleased to introduce you to ledger, a new […]
Azure Active Directory authentication for SQL Server 2022
Part of the SQL Server 2022 blog series. Azure Active Directory (Azure AD) authentication is now supported for […]
How to install SQL Server 2022 step by step
The post How to install SQL Server 2022 step by step appeared first on SQLServerCentral.
Improve scalability with system page latch concurrency enhancements in SQL ...
Part of the SQL Server 2022 blog series. Over the past several SQL Server releases, Microsoft has improved […]
SQL Server 2022: Backup Database Options to AWS S3 Bucket ...
The post SQL Server 2022: Backup Database Options to AWS S3 Bucket – Part 2 appeared first on […]
SQL Server 2022: Backup and Restore database to AWS S3 ...
The post SQL Server 2022: Backup and Restore database to AWS S3 bucket – Part 1 appeared first […]
Improve scalability with Buffer Pool Parallel Scan in SQL Server ...
This blog post is part of the SQL Server 2022 blog series. Buffer Pool Parallel Scan is a […]