Unit testing multi-threaded WPF applications

While working to make a WPF application more responsive by offloading time consuming operations to .net 4.5 tasks (one of my favorite things!), I ran into a problem.  Some of the unit tests just hung.  This was because code running on the UI thread was modified to run a task, which eventually invoked a method…

0

Strange error when using Start-CopyAzureStorageBlob

Every so often you need to copy a bunch of blob data around in the cloud.  The Start-CopyAzureStorageBlob PowerShell cmdlet can be useful for kicking off that copying.  It returns an object you can use to poll on the status of the copy if you are copying large blobs that take a while. While using…

0

How much space does each table take up?

In the DevOps world space matters, especially when you are using PAAS databases in the cloud such as Azure SQL Database (aka SQL Azure) where there can be tight space limits per database.  One useful way to keep track of how much space each table (and accompanying indexes) take up is to use a query…

0

Back from blogcation

Well, it’s been a while, but I’m back from my extended blogcation.  Since my job has shifted again, I’m going to refocus this blog back to development side of things going forward.  Today I have made a cool discovery about OperationContextScopes that might save another developer some time, so I’m going to get started with…

0

Moving to Technet

It occurs to me that this topic is probably more relevant to folks who read blogs at Technet.  So, I’m packing up this blog and moving it to http://blogs.technet.com/b/sqlserveroperations/.  Thanks for reading my blog over the years, and if you like many developers wear multiple hats including an operations hat I hope you’ll join me…

0

SQL Azure Management Pack CTP2 Now Available on the Download Center

The first exciting news I have in the operations and manageability space is that there is now a management pack for monitoring SQL Azure based databases available as a public customer technology preview (CTP)! You can find the bits on the download center here: http://www.microsoft.com/download/en/details.aspx?id=28951 If you haven’t heard of SQL Azure definitely go to…

0

And now for something completely different!

For many years this blog has been about the great SQL Server samples which the SQL Server teams has brought to you.  Today marks a change in the direction of this blog.  For my readers interested in samples, thanks for hanging in there over the years and giving us great feedback.  But my career has…

0

SQL Server 2008R2 RTM Community Samples are now available.

Community sample database and sample code installers for SQL Server 2008R2 RTM are now available.  You can find the database installer at http://msftdbprodsamples.codeplex.com/ and can find all community samples at http://sqlserversamples.codeplex.com/.   Sample code changes include new Reporting Services samples targeted specifically at SQL Server 2008R2.   Sample database changes include the following: ·         All…

0

AdventureWorks Community Sample Databases available for SQL Azure

It is a delight to announce the availability of the AdventureWorks Community Sample Databases for SQL Azure.  You can download the scripts and data files from CodePlex.  To install the databases on your SQL Azure server just follow the directions on the release page at CodePlex or in the ReadMe.htm file which is included in…

0

SQL Server 2008 SR4 sample database installer available

Based on the success of the new sample databases installer we created for SQL Server 2008R2, we’ve created a new samples refresh (SR4) for SQL Server 2008 on CodePlex at http://msftdbprodsamples.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=37109.  This is a much simpler and more robust installer which allows you to select the databases that can be successfully installed, and also provides…

2