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

Why is shrinking IT budgets a good thing?

By

Each year around this time, companies enter the familiar ritual of budgeting. For many,...

Reverse Engineering a Physical Model Diagram

By

I recently wrote about a logical diagram with Redgate Data Modeler. That was interesting,...

Prepping for Certification, Part 3 of ?

By

After I have understood the details for a certification test (part 1), including format...

Read the latest Blogs

Forums

Best analysis approach to reduce data type length in multiple tables

By Lord Slaagh

Hello SSC, I hope everyone is having a happy and safe holiday season! I...

Do you separate data/log files and TempDB files on different disks using AWS EC2

By WebTechie

Hello,   I am receiving multiple direction on deploying SQL Servers in AWS EC2. ...

Service account being in local admin in AWS EC2 environment?

By WebTechie

Hello, I am working with a company on their database administration.  I am trying...

Visit the forum

Question of the Day

A New Operator

In SQL Server 2025, what does this code return? 

SELECT '1' || '0'
 

See possible answers