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.

Creating and Using Inline Table-Valued Functions

Inline Table Valued Functions (iTVFs) are one type of user defined function that is available to implement in SQL Server since SQL Server 2000.

iTVFs remain a very useful tool in our SQL armoury, so let's quickly revisit them and the different ways we can use them in our code.

Your Data After Life

Today Steve thinks about what to do when planning for your digital assets after you pass.

Changing Computer Retail

The way we build and buy computers has changed.