Difference Between Restore with Recovery & Restore with Norecovery
Every tech-conscious person is familiar with restoration process in the world of computing. This process is usually followed by the...
2018-12-13
44,234 reads
Change Tracking Inserts Require SELECT Permission
I’ve been writing about change tracking in SQL Server for some time now, but I recently came across a permissions...
2018-12-13
205 reads
Things I Learned at Summit v20 - Visual Studio Code
Part of a series of posts on cool stuff I learned at PASS Summit v20 (2018) - in this post we'll...
2018-12-13
253 reads
Setting up SQL Server replication in containers
Last week I saw a thread on twitter about how to get replication setup for SQL Server running in a...
2018-12-13
846 reads
The Default Frame for Window Functions
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-12-13
905 reads
Naming Convention Hall of Shame
Call me pedantic, but I can be a stickler for standardized naming conventions. Whether it’s application code, database objects, documentation,...
2018-12-13
214 reads
The Eleven Days of Festivus 2018
It’s that time again! My Eleven Days of Festivus blogging extravaganza is now in its third year, and I’m happy...
2018-12-13
173 reads
SSMS – Docker SQL Server
once we install SQL Server on Docker which we discussed in our last blog, we can connect Docker SQL Server...
2018-12-13
250 reads
Some differences with SQL Server when running on AWS RDS
If you plan on using Amazon Web Services (AWS) to host your SQL Server based applications in the cloud, then...
2018-12-12
886 reads
Some databases may show a NULL collation in the sys.databases DMV
While working on my Swart’s Ten Percent Rule post last week, I needed to test the Windows version of the...
2018-12-12
235 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