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
SQL Server Journey Part 2: Modern Era (2017 – 2026) – AI/Cloud First
By Vinay Thakur
Following up on my Part 1 baseline, the journey from 2017 onward changed how...
Google Moves Up Post-Quantum Cryptography Timeline
By Brian Kelley
In cryptography, the RSA and ECC algorithms which we use primarily for asymmetric cryptography...
The Book of Redgate: No Politics
By Steve Jones
In today’s world, this might mean something different, but in 2010, we had this...
Forums
Dancing Robot Goes Rogue
Comments posted to this topic are about the item Dancing Robot Goes Rogue
advice as i migrate my winscp based ssis pkg to our prod server
Hi , i installed winscp on my pc, added it to GAC thru vs...
Identities and Sequences II
Comments posted to this topic are about the item Identities and Sequences II
Question of the Day
Identities and Sequences II
In thinking about the differences between the identity property and a sequence object, which of these two guarantees that there are consecutive numbers (according to the increment) inserted in a single table?
See possible answers