Watch target memory for each server, and try to balance the load. It's up to you to somehow set this between instances.

Can you connect with localhost or .?

Indeed we have.

That's why I've typically called myself the data janitor.

You need something like this:

SELECT

'SQLAgent - TSQL JobStep (Job 0x'+

CONVERT(char(32),CAST(j.job_id AS binary(16)),2) +

' : Step ' +

CAST(js.step_id AS VARCHAR(3)) +

')', j.job_id, j.name

FROM msdb.dbo.sysjobs...

Until you have an issue, you can't argue anything. If the dev does things and they work, then ignore it. Track things.

There isn't anything that I've seen other than blogs...

Eric M Russell (9/29/2015)

---

To be a true Data Scientist, you probably need a solid academic background in data analysis as well as deep knowledge of whatever domain you're working in....

I thought there was an alias or something in there. Alias' are great. I prefer a FWDN, with a port number after.

mynamedsql.mycorp.com,5555

I'm surprised this is so hard to change. It...

"keep" was meaning the end result. There is one instance on the host at the end, not two or more.

Perhaps some of this works in 2008? Anyone verify this? I've tested in 2012/2014 and it does not work.

SQLCLR doesn't hide the procedure from someone, though it does make the code hard to get to.

However, what is the purpose here? At some point, much of your data manipulation...

For why many developers are looking to NoSQL, look no further than JSON. So many of the new tools and languages have built some support for JSON storage, and the...

ken.trock (9/28/2015)

---

However I do believe we need to test our code. We all do test our code, even if it's with a few before/after queries. What I don't get is...

xsevensinzx (9/28/2015)

---

I can understand the what the author means in the article, especially in the BI realm on my end. Sometimes there is just not enough time due to last...

Jeff Moden (9/27/2015)

---

First, I loved your observations in the article. It takes so little time to "test-as-you-go" that I don't understand why more people don't do it. To wit,...

tbailey 19088 (9/28/2015)

---

Steve,

This rename can be done using sp_dropserver and sp_addserver @local='local.

I tested this on one of my development boxes that had only a single, default-named instance. First, I ran...