Poking the Bear

If you're an experienced, knowledgeable, seasoned (I won't say old), SQL Server data professional, and you choose to use Trace Events (Profiler), more power to you. That's it. That's all I have to say. Do what you think best. I'm never, ever (again), going to second guess you. Further, my apologies for ever having done […]

The Temp Alias

Connect to SQL Server with Python to Create Tables, Insert Data and Build Connection String

Data Activity Tracking Using SQL Triggers

This article goes into a framework for tracking data manipulation activity using a few triggers.

How to Use Any SQL Database in GO with GORM

ORMs (Object Relational Mappers) are tools (libraries, modules, packages) that provide the functionality for interacting with SQL databases. This article will look at how to use any SQL Database in GO with GORM.

The Availability Group Secondary Connection

The DAX Text Contatenation

Making the World Better

Steve reminds us about being charitable if we are fortunate enough to do so.

A Real-world Implementation of Database DevOps: People, Processes, Tools

This series of articles describes a path you can take to transforming an existing, manual and error-prone database development and release process into an automated and reliable Database DevOps 'pipeline', starting here with an overview of what we set out to achieve, and the people, processes and tools involved.

SQL RAISERROR to Better Handle Errors

Learn how and why to use RAISERROR in your SQL Server code to be able to better handle errors that may occur during code execution.