Step-by-Step: How to configure a SQL Server 2008 R2 Failover Cluster Instance in Azure
Introduction
If you are reading this article you probably are still using SQL Server 2008/2008 R2 and want to take advantage...
2019-02-04
1,039 reads
Learning for Feb
By the time you read this, I’ll have decided, but I just finished the first book and need to pick...
2019-02-04
681 reads
Combine Extended Events and TagWith to Monitor Entity Framework
I’m going to start with a sentence that makes a lot of people crazy; As a DBA and database developer, I love Entity Framework. That’s right. Entity Framework is...
2019-02-04
20 reads
Combine Extended Events and TagWith to Monitor Entity Framework
I’m going to start with a sentence that makes a lot of people crazy; As a DBA and database developer,...
2019-02-04
166 reads
SQL Homework – February 2019 – Instance configurations
This homework series really has two purposes. It’s a primer for beginners. These are tasks I think most if not...
2019-02-04
205 reads
Interview Trick Questions
Anybody that has interviewed for a job has most likely run into the trick question. Some interviewers like to throw out multiple trick questions all in an effort to...
2019-02-04
6 reads
Interview Trick Questions
Today, I am diverging from the more technical posts that I routinely share. Instead, as the title suggests, I want...
2019-02-25 (first published: 2019-02-04)
3,177 reads
Cool Stuff in Snowflake – Part 5: Finding Previous Non Null Value
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to share....
2019-02-04
69 reads
SQL Server Monitoring: Keeping track of missing index requests
A lot of us turn to execution plans when we see a slow running query, and it’s not uncommon to...
2019-02-04
197 reads
Undercover Catalogue 0.2 Released
We’re pleased to announce the release of the Undercover Catalogue 0.2 and can be downloaded from https://github.com/SQLUndercover/UndercoverToolbox/tree/master/SQLUndercoverCatalogue
The new version brings...
2019-02-04
122 reads
Blogs
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Forums
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
A Worse Computer; A Better Car
Comments posted to this topic are about the item A Worse Computer; A Better...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers