New SQL Regex Functions in SQL Server 2025 and SSMS
In this article, we cover the new SQL regex functions built into SQL Server 2025 and how these can be used in your SQL code.
I have a passion for crafting Business Intelligence Solutions for my user groups. My experience includes almost 15 years of SQL Server involvement with the last 12 years focused specifically on Business Intelligence, SharePoint, OLAP, SSRS, and Decision Support solutions. Currently, I am a Business Intelligence Architect in the healthcare industry, and I also teach database and analytics classes for Kennesaw State University, Southern New Hampshire University, and Reinhardt University. My education includes an MBA and an undergraduate in Accounting (yes I am a reformed accountant!), both from Kennesaw State University. I enjoy every day by trying to grow my faith and spend precious time with my family. I have been happily married to my wife of over 20 years, and we have two teenagers one who we home school with the help of a University Model School, Cornerstone Prep in Acworth, GA (cornerstoneprep.org). Our other child is a Construction Management major at KSU's Southern Poly / Marietta campus. We are a soccer and Cross Country (XC) family who play, coach, and referee soccer or run for fun most every day. For several years, our family has volunteered (and played with the dogs and cats) at Etowah Valley Humane Society in Cartersville, GA.
- MSSQLTips Awards: Champion (100+tips) - 2016 | Author of the Year - 2015 | Author Contender - 2014, 2016-2021
SQL Server Management Studio and Copilot
Learn how to enable and integrate SQL Server Management Studio and Copilot with this real life example of creating database objects.
What is Tableau?
In this article, we look at what is Tableau and how would you use the powerful business analytics platform instead of Power BI.
Data Quality Testing
In this article, we look at ways data professionals can think about Data Quality and some methods for data quality testing.
Datasets in SSRS to Define the Data Structure
In this article, we look at how to use datasets when developing SQL Server Reporting services reports along with examples.
SQL Server Reporting Services Security
This article examines SQL Server Reporting Services security and what you should know from the Configuration, Web Service, Folder, and Report Level.
SQL Server Reporting Services Quick Reference Guide
Reference guide to key SQL Server Reporting Services topics: installation, configuration, administration, features, report builder tool, and security.
Power BI Best Practices for Development, Visualizations, Performance
Check out this article to learn some best practices when working with Power BI.
Power BI Download, Install and Get Started
In this article learn how to download, install and get started building your first Power BI report using SQL Server data.
Power BI Desktop for Report and Dashboard Design
Learn about Power BI Desktop the stalwart development tool used for the bulk of report and dashboard design work in Power BI.
Power BI Desktop for Business Intelligence
Learn the who, what, where, when and why of Power BI to better understand how this reporting tool fits into your data environment.
New Power BI Diagram View and Schema View for Power Query Editing
Learn how to use the new diagram view along with a schema view in Power BI to make Power Query online editing easier on report designers.
Power BI New Navigation Features for Improved Interactivity
Learn about the new navigation features in Power BI to make for better interactive Power BI reports for the end users.
Power BI Zoom In and Focus Mode for Charts and Graphs
In this article we look at how to add the zoom feature to your charts and graphs in Power BI reports for a better user experience.
SSRS Interview Questions
Review some questions and topics that may come up in an interview related to SQL Server Reporting Services along with many links for further learning.
Auto-Create a Power BI Report
In this article we look at how to get Power BI to Auto-Create a report for your based on data input or copied into a new dataset.
SSRS IIF, Switch and Choose Functions
Learn how to use IIF, Switch and Choose logical functions in SSRS reports to make your reports more dynamic and more appealing to report users.
Build Better SSRS Reports – Things I Wish I Knew
Learn five things you should know about SSRS to help you build and create better reports using SQL Server Reporting Services.
SSRS vs Power BI
Learn about different features of Power BI versus SQL Server Reporting Services and which tool may be a better fit based on development needs.
Getting Started with SSRS
Learn about various aspects of SSRS with resources to get you started as well as build upon your existing knowledge.
Power BI Anomaly Detection
In this article we look at a Power BI feature to detect anomalies and outliers in the data.
Power BI Smart Narrative
Power BI Smart Narrative allows you to add a textual narrative to your reports to help provide additional information to the user.
Power BI Small Multiples Visual Example
Power BI Small Multiples visual is a new feature. Read how to enable this feature and use in Power BI reports.
Power BI Theme Generator New Methods and Customizations
New methods and usage for themes were recently introduced for Power BI and in this article we cover how you can use these and customize them for Power BI.