Category Archives: Blog

Advice I Like: Naps

Learn how to take a 20-minute power nap without embarassment. – from Excellent Advice for Living I don’t like naps. In fact, I try to avoid them and keep going, even when I’m tired. I’d rather power through things and … Continue reading

Posted in Blog | Tagged , | Comments Off on Advice I Like: Naps

T-SQL Tuesday #189–AI and your Career

I’m late to the party this month. Taiob Ali has a great invite for a topic that is likely on most people’s minds: AI and your career. I constantly hear people asking about this (well not lately, I’ve been on … Continue reading

Posted in Blog | Tagged , , , | 3 Comments

Using SQL Compare to Revert a Stored Procedure

Imagine this situation, someone edits a stored procedure on a production server to “fix” something. However, they broke the procedure and you find out the next day. How do you fix this? We’ll use SQL Compare since most of you … Continue reading

Posted in Blog | Tagged , , | Comments Off on Using SQL Compare to Revert a Stored Procedure

Adding a Named Default Constraint to a Table: #SQLNewBlogger

As part of a demo recently I was adding a default value to a new column with a simple DEFAULT and a value. Under the covers this creates a constraint, however, I want to ensure this is named explicitly and … Continue reading

Posted in Blog | Tagged , , | Comments Off on Adding a Named Default Constraint to a Table: #SQLNewBlogger