TSQL Challenge 38 - Calculate SQL Stars awarded to the Winners of TSQL
This challenge involves parsing a delimited string and applying some logic to perform some calculations based on the position of tokens within the string.
2010-09-06
1,475 reads
Press Release
Introduction to SQL Server Statistics
A free virtual chapter presentation by Andy Warren on Sept 7, 2010 at 12:00EDT. This beginner to intermediate level session will introduce you to statistics, including how to create, manage, troubleshoot, and more!
2010-09-03
4,093 reads
SQLBits - The 7 Wonders of SQL
Last day for early bird registration for the next SQLBits conference on Sept 30th-Oct 2, 2010 at York University. SQLServerCentral has a discount code if you'd like to attend.
2010-09-03 (first published: 2010-07-29)
4,127 reads
SQL Saturday #50 - East Iowa
Come to a SQL Saturday in Iowa City on Sept 18, 2010 and get a free day of training from the SQL community.
2010-09-03
954 reads
Tracy Hamlin, Exceptional DBA of 2010, on what it means to go the extra mile
An interview with the Exceptional DBA of 2010, Tracy Hamlin.
2010-08-24
2,715 reads
Tracy Hamlin elected Exceptional DBA of 2010
Congratulations to Tracy Hamlin, voted to be the Exceptional DBA of 2010.
2010-08-23
1,544 reads
TSQL Challenge 37 - Calculate the downtime and duration of servers bas
This is a challenge to identify the downtime of servers from the log data generated by a monitoring application.
2010-08-23
1,520 reads
Improving database development with SQL Source Control
A webinar sponsored by Red Gate Software showing you how easy it can be to source control your database code. Thursday, August 19, 2010 12:00 PM EDT
2010-08-17 (first published: 2010-08-05)
4,659 reads
SQL Social in Kent
On Aug 18, 2010 there is a SQL Social meeting in Kent, UK. Read about the details and attend if you are in the area.
2010-08-10
1,683 reads
TSQL Challenge 36 - Create a graph/Chart with TSQL
This challenge invites you to create a graph/chart using T-SQL
2010-08-09
3,804 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