Find the number of rows for a value, without querying the table

Dear all,

Being a DBA, developers approach me with questions like can you run this query for me in production?

Select*FROM[dbo].[FactInternetSales]
WHERE UnitPrice...

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...

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...

SSAS high availability

If you are looking at providing high availability (HA) for SSAS, here are 3 options:
Install SSAS on a Windows Server...

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...

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...

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...

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...

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...

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...