Upcoming Engagements
I haven’t been speaking a lot lately as I’ve been busy working, planning SQLSaturday #49 – Orlando, and planning PASS SQLRally,...
2010-09-07
481 reads
Blog Posts
Virtual Labs - A Great Resource for SQL Server
I had someone send me a note recently asking some questions about how to get set up to work with...
2010-09-07
1,063 reads
What is Normalization in SQL ?
=> What is normalization ?
Defination :Normalization is the process of efficiently organizing data in a database. There are two goals of...
2010-09-07
303,373 reads
24 Hours of PASS coming over the next two days
Hey folks,
The 24 hours of PASS is coming very quickly.http://www.sqlpass.org/24hours/fall2010/. There are so many great sessions that I don’t know...
2010-09-06
515 reads
An impossible case
In a previous blog entry (Inconsistent NullIf behaviour), Jeff Moden and Dan Halliday(twitter) both made a very similar observation.
When executing...
2010-09-06
550 reads
Awards for SQL Heroism
Motivational time again!
Have you ever worked on a project where someone was seeking their moment in the sun for an...
2010-09-06
218 reads
Building your 1st Performance Point Dashboard in Sharepoint 2010
Hey there gang
The PASS BI Virtual Chapter is presenting some great stuff this fall. September 14th I’m doing a new session on...
2010-09-06
383 reads
Get ready for the Third Annual SW Florida .Net Code Camp!
Hey there database folks! Don’t be scared off by a little .NET. The SW Florida code camp is getting underway...
2010-09-06
364 reads
Idera SQL Tools – An evaluation (Part 2)
This is the 2nd in the series of evaluations I have carried out on Idera’s SQL Server Toolbox. The first...
2010-09-06
1,325 reads
Labor Day Bloopers
Happy Labor day to everyone. A day off for me, but I’m posting a few bloopers from the past couple...
2010-09-06
1,101 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 BCA KCU BENGKULU TLP/WA 08218154374
Hub Cs:08218154374 Jl. S. Parman No.66, Kebun Kenanga, Kec. Ratu Agung, Kota Bengkulu, Bengkulu...
ALAMAT BCA KCU BUKITTINGGI TLP/WA 08218154374
Hub Cs:08218154374 Jl. Sudirman No.59, Bukit Cangang Kayu Ramang, Kec. Guguk Panjang, Kota Bukittinggi,...
ALAMAT KANTOR BCA KCU PADANG TLP/WA 08218154374
Hub Cs:08218154374 Jl. H. Agus Salim No.10 A, Sawahan, Kec. Padang Tim., Kota Padang,...
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