MDX and DMX Templates
One of the most underused features in SSMS is the additional templates that are available for MDX, DMX, and XMLA....
2009-11-23
594 reads
Check out my new blog location
My new blog has been centralized at http://www.bidevelopernetwork.com/blogs/AdamJorgensen/. Check it out for all my new updated content.
2009-11-23
529 reads
The Car Update – Prius Sales
I haven’t done a car update in some time, and I’d like to get back to them. Surprisingly quite a...
2009-11-23
723 reads
Opening Doors – Part 1
As a speaker, blogger, even a DBA at work it’s hard to know when you’re having a positive impact on...
2009-11-23
722 reads
Deploying Reports on Windows 7
Recently I tried to deploy a report to a Report Server on my laptop, which is running Windows 7 Ultimate....
2009-11-23
1,117 reads
Raising a Technology Savvy Daughter
I was introduced to electronics at a very young age. I think I was three when I first started doing...
2009-11-23
712 reads
Change the Report Manager logo
A common question I've been asked a lot lately is how to replace the icon in the Report Manager to...
2009-11-22
14,736 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
Fundamentals of Storage Systems – Capturing IO Patterns
We often take the advice given to us on forums or in articles at face value. Even though the authors...
2009-11-20
4,244 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...
Getting results from a Procedure to join to a query
I have a need to execute a stored procedure and return the results to...
Upgrade 2016 Standard to 2022 Express
Title pretty much says it all - can this be done? I've tried several...
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