ICYMI: SQL in the City Streamed playlist: https://www.youtube.com/playlist?list=PLhFdCK734P8DvVfg9O_csDlxp7jeyAsXV

Happy New Year, and hope you are ready for another exciting year. Or great year. Or just a year.

Quiet here, managed to finish a 5k Sunday and then take it...

Eric M Russell (1/2/2017)

---

In many cases the job itself doesn't really get eliminated, it's just that the requirements of the role get redefined. Sales associates become call center representatives, commercial...

Craigmeister (1/2/2017)

---

My 2 cents:

1. While there is general displacement, there are still opportunities for people who are (were) highly skilled in the displaced occupation. The weaver machines were much faster,...

What are the rules for matching then? Do you need to somehow keep looking for payments to a serial number and month until they are equivalent in the two tables?...

David.Poole (1/2/2017)

---

In the 1980s in the UK we had the miners strike and the decimation of the coal industry. Those communities that recovered did so after a few decades....

I would say it's a security hole since most people worry less about UDP and this may be an open port on lots of firewalls to allow SQL instance discovery....

You have a disparate list of things here. Killing processes is process admin. To look at logins, security admin does this, but also allows creating them. I suspect you'd...

Your example is a bit confusing, since you are showing different paid amounts. I'm guessing this means these are two separate examples, and not intended to relate to each other....

That would...

Probably

Thanks, fixed.

Prizes sent. Let me know if you get them. I assume Yahoo sends a trophy?

New thread for 2017 - http://www.sqlservercentral.com/Forums/Topic1846421-61-1.aspx

chrisn-585491 (12/29/2016)

---

On the flip side there's even more great open data sets to build analysis skills on. Everything from census to the stars, if you want some real data to...

chrisn-585491 (12/29/2016)

---

Microsoft has stumbled some, but has made some great steps with SQL Server, .NET and even cool cross platform tools like VS Code. I'm really enjoying F# and think...