Upgrading SQL Server Central

It's time to look at an instance upgrade for SQL Server Central. Or is it? Steve shares some thoughts about the process and decision making.

Introducing the MySQL DELETE statement

In this article, I focus exclusively on the DELETE statement to help round out our discussion on the core DML statements in MySQL. Overall, the DELETE statement is fairly basic, but one that’s no less necessary to have in your arsenal of DML tools.

Automate Power BI desktop data model with a PowerShell script

Learn how you can use PowerShell to update the Power BI data model.

Dealing with Deadlocks

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