You can use the PIVOT command as well, but I'd recommend crosstabs, as Luis showed.

yes, separate pieces. Some thoughts on why/how you built them and what they accomplish in your mind would be great. Nice to have a setup for testing. I am thinking...

bump

Bump. Haven't seen anything

I tech reviewed the 2005 Encryption book and at the time, all the EKM integrations were hardware appliances that cost $$. I believe Thales and Safeguard were the two I...

Miles Neale (8/28/2014)

---

Thanks Steve. Although we think we have things well under control at all times, time has tendency to erode even the best of plans. To avoid compounding...

It's tough, as Troy Hunt found out.

http://www.troyhunt.com/2013/11/dont-trust-net-web-forms-email-regex.html

Honestly, it's good to try to validate, but don't discard data that doesn't meet the standard you set. It's highly likely your validation is...

Never heard of it.

I'm gonna miss him after this year

http://m.mlb.com/video/v18544975/nyybal-jeter-passes-mantle-on-alltime-games-list/?partnerId=as_mlb_20140828_30536006

No, though it wasn't supposed to be a press release. It was an editorial that I wrote about the events, and what we'll be talking about.

Just a note that the certification doesn't necessarily equate to salary. Experience and tenure might matter more.

You could ask if someone's salary/rate has changed because of the certification if you're...

Not at all. I'd give a range for my company, rather than specifics, but no reason not to get an idea of...

I've been back for a month 🙂

I think the defaults change by versions, but certainly I would hope that yyyy-mm-dd would always be used. Be nice to get people used...

I agree with PHYData DBA. This should be a setting in Windows that SSMS picks up. I would guess that any rendering by a client, regardless of app, should also...

I saw IronPython a few years ago and it looked really interesting, especially with stats work. I haven't done much more than play with it, but I found Powershell to...