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
Robert Sheldon SQL Server Metadata Functions: The Basics To be able to make full use of the system catalog to find out more about a database, you need... 09 March 2016 21 min read
Laerte Junior The PoSh DBA: Assigning Data to Variables Via PowerShell Common Parameters Sometimes, it is the small improvements in a language that can make a real difference. PowerShell is able to introduce... 07 March 2016 7 min read
Uwe Ricken When AUTO_UPDATE_STATISTICS Doesn’t Happen When your SQL Server database is set to have its statistics automatically updated, you will probably conclude that, whenever the... 07 March 2016 10 min read
Matthew Skelton Issue Tracking for Databases Any database development project will be hard to manage without a system for reporting bugs in the code, anomalies and... 25 February 2016 20 min read
