Book Review: Alas, Babylon
I just re-read Alas, Babylon by Pat Frank ($10 @ Amazon). It’s a bit of a touchstone for me. It was...
2010-12-03
613 reads
Blog Posts
Free SQL Server Training for the Week of December 6, 2010
Took a break from posting this last Friday due to the holidays. But I'm back with the weekly updates.
Monday
PASS Data Warehousing/BI...
2010-12-03
941 reads
How Many Have I Read?
I saw this on Facebook, and while I’m not sure of the list, I reproduced it here. I think that...
2010-12-03
541 reads
MCM – Useful Resources
This is just a short post for a Friday. There has been a lot written over the past few weeks...
2010-12-03
558 reads
RTFM365 Week 0
For the next year, I will read from SQL Server Books Online a little every day, and blog about it weekly. ...
2010-12-03
716 reads
Signal Waits and Resource Waits...a clarification
Signal Waits vs. Resource Waits
During my presentation at SQLSaturday#59, I spoke about the categories of wait types, such as...
2010-12-03
20,909 reads
What You Practice
I saw a very interesting blog at 37 Signals on the quote “the things you do more often are the...
2010-12-03
547 reads
All Things Awesome and MidnightDBA-y – 12/2/2010
I’ve got to figure out a good way to present a regular summary of what we do every week. Until...
2010-12-02
652 reads
Clustered index vs Non clustered index
AdvertisementsClustered index vs Non clustered index structure
Clustered and Non clustered indexes are stored in a B – tree structure .
Clustered...
2010-12-02
2,648 reads
December Question: What does it mean to be a Proactive DBA?
One of the things I promote in all my presentations is the importance of being a proactive DBA. Unfortunately, the...
2010-12-02
619 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
Getting results from a Procedure to join to a query
I have a need to execute a stored procedure and return the results to...
Upgrade 2016 Standard to 2022 Express
Title pretty much says it all - can this be done? I've tried several...
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers