Azure Data Lake Store Gen2 is GA
Azure Data Lake Store (ADLS) Gen2 was made generally available on February 7th. In short, ADLS Gen2 is the best of the previous version of ADLS (now called ADLS Gen1)...
2019-02-19
112 reads
Azure Data Lake Store Gen2 is GA
Azure Data Lake Store (ADLS) Gen2 was made generally available on February 7th. In short, ADLS Gen2 is the best of...
2019-02-19
811 reads
How to get Live Execution Plan using Extended Events
Introduction
Have you ever found yourself in a situation where you were supposed to troubleshoot a long running expensive query that...
2019-03-06 (first published: 2019-02-19)
6,862 reads
Do You Have a SQL Server Estate?
At Redgate, we do a lot of research. Maybe not as much as Microsoft Research, but we are always trying...
2019-02-19
864 reads
Finding single use plans in the plan cache
A single use plan is an entry in the SQL Server plan cache that was only used once. When a...
2019-03-07 (first published: 2019-02-19)
3,924 reads
COUNT, DISTINCT, and NULLs
Watch this week’s episode on YouTube.
One thing I see fairly often (and am occasionally guilty of myself) is using COUNT(DISTINCT)...
2019-03-05 (first published: 2019-02-19)
3,592 reads
COUNT, DISTINCT, and NULLs
Watch this week's video on YouTube
One thing I see fairly often (and am occasionally guilty of myself) is using COUNT(DISTINCT) and DISTINCT interchangeably to get an idea of the...
2019-02-19
15 reads
COUNT, DISTINCT, and NULLs
Watch this week's video on YouTube
One thing I see fairly often (and am occasionally guilty of myself) is using COUNT(DISTINCT) and DISTINCT interchangeably to get an idea of the...
2019-02-19
20 reads
SQL Server, What's In My Buffer Cache?
When SQL Server reads pages it stores them in an area of memory called the buffer cache, things like memory...
2019-03-06 (first published: 2019-02-19)
2,293 reads
Interview with Uwe Ricken
I have just done my first interview! The very special guest was Uwe Ricken!
My idea for the interview was...
2019-02-19
118 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 Gurgaon Air Testing Laboratory is owned by FARE LABS Pvt. Ltd.
One lab that has received NABL accreditation is Fare Labs Air Testing Laboratory. Through...
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