Reflecting on the Mythical Man Month
Steve looks back at the Mythical Man Month, a book every software engineer and manager should read.
SQL Automate - A DBA's Time-Saving Toolkit
SQLAutomate is a lightweight PowerShell tool that simplifies SQL Server deployment by automating both installation and post-installation configuration. Whether you're setting up one instance or dozens, this guide shows how to use SQLAutomate to save time and reduce manual work.
Index Scans and Table Scans
There are several things that you can do to improve performance by throwing more hardware at the problem, but usually the place you get the most benefit from is when you tune your queries. One common problem that exists is the lack of indexes or incorrect indexes and therefore SQL Server has to process more data to find the records that meet the queries criteria. These issues are known as Index Scans and Table Scans.
Managing Fabric Lakehouse objects with the new CLI: Data Engineering with Fabric
In this next article, we are going to explore how to install, configure and use the command line to manage a couple different Fabric Lakehouse’s.
Purging Data from a Large Table in SQL Server
Purging data from a table is a common database maintenance task to prevent it from growing too large or to stay in compliance with data retention. When dealing with small amounts of data, this can be accomplished by a simple delete with no issues; however, with larger tables, this task can be problematic. Deleting records requires a lock that can block other processes from writing or even reading the data (depending on your isolation level). In this article I will share a technique I have used to work with some very large tables.
Helping Students with a Data Professional Career
Steve has advice for students looking to become data professionals.
Parameterize Connections in Microsoft Fabric Data Factory using Variable Libraries
Building pipelines in Microsoft Fabric can be complicated, and it's easy to write code that is hard to maintain. Using parameters in your connections helps to build pipelines that are easily configured.
DMV Comparison for SQL Server 2019 vs Azure SQL Database
What DMVs were added to Azure SQL Databases, and which DMVs are missing from Azure SQL Databases but still exist on SQL Server 2019 or other versions?
Greener Grass
Before I start the whining (whinging if you prefer), let me just say I have the greatest job in the world. I'm exceedingly lucky to have it. I'm grateful as can be. And someone else (looking at you Tim) can get it when they pry it from my dead cold fingers. With that out of […]
Blogs
Building a Todo List RESTful API in C++ with Docker, GitHub Actions, Azure ACR: A Beginner’s Guide
C++ is a highly versatile language for developing console applications, batch processing, and performance-critical...
Easily query your GitHub Contribution activity
By Will Assaf
For a variety of reasons, including your Microsoft MVP activity reports, you might want...
Comparing Microsoft Fabric Alternatives in AWS, GCP, and OCI in 2025
By Daniel Janik
Microsoft's unified analytics platform, Fabric, simplifies integration across various tools in Azure by offering...
Forums
SQL Automate - A DBA's Time-Saving Toolkit
Comments posted to this topic are about the item SQL Automate - A DBA's...
Reflecting on the Mythical Man Month
Comments posted to this topic are about the item Reflecting on the Mythical Man...
Updating a Data API Builder Connection String
Comments posted to this topic are about the item Updating a Data API Builder...
Question of the Day
Updating a Data API Builder Connection String
Can I use dab update to update a connection string in my Data API Builder configuration file?
See possible answers