Database Development Gone Wrong

I recently shared a story about how I was personally responsible for a development project going off the rails (and oh boy, did it go off the rails). It’s...

Database Development Gone Wrong

I recently shared a story about how I was personally responsible for a development project going off the rails (and...

Telegraf Setup FAQ for Troubleshooting

I often get emails asking the same time of questions about the setup of Telegraf for SQL Server and Windows...

Enable Mail Profile – Back to Basics

I’ve seen many people go through the trouble of setting up database mail and configuring SQL Agent Alerts only to...

Quick tip: Zoom in Azure Data Studio

If you finally have given a try to Azure Data Studio, and if you use it on a regular basis,...

Whats a SQL Notebook in Azure Data Studio?

Azure Data Studio is a cross-platform database tool for data professionals using the Microsoft family of on-premises and cloud data...

Differences Between the Various Binary Collations (Cultures, Versions, and BIN vs BIN2)

(last updated: 2019-03-15 @ 02:45 EST / 2019-03-15 @ 06:45 UTC )
Binary collations are, in many ways, simpler to understand than non-binary collations...

SQL Server Deadlocks

A quick video clip showing how to create a deadlock in SQL Server and find information about it.

Power BI Monthly Digest – March 2019

In this month’s Power BI Digest with Manuel Quintana [Blog | Twitter] and I will again guide you through some of...

#TSQL2sDay – #112 – Mini cookies

This months TSQL Tuesday is hosted by Shane O’Neill (Blog | Twitter) Shane explains the Topic as:

Dipping into the Cookie Jar...