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
168 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
800 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,049 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
940 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)
3,985 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,781 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
692 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
116 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
30 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,619 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers