SQL Lunch #8 recording
If you weren't able to attend tuesday for SQL Lunch you can watch the recording now mosted on the website. ...
2010-01-15
604 reads
Blog Posts
SQL Server Waits and Queues
Recently, I was asked to do an extensive sql server performance audit and review. I will be sharing some of...
2010-01-15
9,715 reads
SQLServerCentral
My boss gave me an assignment, asking for 200 words on the history of SQLServerCentral. This is what I came...
2010-01-15
1,465 reads
Too Much Data – Idiocracy or Star Trek?
I used to think that too much data was never a bad thing. That having more information out there is...
2010-01-15
928 reads
Using Synthetic Benchmarks To Help Evaluate Database Server Hardware Choices
As a DBA, I think it is very important to stay current on trends in x64 based hardware. The DBA...
2010-01-15
736 reads
Vancouver’s Winter Olympics Less Than 30 Days to Go (!) – But Not Without Issues
There are some Februarys in Vancouver, while growing up, when I can remember wearing shorts and watching plants flowering, therefore with...
2010-01-15
650 reads
Book #9 - Dearly Devoted Dexter
The second in the Dexter series, Dearly Devoted Dexter starts out with him stalking in the bushes. It’s a well...
2010-01-14
836 reads
Broadcasting OPASS over Live Meeting
Well, on January 12th OPASS moved into the present by broadcasting our meeting over the internet using Live Meeting. Our...
2010-01-14
481 reads
DevExpress and a Stumper
Late last year I used the DevExpress controls for a small task after they were recommended by a friend. Very...
2010-01-14
592 reads
Free eBook on SQL Server Maintenance Plans Now Available
My new eBook, Brad’ Sure Guide to SQL Server Maintenance Plans is now available as a free, 269 page PDF...
2010-01-14
1,779 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