PowerShell may not return enough information in an exception. You can read the response stream to dig deeper: $stream = new-object System.IO.StreamReader($Error[0].Exception.InnerException.Response.GetResponseStream()) $results = $stream.ReadToEnd() […]
Continue readingCategory: Windows
Windows
Could not load file or assembly ‘msshrtmi’
Back to my MVC Web Application… After I added a new Windows Azure Cloud Service project to the solution, I could not load the application […]
Continue readingMVC Web Application Error: ‘LocalSqlServer’ was not found
I created a new MVC Web Application and added a new Windows Azure Cloud Service project to the solution. The project was able to build […]
Continue readingSearch for text within columns, tables, store procedures, and jobs in SQL 2008
Search the information_schema for columns, tables, stored procedures, and jobs by name: –Query to list stored procedures that match a pattern select ROUTINE_SCHEMA, ROUTINE_NAME, ROUTINE_DEFINITION […]
Continue readingBuild a Web Setup Project using devenv to Create an MSI
I was disappointed when I learned that you still could not build a Web Setup Project vdproj file using MSBuild. However, you can still use […]
Continue readingPowerShell String to Array to a Foreach Loop
I always forget to use the Split command (or write it in VBScript before I remember PowerShell). The following command takes a comma separated list […]
Continue readingLaunching commands in PowerShell
Something I always need to look up when I’m running commands from a PowerShell script. It is always tough to get the spaces just right: […]
Continue readingIndexing a VARCHAR(MAX) column
A helpful article on using a computed column to index a VARCHAR(MAX) column: Indexing VARCHAR(MAX)
Continue readingSQL 2008 Configuration Manager: Cannot connect to WMI provider
On a 64-bit computer, you install an instance of the 32-bit (x86-based) version of Microsoft SQL Server 2008. On the same computer, you install an […]
Continue readingRemove File Server from Cluster Manager using PowerShell
I needed to remind myself about a terrific PowerShell command that will remove resources from Cluster Manager. Run the following PowerShell commands to remove the […]
Continue reading