Other Dennes Torres in Other SQL Server: Optimize for Ad Hoc Workloads – use or not use I used to believe this option was something almost absolute: it should be enabled as best practice. I was in... 06 December 2023 5 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
Ben Johnston in SQL Server SQL Server Row-Level Security: Integration, anti-patterns, and alternatives (complete guide, part four) A complete guide to SQL Server Row-Level Security integration, anti-patterns, and alternatives.… 17 September 2023 20 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
SQL Server Ben Johnston in SQL Server A practical introduction to Row-Level Security in SQL Server (complete guide, part one) Row-Level Security in SQL Server lets identical queries return different rows per user. Here's how it works, when to use... 01 August 2023 16 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
Other Louis Davidson in Other Generating Repeatable Sets Of Test Rows In order to test graph structures, I needed a large set of random data. In some ways, this data will... 30 September 2022 11 min read
T-SQL Programming Greg Larsen in T-SQL Programming Summarizing data in SQL Server using GROUP BY and HAVING clauses You can summarize data to get counts, averages, sums, and more using GROUP BY in T-SQL queries. Greg Larsen shows... 27 May 2022 11 min read
Other Louis Davidson in Other SQL Server Graph Tables – Cross Database Surprises Louis Davidson explains how to get around an interesting issue when doing cross-database queries involving graph database tables.… 21 March 2022 3 min read
T-SQL Programming Greg Larsen in T-SQL Programming The basic T-SQL SELECT statement The SQL language is used across many relational database platforms. Greg Larsen explains the basics of the SELECT statement for... 22 February 2022 10 min read
Other Dennes Torres in Other Query Store and hints: More Powerful than ever Dennes Torres explains how Query Store hints work in Azure SQL Database and Managed Instance.… 29 November 2021 6 min read
