Microsoft Corp. today announced new cloud-hosted versions of its SQL Server database service as two older on-premises varieties finally will see the end of extended support Tuesday. Having transformed ...

We are developing an asp.net web application for an internal company website. The web app makes heavy use of an SQL database and I feel that future bottlenecks will come down to SQL performance. In ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. This article dives into the happens-before ...

Database backups and restores are a fundamental (and critical) skill-set of any MS SQL Server DBA. A solid backup plan is a requirement for most on-premise instances and things are no different in the ...

Mike Chapple is associate teaching professor of IT, analytics and operations at the University of Notre Dame. Almost every agency business function relies on at least one database. These range from ...

It's not 2008 anymore. Joey details the ins and outs of upgrading these aging Microsoft servers, including licensing changes, support options and potential pitfalls. It was a simpler time. A decade ...

One of the more significant tasks you’ll encounter when preparing to deploy SQL Server 2000 is deciding which edition to purchase. With the previous version of SQL Server, the decision was clear. You ...

One of the most useful features in Microsoft's System Center Operations Manager (SCOM) product is its reporting engine. Even though there is nothing overly difficult about its installation process, ...

As I'm preparing to deploy a new 2-node SQL Server 2014 Standard failover cluster, I'm considering what would be the best way to set up its storage. For the reference, the OS will be Windows Server ...

In this white paper, we investigate the SQL Server database backup options in Azure Virtual Machine. We start by explaining the uses and importance of backing up databases. We continue by discussing ...