How to Forecast Data in Power BI
Learn how you can use Power BI to forecase the future trends of data.
2025-05-26 (first published: 2023-02-27)
51,175 reads
Articles
Top 5 Power BI Common Pitfalls
What are some of the most common mistakes when working with Power BI? For example, when a junior colleague starts on a Power BI project for the first time, what are the pitfalls you try to warn them about? What advice would you give them?
2025-05-26
Analyzing Tempdb Spills and Usage Across Recursive Queries
This article examines how tempdb is affected by recursive queries, using a few different methods.
2025-05-23
2,144 reads
Introduction to GitHub Actions Part 2: GitHub-hosted runners
In this article, you’ll learn about the many options for using a GitHub-hosted runner, including Docker.
2025-05-23
SQL STRING_AGG Function Use and Examples
The STRING_AGG function concatenates strings separated by a specified separator. This was introduced with SQL Server 2017.
2025-05-21
Helpful Management Studio Settings and Features
Learn a few tips and tricks to make your work with SSMS much more efficient and helpful.
2025-05-19
5,458 reads
Securing the DevOps Pipeline Part 2: Hardening Kubernetes and Cloud Security
In Part 2, we shift our focus to securing containerized deployments and cloud infrastructure. We will cover Kubernetes security hardening, real-time monitoring, infrastructure as code (IaC) security, and shifting security left to catch misconfigurations early. These strategies will help your team secure workloads in production and respond to potential threats before they lead to a security breach.
2025-05-19
How to Safely Remove a SQL Server Data File Without Downtime
Learn how to safely remove a SQL Server .ndf data file without any downtime using DBCC SHRINKFILE (EMPTYFILE). This hands-on tutorial walks through real-world Azure-based setup, data redistribution, and storage cleanup — ideal for DBAs managing enterprise SQL Server environments.
2025-05-16
2,849 reads
SQL ASCII Function Use and Examples
The ASCII function is used to return the ASCII value for the first character in a string.
2025-05-16
Your SQL Server Needs Spring Cleaning, Too.
First things first: pick up that filthy keyboard, take it over to the trash can, turn it upside down, and give it a good, vigorous shake.
2025-05-14
Blogs
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
This Week's AI Trust Problem Became Everyone’s Problem
Comments posted to this topic are about the item This Week's AI Trust Problem...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers