Rod, I did that very early on when I was just starting out. I ended up moving without any idea if I'd find a job and managed to get one...

I moved when I was younger and without a family. I had the opportunity to move to DFW and for a pretty significant raise. That gave me an advantage of...

You might need a business account to set up Slack rooms, but once set up, you can join once invited. I'm part of two Slack rooms, both using personal e-mail...

I might use it for conversations about SQL. There's no text limit like on Twitter and it could reach across companies. The problem is that Slack can be a distraction...

While I can see jobs being scripted, I'm wondering if anyone has come up with good ways to put SSIS code into version control? I know you can put versions...

That scenario is one reason I implemented Schema Change triggers on my last set of servers. We had a shared Dev environment and it was really, really easy to miss...

blog 24112 (12/23/2015)

---

chudman (12/23/2015)

---

Did you execute the script within the context of the database you want to analyze? If you run this script against the default database when you...

Working in a healthcare-related field, we recently started using schema to differentiate tables containing PHI from those that are more generic use (lookup tables and the like). We can lock...

For what it's worth, I'm pretty sure these were compiled into a GitHub repo here: https://github.com/red-gate/SQL-code-smells

And for those using SSDT, Dave Bally wrote an add-in here:

https://github.com/davebally/TSQL-Smells

(Note...

Ali,

You may want to verify the account used to run the job vs. the one you're using to run the batch file when it works. There could be...

I remember working with a Dev Lead who would grill people on their knowledge, but mostly to figure out where that knowledge stopped or to see how deep/wide their knowledge...

Jeff Moden (9/4/2015)Sorry... I get totally disgusted every time I help someone try to find a decent DBA/Developer. Where are the people that actually care enough about their...

Stephen, you bring up a good point about text files. Technically, DTSX files are text (just XML, right), but trying to maintain diffs of those is a beating because of...

It helps when you use VCS and all builds to the databases (except local) have to come from the source control system. We had all of the systems locked down...

I've been using it for a while, but the hardest part was knowing how to get started. We initially started with just the "upgrade" scripts, but after a really bad...