Disclosure: I work for Redgate Software.

We, obviously, sell a backup product. Prior to SQL 2014, the security advantages of encryption were a bigger selling point. With 2014 +, if you...

Not quite enough time to completely debug, but if you're on SQL 2012+, you might be able to use windowing functions and an OVER() clause to help.

A couple of things....

I think you've hit it. Each test runs as a separate tsqlt.run call rather than a larger call with all results.

At the end of the day, I really only worry...

Jeff Moden (1/15/2016)

---

Heh... the title of this article should be titled "Security vs Convenience" because the current title is actually a bit of an oxymoron.

What I mean by that is...

ZZartin (1/15/2016)

---

The default behavior is to use the database user with the same name you use to login to the server with, if anything I would change allowing DB users...

Sounds like a bug of some sort. I wonder if there's some restart bug that enables NP?

I'd file this on Connect.

Logo for the site in EPS. Must have...

I'm here in the UK, flew over last night.

At least it's not raining.

I wanted to, but my daughter has a volleyball tournament this weekend and I fly to the UK Monday.

My eye is...

First time, sure. But after a couple days, he'd be used to it. Somewhat.

People still bail out. Lefties mess with me (I bat left), but I've hung in on some....

I think some can. Certainly the hand eye coordination to hit is important. Now, can he adjust his swing, especially when the ball has strange motion. Not sure how much...

This is strange. If I stop the endpoint, I get an error (attached).

If I start the endpoint, I can connect with this in SSMS:

Server: np:\\.\pipe\MSSQL$SQL2016\sql\query

Windows Auth credentials

I'd check this for...

The rocket engine that landed was inspected and is supposedly able to be re-used, but it's be preserved for testing right now. Not sure if that particular one will be...

This is a bit strange. I have NP disabled, but I see it started with this

select * from sys.endpoints

Can you run this:

alter endpoint [TSQL Named Pipes] state = STOPPED

Can...

There are certainly huge potentials for abuse with this technology, but there are also some interesting positive, proactive things we can do.

My point is that there are opportunities here for...