DAX table functions for paginated reports: Part 2
To return detail data using DAX, use the table functions. Adam Aspin covers UNION, EXCEPT, INTERSECT, and CALCULATETABLE in this article.
Demo webinar: SQL Monitor
Managing your entire SQL Server estate, on premises, in the cloud or a hybrid, with instant problem diagnosis, intelligent and customizable alerting has never been more vital. Discover how Redgate’s SQL Monitor enables all this from a single pane of glass.
The Central Management Servers Extension in Azure Data Studio
Learn how to use Azure Data Studio to access a Central Management Server.
Would You Still Love Linux If Windows Was Free?
A guest editorial today looks at the OS debate: Windows v Linux.
Moving to Team-Based Database Development with Flyway
Describing a route from a basic, 'managed' system of database development to use of branching and merging and CI, using Flyway. By taking these steps, you'll reduce development conflicts, lift testing restrictions, and the organization will have much more flexibility on the release of features and bugfixes.
Use Cases for WHILE and GOTO Loops with T-SQL for Time Series Data
In this article we cover situations where using a loop in T-SQL to process data for time series analysis is beneficial to get the desired results.
Using Technology for Health
I've been fairly healthy and fit for most of my life. While I've always had a few extra pounds, I do try to eat better than average and I exercise regularly. That didn't stop age and some pandemic laxity from catching up with me. My annual checkup last December had my doctor (and me) slightly […]
Is the Time of the DBA Ending?
The DBA role might be changing, but Steve thinks this creates opportunities.
Oracle ASM: Migrating from UDEV devices to the ASM Filter Driver
This article looks at the way in which you can convert unmanaged devices to the ASM filter drive in an Oracle system.
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 restore with the pg_dump and pg_restore utilities.
Blogs
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
Demo Tracking Dropped Objects
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Randomly Selecting Columns and Rows from a Table or View
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
How Can SQL Server Detect Application Errors When Developers Can’t?
Comments posted to this topic are about the item How Can SQL Server Detect...
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers