Generate Random Dates in T-SQL
In this article we look at how to generate random dates in SQL Server to build a sample dataset along with code and examples
2022-08-05
T-SQL
2022-07-27
595 reads
Generate Random Dates in T-SQL
In this article we look at how to generate random dates in SQL Server to build a sample dataset along with code and examples
2022-07-27
Summarizing data using GROUP BY and HAVING clauses
You can summarize data to get counts, averages, sums, and more using GROUP BY in T-SQL queries. Greg Larsen shows you how.
2022-07-25
T-SQL Comment Best Practices for SQL Server
Learn different ways to add comments to your T-SQL code when working with SQL Server along with several examples.
2022-07-18
2022-07-15
553 reads
2022-07-11
603 reads
Different ways to Convert a SQL INT Value into a String Value
In this article we cover different ways to convert a SQL Server numeric value into a string value.
2022-07-08
2022-07-04
462 reads
Working with T-SQL function AVG ()
Learn about the T-SQL function, AVG(), and see how it is used in a few different cases.
2022-07-01
2,755 reads
Blogs
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Want to look at cloud reporting but not sure what the costs will be?
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
The Joyful Craftsmen and the Revolt BI join forces
The Joyful Craftsmen has become the new owner of Revolt BI. The merger creates...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
SQL Server Enum Implementation: A Single-Row View Strategy for Avoiding Magic Values
Comments posted to this topic are about the item SQL Server Enum Implementation: A...
BIT_COUNT I
Comments posted to this topic are about the item BIT_COUNT I
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers