Storage options for SQL Server database files in Azure
If you are using SQL Server in an Azure VM (IaaS) you have a number of options of where to store the database files (.mdf, .ldf, and .ndf). Most...
2019-01-29
430 reads
Storage options for SQL Server database files in Azure
If you are using SQL Server in an Azure VM (IaaS) you have a number of options of where to...
2019-01-29
1,075 reads
Opening a Twitch Channel, Data Wisdom
I want to let you know that I’m starting a channel on Twitch. You’ll be able to see it here. I’m going to start doing regular live events on...
2019-01-29
5 reads
Opening a Twitch Channel, Data Wisdom
I want to let you know that I’m starting a channel on Twitch. You’ll be able to see it here....
2019-01-29
185 reads
Query tuning: The IN clause
This post will cover the IN clause and another way to rewrite the same logic. I don’t intend to say...
2019-01-29
2,676 reads
Cardinality: Not Just For The Birds
Watch this week’s episode on YouTube.
When building indexes for your queries, the order of your index key columns matters. SQL...
2019-01-29
1,027 reads
Cardinality: Not Just For The Birds
Watch this week's video on YouTube
When building indexes for your queries, the order of your index key columns matters. SQL Server can make the most effective use of an...
2019-01-29
7 reads
Cardinality: Not Just For The Birds
Watch this week's video on YouTube
When building indexes for your queries, the order of your index key columns matters. SQL Server can make the most effective use of an...
2019-01-29
8 reads
Authentication considerations for your applications when migrating to Azure SQL Managed Instances
This blog post is related to my previous blog post on Azure SQL Managed Instances:
Azure SQL Managed Instance – full blown...
2019-01-29
351 reads
Azure SQL Managed Instance – full blown SQL Server in the cloud….?
This blog post is one that I have had percolating in the background since around November 2018.
My good mate John...
2019-01-29
1,179 reads
Blogs
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...
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
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