I’m Missing Data
One of the things that I thought about doing after the 2008 PASS Summit was to bring someone along with...
2009-11-20
705 reads
Blog Posts
MDX, DMX, and XMLA Templates
One of the most underused features in SSMS is the additional templates that are available for MDX, DMX, and XMLA....
2009-11-20
3,141 reads
PASS Summit 2009 Final Thoughts…or What I've Learned From The 2009 Summit
Last week I wrote a day by day recount of my PASS Summit experience (Monday, Tuesday, Wednesday, Thursday, Friday). Since...
2009-11-20
714 reads
Should DBAs have local administrator rights?
This was actually spurred by a post from Ted Krueger (@onpnt), which led to a short, but hearty, discussion on...
2009-11-20
14,019 reads
SQL Job Ownership Article on SSC.Com
Today, Please see my featured article appearing on SQLServerCentral.com discussing SQL Agent Job Ownership.
Have you ever had a situation...
2009-11-19
630 reads
Book Review: The Cleaner
I read The Deceived a few weeks back and enjoyed it, even though it was the 2nd book in the...
2009-11-19
499 reads
Licensing For Everyone
I used to really try not to over-license in the small companies I worked at. It seems I’d spend a...
2009-11-19
790 reads
Load Windows 7 with a Thumb Drive
With the explosion of Netbooks, it has become important to find new ways to load operating systems. I recently picked...
2009-11-19
403 reads
PDC 2009 Laptop Giveaway
During Steven Sinofsky’s keynote address at PDC09 today, he started telling a story about how some of the engineers in...
2009-11-19
1,025 reads
Impressions of PDC09 Day One
Back before I grew up and became a DBA, I used to be a developer. This seems to be a...
2009-11-18
485 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
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
ALAMAT BANK BCA KCU PEMATANG SIANTAR TLP/WA 08218200233
Telp Cs: 08218200233 Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera...
ALAMAT KANTOR BCA KCU ASIA TLP/WA 08218200233
Telp Cs: 08218200233 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