Year in Review 2018 – The Year of Making a Difference – Up to 50
Rough Year, But 50 Kids, Can’t Beat That!
Last year was a pretty rough year personally. I totaled two cars, not...
2019-01-04
154 reads
Blog Posts
Automating CRUD procedures generation using T-SQL (enhanced).
In this post I will describe the helper procedure that based on metadata generates numerous database objects around views and...
2019-01-03
394 reads
Event Tracing for Windows Target
There are many useful targets within SQL Server's Extended Events. Of all of the targets, the most daunting is probably the Event Tracing for Windows (ETW) target. The ETW...
2019-01-03
17 reads
Event Tracing for Windows Target
There are many useful targets within SQL Server’s Extended Events. Of all of the targets, the most daunting is probably...
2019-01-03
1,357 reads
File Maintenance – Cleaning Up Old Files
Using SSIS to Maintain the File System
We have all run into a need or a desire to clean up old...
2019-01-03 (first published: 2018-12-21)
2,881 reads
Forecasting Kyle Kuzma’s Field Goal Percentage (FG%)
More and more tools are becoming available for data analysts and data scientists. These tools provide convenience and lower the bar...
2019-01-03 (first published: 2018-12-22)
2,450 reads
Let’s talk SQL Server Waits: Topic 1 – SOS_SCHEDULER_YIELD
Over the next few weeks we will be reviewing some of the common SQL Server Waits. We will explain what...
2019-01-03
1,565 reads
Query Store max size limit is not a hard limit
If you’re on SQL Server 2016 or above, maybe you’re thinking about using the Query Store. That’s good! It’s an...
2019-01-03
1,651 reads
Some of my goals for 2019
In late December 2018 I had a discussion with Amanda Martin the PASS Community Manager around things that I would...
2019-01-03
211 reads
Speaking at DataGrillen 2019
I’m delighted to announce I’m selected to speak at the 2019 edition of SQLGrillen DataGrillen. This is a German conference with the catchy tagline “Data, beer und Bratwurst”. I...
2019-01-03
18 reads
Blogs
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...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
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