Find Char nullables to possibly go for not nullables

I often find columns in tables of the databases that are defined to allow NULLs but have non NULL values. That’s actually an...

Comments on Proposed Changes to the NomCom Process

On Friday Thomas LaRock posted Changes to the NomCom Process on the PASS blog for comment prior to the Board...

Change Tracking for Data Warehouse Loads (Webinar)

For data warehouse professionals, data change detection is is a central part of what we do. Accurately detecting new, changed,...

Now exactly which proposal is this

Introduction

Oft times we are forced into situations where we clearly need to think outside of the box. A case at...

Another Source of Knowledge

It started with a tweet from one the many members of the #sqlfamily who always has something meaningful to say,...

SQL Server Locks – Back to Basics

A fundamental component of SQL Server is locking and locks. The locking mechanism helps to control access to resources to help maintain data integrity.
Related Posts:

An Experiment with Deadlocks March...

SQL Server Locks – Back to Basics

Prelude in SQL Minor
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to...

Trekking through the DAX Jungle In Search of Lost Customers

I like to think I’m proficient at writing DAX and building SSAS tabular models. I enjoy a good challenge and...

Installation of SQL Server (Part 2 - Post-installation)

Previously we discussed about the pre-installation consideration, which can be found here. In the second part of this series, we...

Goodness-of-Fit Testing with SQL Server Part 6.1: The Shapiro-Wilk Test

By Steve Bolton
…………Just as a good garage mechanic will fill his or her Craftsman with tools designed to fix specific...