Midlands PASS Meeting for April 2019
The Midlands PASS April 2019 meeting will be held on April 2nd and we’ll be welcoming Matt Gordon (twitter | website)!
Meeting...
2019-02-06
143 reads
Blog Posts
SQL server connection and blocking finding script
SQL server connection and blocking finding script...
[[ This is a content summary only. Visit my website for full links, other...
2019-02-06
180 reads
SQL server connection and blocking finding script
SQL server connection and blocking finding script...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2019-02-06
13 reads
Using Cloud Academy
The other day I talked about using Microsoft Learn. Well, honestly, Cloud Academy is the learning tool I’ve been using...
2019-02-06
219 reads
Using Docker to run Integration Tests for dbachecks
My wonderful friend André Kamman wrote a fantastic blog post this week SQL Server Container Instances via Cloudshell about how...
2019-02-06 (first published: 2019-01-19)
2,276 reads
Versions of Stored Procedures
I never knew this, but stored procedures have versions.
I was browsing the CREATE PROCEDURE doc page, and stumbled upon this...
2019-02-06
1,054 reads
What is Azure Key Vault?
Keys and secrets (AKA passwords) are an essential part of data protection management not only on-premises, but within the cloud...
2019-02-06
256 reads
When the buffer pool isn’t just in memory
Last time we looked at the four major components of a computer system, and then looked at the SQL Server...
2019-02-06
196 reads
Forensic Analysis on Updated Values of Database Tables to Check Any Digital Crime
SQL Server is a relational database management product developed by Microsoft. It is prominently deployed by enterprises all over the...
2019-02-05
527 reads
Automating Database Maintenance with Jess Pomfret and dbatools
Watch this week's video on YouTube
dbatools is one of the coolest community projects I've seen - it is amazing how many commands are available to help make managing your...
2019-02-05
6 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 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