Databases


Matrix

Microsoft Build: A Deeper Dive into SQL Server 2022

Build 2022 marks the long-awaited public preview of Microsoft's next-generation database engine. Here are the top seven new SQL Server 2022 features to look out for.

SQL Server 2022 Public Preview Expected Mid-Year

SQL Server 2022 is nearing a public preview release, Microsoft announced on Monday.

Tracking Performance Impacts of SQL Server Changes

Getting a bird's eye view can help to quickly spot trouble areas.

Flexible Server for Azure Database for PostgreSQL Now Commercially Available

Microsoft on Tuesday announced the "general availability" (GA) commercial release of the Flexible Server deployment option for the Azure Database for PostgreSQL service.

Introducing SQL Server 2022: Top 3 New Features Announced at Microsoft Ignite

The next major version of Microsoft's flagship database engine is now in private preview. Here's what you need to know about it.

What Is TempDB and Why Does It Matter?

Time to hit the basics and dive into how theSQL Server database engine works.

That One Easy Trick for SQL Server Performance

Here's how to fix that performance database query to speed up response time.

Vortex

Microsoft Gets Behind Eclipse Data Connector for B2B Collaborations

Microsoft recently described Eclipse Data Connector (EDC) progress, along with its efforts to align cross-organizational data-sharing needs with Europe-based privacy and security laws.

Q&A with Karen Lopez: A Database Designer's Favorite New SQL Server Features

Some SQL Server features are good, some are great -- and some are great only in the right situations and in the right hands. Learn how to spot the difference.

Almost Half of Databases Are Vulnerable to Attack

According to a five-year study by California-based security firm Imperva Inc., 46 percent of all global on-premises databases have existing flaws that can be leveraged by outside attackers.

Q&A with Thomas LaRock: The Top 5 Common SQL Server Problems (and How To Fix Them)

A Microsoft data platform MVP on the state of SQL Server today -- how it's evolved in Microsoft's Azure-first word, the best features to emerge in recent years and troubleshooting gotchas.

Microsoft to Azure Cosmos DB Users: Your Data May Have Been Exposed

Microsoft warned thousands of Azure Cosmos DB users last week that their data may have been exposed through a recently discovered security flaw in Jupyter Notebook.

Why Activity Monitor May Be Hurting Your SQL Server's Performance

As Joey explains, Activity Monitor consumes a lot of resources and yields little usable data. Here are some third-party alternatives.

Chalk Arrow

So You Need To Move Off SQL Server 2016

As of July 13, SQL Server 2016 no longer has mainstream support. Your next steps as a DBA include understanding Microsoft's support model, knowing the risks of upgrading and then biting the upgrade bullet.

Azure Arc-Enabled SQL Managed Instance Reaching GA Next Month

Microsoft plans to release a "General Purpose" version of its Azure Arc-enabled SQL Managed Instance (MI) at the "general availability" (GA) commercial-release stage, "starting July 30, 2021."

Subscribe on YouTube