MDX Time Calculation Shortcuts
There are lots of ways to calculate time comparisons in MDX, but there are some great shortcuts. The functions WTD,...
2010-02-20
292 reads
Connecting to DB2 AS\400 with SSIS
We have a lot of projects in our organizations that require us to work with database systems other than SQL...
2010-02-20
4,512 reads
Carrier Pigeon Beat Local Telcom
It’s not often that we find stories that make us laugh out loud, unless they have to do with situations...
2010-02-20
247 reads
Automate Back Slashes in Your File Path Expressions in SSIS
One of the most aggravating things when work with the SSIS expression language is when you have to combine file...
2010-02-20
2,328 reads
Keynote Speaker!
Actually it’s not as big a deal as it sounds, but still a little exciting. I was asked to be...
2010-02-20
684 reads
Free SQL Server Webinar Series
Are you new to SQL Server?Do you want to learn about its many features and capabilities? If so, please join...
2010-02-20
777 reads
Connecting to DB2 AS\400 with SSIS
We have a lot of projects in our organizations that require us to work with database systems other than SQL...
2010-02-20
1,706 reads
MS SQL Server Migration Assistant for MySQL v1.0 CTP1
There it is the SQL Server Migration Assistant or SSMS for MySQL, it comes for both versions SQL Server 2008...
2010-02-20
1,873 reads
So You Want to Write a Book?
What the heck is wrong with you?
Still interested? Fine. I’ll tell you my take on this whole business. I’m only...
2010-02-19
705 reads
Reporting Services Switch Function
Recently a client requested to create a Reporting Services expression that emulated the CASE WHEN statement from T-SQL. The expression...
2010-02-19
4,291 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 Kontak Bank BCA KCP Ubud Telp:08218154393
WA:08218154393 Jl. Raya Ubud No.10, Petulu, Kecamatan Ubud, Kabupaten Gianyar, Bali 80571
Alamat Kontak Bank BCA KCP Maluku Telp:08218154393
WA:08218154393 Jl. Maluku No.10, Dauh Puri, Kec. Denpasar Bar., Kota Denpasar, Bali 80119
Alamat Kontak Bank BCA KCP Ciawi Telp:08218154393
WA:08218154393 Jl. Raya Ciawi No.151, Pakemitan, Kec. Ciawi, Kabupaten Tasikmalaya, Jawa Barat 46156
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