Chisom Kanu in Development EsProc SPL and SQL: Complementary, But Different, Technologies Have you ever surfed the internet and felt overwhelmed by personalized advertisements that appear to know your every desire? Have... 26 August 2024 23 min read 1
Ben Johnston in SQL Server How to master a database configuration audit in SQL Server: a complete guide A SQL Server database configuration audit is where most issues are found — from compatibility levels and file locations, to... 20 August 2024 16 min read
Ben Johnston in SQL Server SQL Server Configuration Audit: Complete Checklist and T-SQL Scripts Complete SQL Server configuration audit checklist with T-SQL scripts: edition and patch level, file locations, sp_configure settings, logon triggers, login... 25 July 2024 22 min read 1
Ben Johnston in SQL Server How to successfully execute a SQL Server hardware audit (complete guide) Learn how to audit SQL Server hardware and Azure cloud configuration — covering CPU, memory, storage, OS version, and backups... 17 July 2024 14 min read
Ben Johnston in SQL Server SQL Server Audit Checklist: Discovery & Setup Audit SQL Server with a structured discovery checklist. Covers server configuration, disk and memory, backups, security, database settings, and code... 06 June 2024 30 min read
Ben Johnston in SQL Server 11 proven data warehouse load patterns (complete guide, part two) 11 proven data warehouse load patterns — revised date, modified flag, hash comparison, history tables, and more — with the... 31 December 2023 30 min read
Ben Johnston in SQL Server Getting started with data warehouse load patterns (complete guide, part one) The requirements, prerequisites, and general patterns behind every solid data warehouse load — from natural keys and refresh rates to... 26 November 2023 28 min read
Ben Johnston in SQL Server SQL Server Security Features: Complete Guide Complete guide to SQL Server security features - TDE, Always Encrypted, Dynamic Data Masking, Row-Level Security, auditing, firewall rules, and... 15 October 2023 39 min read
Ben Johnston in SQL Server How to detect and mitigate Row-Level Security attacks in SQL Server (complete guide, part six) Detect and mitigate attacks against SQL Server Row Level Security (RLS) - side-channel timing attacks, excessive-error patterns, brute force attempts.... 03 October 2023 25 min read
Ben Johnston in SQL Server SQL Server Row-Level Security: Attacks & vulnerabilities (complete guide, part five) Explore SQL Server Row-Level Security vulnerabilities - direct attacks, indirect attacks, and side-channel bypasses. Essential reading before deploying RLS in... 25 September 2023 22 min read
SQL Server Ben Johnston in SQL Server SQL Server Row-Level Security: Performance, tuning, and troubleshooting (complete guide, part three) Tune SQL Server Row Level Security performance: compare authentication methods (SESSION_CONTEXT, roles, AD), optimise access predicate indexing, and troubleshoot ETL... 10 September 2023 25 min read
MySQL Robert Sheldon in MySQL MySQL Constraints Guide: PRIMARY KEY, FOREIGN KEY, NOT NULL, DEFAULT, and CHECK Constraints with Examples Complete guide to MySQL constraints - PRIMARY KEY for unique row identification, FOREIGN KEY for referential integrity, NOT NULL for... 07 September 2023 31 min read
SQL Server Ben Johnston in SQL Server Unmasking SQL Server Dynamic Data Masking, Part 5: Mitigations and Summary This is the fifth and final part of this series on SQL Server Dynamic Data Masking. In this article, I’ll... 30 July 2023 12 min read
SQL Server Ben Johnston in SQL Server Unmasking SQL Server Dynamic Data Masking, Part 4, Unmasking Formatted and Unformatted Text Continuing from the previous entry in this series on security concerns with using Dynamic Data Masking, in this article I... 27 June 2023 30 min read
T-SQL Programming Greg Larsen in T-SQL Programming SQL Subquery in SELECT: Examples & Syntax Guide Learn to embed subqueries inside a SELECT statement in SQL Server. Covers scalar subqueries, correlated subqueries, derived tables, and how... 26 June 2023 15 min read
SQL Server Ben Johnston in SQL Server SQL Server DDM Security Risks: Side Channel Attacks and Partial Unmasking SQL Server Dynamic Data Masking can be bypassed: learn how side channel attacks use range queries to infer masked values,... 14 June 2023 31 min read
SQL Server Ben Johnston in SQL Server SQL Server Dynamic Data Masking Setup Guide Set up SQL Server Dynamic Data Masking step by step. Covers ALTER TABLE masking syntax, mask functions (default, email, random,... 07 June 2023 28 min read
SQL Server Ben Johnston in SQL Server SQL Server Dynamic Data Masking: Introduction and Use Cases (Part 1) SQL Server Dynamic Data Masking (DDM) obfuscates column data for unauthorized users without changing the stored data. Part 1 introduces... 26 May 2023 13 min read
T-SQL Programming Greg Larsen in T-SQL Programming Paging Data in T-SQL Sometimes when working with very large sets of data, you may not want to return all of the data at... 20 March 2023 10 min read
Blogs Dennes Torres in Blogs What’s new in T-SQL in SQL Server 2022 There are many new features in SQL Server 2022. In relation to T-SQL querying, there are a few as well... 04 July 2022 8 min read
