How to write a SELECT query
My First SELECT Statement Microsoft SQL Server makes it really easy for us to query tables. In SQL Server Management...
2017-05-24
173 reads
Blog Posts
Power BI – Problem, Design, Solution (Concatenated Tooltip)
Welcome to a new series that I’m starting with a few colleagues at Pragmatic Works. The goal of this series...
2017-05-24
801 reads
SSAS high availability
If you are looking at providing high availability (HA) for SSAS, here are 3 options:
Install SSAS on a Windows Server...
2017-05-24
1,093 reads
TIL: Microsoft Azure Part 2
Last week I started a multi-part series on Today I Learned (TIL) about Microsoft Azure. This is part two of...
2017-05-24
949 reads
Using Azure Machine Learning with an on-premises Database
With Azure Machine Learning (AzureML) you have access to a cloud based, flexible and friendly method to perform machine learning...
2017-05-24 (first published: 2017-05-14)
4,012 reads
Copy-SqlJob, a handy dbatools cmdlet
One of the things I’ve often needed to do is move jobs around between instances of SQL Server. I’ll often...
2017-05-23 (first published: 2017-05-08)
1,786 reads
Database snapshot issue with sqlserver
Database snapshot issue with sqlserverDatabase snapshot issue with sqlserverDatabase snapshot issue with sqlserverDatabase snapshot issue with sqlserverDatabase snapshot issue with...
2017-05-23
696 reads
Experienced DBA: Rookie Mistake
M.A.S.H 4077. Mobile Army Surgical Hospital. One of my all time favorite TV shows that I still watch to this...
2017-05-23
120 reads
How To Use Temporal Tables For Easy Point-In-Time Analysis
Watch this week's video on YouTube
Have you ever needed to look at what data in a table used to look like?
If you have, it probably took a knuckle-cracking filled...
2017-05-23
33 reads
Power BI Custom Visuals Class (Module 50 – Narratives)
In this module you will learn how to use the Narrative Power BI Custom Visual. The Narrative visual is developed...
2017-05-23 (first published: 2017-05-09)
1,620 reads
Blogs
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Forums
It's Never Just One Thing
Comments posted to this topic are about the item It's Never Just One Thing
Calculating Min-Max Normalization in PowerBI
Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI
Checking the Error Log III
Comments posted to this topic are about the item Checking the Error Log III
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers