Fuzzy Processing

There are times when you don't want to get exact mathematical calculations in data processing, and Steve Jones talks about one of them today.

Stairway to DLM Dashboard Level 1: An Introduction

In the first article of this stairway, learn what DLM Dashboard can do and how it provides a useful service to DBAs and developers.

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.