T-SQL Programming Dennes Torres in T-SQL Programming SQL Server 2019 Graph Database and SHORTEST_PATH With SQL Server 2019 on the way, it’s time to begin learning about all the new features. In this article,... 11 September 2019 13 min read
T-SQL Programming Monica Rathbun in T-SQL Programming What are Columnstore Indexes? Microsoft continues to enhance the performance of SQL Server with new features. In this article, Monica Rathbun explains how to... 22 July 2019 15 min read
T-SQL Programming Joe Celko in T-SQL Programming Modeling Time There are those who argue that time doesn’t really exist; it’s just an illusion. That debate won’t keep you from... 15 July 2019 16 min read
T-SQL Programming Rodney Landrum in T-SQL Programming A MongoDB to SQL Server Migration: Data Typing and Un-nesting Importing data from one system to another is a common task for database professionals. It’s possible to spend a lot... 20 June 2019 15 min read
T-SQL Programming Mala Mahadevan in T-SQL Programming Converting a History Table into a System-Versioned Temporal Table Temporal tables were introduced with SQL Server 2016. To take advantage of this feature, you might start fresh with a... 13 March 2019 15 min read
Editorials Kendra Little in Editorials Why You Shouldn’t Hardcode the Current Database Name in Your Views, Functions, and Stored Procedures “There are only two hard things in Computer Science: cache invalidation and naming things” Phil Karlton I’m terrible at naming... 12 March 2019 4 min read
T-SQL Programming Phil Factor in T-SQL Programming What are Inline Indexes? New releases of SQL Server arrive at a quick pace, and it's difficult to keep up with the many features... 26 February 2019 13 min read
T-SQL Programming Kathi Kellenberger in T-SQL Programming The Performance of Window Aggregates Revisited with SQL Server 2019 T-SQL window functions have been a fantastic addition to the T-SQL language. In this article, Kathi Kellenberger reviews how optimizations... 11 February 2019 11 min read
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 Saving Data to Various Formats, Using SQL You have many options when exporting data from a database. In this article, Phil Factor compares several methods including XML... 24 December 2018 12 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 Transferring Data with JSON in SQL Server JSON is a viable option for transferring data between systems. It has the ability to include schema information along with... 25 November 2018 31 min read
T-SQL Programming Phil Factor in T-SQL Programming The Crimes of Chicago: Working with Data in MongoDB NoSQL databases like MongoDB are gaining popularity, but using the right tools for the job at hand is most important.... 03 August 2018 26 min read
T-SQL Programming Kathi Kellenberger in T-SQL Programming T-SQL Window Functions and Performance T-SQL window functions, introduced in 2005 with enhancements in 2012, are great additions to the T-SQL language. In this article,... 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 Converting a Database to In-Memory OLTP In-Memory OLTP was introduced with SQL Server 2014 as a way to improve transaction performance. There are several scenarios that... 10 May 2018 29 min read
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 19 min read
