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

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

Goodbye Pragmatic Works

Normally when I write a blog, I start out will a Hello to my Dear Reader.   Not today.  This was almost a blog I didn't write because I...

Goodbye Pragmatic Works

Normally when I write a blog, I start out will a Hello to my Dear Reader.   Not today.  This was...