Automating SQL Server Inventory Collection with SQLInventory
Learn about a free inventory tool to help you keep track of basic information on your servers.
Own Your Mistakes
Hello, Grant again as Steve is on sabbatical. My evenings and weekends are currently being used to update my SQL Server query performance book for 2025. I really enjoy it because writing the book forces me to structure my learning on SQL Server 2025, not just hit it in some slipshod manner. Plus, I've got […]
Parameterize Connections in Microsoft Fabric Data Factory using Variable Libraries
Building pipelines in Microsoft Fabric can be complicated, and it's easy to write code that is hard to maintain. Using parameters in your connections helps to build pipelines that are easily configured.
DISTINCT and UNION: What happens when you use them together?
When I was perusing my LinkedIn feed the other day, I came across this thread about using SELECT *. In one of the replies, Aaron Cutshall noted that: “Another real performance killer is SELECT DISTINCT especially when combined with UNION. I have a whole list of commonly used hidden performance killers!”
Filling Big Shoes
Hey all! It's me, Grant. For those who don't me, Grant Fritchey. I work with Steve Jones, the person normally talking to you here. Yes, Redgate actually employs me, and continues to. I don't know why either. Anyway, Steve is off for a few weeks on his sabbatical. More power to him and I hope […]
Stairway to Snowflake Level 8 - Event Tables
In this next level of the Stairway to Snowflake, we delve into Event Tables. These are used to capture telemetry from your Snowflake database.
How SQL Server 2025’s Optional Parameter Plan Optimization Works
SQL Server 2025 improved PSPO to handle multiple predicates that might have parameter sensitivity, and that’s great! I love it when Microsoft ships a v1 feature, and then gradually iterates over to make it better. Adaptive Memory Grants were a similar investment that got improved over time, and today they’re fantastic.
How to Work with RStudio and SQL Server
Learn how to get started running R scripts in R/Studio for data analysis.
Segments for Protection
Computer network security is important, and it's something we ought to be more concerned with as data professionals.
Data Encoding Schemes
Your choice of how you encode data can be significant. With computers and databases, you have a wide range of options. As a programmer, you will likely be called upon at some time in your career to design and coding scheme for particular application. It would really help if you at least avoided designing a bad one.
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Forums
How Can SQL Server Detect Application Errors When Developers Can’t?
Comments posted to this topic are about the item How Can SQL Server Detect...
Getting Database MaiL Profiles
Comments posted to this topic are about the item Getting Database MaiL Profiles
Preserving Data
Comments posted to this topic are about the item Preserving Data
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers