The SQLSaturday Squirrel
A bit of mid week humor. Recently I met up with Jack Corbett to review our room options for SQLSaturday...
2010-09-14
536 reads
Blog Posts
T-SQL Tuesday #10 - Indexes
It’s time for T-SQL Tuesday again, the brainchild of Adam Machanic (Blog|Twitter), and this month’s topic is Indexes. A thanks...
2010-09-14
1,639 reads
24 (28) Hours of PASS on Sep 15, 2010
It’s back with a slightly different format this time, 28 hours of seminars delivered over two days, and it’s all...
2010-09-13
573 reads
Database automation and appliances
10 years ago IT professionals considered database technology “mature” and analysts were preparing to...
2010-09-13
14 reads
Database automation and appliances
10 years ago IT professionals considered database technology “mature” and analysts were preparing to slide it into a commodity status… But on the Exabyte era, we depend on databases...
2010-09-13
14 reads
Getting Drive Info, Part 4, the SSIS Script Component
In this installment of the Getting Drive Info series (Part 1, Part 2, Part 3), SSIS will be used to...
2010-09-13
1,342 reads
Getting Drive Info, Part 4, the SSIS Script Component
In this installment of the Getting Drive Info series (Part 1, Part 2, Part 3), SSIS will be used to collect and save the drive information. SSIS provides multiple...
2010-09-13
12 reads
Project Phoenix expands to Australia and New Zealand
A couple of months ago, many Microsoft MVPs received Visual Studio 2010 Ultimate MSDN subscriptions (retail value: ~$12,000) to distribute...
2010-09-13
628 reads
Quote of the Day
I do not usually post a quote of the day but since this is my own quote I decided to...
2010-09-13
358 reads
Space Coast User Group Recap
I had the pleasure of making my second annual September visit to the Space Coast SQL Server User Group in...
2010-09-13
342 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