Is It that Time Again?
Yes, it is. As I mentioned a few months back, it is important to pay attention to when Microsoft releases...
2010-09-23
510 reads
StrateSQL
Index Black Ops Part 3 – Index Usage
Last week, I mentioned in my TSQL2sDay index summary post, that I’d be writing a few posts on the information...
2010-09-22
1,465 reads
September PASSMN Meeting Tonight
As I’ve mentioned a couple times already our PASSMN meeting tonight will be in a new location. This is a ...
2010-09-21
442 reads
SQL Saturday 50 (#sqlsat50) – A Tale
This past weekend I went to SQL Saturday 50 – this is a day long SQL training event that is put...
2010-09-21
826 reads
September PASSMN Meeting This Week
Enjoying the fall here in Minnesota? The leafs are changing a bit and temp has been dropping. Has that left...
2010-09-20
509 reads
Share Your Experiences at #SQLSAT58
Ever thought about sharing your experiences with SQL Server to more than just your immediate peers and colleagues? Up here...
2010-09-20
638 reads
Index Black Ops Part 2 – Page IO Latch, Page Latch
As I mentioned in my TSQL2sDay index summary post, the I am writing a few posts on the information that...
2010-09-16
3,107 reads
Index Black Ops Part 1 – Locks and Blocking
As I mentioned in the my TSQL2sDay index summary post, the next few posts will be on sys.dm_db_index_operational_stats and the...
2010-09-15
1,405 reads
September PASSMN Meeting Next Week
Ever feel like you are all alone? Maybe a little isolated? This month’s PASSMN meeting might bring up these feelings...
2010-09-15
627 reads
An Index on Indexing #TSQL2sDay
Here we are with another T-SQL Tuesday and time for my entry into the fray. This month we are talking...
2010-09-14
727 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