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
Tag: sql server
Getting Started in “Data”
Here I’m talking to someone trying to break into “Data” as a career field in a small to medium sized company. This might mean moving from help desk or marketing or customer service to DBA, Data Analyst, or Data Engineer. These data jobs reflect a LOT of overlap when you work in smaller companies, as I … Continue reading Getting Started in “Data”
Columnstore Index Goodness
In case I needed a reminder of how cool columnstore indexes are for analytic queries, I made this example to jog my memory. I used the StackOverflow 180 GB sized database you can download from Brent Ozar's site. I have it running in VMWare Workstation pro, but these days you can run your SQL Server … Continue reading Columnstore Index Goodness
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
Justin Onstot 