With Extended Support for SQL Server 2008 and SQL Server 2008 R2 ending in July 2019, to be followed six months later by the end of Extended Support for Windows Server 2008 and 2008 R2 in January 2020 ...

In recent releases of SQL Server, Microsoft has delivered a great deal of feature enhancements and performance improvements. This rapid delivery has been facilitated by some development changes at ...

It was barely a month ago that Microsoft announced the general availability of SQL Server 2017 after having released the product in preview and release candidate forms earlier in the year. Today, at ...

On August 30, Microsoft announced the public preview of the Azure Database Migration Service (DMS) to support online migrations of various databases to Azure. What’s an “online migration”? Online ...

There are lots of ways to create MSSQL databases via PowerShell. We could invoke a T-SQL query using the CREATE DATABASE term, we could write some code to use the [Create() method with SMO] or, if ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

The only way to get extended support for 2008 versions of Windows and SQL Server is in the cloud. Here’s why you should be thinking about 2012 migrations now as well. The release of Windows Server ...

The October release of Azure Data Studio (formerly called SQL Operations Studio) includes preview support for SQL Server 2019 and more. Azure Data Studio, which was introduced last year as SQL ...

SQL Server’s new Accelerated Data Recovery feature makes database recovery a snap. How does it work? Databases are wonderful things, until they go wrong. Then you’re left waiting for a recovery to ...

As developers look to harness the power of AI in their applications, one of the most exciting advancements is the ability to enrich existing databases with semantic understanding through vector search ...