BWFC (2/18/2016)

---

To be pedantic, it depends on what edition you run the code. I know that the unwritten rule is assume the latest version but many people testing that,...

thisisfutile (2/17/2016)

---

I've been tempted to rely, 100%, on the "I forgot my password" links on more critical sites. They all send an email (and I have a very secure...

djj's solution works, whether you have more or less:

DECLARE @a VARCHAR(100)

SELECT @a = 'aaa'

SELECT LEFT(@a, 50)

SELECT @a = 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'

SELECT LEFT(@a, 50)

However, if you truncate data, make sure clients know there...

On one hand, I'm glad I no longer code in C, on the other hand, lots of work available: http://arstechnica.com/security/2016/02/extremely-severe-bug-leaves-dizzying-number-of-apps-and-devices-vulnerable/

Gary Varga (2/16/2016)

---

Steve Jones - SSC Editor (2/16/2016)

---

...The other concern is what if there is a v2.0 branch in development that mirrors production. What prevents a developer from accidentally checking...

yes

jasona.work (2/16/2016)

---

So, saw Deadpool this weekend and I must say, it was really fun and quite funny.

They didn't overdo the "breaking the fourth wall" (if you're not familiar with the...

jasona.work (2/15/2016)

---

So, a question for everyone:

How do you feel if someone comes back and tells you that they tested a solution you provided before they told their bosses it was...

Did you get the context of the job?

I tend to agree with you that there should be a central VCS and one set of code for an application/database. Branching when needed, but contained.

However, the person that talked...

I saw this from Patrick Keisler: http://www.patrickkeisler.com/2013/07/are-you-primary-replica.html

He's querying the role column for a 1, and while that shouldn't matter, I'm wondering if there is some context that's different. Obviously you...

What does the step do? If you log in to a console of the server as your proxy and execute the code in the step, what happens? Not the step,...

Orlando Colamatteo (2/13/2016)

---

Thanks for leaving out a bunch of steps to get to the eventual solution (like creating the cert and opening the key). Forced me to do a bit...

Sorry, meant to post this. We have a Stairway to help you get started: http://www.sqlservercentral.com/articles/134869/

Second vote for extended events. This is lightweight and you can leave the session running.