When working with Blackbaud Enterprise CRM, you may create tasks that point to a report. Here’s how to extract the related report and roles from a task:
;WITH XMLNAMESPACES ('http://www.w3.org/2001/XMLSchema-instance' AS xsi,
'http://www.w3.org/2001/XMLSchema' AS xsd,
'bb_appfx_commontypes' AS common,
'bb_appfx_pagedefinition' AS pagedef,
TC.TASKSPECXML.value('(//TaskSpec/common:ShowReport/@ReportID)', 'varchar(100)') REPORTID_FROMTASKSPEC,
TC.TASKSPECXML.value('(//TaskSpec/common:ShowPage/@PageID)', 'varchar(100)') PAGEID
INNER JOIN SYSTEMROLE SR
ON R.SYSTEMROLEID = SR.ID
INNER JOIN TASKCATALOG TC
ON R.TASKID = TC.ID
Just read this article from Business Insider entitled This viral video from Microsoft on how girls feel about science is fantastic.
It’s awesome. Loved it. Spoiler alert – at the end of the video, the girls get a card from Microsoft that encourages them to keep on doing what they do:
Thanks @Microsoft for encouraging girls to do science.
To back up your database to Azure BLOB storage, first you need to set up the BLOB storage in your Azure account. You will also need to create a container first.
You can back up the database to Azure by using either PowerShell or T-SQL.
We had to trace which among our hundreds of Blackbaud Enterprise CRM (BBEC) ad hoc queries were using Site from the Designation node. We also needed to figure out if they were being used as output or being used as filter.
Here’s the script that did the trick.
You’re a SQL Server DBA and you want to learn Windows Server Failover Clustering? On April 20, 2015 MSSQLTips is hosting an online training, and you can learn from SQL Server MVP and MCM (Microsoft Certified Master) Edwin Sarmiento. Check out the details here:
Do you know that changing a shared axis chart to a stacked bar chart in Tableau is as easy as one drag?
Supposed you have a shared axis chart like this:
I had a question from one of my students tonight about how to show the header for text table with a single measure. It’s not super straightforward to do this in Tableau. You can’t simply to go the measure pill and show the header (because it doesn’t have it).
Let’s recreate the default Tableau behavior first, using Superstore Sales.
1. Double click on a dimension, for example, Product Category
2. Double click on a measure, for example, Sales
What you will get is something like this: