My SQLSat54 Experience
In case you hadn’t heard SQLSaturday #54 was Oct 23 in Salt Lake City. It was a dreary opening to...
2010-10-25
1,119 reads
SQL RNNR
A Haunting TSQL Tuesday Tale
Time for the ghouls and goblins to come out of the woodwork once again for another tale of deception and...
2010-10-12
1,428 reads
A Haunting TSQL Tuesday Tale
If you truncate a table, you cannot undo the action like you can with a delete. What is the difference between the two methods to remove data from a...
2010-10-12
2 reads
October 2010 TSQL Tuesday Reminder
Holy Cow, another month has flown by without much of a hint. We now have upon us another TSQL Tuesday....
2010-10-07
638 reads
It’s Implied
This has been on my radar now for a little over a week. I ran across a request in the...
2010-10-05
754 reads
The Year of the Phantom
It is amazing how fast time moves the older (and slower) we as humans get. Looking back on time, it...
2010-10-03
625 reads
Red Pyramid
After having read the Percy Jackson series of books, I wanted to read a few more books by Rick Riordan....
2010-10-02
477 reads
SQLSat 54
Wow, I have really been kinda slow in the blog department for a couple of weeks now. I have a...
2010-10-01
592 reads
TSQL Tuesday Indexes and Blobs
Woohoo – chugga chugga chugga chugga – woo woo. The train is pulling into town once again for another installment in the...
2010-09-15
1,751 reads
September TSQL Tuesday
It is hard to believe that time is flying like it is. Already it has been a month since I...
2010-09-08
523 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
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...
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...
locking down agent for new user on our dev machine
hi , a new user wants to be able to add sql agent jobs...
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...
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