SQLXML: How to get related role ad report from a Blackbaud Task (TASKPECXML)

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,
              DEFAULT 'bb_appfx_task'), 
taskcte AS 
(
SELECT  
   TC.NAME TASKNAME,
   SR.NAME ROLENAME, 
   R.SYSTEMROLEID, 
   TC.TASKSPECXML,
   TC.TASKSPECXML.value('(//TaskSpec/common:ShowReport/@ReportID)[1]', 'varchar(100)') REPORTID_FROMTASKSPEC,
   TC.TASKSPECXML.value('(//TaskSpec/common:ShowPage/@PageID)[1]', 'varchar(100)') PAGEID 
FROM
    V_SECURITY_SYSTEMROLEASSIGNMENT_USER_TASK R
    INNER JOIN SYSTEMROLE SR
    ON R.SYSTEMROLEID = SR.ID
    INNER JOIN TASKCATALOG TC
    ON R.TASKID = TC.ID
)

SELECT * 
FROM taskcte

Girls do science – and @Microsoft #Recruiting2027 awaits

microsoft recruiting2027
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:
encouragement

Thanks @Microsoft for encouraging girls to do science.

Back up SQL Server database to Azure BLOB Storage

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.
azure blob storage and container
You can back up the database to Azure by using either PowerShell or T-SQL.
Read more

Determining Blackbaud Ad Hoc Queries that use Site in Designation

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.
Read more

MSSQLTips: Windows Server Failover Clustering for the SQL Server DBA

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:
http://www.mssqltips.com/sqlservertraining/3/windows-server-failover-clustering-for-the-sql-server-dba/

Showing Header for Text Table with Single Measure in Tableau

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:

default behavior - no header

Read more

« Older Entries Recent Entries »