.NET Lance Talbert in .NET Saving Game Data with Unity One of the most critical things that a game must do is to save data like the preferences and score.... 03 February 2020 12 min read
T-SQL Programming Edward Pollack in T-SQL Programming Efficient Solutions to Gaps and Islands Challenges Window functions are useful for solving many SQL queries. In this article, Ed Pollack demonstrates how they can be used... 21 January 2020 32 min read
T-SQL Programming Kathi Kellenberger in T-SQL Programming What Does PERCENTILE_CONT Do? In this article, Kathi Kellenberger takes on a logic puzzle in trying to understand how the windowing function, PERCENTILE_CONT, works.... 17 October 2019 10 min read
T-SQL Programming Joe Celko in T-SQL Programming SQL and Scope Understanding scoping rules is a basic skill for developers. In this article, Joe Celko gives a bit of the history... 07 October 2019 20 min read
Dennes Torres OPTIMIZE_FOR_SEQUENTIAL_KEY: New 2019 feature Dennes Torres explains the 2019 option OPTIMIZE_FOR_SEQUENTIAL_KEY which can alleviate the pain of insert hotspots.… 27 August 2019 3 min read
BI Andy Brown in BI Using the FILTER Function in DAX In the previous article of this series, Andy Brown of Wise Owl Training explained how to use the oh-so-important CALCULATE... 17 April 2019 13 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
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
Blogs Phil Factor in Blogs SQL naming conventions SQL naming conventions for tables, and all the associated objects such as indexes, constraints, keys and triggers, are important for... 09 January 2019 9 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
Blogs Phil Factor in Blogs Constraining and checking JSON Data in SQL Server Tables So you have a database with JSON in it. Can you validate it? I don’t mean just to ensure that... 17 December 2018 17 min read
Blogs Phil Factor in Blogs Producing Data and Schemas in JSON array-of-array format. JSON was initially designed for the informal transfer of data that has no schema. It has no concept of a... 05 December 2018 24 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
Blogs Phil Factor in Blogs How to validate JSON Data before you import it into a database. If you are, as you should be, checking JSON data in a whole lot of files before you import them... 16 November 2018 4 min read
Blogs Louis Davidson in Blogs Using WITH in an IF Condition I am in the middle of working on my DB Design conference that occurs in a bit over a week... 05 September 2018 7 min read
Blogs Louis Davidson in Blogs Finding duplicated data in a case insensitive column The other day, I had a problem with some data that I never dreamed I would ever see. In a... 08 August 2018 4 min read
BI Robert Sheldon in BI Power BI Introduction: Working with Parameters in Power BI Desktop —Part 4 Power BI allows you to use parameters to make your reports dynamic. In this article, Robert Sheldon demonstrates how parameters... 05 July 2018 14 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
Blogs Louis Davidson in Blogs Row-wise system function calls, always the same? Assumptions are generally terrible things for programmers (and likely my next “What Counts” blog goes there), because what looks to... 20 June 2018 6 min read
