Adam Aspin in BI

DAX Paginated Reports Part 2: Variables, EXCEPT/UNION, GROUPBY, and CALCULATETABLE

DAX for Power BI paginated reports Part 2: scalar and table DAX variables, EXCEPT/UNION/INTERSECT for set operations, GROUPBY and SUMMARIZE,...

15 February 2022 13 min read

PostgreSQL

Grant Fritchey in PostgreSQL

How to back up and restore in PostgreSQL: Learning PostgreSQL with Grant

You can perform PostgreSQL backups with the pg_dump command. In this article, Grant Fritchey explains how to back up and...

08 February 2022 12 min read

Azure

Dennes Torres in Azure

Eight Azure SQL configurations you may have missed

Azure SQL Database has been around for over ten years and is constantly evolving with new capabilities and options. Dennes...

07 February 2022 12 min read

MySQL

Robert Sheldon in MySQL

Getting started with MySQL

The first step when getting started with MySQL is to get it installed and running. In this article, Robert Sheldon...

31 January 2022 14 min read

BI

Adam Aspin in BI

DAX table functions for paginated reports: Part 1

Several DAX table functions can be used for paginated reports when you want all the data, not a summary. Adam...

21 January 2022 15 min read

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

Oracle

Jonathan Lewis in Oracle

Transformations by the Oracle Optimizer

To troubleshoot poorly performing SQL in Oracle, you must understand which transformations the optimizer has made. Jonathan Lewis demonstrates several...

14 January 2022 16 min read

PostgreSQL

Grant Fritchey in PostgreSQL

Creating a Database and Tables in PostgreSQL: Learning PostgreSQL with Grant

The syntax for creating databases and tables in PostgreSQL is similar to other RDBMS. In this article, Grant Fritchey shows...

10 January 2022 7 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

Featured

Grant Fritchey in Featured

Connecting to PostgreSQL: Learning PostgreSQL with Grant

Database professionals often work with more than one database platform. Grant Fritchey explains setting up and connecting to PostgreSQL database.…

23 November 2021 7 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

Register for Simple Talk

Databases

DAX Paginated Reports Part 2: Variables, EXCEPT/UNION, GROUPBY, and CALCULATETABLE

How to back up and restore in PostgreSQL: Learning PostgreSQL with Grant

Eight Azure SQL configurations you may have missed

Getting started with MySQL

DAX table functions for paginated reports: Part 1

CHAR vs VARCHAR vs VARCHAR(MAX) in SQL Server

Vertipaq optimization and its impact on columnstore compression

Transformations by the Oracle Optimizer

Creating a Database and Tables in PostgreSQL: Learning PostgreSQL with Grant

Replace a SQL Server Identity Column with a Sequence Number: Two Methods

Quantifier predicates

DAX Filtering for Paginated Reports: A Guide

How to return multiple sequence numbers with sp_sequence_get_range

Connecting to PostgreSQL: Learning PostgreSQL with Grant

Introduction to DAX for paginated reports

BETWEEN the two of us

Using SQL Server sequence objects

Ransomware: A world under threat

Introduction to SQL Server sequence objects

Azure Synapse Serverless SQL: Querying Blob Storage with OPENROWSET – Filepath Filtering, Partitioning, Parquet vs CSV, and External Tables