SSWUG Fall 2010 Virtual Conference This Week
Conference Time! The SSWUG Fall 2010 Virtual Conference is coming up this week. On October 20-22, you can attend a...
2010-10-18
563 reads
StrateSQL
4-Weeks to PASS Summit 2010 Countdown – Lunch
There are now 4 weeks until the PASS Summit and a few times now I’ve discussed ( 1, 2, 3 ) some...
2010-10-14
783 reads
Finding Missing Values from an Array
Missing NumbersToday a developer came up to me and wanted help solving a problem he was running into with a...
2010-10-13
1,056 reads
Return of Index Analysis Part 3
Let’s Anaylze An Index!Time for part three of my continued Index Analysis query. The previous posts in this series are:...
2010-10-13
984 reads
Index Black Ops Part 6 – Fill Factor vs. Page Splits
In my TSQL2sDay index summary post, that I’d be writing a few posts on the information that is contained in...
2010-10-11
3,682 reads
Project Phoenix
Project PhoenixSometime people need a hand up – an opportunity to rise from the ashes. Over the last couple of years...
2010-10-09
895 reads
5-Weeks to PASS Summit 2010 Countdown
With 5-weeks until the PASS Summit it’s time to start getting ready for the event. As I’ve discussed a couple...
2010-10-06
741 reads
PASSMN Board of Directors Nominations
It’s that time of the year again. Time to get in some nominations for the 2011 PASSMN Board of Directors. ...
2010-10-06
1,099 reads
Return of Index Analysis Part 2
Let’s Anaylze An Index!Time for part two of my continued Index Analysis query. The previous posts in this series are:
Analyze...
2010-10-06
1,039 reads
SQL Saturday 58 Schedule Released
We technically released it on Monday but I didn’t want to blog about it for a couple days since we...
2010-10-06
742 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