Jeff Moden (5/18/2015)

---

TomThomson (5/18/2015)

---

Jeff Moden (5/17/2015)

---

Heh... I look at the recommendations for "scripting" languages with a bit of disgust. There are so many things that SQL Server does very...

I use Python for my automation and data pipeline with the many Python based API's that feed our database. I rarely rely on VB Script or Powershell to get those...

Jeff Moden (5/16/2015)

---

I was interviewing one person who claimed over 10 years working as a Senior DBA and "tuning experience". Here's how the clustered index segment went.

Me: Tell...

I personally love SQL Prompt for comments in my code. I love JIRA/Confluence for build management and documentation of my environment that's accessible to the entire team.

I forget what amazing...

What's wrong with this picture?

Jeff Moden (5/12/2015)

---

Just so that no one thinks I'm a Luddite, I absolutely believe in new and better technology. For example, ROW_NUMBER and the other ranking functions are one...

I agree. Having that wider set is extremely important. I don't really know too many guys in my field who don't have a wider reach because the job market today...

100% virtualized here in both dev and prod as well.

I was making a push to have NoSQL to be on physical because of the reduction in performance when virtualized from...

ScottPletcher (5/8/2015)

---

Don't get overly focused on having a primary key per se. Some tables require them, some don't. Data integrity is vital, but a primary key doesn't guarantee...

Grant Fritchey (5/8/2015)

---

xsevensinzx (5/8/2015)

---

This is the uphill battle I face though. I have no verification if 1 million or 5 million identical rows are correct or incorrect. Thus, all are...

Grant Fritchey (5/8/2015)

---

xsevensinzx (5/8/2015)

---

GilaMonster (5/8/2015)

---

xsevensinzx (5/8/2015)

---

What if you are allowed to have duplicates with transactional records that have customer ID's which forms the relationship? What purpose is the PK giving...

GilaMonster (5/8/2015)

---

xsevensinzx (5/8/2015)

---

What if you are allowed to have duplicates with transactional records that have customer ID's which forms the relationship? What purpose is the PK giving you outside of...

spaghettidba (5/7/2015)

---

A relation must have a primary key. If your table does not have a primary key, then it's the physical implementation of something that doesn't exist in the relational...

WayneS (5/4/2015)

---

Lynn Pettis (5/4/2015)

---

I have to agree as well. I have almost 20 years experience and I know that I don't know everything. I still have a lot...

I'm so confused on what's going on right now. I started looking on Google and bumped into the NSA and now I'm back to The Stig. 😀