Find SQL Database Owner with T-SQL
One thing that on occasion bugs me about PDW or APS or whatever it happens to be called this week...
2014-05-08 (first published: 2014-04-29)
4,289 reads
Bradley Schacht
Webinar Q&A: Getting Started With Analysis Services
I recently presented a free webinar for Pragmatic Works Free Training on the T’s about Getting Started With Analysis Services....
2014-03-21
1,443 reads
SharePoint 2013 – Failed to install the product: D:\global\oserver.msi ErrorCode: 1603(0x643)
I often do my SharePoint setups on virtual machines since I need to build them up and tear them down...
2014-03-04
2,853 reads
Webinar Q&A: New BI Features in SharePoint 2013
I recently presented a free webinar for Pragmatic Works Free Training on the T’s about new Business Intelligence features in...
2014-02-28
1,782 reads
A New Year is Right Around the Corner
If you read my 2013 Year In Review you may be here today wondering why I haven’t posted anything despite...
2013-12-30
1,563 reads
Presentation Update: New BI Features in SharePoint 2013
It’s time for another free webinar!!
Whether you like it or not SharePoint is here to stay! With every release of...
2013-12-06
1,234 reads
Presentation Update: Change Data Capture (CDC) Made Easy With SSIS 2012
Come get your learn on with Pragmatic Works and myself! In January I’ll be dropping some knowledge about change data...
2013-12-05
1,245 reads
Year In Review: 2013
Ok, so it’s not quite the end of the year yet. I figured I would get a head start on...
2013-12-04
1,236 reads
Webinar Q&A: Practical SSAS: Getting Started with Analysis Services
A couple of weeks ago I did two webinars for the Pragmatic Works Free Training on The T’s. The first...
2013-12-03
1,263 reads
Webinar Q&A: SSIS Design Patterns for Loading a Data Warehouse
I’m not going to sugar coat it. I’ve been a bit of a slacker lately. Unfortunately I didn’t get the...
2013-12-03
1,581 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