T-SQL Programming Phil Factor in T-SQL Programming Importing JSON Collections into SQL Server Microsoft introduced native support for JSON in SQL Server in version 2016. In this article, Phil Factor shows how to... 09 May 2018 20 min read
T-SQL Programming Robert Sheldon in T-SQL Programming SQL Server Graph Databases – Part 5: Importing Relational Data into a Graph Database In the final article of this series, Robert Sheldon shows how to move from a relational structure to a graph... 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 An Easier Way of Transposing Query Result in SQL Server T-SQL does not have an easy way to transpose a row and a column. Of course, there is the PIVOT... 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 Scripting the Description of Database Tables Using Extended Properties Stored procedures, for example, are very easy to document. The comment block at the beginning stays with the code and... 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
Opinion Pieces Joe Celko in Opinion Pieces Degree of Duplication Technology is constantly moving forward, but it is also helpful to understand how we arrived where we are today. Joe... 25 January 2018 13 min read
T-SQL Programming Phil Factor in T-SQL Programming An Easier Way of Pivoting Data in SQL Server There are several methods to pivot, or transpose, data in T-SQL, but most are difficult to understand and write. Phil... 16 January 2018 17 min read
T-SQL Programming Joe Celko in T-SQL Programming Validation, Verification, and Modification A proper database design is very important, and changes to fix problems after the fact are expensive. In this article,... 26 December 2017 20 min read
T-SQL Programming Alfonso Hernandez in T-SQL Programming Summarizing Data Using the GROUPING SETS Operator Writing aggregate queries is one of the most important tasks for anyone working with T-SQL. Determining the expressions required in... 14 November 2017 9 min read
T-SQL Programming Phil Factor in T-SQL Programming Importing JSON Data from Web Services and Applications into SQL Server To support many applications, it makes sense for the database to work with JSON data, because it is the built-in... 27 October 2017 35 min read
T-SQL Programming Joe Celko in T-SQL Programming Simple SQL: Handling Location Datatypes How do you record locations in SQL? Most relational database systems support spatial and geographical data, generally using the round-earth... 19 October 2017 14 min read
Blogs Phil Factor in Blogs Consuming hierarchical JSON documents in SQL Server using OpenJSON Over the years, Phil was struck by the problems of reading and writing JSON documents with SQL Server, and wrote... 12 September 2017 14 min read
T-SQL Programming Joe Celko in T-SQL Programming Missing Data In the real world of business or scientific reporting and analysis, data can prove to be awkward. It can be... 08 September 2017 11 min read
.NET Dan Turner in .NET Why is My Database Application so Slow? When your application is running slowly, the reflex action is to blame the database queries. It is certainly true that... 24 August 2017 14 min read
T-SQL Programming Joe Celko in T-SQL Programming Simple SQL: Random Thoughts How does one get a truly random sample of data of a certain size from a SQL Server database table.... 11 August 2017 9 min read
