Byte Me: Killer Conference

SQL Azure Reporting Automation

This article will talk about preparing a runbook in Azure to schedule the report of space usage of databases in Azure environment

Dealing with High Concurrency with Table Hints

Systems with a large number of requests on a critical database table are prone to blocking and slowness. We take a look at getting things done using T-SQL table hints.

Properly Persisted Computed Columns

Paul White walks through a new trace flag in SQL Server 2016 designed to yield better execution plans (and performance) for queries involving computed columns.

Statistics in SQL: Kendall’s Tau rank correlation

Statistical calculations in SQL are often perfectly easy to do. SQL was designed to be a natural fit for calculating correlation, regression and variance on large quantities of data. It just isn't always immediately obvious how. In the second of a series of articles, Phil factor shows how calculating a non-parametric correlation via Kendall's Tau or Spearman's Rho can be stress-free.

Help for DBAs Who Support SSIS…

SSIS Catalog Compare helps DBAs work with their SSIS project configurations and catalogs, deploying changes from environment to environment.

Scoring Outliers with R

What is normal? More to the point, what is abnormal? We will look at using R to score outliers in a typical monitoring dataset.

The Invisible DBA

Do you want super powers? Learn how to be an invisible DBA!

Use T-SQL to Find Folders Using the Most Disk Space

Your SQL Server drives are running out of disk space and you want a way to quickly tell which sub-directories are taking the most space - here's how to do it with T-SQL.

Setting up R in SQL 2016 – Avoiding Pitfalls

Setting up R in SQL 2016 proved to be trickier than expected, but here is how to avoid the frustrations.