MDX Puzzle #6
As we continue with the puzzles, I will continue to introduce new MDX functions. In this puzzle the requirements are...
2010-08-25
631 reads
SQLDownSouth
SQL Saturday #28 - Lessons Learned
After spending a week in Tampa, FL at a client site I've had some time to unwind and reflect back...
2010-08-23
959 reads
SQL Reporting Services - Line Graph with a Vertical Bar
So, I was recently asked if you could display a vertical bar on a line graph to denote the last...
2010-08-11
3,334 reads
MDX Puzzle #5 - Solution
Again I want to apologize for the slow posting of the solution to this puzzle, but I have been hard...
2010-08-10
583 reads
SQL lunch #28-SSIS Design Patterns 1a: Introduction to SSIS Design Patterns
In this three part series SQL Server MVP Andy Leonard will discuss SSIS Design Patterns.
Speaker: Andy Leonard
Add To Outlook:...
2010-08-08
1,072 reads
SQL Saturday #28 Update
We are just about a week away from probably the biggest FREE training event to ever take place in Baton...
2010-08-06
554 reads
SQL Saturday #28 Announces: Asks The Experts
Do you have a challenging SQL Server or .Net issue that is causing you to have sleepless nights? Well, we...
2010-08-03
516 reads
MDX Puzzle #5
Writing YTD totals and Running totals using T-SQL can take a little effort. However, with MDX it's not too difficult. ...
2010-08-01
551 reads
MDX Puzzle #4 - Solution
This puzzle may not have been much of a challenge, but it introduced two new MDX concepts. I have to...
2010-07-30
1,561 reads
2010 3rd Quarter Goals
Now that we are into the third quarter of 2010 I decided to post an update of my 2nd quarter...
2010-07-28
1,012 reads
Blogs
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Forums
ALAMAT KANTOR BCA KCU KISARAN TLP/WA 08218200174
Telp Cso: (0821)8200174 Jl. Cokro Aminoto No.28, Kisaran Kota, Kec. Kota Kisaran Barat, Kabupaten...
ALAMAT BCA KCU PEMATANG SIANTAR TLP/WA 08218200174
Telp Cso: (0821)8200174 Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera...
ALAMAT KANTOR BCA KCU ASIA TLP/WA 08218200174
Telp Cso: (0821)8200174 Jl. Asia, Simpang, Jl. Bakaran Batu No.1 C, Sei Rengas II,...
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