Consolidating My Brand
I decided that I really like the WordPress platform, and more importantly, that I need to consolidate all the work...
2011-01-08
814 reads
Blog Posts
Microsoft Certified Master in SQL Server 2008 Knowledge Exam
I woke up bright and early this morning to take the beta version of the Microsoft Certified Master in SQL...
2011-01-08
977 reads
31 Days of SSIS – What The Sorts?! (7/31)
31 Days of SSIS
Welcome to day seventh day of the 31 Days of SSIS. If you are just joining the...
2011-01-07
554 reads
An Artist I’m Not!
One of the gifts my Mom gave my children was a ‘Painting Rocks’ kit. Great marketing, six medium sized rocks,...
2011-01-07
556 reads
Happy moments in 2010
Happy moments in 2010
Hi all wish you a happy new year.
I know it’s a late post anyway I am going...
2011-01-07
1,430 reads
It’s A Major Award!
“It’s a major award!” That’s what Darren McGavin’s signature role, Mr. Parker, proudly proclaimed to friends and family in the...
2011-01-07
592 reads
RTFM365, Week 5
I’m trying to plan out this week better, and come at the RTFM readings with a sense of direction an...
2011-01-07
468 reads
Speaking at EDMPASS This Month
If you are up in Edmonton around January 26th, you can hear my voice at the EDMPASS January user group...
2011-01-07
431 reads
SQL Server Index Tuning for Mere Mortals
One of the most important things to measure, monitor, and “get right” for good overall SQL Server OLTP performance is...
2011-01-07
3,476 reads
The laptop rebuild continues
Not done yet, but I have been slowly patching and installing software over the last few evenings, stuck at my...
2011-01-07
663 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
ALAMAT KANTOR BCA KCU WISMA ASIA TLP/WA 08218200233
Telp Cs: 08218200233 Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, RT.4/RW.9, Kota Bambu...
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