Easy Open Event Log Files
Extended Events is a powerful tool with plenty of ease of use and flexibility. This flexibility allows the DBA to better service the needs of the developers when the...
2019-06-07
260 reads
Gone Fishing…
It's SQLIntersection time, and also time to meet a new member of the family. He's old enough for social media, though...
2019-06-07
20 reads
Mitre’s ATT&CK Security Framework
Mitre’s ATT&CK security framework was mentioned often at the Techno Security and Digital Forensics Conference. I admit that I’m not well-versed on it, yet. However, its purpose makes sense....
2019-06-07
56 reads
How to get Authentication Token for Dynamics 365 Finance and Operations on-premise and cloud deployments to run REST API using Powershell and the client credentials grant method
Before being able to run REST APIs to do specific tasks programmatically in Dynamics 365 for Finance and Operations (hereby known as D365FO), the application needs to be able...
2019-06-07
372 reads
Working with Arrays in Azure Data Factory
(2019-June-06) I remember I had a professor at my university who very often would encourage his students to learn and get more experienced with simple things first. Learn the basics...
2019-06-25 (first published: 2019-06-07)
49,720 reads
Common Data Model
The Common Data Model (CDM) is a shared data model that is a place to keep all common data to be shared between applications and data sources. Another way...
2019-06-20 (first published: 2019-06-06)
1,781 reads
Powershell script to find new servers in an AD domain
This is actually part of a process I am creating to automatically discover SQL Server instances in an Active Directory domain. So there...
2019-06-19 (first published: 2019-06-06)
1,372 reads
Sysinternals – A Swiss Army Knife for IT Pros
I’m at the Techno Security and Digital Forensics conference in Myrtle Beach again this year. I sat in on a presentation about performing malware analysis. The analyst began with...
2019-06-06
455 reads
To use ALTER DATABASE, the database must be in a writable state in which a checkpoint can be executed. – when moving files on an Availability Group secondary.
Here’s a little error that I stumbled across the other day when trying to migrate the data files of an Availability Group secondary node onto a nice new SAN....
2019-06-06
156 reads
Moving to a Modern Microsoft Platform
Melbourne Event – Monday 17th June 2019 (Free – including lunch and prizes) PASS, in conjunction with Microsoft, Intel and community leaders are offering free training on Moving to...
2019-06-06
10 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