T-SQL Programming Greg Larsen in T-SQL Programming Summarizing data using GROUP BY and HAVING clauses You can summarize data to get counts, averages, sums, and more using GROUP BY in T-SQL queries. Greg Larsen shows... 27 May 2022 11 min read
T-SQL Programming Edward Pollack in T-SQL Programming Getting results using less T-SQL There is usually more than one way to write a query. In this article, Edward Pollack explains a few ways... 27 April 2022 16 min read
T-SQL Programming Greg Larsen in T-SQL Programming The basic T-SQL SELECT statement The SQL language is used across many relational database platforms. Greg Larsen explains the basics of the SELECT statement for... 22 February 2022 10 min read
T-SQL Programming Joe Celko in T-SQL Programming Quantifier predicates Predicates in SQL are often complex and difficult to understand. In this article, Joe Celko explains the logic behind a... 27 December 2021 11 min read
T-SQL Programming Joe Celko in T-SQL Programming BETWEEN the two of us BETWEEN can be used in a SQL WHERE clause to filter on a range. Joe Celko explains the history of... 15 November 2021 11 min read
CI/CD Sebastian Meine Liz Baron in CI/CD How to successfully deploy databases with external references Database objects often have references to external databases which makes continuous integration problematic. In this article Liz Baron and Sebastian... 29 September 2021 8 min read
T-SQL Programming Kathi Kellenberger in T-SQL Programming How LAG compares to other techniques LAG pulls a column from another row without a self-join. In this article, Kathi Kellenberger shows how LAG compares to... 07 September 2021 13 min read
T-SQL Programming Joe Celko in T-SQL Programming Data, N-Tiles & Medians Joe Celko takes a look at how SQL Server can do some of the work for you such as calculating... 01 June 2021 14 min read
Editorials Kathi Kellenberger in Editorials What is an ad hoc query? Someone recently asked me which queries are ad hoc in SQL Server. An ad hoc query is a single query... 04 May 2021 4 min read
T-SQL Programming Shel Burkow in T-SQL Programming A data transformation problem in SQL and Scala: Dovetailing declarative solutions Part II In this article, Shel Burkow uses the SQL execution plan from the previous article to write a program in Scala.… 26 March 2021 15 min read
T-SQL Programming Joe Celko in T-SQL Programming What is interpolation? In this article, Joe Celko explains interpolation and covers a bit about the history and what we all did before... 11 March 2021 10 min read
T-SQL Programming Shel Burkow in T-SQL Programming A data transformation problem in SQL and Scala: Dovetailing declarative solutions This article is an interesting approach to solving a data transformation problem in SQL and Scala. Shel Burkow uses a... 22 February 2021 11 min read
T-SQL Programming Uwe Ricken in T-SQL Programming Heaps in SQL Server: Part 4 PFS contention When inserting rows into a heap, SQL Server must sometimes update the PFS page which can PFS contention and affect... 05 January 2021 14 min read
T-SQL Programming Joe Celko in T-SQL Programming Normal Forms To prevent data change anomalies, a database should be normalized. Did you know that there are 10 normal forms? In... 20 November 2020 22 min read
T-SQL Programming Joe Obbish in T-SQL Programming Dynamic Data Unmasking The SQL Server 2016 dynamic data masking feature may seem like a great way to obfuscate data for downstream systems... 15 September 2020 12 min read
T-SQL Programming Edward Pollack in T-SQL Programming Hands-On with Columnstore Indexes: Part 4 Query Patterns All queries run fast against columnstore indexes, right? In this article, Edward Pollack demonstrates some query patterns that don’t perform... 01 September 2020 21 min read
T-SQL Programming Uwe Ricken in T-SQL Programming Heaps in SQL Server: Part 3 Nonclustered Indexes Uwe Ricken continues his series on heaps. This time he demonstrates a common scenario where the query against a heap... 18 August 2020 8 min read
Phil Factor Temporary Tables in SQL Server Temporary tables are used by every DB developer, but they're not likely to be too adventurous with their use, or... 01 August 2020 22 min read
Performance Edward Pollack in Performance Hands-On with Columnstore Indexes: Part 3 Maintenance and Additional Options In this article of this series, Edward Pollack demonstrates the maintenance of columnstore indexes. He also takes a look at... 21 July 2020 22 min read
T-SQL Programming Edward Pollack in T-SQL Programming Hands-On with Columnstore Indexes: Part 2 Best Practices and Guidelines In the second article of this series, Edward Pollack demonstrates some ways to design and populate a columnstore index to... 24 June 2020 20 min read
