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.
Stairway to SQL Server Replication: Level 3 - Transactional Replication – The Publisher
The Publisher is the database where all
replicated data originates. Each Publisher can have multiple publications
defined within it. Each publication contains a set of articles that all need to
reside in a single database. Each article corresponds to all or part of a single
database object. A single database object can map to an article in more than one
publication.
The Tech That is Gone
As we start a new year, Steve looks back at old technology that doesn't exist anymore.
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 […]
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Having a Little Fun at SQL Server Central
Comments posted to this topic are about the item Having a Little Fun at...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers