Iwas Bornready (10/1/2015)

---

It sounds good, and may be good. It certainly must be for you. But I have a set amount of work that needs to get done. How do...

Brad Allison (10/1/2015)

---

This is great advice that I will share with my small team of SQL Server developers I work with. I usually give them some daily technical inspiration...

Tepluken (10/1/2015)

---

Terrific advice. I always take a walk at the end of the day. Usually I will listen to a podcast as I walk to pass the time; however once...

I do usually tell people in Scouts or kids sports that I'm a computer guy. If they know something and want to ask more, I will talk about databases.

I'm not clear what you are seeing here.

You can connect with SSMS. What are the credentials?

In Data Tools, do you mean SQL Server Data Tools? SSDT? Can you enter the...

Apart from what has been suggested, I try to solve things like this for one area. Write down the plan for one dimension or entity and solve each one. Then...

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.