Using IIF in Reporting Services
I found an interesting use for the IIF function in a Reporting Services report this week. I needed to provide...
2007-03-10
1,727 reads
Blog Posts
SQL Server Learning Opportunities!
There are two big SQL Server learning opportunities I want to remind you about. First, DevTeach/SQLTeach will be held in...
2007-03-09
1,800 reads
Midlands PASS Job Board
In order to assist those members of the Midlands PASS Chapter looking for new positions, I have put up a...
2007-02-26
1,347 reads
Hacked
Boy that was fun. Getting a bunch of emails that we had been hacked and tracking down someone updating all...
2007-02-22
1,523 reads
SP2
Mentioned by Tim Mitchell, but SP2 is out.
Seems more like enhancements to make things smoother and lots of changes in...
2007-02-20
1,464 reads
SQL Server SP2 released
Today, Microsoft released Service Pack 2 for SQL Server 2005. Though mostly a series of fixes for minor issues, there...
2007-02-19
1,427 reads
Microsoft SQL Server certification
A few weeks ago I was engaged in a useful discussion about the merits of getting certified on Microsoft SQL...
2007-02-18
1,919 reads
Daylight Saving Time and SQL Server
If you're in the United States, chances are you've already heard about Daylight Saving Time (DST) occurring 3 weeks early...
2007-02-13
2,672 reads
Midlands PASS Site Online
I have put the Midlands PASS site online temporarily at Truth Solutions. You can reach it here:
http://www.truthsolutions.com/MidlandsPASS/
The slides from Paul...
2007-02-12
1,616 reads
Guest Editorial Week
I've been writing the editorials for over two years now and it's become an almost daily part of my life....
2007-02-11
1,452 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