SQLLunch Resources – Mining Nuggets from the Default Trace
I did my first SQLLunch today and it was fun. I don’t know how many attended, my last look was...
2009-12-21
361 reads
MySpace Using SSDs
Glenn Barry (blog, twitter) posted a note about MySpace using Fusion-IO PCi-E cards to replace hard drives in their systems....
2009-12-21
1,133 reads
Developer Stereotypes
It’s interesting to listen when DBA’s get together, there is always a story or two about the evil that developers...
2009-12-21
1,019 reads
String Manipulation - CHARINDEX()
I see charindex used quite commonly in string manipulation. What I rarely see used is the optional third parameter. Here...
2009-12-19
4,440 reads
Have Lunch with Me
I know you all are clamoring for the opportunity to have lunch with me so I agreed to do a...
2009-12-18
342 reads
Anaylsis Services Partitions and Aggregations PASS Session
For a little more than a year now I've been a part of the PASS BI SIG and have tried...
2009-12-18
431 reads
iPhone Stockholm Syndrome?
I’m not sure it’s true. I don’t think I have iPhone Stockholm Syndrome, as suggested by the article. It’s actually...
2009-12-18
1,472 reads
Taking Notes When You Don't Have a Computer
Yesterday I talked about taking notes using Google Docs. It's a great way if you've got multiple systems (especially with...
2009-12-18
1,563 reads
Stop Splashing with –NoSplash
Many times when I'm teaching a class or working with a group, they express frustration at the load time for...
2009-12-18
487 reads
Holidays and Parties, Gift, Expectations, and Wishes
Most companies do something at the holidays, although it seems to be less with each year, and certainly this holiday...
2009-12-17
1,007 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