Power BI Custom Visuals Class (Module 11 – Calendar Visualization)

In this module you will learn how to use the Calendar Visualization Power BI Custom Visual.  The Calendar Visualization is...

Recipe for an awesome (free) SQL Server workstation

Windows 10. Where we're going we don't need legacy software, but if you do, then download PowerShell 5.0 instead.
SQL Server...

Script for creating test data for odds ratio

Make sure you have a working version of SQL Server 2016.
USE [master]

GO
/****** Object: Database [WorldHealth] ******/

CREATE DATABASE [WorldHealth]

CONTAINMENT = NONE

ON PRIMARY

(...

SQLPSX is Finally Getting Updated

The most current code is now on Github, with the Codeplex version being depreciated. You can read all about the...

T-SQL Tuesday #081: Getting Sharper

Sharpen Something
This month I am the host of the TSQL Tuesday blog party. In the invite, which can be read...

T-SQL Tuesday #081: Getting Sharper

Getting sharper at JSON through a little experimentation.
Related Posts:

Passion, Challenges, and SQL February 12, 2019

T-SQL Tuesday #097: Learning Plans December 18, 2017

T-SQL Tuesday 109: Influence Somebody Invite...

Visual Studio Basics for use with ReadyRoll

This is the 3rd post in the series: SQL Server and Continuous Integration. This time I’ll cover the prerequisites of using ReadyRoll...

Audit All Select Statements

Legislation and regulation sometimes dictates that certain activities must be tracked within a database. On occasion, it will be required...

Azure SQL Database For Your First Database

This is post 8 supporting  Tim Ford’s (b|t) initiative on #iwanttohelp, #entrylevel. Read about it here.
In post #6, I talked about...

Does sp_rename on a column preserve the ms_description?

Did some checking as couldn't find help in the MSDN documentation. My test on SQL 2016 shows that since the...