Conditionally Returning Rows Based On Query Results

Watch this week's video on YouTube
While I normally prefer formatting my query results in a downstream app/reporting layer, sometimes I can't get around adding some business formatting logic to...

Data Factory V2 Activity Dependencies are a Logical AND

Azure Data Factory V2 allows developers to branch and chain activities together in a pipeline. We define dependencies between activities as...

Database Transaction log file full in the full recovery model

AdvertisementsI am seeing in more environment the database recovery model is set FULL and there is no transaction log backup...

how to embed a PowerBI report into HTML code

PowerBI is a powerful reporting solution for Business Intelligence for analytical reports, it is not meant to replace SSRS, the...

Internal Query Processor Error Debugged

In Joyful Craftsmen we provide, among other things, technical support to our customers, which from time to time involves us...

Lookup. Foreign Key Constraint vs Check Constraint

This post helps in deciding between choosing foreign key and check constraints in case we need to constraint the data...

Speaking at SQL Saturday Oregon

I am so excited and honored that I have been selected to speak at SQL Saturday Oregon on November 3,...

ASF 015 video invitation

“This was in Dallas, we had our MVP Summit in Dallas and there were only maybe like less than 10...

Checking for Membership of a Specific Active Directory Group

As part of my job I manage a bunch of SQL instances for Development and Test.
Access is managed though Active...

Generic Modifier In & Out C#

In [Contravariant]
The image is self-explanatory.

Out [Covarient]
The image is self-explanatory.