In part 1 of my SQL Server 2022 features series, you learned about the improvements to the cardinality estimator component of query optimization. In this installment, you will learn about another ...

In the first of this two-part series, Microsoft's lead SQL architect explains how the company collects -- and secures -- telemetry data from Azure SQL Database customers to improve its engineering ...

In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database.

Microsoft has released the first release candidate for SQL Server 2025, touting AI capabilities and experimental features ...

Windows Server 2008, formerly codenamed Longhorn Server, is due in the second half of this year. In the first instalment of a two-part preview, we take a look at some of the key functionality in ...

How to run your own e-mail server with your own domain, part 1 Gmail? Apple? The cloud? Forget 'em all—in this series, we take your e-mail back.

In my last column (published in the February e-edition and the March print edition of DBTA), I reviewed the overall coding landscape for SQL Server with special focus on LINQ to SQL, a new technology ...

Now that you have some ideas about internal storage vs. memory after reading Part 1, here in Part 2 I'll talk about the two main types of external storage devices: direct-attached storage (DAS ...

Microsoft removes the version still included for compatibility for good. It has long been considered obsolete.

Five SQL Improvements That Are Transforming Hadoop &Big Data Analytics Several key Hive features introduced by the Stinger and Stinger.next projects are democratizing SQL on Hadoop and making Big Data ...