Ethical Hacking Tutorial

This article explains ethical hacking and how this might be a career field worth pursuing.

Cross-RDBMS Code Quality Reports in Flyway

This article demonstrates how to run basic cross-RDBMS code quality checks using SQL Fluff. We analyze the results in PowerShell to produce reports and analytics on the number or types of issues found.

Using sp_prepare and sp_execute to utilize prepared SQL statements

Learn about prepared statements in SQL Server, what they are, and how to use them along with the commands sp_prepare and sp_execute.

Express.js or Next.js for your Backend Project

In this article, I will introduce two JavaScript frameworks that can be used to build backend projects.

Setting up for Team-based Database Development using Flyway Desktop

This article provides a simple demonstration of how a small team of developers might set up a Flyway Desktop project to manage, automate, and control database development.

Indexes: When Column Selectivity Is Not Always A Requirement

While preparing for my SQL Saturday Salt Lake City presentation, Climbing the B-Tree, I ran into one of the “word of mouth” facts that the first column of an index should be highly selective, i.e., it should only point to one or a few rows. This is not always the case and I’ll show you […]

Should You Use SQL Server 2022’s STRING_SPLIT?

SQL Server 2022 improved the STRING_SPLIT function so that it can now return lists that are guaranteed to be in order. However, that’s the only thing they improved – there’s still a critical performance problem with it.

The Importance of a Good Data Model in Power BI Desktop

T-SQL Language Changes in SQL Server 2022 Part 3

Learn about more of the T-SQL language changes in SQL Server 2022. This article is the third in a series and will cover the changes to the JSON functions.

Enabling digital transformation – and data modernization – with DevOp

Where does data fit into the digital transformation story? Discover how and why it deserves a place in this fascinating piece from Pramod Sadalage, principal consultant at Thought Works