Databases


SQL Server 2022 Preview Available for Linux

Microsoft this week noted that its SQL Server 2022 public preview, made available late last month, can now be tried on some Linux distros.

DBAs: You Need To Learn PowerShell

It's time. Make your life a lot easier by automating those time-intensive tasks.

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.

Yellow Wire Fence Graphic

Microsoft Enables SQL Server Information Protection Scheme

The Microsoft Information Protection (MIP) service now works with SQL Server data, and can be applied using SQL Server Management Studio (SSMS), according to a Monday Microsoft announcement.

SQL Server 2022 Public Preview Expected Mid-Year

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

Making Managed Instance Better with NoRecovery

Here's how Microsoft can make data migration easier on us.

Microsoft Ending Support of SQL Server 2019 Big Data Clusters

Microsoft announced late last month that it'll be ending support for two SQL Server capabilities, with cloud services and SQL Server 2022 typically proposed as replacements.

Tracking Performance Impacts of SQL Server Changes

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

Understanding Dirty Reads: What NOLOCK Does to Your Queries

Let's break down when it's ideal to use the NOLOCK hint and when you should never use it.

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.

Subscribe on YouTube