I’ve had to use a variation of this script many times and each time I’ve been stumped for 30 minutes before coming to a solution. […]
Continue readingRename an Ubuntu Linux Server
I had to look this up (I forgot about /etc/hosts): To rename an Ubuntu server (in this case 12.04), SSH to the server and: sudo […]
Continue readingRename tables, columns, and objects in SQL
I started the New Year renaming some tables and columns to match a new schema. I forgot about a great stored procedure, so wrote this […]
Continue readingQuery for the last SQL database backup date
Helpful to determine when the last database backup occurred. List all databases and the last created date of the backup. SELECT SERVERPROPERTY(‘Servername’) AS [Server Name] ,msdb.dbo.backupset.database_name […]
Continue readingSQL Trace: Duration
A good trace to debug with an sp duration (to limit the results – which can be overwhelming – and check for long running queries): […]
Continue readingStudy an Exception in PowerShell
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 readingCould 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 reading