Security, Privacy & Compliance Fabiano Amorim in Security, Privacy & Compliance SQL Server View-Based Security Flaw: How Error Messages Expose Hidden Data View-based row-level security in SQL Server leaks information through error messages - a user who can't see a row can... 19 October 2020 11 min read
Database DevOps Grant Fritchey in Database DevOps What is database continuous integration? Have you ever longed for a way of making the delivery of databases more visible, predictable and measurable? Do you... 07 October 2020 9 min read
T-SQL Programming Phil Factor in T-SQL Programming SQL Server Temp Tables: Types, Syntax & Best Practices Everything about SQL Server temporary tables: local (#temp), global (##temp), table variables, and when to use each. Includes creation syntax,... 01 August 2020 23 min read
Other Phil Factor in Other Tackling Imperial and US Customary Measurements in Databases The old measurements of length, area, volume and weight in the UK and the States refuse to die. They are... 06 May 2020 10 min read
Roy Ernest Introduction to SQL Server Spatial Data Many applications require the handling of geospatial data. Roy and Surenda take you through the basics of SQL Server spatial... 18 March 2020 22 min read
CosmosDB Adam Aspin in CosmosDB Cosmos DB SQL: Querying Complex JSON – Arrays, Schema on Read, and Subqueries Query complex JSON in Azure Cosmos DB SQL: access subnodes and arrays, handle schema-on-read inconsistencies, detect missing attributes, check data... 13 May 2019 16 min read
CosmosDB Adam Aspin in CosmosDB Cosmos DB SQL Workarounds: LEFT, RIGHT, YEAR, MONTH, DAY, and Wildcard Search via SUBSTRING and String Functions Practical workarounds for common T-SQL idioms in Azure Cosmos DB SQL API - wildcard searches using CONTAINS and STARTSWITH, null... 03 April 2019 10 min read
CosmosDB Adam Aspin in CosmosDB Introduction to SQL for Cosmos DB This article by Adam Aspin reviews the Azure Cosmos DB SQL API from the perspective of the relational database developer.... 06 March 2019 22 min read
Kalen Delaney SQL Server Internals: In-Memory OLTP In this book Kalen Delaney introduces and explains how the 2016 In-Memory OLTP engine works. The Hekaton internals knowledge offered... 07 December 2017 2 min read
Oracle Aman Sharma in Oracle Understanding Oracle SQL Query Parsing: Part 4 – Understanding Bind Variable Peeking Learn all about Oracle SQL bind variables: the potential issues surrounding bind variables and how to handle them.… 03 February 2017 8 min read
Oracle Aman Sharma in Oracle Understanding Oracle SQL Query Parsing – Part 3: Bind Variables and Cursor Sharing In this third article, we will look at the issue of duplicate SQL statements and how Bind Variables can help... 20 January 2017 9 min read
Oracle Aman Sharma in Oracle Oracle Parent and Child Cursors: The Library Cache Sharing Model, Soft Parse Deep Dive, and Cursor Version Count Diagnostics Oracle parent and child cursors explained - how the library cache shares SQL execution plans across identical statements while maintaining... 12 December 2016 11 min read
Hugh Bin-Haad Relational Algebra and its implications for NoSQL databases With the rise of NoSQL databases that are exploiting aspects of SQL for querying, and are embracing full transactionality, is... 01 April 2016 4 min read
Robert Sheldon SQL Server System Functions: The Basics Every SQL Server Database programmer needs to be familiar with the System Functions. These range from the sublime (such as... 31 March 2016 22 min read
Elizabeth Ayer The Comeback of Migrations-Based Deployments With database deployments, not all script-based processes are equal. Some use change scripts in a free-and-easy way, and some, which... 17 March 2016 11 min read
SQL Server Kathi Kellenberger in SQL Server FIFO Stock Inventory in T-SQL: The Window Function Approach vs Dave Ballantyne’s Original Set-Based Solution Solving the FIFO (first-in, first-out) stock inventory problem in T-SQL with window functions (Kathi Kellenberger's approach using SUM() OVER with... 16 March 2016 14 min read
Matthew Skelton Database Lifecycle Management for ETL Systems Few databases are self-contained. They take data from other sources, and publish them to downstream consumers of data. These ETL... 16 March 2016 32 min read
Enrico van de Laar The SQL Server 2016 Query Store: Forcing Execution Plans using the Query Store The SQL Server 2016 Query Store can give you valuable performance insights by providing several new ways of troubleshooting queries,... 16 March 2016 7 min read
Dennes Torres Creating a Date Dimension in a Tabular Model As well as its multidimensional model, SQL Server Analysis Services (SSAS) now has a tabular model of database that either... 15 March 2016 23 min read
Matthew Skelton Database Migrations: Modifying Existing Databases It should be simple to upgrade a database to a new version. It certainly can be, but if you need... 09 March 2016 34 min read
