Featured

SQL Server Performance Tuning: A Far From Almost Comprehensive Guide for the Curious Coder

Part 0 - Introduction and All That Stuff.... Hello, wonderful coders! Are you ready for another thrilling adventure into the world of technology? Today, we're diving deep into the mystifying and magical world of SQL Server performance tuning. That's right, my intrepid readers, we're about to unravel the secrets behind a faster, smoother, and more … Continue reading SQL Server Performance Tuning: A Far From Almost Comprehensive Guide for the Curious Coder

Featured

Setup a Simple Transactional Replication lab

At my former employer, one of the key components of our Business Intelligence environment was transactional replication of data between production and the Data Warehouse. Because this replication was critical to our reporting/BI pipeline, not to mention my livelihood, I wanted to dig into to how transactional replication works. As usual for me, the first … Continue reading Setup a Simple Transactional Replication lab

Sarcasm and ChatGPT Simple Sentiment Analysis

I had fun with some sentiment analysis testing using the OpenAI gpt-3.5-turbo model. This came as a tangent as I was working through the Prompt Engineering for Developers class offered by deeplearning.ai. The idea is to scan through prompts on a product review site - think eBay or customer generated listings on eCommerce sites. Without … Continue reading Sarcasm and ChatGPT Simple Sentiment Analysis

Python Decorators: Adding Magic to Your Functions

In the enchanting world of Python programming, decorators work like spells, allowing you to modify the behavior of functions or methods without the need for altering their code. Essentially, these higher-order functions accept another function as input, and in return, conjure up a new function with enhanced or altered behavior. With the power of decorators, … Continue reading Python Decorators: Adding Magic to Your Functions

The Importance of Updating Statistics in SQL Server and the Challenges with Large Tables

As a database enthusiast and SQL Server aficionado, I've come across countless scenarios where performance was subpar and the underlying issues were obscured. Today, I want to shed some light on the importance of updating statistics in SQL Server and discuss why large tables with billions of rows might not be suitable candidates for auto-updating … Continue reading The Importance of Updating Statistics in SQL Server and the Challenges with Large Tables

Part 1: SQL Server Performance Tuning: A Far From Almost Comprehensive Guide for the Curious Coder

Section 1: Why Performance Tuning Matters – A Deeper Dive with Examples Ah, my knowledge-thirsty friend, you're in for a treat! Let's delve deeper into the significance of performance tuning and explore some examples to illuminate the benefits of this enigmatic art. Performance tuning is like casting a magic spell on your SQL Server, transforming … Continue reading Part 1: SQL Server Performance Tuning: A Far From Almost Comprehensive Guide for the Curious Coder