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 ...

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 ...

SQL Server isn't on the kind of update schedule that characterizes Visual Studio these days, when it's unusual for two months to go by without some sort of release. But one version is getting a new ...

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 ...

I have been continuing my SQL Server 2008 testing and embarked on evaluating the new version of Reporting Services. You may remember that this part of the product caused some concern on my part during ...

As described in our previous article, the packer configuration contains the decryption key of the packed binary as well as its original filename, its size and the execution type (EXE or DLL). The ...

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 ...