The RDBMS formerly known as SQL Server vNext is now out as SQL Server 2017 Community Technology Preview 2.0. The RDBMS formerly known as SQL Server vNext is now out as SQL Server 2017 Community ...

Microsoft today announced the next version of its flagship RDBMS is officially named SQL Server 2017 and made a new Community Technology Preview (CTP) available for download. Previously referred to as ...

Microsoft yesterday announced major enhancements to its cloud data warehouse offering. Microsoft Corporate Vice President for Azure Data, Rohan Kumar, gave me the skinny in a private briefing in New ...

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 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. In part one of this article, I described a ...

Google’s first attempt at MySQL as a service, Cloud SQL, launched in 2011, was somewhat of a disappointment from the standpoint of performance and scalability. Cloud SQL Second Generation, which was ...

Let's follow up the last column with a step-by-step breakdown shows how the PowerShell script automates SQL Server backups, manages retention, logs activity and verifies data integrity. In my first ...

Isn't there an easy way to get a 2-digit day from a SQL query?<BR><BR>SELECT datepart(dd, getDate()); <BR><BR>will return "1" for July 1st. How can I get it to return ...