Data Warehousing Tip #8 – Make it better
In this article I’ll discuss making your data warehouse better. I’ll admit that this is a pretty obvious aspiration, but...
2019-02-11
855 reads
Blog Posts
Last Week Reading (2019-02-10)
Hello Data Folks! It has been a very fast week and an extensive weekend whilst I have been at SQL...
2019-02-11
127 reads
Looking for More Storage
I got a new cell phone. Not big news, but it’s primarily because I need want more storage. It’s a...
2019-02-11
212 reads
Memory Grants part 5: Query hints
Proceed with caution, if you’re thinking of using query hints. This post will specifically cover min_grant_percent and max_grant_percent.
My opinion on...
2019-02-11 (first published: 2019-01-22)
10,286 reads
Query Store and a READ_ONLY Database
What happens in Query Store when the database itself is READ_ONLY? Yeah, I don’t know. Let’s find out. READ_ONLY The only way to find out how this works is...
2019-02-11
10 reads
Quick tip: Speeding up deletes from SSIS execution log
If you have SQL Server Integration Services installed on your server, and you left the default configurations a table named sysssislog is created on MSDB database, it contains logging entries...
2019-02-11
20 reads
Weekly reading #2
Good morning! It is Monday! We spent the weekend in Kraków taking part in the SQLSaturday #824. It was a...
2019-02-11
118 reads
Why You Shouldn't Use SELECT * In Production Systems (EVER!)
OK so the title is a bit of a bold statement but bear with me, I’ve been burned by this...
2019-02-11 (first published: 2019-01-23)
6,845 reads
Azure Virtual Machine Boot Diagnostics
If you have ever rebooted a virtual machine and feel like you are in the dark to it’s current state,...
2019-02-08
384 reads
Developing pipelines in Azure Data Factory using Template gallery
(2019-Feb-08) I often see demos of Azure Data Factory (ADF) development techniques with a modest set of activity tasks and not...
2019-02-08
692 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