T-SQL Programming Kathi Kellenberger in T-SQL Programming PERCENTILE_CONT in SQL Server: Continuous Percentile and Interpolation Explained How the SQL Server PERCENTILE_CONT function computes continuous percentiles using interpolation, with a worked example from AdventureWorks, comparison with PERCENTILE_DISC,... 17 October 2019 11 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: Tables, Columns, Indexes & More SQL Server naming conventions for tables, columns, indexes, constraints, keys, and triggers. Covers identifier rules, reserved words, temporary tables, and... 09 January 2019 9 min read
T-SQL Programming Phil Factor in T-SQL Programming SQL Server Export Formats Compared: BCP, XML, CSV, Tab-Delimited Performance and Gotchas Benchmarked comparison of SQL Server export formats - native BCP, XML via BCP, CSV, tab-delimited - for performance and handling... 24 December 2018 13 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 SQL Server JSON: Transferring Data with FOR JSON, OPENJSON, and JSON Schema Validation Transfer data between SQL Server databases using JSON - exporting tables with FOR JSON, importing with OPENJSON, validating file contents... 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
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 Migrate a SQL Server Database to In-Memory OLTP: Full Guide Step-by-step guide to migrating a SQL Server database to In-Memory OLTP. Covers limitations, foreign key workarounds, data type compatibility, natively... 10 May 2018 30 min read
