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
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: 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
T-SQL Programming Robert Sheldon in T-SQL Programming SQL Server Graph Databases – Part 4: Working with Hierarchical Data in a Graph Database The Graph Database feature, new with SQL Server 2017, can be used to represent hierarchies. In this article of the... 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 SQL Server has a couple of different ways to represent hierarchies, but they do not allow storing any additional information... 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 – Part 1: Introduction SQL Server 2017 now includes a new feature to represent complex relationships in data called Graph Databases. Robert Sheldon introduces... 06 March 2018 16 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 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 16 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
