The External Pushdown

The VALUES Limit

Build Your Own SQL Server Central Monitoring Solution with PowerShell

In this article, we look at how to use PowerShell scripts to query all of your SQL Server instances to build your own central monitoring solution.

Practical IOT

The use of IoT and lots of data is allowing governments to better serve their citizens.

Adding SQL Variant Data

Refresh a Power BI Dataset using Microsoft Power Automate

Learn how to refresh a Power BI dataset by integrating Power Automate into the report.

THROW Messages

Backing up MySQL Part 1: mysqldump

mysqldump is one of the most popular database backup tools in the MySQL world. The tool is prevalent partly because it’s very basic and quite powerful – mysqldump database backup tool is command line-based, very simple and very straightforward to use. As far as MySQL or its flavors (MariaDB and Percona Server) are concerned, this command line-based tool is one of the top choices for junior and senior database engineers across the world alike.

Stairway to DAX and Power BI Level 19: Dates Functions: STARTOFMONTH(), STARTOFQUARTER(), STARTOFYEAR()

Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces three DAX Time Intelligence functions related to the Start of Periods: STARTOFMONTH(), STARTOFQUARTER(), and STARTOFYEAR(). He discusses the syntax, uses and operation of each, and then provides hands-on exposure to the function in Power BI.

SQL Server Indexes to Improve Query Performance

In this article, we look at how to design SQL Server indexes and why the way an index is created makes a difference in query performance.