T-SQL Programming Joe Celko in T-SQL Programming Empty Thoughts: Working with NULL Whether or not to have NULLable columns in a table can be a religious debate, and how missing data is... 10 January 2019 12 min read
T-SQL Programming Phil Factor in T-SQL Programming SQL Server Export Formats Compared: BCP, XML, CSV, Tab-Delimited Performance and Gotchas Benchmarked comparison of SQL Server export formats - native BCP, XML via BCP, CSV, tab-delimited - for performance and handling... 24 December 2018 13 min read
T-SQL Programming Joe Celko in T-SQL Programming Data Quality Problems with data quality are easier and cheaper to prevent than to solve later. In this article, Joe Celko talks... 05 December 2018 11 min read
T-SQL Programming Greg Larsen in T-SQL Programming There is a New COUNT in Town Now that SQL Server 2019 is on the way, it’s time to start learning about the new capabilities. In this... 29 November 2018 14 min read
T-SQL Programming Phil Factor in T-SQL Programming SQL Server JSON: Transferring Data with FOR JSON, OPENJSON, and JSON Schema Validation Transfer data between SQL Server databases using JSON - exporting tables with FOR JSON, importing with OPENJSON, validating file contents... 25 November 2018 31 min read
T-SQL Programming Phil Factor in T-SQL Programming Getting Started with MongoDB and PowerShell: A Real-World Data Walkthrough Learn MongoDB with PowerShell using a real 6.5 million record dataset: install MongoDB, import CSV data, create indexes, run aggregation... 03 August 2018 26 min read
T-SQL Programming Kathi Kellenberger in T-SQL Programming T-SQL Window Functions: Performance, NTILE & Framing Master T-SQL window function performance: understand OVER clause sorting, PARTITION BY, NTILE, framing (ROWS vs RANGE), indexing strategies, and how... 27 June 2018 11 min read
T-SQL Programming Joe Celko in T-SQL Programming Missing Data Missing data is a difficult and common problem to solve. In this article, Joe Celko explains several approaches to deleting... 20 June 2018 10 min read
T-SQL Programming Kathi Kellenberger in T-SQL Programming Introduction to T-SQL Window Functions T-SQL window functions were introduced in 2005 with more functionality added in 2012. Many database professionals are not aware of... 13 June 2018 13 min read
T-SQL Programming Darko Martinović in T-SQL Programming Migrate a SQL Server Database to In-Memory OLTP: Full Guide Step-by-step guide to migrating a SQL Server database to In-Memory OLTP. Covers limitations, foreign key workarounds, data type compatibility, natively... 10 May 2018 30 min read
T-SQL Programming Phil Factor in T-SQL Programming Importing JSON into SQL Server: OPENJSON for Arrays, Nested Arrays, and Complex Collections Import JSON documents into SQL Server using OPENJSON - covering simple arrays of objects, nested arrays (with CROSS APPLY), and... 09 May 2018 21 min read
T-SQL Programming Robert Sheldon in T-SQL Programming SQL Server Graph Databases Part 5: Import Relational Data into Graph Tables Learn how to import AdventureWorks relational data into SQL Server graph node and edge tables, query the graph data with... 30 April 2018 20 min read
T-SQL Programming Robert Sheldon in T-SQL Programming Graph Databases for Hierarchical Data in SQL Server (Part 4) Model hierarchical data in SQL Server graph databases: org charts, multi-level relationships, MATCH queries, and closure table workarounds for complex... 23 April 2018 21 min read
T-SQL Programming Phil Factor in T-SQL Programming SQL Server Closure Tables: Model Hierarchies in SQL Learn the closure table pattern for modeling hierarchies in SQL Server. Convert self-referencing tables to separate node and edge tables... 10 April 2018 21 min read
T-SQL Programming Robert Sheldon in T-SQL Programming SQL Server Graph Databases – Part 3: Modifying Data in a Graph Database Modifying data in Graph Database tables is similar to working with traditional tables, but there are several things to consider.... 10 April 2018 19 min read
T-SQL Programming Robert Sheldon in T-SQL Programming SQL Server Graph Databases – Part 2: Querying Data in a Graph Database Along with Graph Databases, Microsoft has introduced the new MATCH function for querying them. Robert Sheldon explains how to use... 22 March 2018 14 min read
.NET Darko Martinović in .NET Transposing SQL Server Query Results with SQLCLR: Dynamic Row-to-Column Rotation Transpose SQL Server query results dynamically using a SQLCLR stored procedure - no need to know column names in advance.... 13 March 2018 18 min read
T-SQL Programming Robert Sheldon in T-SQL Programming SQL Server Graph Databases: Nodes, Edges & MATCH (Part 1) Introduction to SQL Server graph databases: create node and edge tables, define relationships with CREATE TABLE AS NODE/EDGE, and query... 06 March 2018 17 min read
Database DevOps Phil Factor in Database DevOps Script SQL Server Extended Properties for Table Documentation Learn to script SQL Server extended properties for table and column documentation using a JSON-based approach. Includes T-SQL functions, automation... 03 March 2018 31 min read
T-SQL Programming Joe Celko in T-SQL Programming Charles Bachman and Pointer Chains Joe Celko reminisces about the origins of databases and one of the early pioneers, Charles Bachman. He explains how pointer... 28 February 2018 16 min read
