What's "Actually" going on with that Seek?

Rob Farley digs deeper into seeks and actual rows read, demonstrating a case where you want a non-sargable expression in the WHERE clause.

Byte Me: DeleteDeleteDelete

Introduction to the Azure SQL Database Advisor

One of the challenges associated with running your workloads in Azure SQL Database is the limited level of management oversight. Fortunately, there is an alternative approach that leverages the functionality incorporated into the recently introduced Azure SQL Database Advisor - Marcin Policht provides a brief overview.

Power BI to Azure SQL and Google Analytics

In this demo, we will give an introduction from 0 about Power BI and how to connect to Azure SQL Databases and Google Analytics

The Bad Data Shutdown

Not more hacking, but rather a data error in some cars is disturbing to Steve Jones.

3 Built-In Technologies for Centralizing SQL Server Administration

DBAs can be more effective in managing their workload by centralizing their procedures. There are several features of SQL server that can be harnessed to this end: PowerShell is only part of the solution: there is also Central Management Server, Master /Target Agent and the Remote Server Administration Tools. It's time to work out your objectives and pick the most suitable technologies to meet them.

Independence Day II

It's a holiday in the US and Steve Jones wishes everyone a good day.

Difference between SQL Server Unique Indexes and Unique Constraints

Uniqueness of values in specific columns can be enforced in a SQL Server table by creating a unique constraint or a unique index on those columns. In this article, Sergey Gigoyan looks at what the differences between the two are, and how SQL Server handles them both.

An example of how networking netted a new job

Today we have a guest editorial as Steve is away on vacation. You often hear about how important it is to network. This is a story of how my network helped me get a new job.

SSIS Design Pattern - Staging Delimited Flat Files

Learn how to use SSIS to load Delimited Flat Files to staging tables.