Archiving Azure SQL Database to a BACPAC

UPDATE: The other half of this scenario has been posted. Check out Importing a BACPAC to SQL Server.
Azure SQL...

Accidental DBAs, the Developer Edition

I recently spoke at the OKC SQL Saturday. I had an wonderful time and the organizers, volunteers and other speakers...

Sql Server – Listing all tables Metadata (Table Size, row count, Index Size)

Sql Server – Listing all
tables Metadata (Table Size, row count, Index Size)

Suppose you need to find out Table size, row
count , index...

Team Purple

This is Down Tools Week at Redgate Software, and I’m visiting the office. I had hoped to dive into a...

Sql Server - Top Slowest Queries or Resource Extensive Queries

Top
Slowest Queries or Resource Extensive Queries

Whenever your database is facing any performance issue or resource scarcity,
the first step should be...

SQL Server 2016 - Are you ready for upgrade?

SQL Server 2016 has been officially launched for a little more then three month, many people are feeling excited to...

The Non-Replicated Backup Mystery

I recently configured a backup job to run on the principal server of a mirrored pair. The idea was to backup...

October precon in Orlando: “The Lifecycle Approach: Maintenance Problems & Solutions”

On October 7 we will be presenting a full day of maintenance and backup learnin’! Register here: https://www.eventbrite.com/e/sql-saturday-564-the-lifecycle-approach-maintenance-problems-solutions-tickets-26867268724 And while you’re at...

Statistics with T-SQL and R – the Pearson’s Correlation Coefficient

In this post I will attempt to explore calculation of a very basic statistic based on linear relationship between two...

Why Would I Want to Use JSON in SQL Server?

SQL Server 2016 offers built-in support for JSON, in a similar way to the support offered for XML since SQL...