If the database is in standby, AFAIK, it's read only. No transactions can be run here.

djj is correct. Everything in SQL is a separate item. The login is separate from the user in a database. The permissions to objects are separate from both, as are...

This is interesting. I think it would be low priority compared to other sessions, but I would be intrigued. I think this might be a good one for the Pro-Dev...

According to Amazon's RDS docs, SSIS/RS/AS aren't on RDS. You need an EC2 or on-premise instance to run these: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_SQLServer.html

I did see recently that Amazon was integrating AD with AWS...

I've done this in testing with a self signed certificate. We did this years...

Jeff Moden (3/28/2016)

---

Steve Jones - SSC Editor (3/28/2016)

---

sa can't be locked out, so it's susceptible to brute force. If you run mixed mode, you do need network controls to try...

Ed Wagner (3/28/2016)

---

Steve Jones - SSC Editor (3/28/2016)

---

sa can't be locked out, so it's susceptible to brute force. If you run mixed mode, you do need network controls to try...

More just trying to...

sa can't be locked out, so it's susceptible to brute force. If you run mixed mode, you do need network controls to try and prevent constant attacks.

There is this: http://www.officereports.com/spss-survey-reporter-alternative

However, I don't know of any free software for this. Likely you will need to buy some license to work with these files.

NOTE: We do not condone...

yes, sorry. Typo corrected. That's what I get for trying to type code in here instead of copy/paste.

When you reply (or start) a topic, there is a drop down below the edit box. This has the subscription type.

By default it is set for immediate notification. If you...

Iwas Bornready (3/28/2016)

---

Good subject today. I agree on the input errors and especially coding for them. Limit input to what is acceptable and allow for easier cleanup when even that...

david.gugg (3/28/2016)

---

Anyone else here have problems with accidentally IMing their passwords out to coworkers? It's so easy to think you are in one application, but instead you have Lync...

Andy Hogg (3/25/2016)

---

Hi Steve, am I misreading this?

The correct answer is recognised as:-

GROUP BY Person HAVING COUNT(DISTINCT Played) = 3

I agree with that.

But then in the subsequent explanation, one of...