Measure Group Properties Explained
When configuring measure groups in SSAS, you want to make sure you address a few important properties. They are show...
2010-02-21
2,883 reads
MDX Member Functions
There are a large number of Member functions in MDX that do everything from returning ancestry of a member to...
2010-02-21
1,687 reads
Free Data From Across the Pond
Ok so I know a statement like that will whip some of you into a frenzy, but it’s true. No...
2010-02-21
534 reads
I'm Speaking at SQLLunch
I am excited to be speaking at SQLLunch.com on March 1st. SQL Lunch is a great website event where Host...
2010-02-21
348 reads
Microsoft AdCenter and SQL Server Analysis Services 2008
There is a recently published whitepaper that talks about Microsoft AdCenter using SSAS 2008 to accelerate performance over 2005. Most...
2010-02-21
526 reads
Disk Partition Alignment
This whitepaper from Greg Lowe talks about the important strategy behind disk partition alignment. This is focused mainly in SQL...
2010-02-21
529 reads
Data Type Precedence and Implicit Conversions
In my last post, I noted that one of the biggest differences between ISNULL and COALESCE was the fact that...
2010-02-21
4,507 reads
Modifying SQL in a Lookup Transform
Oftentimes you need to make a more advanced join that the default LookUp Transform will allow. The challenge is when...
2010-02-20
352 reads
Selecting Top N Rows from Excel Source
Excel is a significant source of data in most enterprises. Therefore there is a large amount of Excel work being...
2010-02-20
273 reads
SSAS Query Processing and Performance Tuning
Any of us can work with some simple MDX queries and get them to do what we want, but in...
2010-02-20
295 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