Achievement Unlocked – SQL Bits
Several weeks ago, while on a flight traveling home from San Francisco, I received an exciting email. I had submitted...
2019-02-15
489 reads
Practical Web Scraping–Getting Started
As part of my learning goals for 2018, I wanted to work through various books. This is part of my...
2019-02-15
1,374 reads
Partitioning 4: Finding partitioning in DMVs and Object Explorer
Happy Friday! Today’s post will be light on the performance side and instead, I’m going to talk about how to...
2019-02-15
1,934 reads
ASF 019 video invitation
Check how many bicycles he has got at home and where was the destination of last year of a 400...
2019-02-15
111 reads
Speaker at SQL Saturday’s Guatemala city 2019
I’m very happy to announce that for the second year in a row I will be participating as speaker in...
2019-02-15
185 reads
Learn about the State of Database DevOps Next Week
It’s a week to my webinar with Donovan Brown (bt, yg), leader of the League of Extraordinary Cloud DevOps Advocates,...
2019-02-14
230 reads
DBA Myths: Can a differential backup get bigger than the full backup?
The thing about DBA Myths is that they are generally widespread and widely believed. At least I believed this one...
2019-03-04 (first published: 2019-02-14)
2,455 reads
Undercover Catalogue 0.2.1, Fixes An Issue With The Recording Of Unicode And MAX Datatype Lengths
Please see https://sqlundercover.com/undercover-catalogue-0-2/ for full details on the Undercover Catalogue and how to obtain it.
We’ve spotted an issue where unicode...
2019-02-14
133 reads
Partitioning 3: Beyond just partition elimination
In Partitioning 2, I showed how to analyze which partitions were accessed by our Index Seek. However, we were searching...
2019-03-04 (first published: 2019-02-14)
1,869 reads
Violin Plots in Power BI
In case you aren’t familiar, I would like to introduce you to the violin plot.
A violin plot is a...
2019-03-05 (first published: 2019-02-14)
3,124 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
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...
Forums
Learn From History
Comments posted to this topic are about the item Learn From History
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...
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