A Primer on Attaching Databases with PowerShell Method AttachDatabase

A Primer on Attaching Databases with PowerShell Method AttachDatabase

Attaching a SQL Server database using PowerShell can be straightforward. Here's an effective and easy approach using the...

BI Training with Eugene Meidinger

I’ve known Eugene Meidinger (SQLGene) for a number of years and we share a lot of interests outside of technology. We’re both avid boardgame and card game players, though...

Using Spark Connect from .NET

Introductory Ramble Spark Connect In July 2022, at the Data and AI summit, Apache Spark announced “Spark Connect,” which was a way of connecting to Apache Spark using the...

Just Buy the Keyboard

The holidays have passed and it’s a new year. You probably have a gift card or two and haven’t decided how to use it yet. Allow me to help:
Buy...

Architecting Zero Downtime Deployments at THAT Conference

Thanks to everyone that came to my talk at THAT Conference. The deck is here, if you want to download it and use it as a resource, or to...

Fabulous Stuff in Fabric – Part 3: Shortcuts

A while ago I had a little blog post series about cool stuff in Snowflake. I’m doing a similar series now, but this time for Microsoft Fabric. I’m not going...

Last Weeks Reading (2024-01-28)

📰 News Fabric end-to-end use case: Data Engineering part 2 – Pipelines If you’re new in Microsoft Fabric – check this series and build it with Sam. Set up...

Off to THAT Conference

I’m in Round Rock, TX today at THAT Conference. I attended THAT Conference in Wisconsin Dells last summer, and it was fun. I took my wife, but I wish...

Troubleshooting SQL Server Error 8623: The query processor ran out of internal resources and could not produce a query plan

SQL Server Error 8623

At least once day, an application for one of the databases I manage gets this error:The query processor ran out of internal...

Videos from MITRE ATT&CKcon 4.0

If you aren’t familiar with the ATT&CK framework and knowledge base, it’s a tool to help classify and understand cyberattacks. Recently (Oct 2023), ATT&CKcon 4.0 was held and MITRE...