Data Lifecycle Management using SQL Server

With the data proliferation issues, a well-defined lifecycle for data retention is a growing demand.

Go Code

Steve Jones wants more people to learn to code.

Azure SQL Database - Implementing Azure AD Authentication

Marcin Policht focuses on the specifics of using Azure Active Directory to authenticate to Azure SQL Database.

Byte Me: Plugged in

Find and Remove Duplicate Rows from a SQL Server Table

Though duplicate rows are bad practice, sometimes they're necessary for a short time. But how do you clean your tables when they're no longer needed? Sergey Gigoyan provides a few different solutions.

Bring Solutions

In today's world, technology workers need to point out solutions, not problems.

Using OVER() to Remove Duplicate Rows

Tables used purely for reporting sometimes lack a unique identifier. Find out how to remove duplicates from such a table when data loads go bad.

SQL Server Timeouts During Backups and CHECKDB

So you’re hosting your SQL Server in the cloud, and you’ve noticed that when you’re running a backup or a DBCC CHECKDB, you suffer from extreme performance problems - what's going on? Brent Ozar explains.

I can ODBC clearly now

ODBC is the closest thing we have to a universal standard for data access across platforms, applications and data sources. So why doesn't DocumentDB support it?

TempDB growth due to version store on AlwaysOn secondary server

On a not-so-busy day, I received an alert saying tempdb has grown to 90 percent of the drive size and there is only 10 percent space left on the drive. The server is a SQL Server 2014 instance and hosts AlwaysOn secondary databases.