SQLPASS Day 2: Keynote Live Blog
Them's some SEXY DBAs...
I’m live blogging the PASS keynote…it’s 8:44 local time.
Here’s the PASS website description of the day 2 keynote...
2010-11-10
515 reads
Jen McCown
SQLPASS Day 2: WIT Luncheon Live Blog
12:42pm local time at the live streamed Women in Technology luncheon…let’s blog. I’ll italicize my comments, to differentiate betwee that...
2010-11-10
1,126 reads
SQLPASS Day 1: Keynote Live Blog
Day 1 Keynote Jumps the Shark with Tina Turner Impersonator
I’m live blogging the PASS keynote…it’s 8:38 local time.
You wouldn’t guess...
2010-11-09
762 reads
MERGE Statement Corrected, or, How to Eat Crow in Public
Better pull out the excuse-o-meter
I have no excuse, none whatsoever.
In my T-SQL Brush-Up presentation to the North Texas SQL Server...
2010-11-03
842 reads
Attend the PASS Summit From Home
You there, sitting in your cube and fuming at all the PASS Summit talk: you couldn’t talk your company into...
2010-11-01
882 reads
A Little SSMS Wish
IN SQL Server 2000, we didn’t have the fancy-schmancy Management Studio…we had Enterprise Manager and Query Analyzer, and we liked em,...
2010-10-27
518 reads
SQL Saturday #56 BI Edition Wrap-up
On Saturday I (unexpectedly) presented at Dallas’ first Business Intelligence-focused SQL Saturday at the Microsoft campus in Irving. I wasn’t on...
2010-10-25
1,515 reads
SQL Saturday #56 – The 24 hour Challenge
SQL Saturday #56, Dallas BI edition, is tomorrow. Last night before the NTSSUG meeting, we had an unusually high number of...
2010-10-22
800 reads
Ground Zero Database Design: Part 2
Last week I wrote Ground Zero Database Design, thinking that was a good enough bare-bones intro (with recommended reading!) that...
2010-10-20
747 reads
SQLKilt / WIT Shirts
This shirt was specifically requested by an online friend who shall remain nameless (his name rhymes with “Duck Hoodie”). Another...
2010-10-20
1,100 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