Tag Archives: syndicated

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

Just a few weeks to PASS on Tour and the Redgate Summit

It’s just a few weeks until the PASS Summit on Tour in New York City. This is the first event in the series, and I’m excited to go back to New York City this year. I’ve been there a few … Continue reading

Posted in Blog | Tagged , , | Comments Off on Just a few weeks to PASS on Tour and the Redgate Summit