Learn SQL Server Greg Larsen in Learn SQL Server CHAR vs VARCHAR vs VARCHAR(MAX) in SQL Server Understand when to use CHAR, VARCHAR, or VARCHAR(MAX) in SQL Server. Compares storage behaviour, performance trade-offs, and gives practical data-type... 20 January 2022 15 min read
BI Edward Pollack in BI Vertipaq optimization and its impact on columnstore compression Vertipaq optimization is a critical component of the columnstore compression process. Edward Pollack explains how it works and what you... 19 January 2022 21 min read
Learn SQL Server Greg Larsen in Learn SQL Server Replace a SQL Server Identity Column with a Sequence Number: Two Methods Learn how to replace a SQL Server IDENTITY column with a SEQUENCE number using two methods: step-by-step column modification (with... 04 January 2022 16 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
BI Adam Aspin in BI DAX Filtering for Paginated Reports: A Guide Master DAX filtering for paginated reports using SUMMARIZECOLUMNS. Covers basic filters, OR logic, expressions, and rscustomdaxfilter for Power BI Premium... 17 December 2021 14 min read
Learn SQL Server Greg Larsen in Learn SQL Server How to return multiple sequence numbers with sp_sequence_get_range Developers can work with multiple range values at once using sp_sequence_get_range. Greg Larsen explains how to return multiple sequence numbers... 30 November 2021 13 min read
BI Adam Aspin in BI Introduction to DAX for paginated reports SSRS reports can be built using DAX. In this article, Adam Aspin explains how to get started using DAX to... 15 November 2021 18 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
Learn SQL Server Greg Larsen in Learn SQL Server Using SQL Server sequence objects SQL Server sequence objects have several properties that control how they behave. Greg Larson explains the options of using SQL... 15 November 2021 14 min read
Security Robert Sheldon in Security Ransomware: A world under threat Ransomware has threatened many organizations over the past few years. In this article, Robert Sheldon explains the history of ransomware... 01 November 2021 12 min read
Learn SQL Server Greg Larsen in Learn SQL Server Introduction to SQL Server sequence objects SQL Server sequence objects can be used in place of identity columns. In this article, Greg Larsen explains how to... 25 October 2021 15 min read
T-SQL Programming Dennes Torres in T-SQL Programming Azure Synapse Serverless SQL: Querying Blob Storage with OPENROWSET – Filepath Filtering, Partitioning, Parquet vs CSV, and External Tables Performance-tuning SQL queries against Azure Blob Storage using Synapse Serverless SQL pool - filepath filtering with the filepath() function, partition-based... 21 October 2021 18 min read
BI Sanil Mhatre in BI Text Mining and Sentiment Analysis: Data Visualization in Tableau Tableau is a popular visualization tool used by organizations around the world. In this article Sanil Mhatre demonstrates sentiment analysis... 18 October 2021 19 min read
Performance Edward Pollack in Performance Automating SQL Server Extended Events: Permanent Tables and Scheduled Collection Automate SQL Server Extended Events data collection: store event XML in permanent tables, build a stored procedure to manage the... 04 October 2021 19 min read
Security Robert Sheldon in Security Cybersecurity threats Not a week goes by without news of a new cyberattack. In this article, Robert Sheldon explains the cybersecurity threats... 30 September 2021 12 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
Learn SQL Server Greg Larsen in Learn SQL Server Working with SQL Server identity columns SQL Server identity columns are easy to add to a table, but you must understand how they work to use... 24 September 2021 12 min read
PowerShell Greg Moore in PowerShell Building an ETL with PowerShell There are many ways to load data into a SQL Server database. In this article, Greg Moore demonstrates how to... 22 September 2021 11 min read
Database Administration Edward Pollack in Database Administration SQL Server Extended Events: Creating Sessions, Events, Actions, Filters, and Targets Build a SQL Server Extended Events session from the ground up - choosing events, attaching actions, applying filters, selecting targets... 14 September 2021 15 min read
T-SQL Programming Kathi Kellenberger in T-SQL Programming LAG in SQL Server: Performance vs Self-Join, CTE, APPLY, and Cursors Benchmarked Benchmarked comparison of the SQL Server LAG function against eight alternative techniques for including a column from a previous row:... 07 September 2021 13 min read
