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
Blogs Annette Allen in Blogs Who comments code? I am a firm advocate of commenting code, but you need to make sure that you are commenting the right... 05 May 2018 1 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
Blogs Louis Davidson in Blogs Finding overlapping ranges of data This week, I had a problem where I needed to find and eliminate from the results of my query, data... 18 April 2018 15 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
Blogs Louis Davidson in Blogs Just What Exactly Will Cast to a Bit Value? I am working through my OneNote folder of blog ideas, and this one, while being one of the least consequential... 02 April 2018 4 min read
Louis Davidson Eliminating Annoying Space Characters Via Check Constraints Along with designing databases, I do a lot of ETL from, well, let’s call them “third party systems that I... 26 March 2018 9 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
Blogs Phil Factor in Blogs Using Stored Procedures in SQL Server that return several results. Stored Procedures give you more freedom than functions, and so they would be the obvious way of developing processes in... 07 March 2018 3 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 Administration Danny Kruge in Database Administration Changing Data Types on Large Tables: The INT to BIGINT Conundrum Changing a data type seems like a simple task unless the table is quite large and downtime must be kept... 19 February 2018 10 min read
Blogs Louis Davidson in Blogs Outputting Status In Your T-SQL Code The versatility of T-SQL allows you to create complex scripts to accomplish just about anything you need to do. In... 09 February 2018 5 min read
BI Robert Sheldon in BI SQL Server Machine Learning Services – Part 5: Generating Multiple Plots in Python Visualization is often the first step in analyzing data. Python makes visualization easy. In this article, Robert Sheldon demonstrates how... 07 February 2018 28 min read
Blogs Louis Davidson in Blogs Inline Index Definition There are a lot of features of SQL Server that I (and I know some of you), never really get... 18 January 2018 3 min read
T-SQL Programming Phil Factor in T-SQL Programming Pivoting Data in SQL Server with JSON: A Generic Dynamic Matrix Approach A JSON-based approach to pivoting and transposing data in SQL Server that works without knowing column names in advance. Covers... 16 January 2018 17 min read
BI Robert Sheldon in BI SQL Server Machine Learning Services – Part 3: Plotting Data with Python One of the advantages of running Python from SQL Server is the ability to create graphics to assist in analysis... 02 January 2018 26 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
BI Robert Sheldon in BI SQL Server Machine Learning Services – Part 2: Python Data Frames SQL Server Machine Learning Services provides the ability to run Python scripts directly against data in SQL Server. To do... 18 December 2017 28 min read
