Category Archives: SQL Server

Enable Service Broker

Logging here for future reference.  I’m writing some caching code and am using the the System.Data.SQLClient.SQLDependency feature of the .NET framework to send a change notification event to my web services when the underlying data changes. If when enabling Service … Continue reading

Posted in SQL Server | Leave a comment

BizTalk Tip : Number of Orchestrations Tracking Data Query

Quick query to give number of orchestration instances over the last week. Grouped by orchestration name.

Posted in BizTalk Server, SQL Server | Leave a comment

(Restoring…)

Quick SQL Tip.  After restoring a SQL Server database you may see within SSMS object explorer that the database stays in <database name> (Restoring…).  To fix this run the below.  Refresh your object browser and all should be good. RESTORE … Continue reading

Posted in SQL Server | Leave a comment

SQL Server Table Size

Tip for future reference.  Use the below from SSMS to get stats on the size of a table. exec sp_spaceused ‘<tablename>’

Posted in SQL Server | Leave a comment

MDS : The Microsoft SQL Server license has expired.

If you get the above error when navigating to the Master Data Services web application, check the application pool that’s running the web application does not have “Enable 32-Bit Applications” set to true under the application pool advanced settings.

Posted in SQL Server | Leave a comment

Master Data Services – Reorder Attributes “an unknown error occurred”

I came across this annoying error today whilst putting together some MDS entities. I was reordering the leaf member attributes of my entities when it threw the error “an unknown error occurred”. Yep, that tells me a lot. Reordering was … Continue reading

Posted in SQL Server | Leave a comment

T-SQL Tip : Cloning a record

Simple little T-SQL tip.  I wrote a stored proc today that clones a record and assignes a parentId to the cloned record to form a parent child relation between records in the same table.

Posted in SQL Server | Leave a comment