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 readingAuthor: kevin
SQL 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 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 reading