A day in the life of a DBA using SQL Monitor: in a 90 second video!
We created a new, short video to show how a DBA can use SQL Monitor in their day to day work, including sharing reports with senior leaders. Watch it now.
Running a Python Application as a Windows Service
In this article, we look at how to build a Python application that runs as a Windows Service to handle ongoing routine tasks.
Stairway to MDX - Level 13: MDX Time/Date Series Functions: LastPeriods() and ParallelPeriod() Functions
BI Architect Bill Pearson continues with the third of a subseries surrounding a group of MDX functions we can use to support analysis and reporting in a time / date context. In this Level, we will explore the LastPeriods() and ParallelPeriod() functions, and get hands-on practice with each in meeting sample business requirements.
The Azure Carrot
There is a promotion for SQL Server 2012 customers that might be considering the cloud and worried about support.
Generate Random Dates in T-SQL
In this article we look at how to generate random dates in SQL Server to build a sample dataset along with code and examples
How to install SQL Server 2022 step by step
In this article, we cover how to install SQL Server 2022.
AI Ethics
I found this article to be an interesting look at how we might add ethics to AI systems in one area. As the article points out, "... today there is no broadly accepted AI ethics framework, or means to enforce it. Clearly, ethical AI is a broad topic ...". Glad someone is thinking, or many […]
Infographic Designer Visuals in Power BI
Learn how you can make your visuals more interesting with the Infographic Designer Visual.
Query SQL Server with Python and Pandas
In this article, we examine how to read SQL Server data and parse it directly into a dataframe and perform operations on the data using Python and Pandas.
Blogs
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Forums
Windows logins for users migrated from DomainA to DomainB
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers