David.Poole (8/25/2016)

---

For a census the app simply collects the post from a web form and persists it.

Given that it is a once every 10 year thing with fixed questions you...

Can't wait for the next discussion about JOINS.

Had to look this one up as we are still on 2008R2.

I just need a couple more years. But in spite of that I decided to move from IT into Compliance. Wow, what a change. This is a career opportunity young...

Easy one. I actually use this once in a while.

Gary Varga (8/23/2016)

---

Another issue with implementing security properly is that it takes thought and time. Given too much pressure on delivery can see these practices thrown out of the window...

We turned them off when we migrated data into a new database. But never under normal operating conditions.

I totally agree about the duplication of code. Sometimes it is the best route.

Didn't even know these existed. Thanks.

I look a the list as a good set of principles to live your life by, outside of work.

Another good article in the series.

Can hardly wait until we get on 2016.

I played around with it a bit.

I can stuff '20790606 23:59:29' into a smalldatetime variable and it comes back out as '20790606 23:59:00'

If I put '20790606 23:59:30' into it...

Like everyone has already noted, typo on the datetime; should be smalldatetime.

I don't get it.