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

Generic Modifier In & Out C#

In [Contravariant]
The image is self-explanatory.

Out [Covarient]
The image is self-explanatory.

Generic Modifier In & Out C#

In [Contravariant]The image is self-explanatory.

Out [Covarient]The image is self-explanatory.

Highlighting sp_spaceused

I’ve been using sp_spaceused a lot recently so I thought I would bring it up again. Basically it’s a quick...

How does data file size relate to log file size?–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

How much affects encryption to your database performance?

Transparent data encryption (TDE) helps you to secure your data at rest, this means the data files and related backups are encrypted, securing your data in case your media...