Checking for constraints in SQL Server

n n From time to time, you may find that you need to test for the existence of a SQL Server table constraint before you perform some action, such as dropping or altering a constraint or table. Below is a snippet I have found useful. DECLARE @constraintName varchar(200); SET @constraintName = ‘SomeConstraintName’; IF ( SELECT …

LEAF Owner Tips: Charging in Cold Weather while away from home.

When I first got my 2013 Nissan LEAF, it was late January and the day I took delivery the temperature high was around 32 degrees Fahrenheit. That night on my way home I had to stop at a quick charge (CHAdeMO) station. I didn’t know how to get the climate control to turn on while …

Nissan LEAF: My Top 5 Favorite Things

After nearly 11 months of driving a Nissan LEAF and 5600 miles logged, I thought I should share my 5 favorite things about this BEV (Battery Electric Vehicle). Instant Torque… this baby can really zip around town, especially when not in ECO mode. Runs solely on Electricity! Low Maintenance. Climate Control* and Heated Steering Wheel …