Log File Architecture

SQL Log File Too Big

Is your SQL database log file too big? Maybe it is. But maybe it’s not. When log files keep growing and appear to be too big some might suggest switching to Simple recovery, shrinking the log file, and switching back to Full recovery. While this will work to shrink the file and free up disk […]

Joining a Community

In the last week I've been actively trying to join the PostgreSQL community. It's been an interesting experience. I suspect it's going to stay interesting for a while. As part of what I'm doing, I saw this excellent video from Ryan Booz, talking about joining a new community. It got me to thinking. You have […]

SQL Server Development Using Free Tools

You can make SQL Server database development faster and easier with a FREE toolkit!

Using Logging with the Delete Activity in Azure Data Factory

This short piece shows how to add logging for the Delete activity and track which files or folders are deleted.

Managed Instance Database Limits

The Great Developer Resignation

In 2021, many companies had employees leave positions. The number of people resigning from their jobs was so high that the term "The Great Resignation" began appearing in many publications. A number of industries were affected, and there are no shortage of pundits and experts analyzing why. This happened primarily in the US, but the […]

Model Good Behavior

I'm answering a question in the forums and I spot something that crawls up my spine: ;WITH... The person was using a Common Table Expression (CTE) which requires that the preceding statement in the batch have a statement terminator, the semi-colon. However, since the terminator isn't required everywhere, lots of people don't use it at […]

SQL Server Monitoring Using Free Tools

You can do essential monitoring of SQL Server instances and databases with a FREE toolkit!

Most of Us Are Vulnerable

Security is hard, and while data professionals might not be responsible for network issues, we ought to be aware that there could be vulnerabilities that might attack our systems.