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...

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...

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 experience of working with constraints and when I got to...

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 experience of working with constraints and when I got to...

How to Use Parameters Like a Pro and Boost Performance

Yesterday I presented my favorite session “How to Use Parameters Like a Pro and Boost Performance” in the DBA Fundamentals...

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...

NULLs to Not NULLs

I have found many columns in many tables of many databases that are defined to allow NULLs but have non NULL...

Refreshing KPI Data in SSRS 2016

Continuing my blog from last week, Creating KPIs in SQL Reporting Services, I am now going to explain how to...

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...

SWITCHing IDENTITY in the Pub

I was recently talking to a friend in our local pub about a problem he had with tables not using IDENTITY...