Sql Table Refactoring Challenge
I've been working a bit on cleaning up a large table to make it
Blog Posts
MANY articles on a wide array of topics. You’ll find a lot of my newer content is going to my YouTube channel first, but I do still blog occasionally.
Detect Unicode Usage in SQL Column and Optimize Storage
One optimization you can make to a SQL table that is overly large
Government Mandates and Programming Languages
A recent SEC proposal(which, at over 600 pages, I haven’t read in any detail) includes the following: “We are proposing to require the filing of a computer program (the"waterfall computer program,” …
Sql Server Prevent Saving Changes That Require Table to be Re-created
When working with SQL Server Management studio, if you use the Design view of a table and attempt to make a change that will require the table to be dropped and re-added, you may receive an error message like this one:
Determine All SQL Server Table Sizes
I'm doing some work to migrate and optimize a large-ish (40GB) SQL
PowerShell Control over Nikon D3000 Camera
My wife got me a Nikon D3000 camera for Christmas last year, and I'm loving it but still trying to wrap my head around some of its features. For instance, when you plug it into a computer via USB, it doesn't show up as a …
Clone a VirtualBox Machine
I just installed which I want to try out based on recommendations
Run MSTest Without Breaking on Exceptions in VS2010
Quick tip I just figured out (no R# installed yet) when using
VS2010 Launch Presentations
Last week I was in Vegas to present at the DevConnections/ VS2010
ASP.NET MVC 2 and Windows Azure
If you upgrade an Azure web instance to use ASP.NET MVC 2, make