Joyful Crafsmen is a young company designing, constructing and operating business intelligence solutions for enterprises. People behind are experts in Microsoft Data Platform, which includes SQL Server, Microsoft Azure, Power BI and other leading edge Microsoft technologies. Sharing our know-how with others is our other love. Through training, consulting, and teaching in our community, we help others to be better and better every day.

All authors

All authors

Blogs

A New Word: Feresy

By

feresy – n.  the fear that your partner is changing in ways you don’t...

Mastering the ORDER BY Clause in SQL Window Functions

By

This article provides a comprehensive overview of the ORDER BY clause within SQL window...

SQL Data Pipelines: The Ultimate Guide to Streamlining Your Data Flow

By

Want to build a data analytics foundation that transforms raw data into valuable business...

Read the latest Blogs

Forums

The Cloud Security Problem

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Cloud Security Problem, which...

MySQL joining - a tricky problem from a newby

By dkreynolds

Hi, I'm not even sure whether this is possible. I've three tables, one containing...

Iterative query to sum a colum relating to dates.

By Tallboy

Hi, I have a simple table with 5 columns as follows with about 80,000...

Visit the forum

Question of the Day

No Renames

Which of these can't be renamed with sp_rename?

See possible answers