Joey on SQL Server A Closer Look at the Newest Azure SQL Database Features Microsoft's cloud DBaaS has had a whirlwind month with the introduction of managed instances, database migration tools ...

The SQL Server technology family's innovations extend beyond the "box product" (i.e. on-premises SQL Server), though. For example, Microsoft is bringing Azure SQL Database Managed Instance to ...

Microsoft's database releases from 2008 and 2010 reach end of extended support. In response, Redmond says, that for many customers, the time for cloud migration has arrived.

PolyBase, a data virtualization feature for SQL Server, allows users to seamlessly query data from various external sources directly using T-SQL (Transact-SQL) without the need for separate client ...

One way that organizations are storing data in the cloud is by moving their databases to the cloud. What once meant building an entire physical server, patching it, installing software like Microsoft ...

Azure SQL Managed Instance General Purpose is "a tier of Microsoft's relational database service, based on SQL Server, that operates like an on-premises SQL Server instance," Snodgrass explained ...

How to Synchronize Two Microsoft SQL Databases. If your business uses Microsoft SQL Server, you may want to have multiple instances of servers on multiple computers for synchronization or backup ...

Here is a list of common wait types and techniques that every DBA (or wannabe DBA) should know. While there are many more wait types than listed here, understanding these will give you a leg up when ...

Pairing your on-prem SQL Server with a cloud-based instance for high availability has its challenges, but they can be overcome. Here’s how.

Ask 10 people 'What is high availability?' and you might get 15 different answers. For the purposes here, HA will be defined as ensuring SQL Server is operating when and as needed. 'When' takes into ...