Have a safe, enjoyable trip Steve and I hope to run into you at Summit! 😎

RonKyle (8/11/2016)

---

I would tell my kids that "Family comes first, but not always." There would be times in life where work temporarily came first. Had it remained permanently...

Good reminder Ben. I had to learn a long time ago that you work to live, not live to work. If your life is out of balance, so...

This highlights the issues of confusing views with tables and views referencing other views. In my 30+ years, I've found that such practices lead to more problems than solutions.

Steve Jones - SSC Editor (7/29/2016)

---

Ha, we have a living quarters as well. Maybe we can roll together to an event? Or you can swing by the ranch when you...

First off Steve, I completely agree with you about the new ruling for the 600 mile radius. Having SQL Saturdays in close proximity back-to-back allows many to attend who...

It never ceases to amaze me just how easy movies and TV make complex computing tasks like hacking unknown systems (what if the aliens didn't have a binary system?), high-speed...

pietlinden (6/30/2016)

---

I guess if you're forced to do something "clever" then you have to document your code inside the code... not in some "book" somewhere that nobody can find. (Yeah,...

Yeah,...

Personally, I prefer using an account name as email addresses are much more subject to change. I've had issues where I could not change my email account (not on...

xsevensinzx (6/24/2016)

---

I think by far the biggest hurdle for me in designing a new data warehouse or even a new database is clearly outlining the ERD and all the ETL...

I've lost track of the number of database applications that I've built from scratch over the last 30 years. One thing is true though, I never got them completely...

Way back when I was in school (still in the days of green bar line printers) subjects like database theory, set theory, and...

Yes, you are correct that column references are repeated. I feel that those...

The use of APPLY is interesting and I did learn a couple of things, but in my opinion the CTE approach exemplified earlier is cleaner and easier to read especially...