Validating Replication (All or Just One Article)
You may sometimes have reports or other processes that are dependent on transactional replication being current. If that is the case, you will probably need a mechanism to check...
2019-08-09
26 reads
Salaries in Job Ads
Hiring at Basecamp is interesting. I caught this interview and think it’s a good look at a process most of us have gone through, but perhaps not thought about....
2019-08-09
32 reads
Graph Databases – Introduction
I have been looking into this feature and also into understanding graph data in general. I believe introduction of graph database feature in SQL Server has many advantages –...
2019-08-22 (first published: 2019-08-09)
849 reads
Podcasts on Modern Data Warehouse
I did a couple of recent podcasts that I wanted to mention: The first one was with Kirby Repko from the YouTube channel SQLTalk: Modern Data Warehouse Design with...
2019-08-23 (first published: 2019-08-08)
483 reads
T-SQL Tuesday #117 Invitation – When Have You Used MOT Tables?
When Memory-Optimized Tables (MOT) were announced for SQL Server, there was a lot of excitement about the technology. After this was released on SQL Server 2014, feelings waned with...
2019-08-08
59 reads
My Preferences for SSIS Design
Lately, I have been using SSIS execution frameworks and Biml created by other people to populate data marts and data warehouses. It has taught me a few things and...
2019-08-20 (first published: 2019-08-08)
1,168 reads
Data Lake Architecture using Delta Lake, Databricks and ADLS Gen2 Part 1
I have read quite a bit about “the death of Big Data” recently. To be
honest I’ve never liked the term Big Data. It has always skewed people’s
thinking...
2019-08-08
22 reads
Data Lake Architecture using Delta Lake, Databricks and ADLS Gen2 Part 1
I have read quite a bit about “the death of Big Data” recently. To be
honest I’ve never liked the term Big Data. It has always skewed people’s
thinking...
2019-08-08
24 reads
Data Lake Architecture using Delta Lake, Databricks and ADLS Gen2 Part 1
I have read quite a bit about “the death of Big Data” recently. To be
honest I’ve never liked the term Big Data. It has always skewed people’s
thinking...
2019-08-08
284 reads
PASS Summit 2019 – spending the time
The session line up for PASS Summit 2019 was announced today...there are so many good sessions to go to..managing time and what we do with our limited time there...
2019-08-08
28 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