Code

Jeff Moden (5/5/2015)

---

From the blog:[hr]

Joins: When coding outer joins, always order your data sources so that you can write left outer joins. Don’t use right outer joins, and never...

I agree with Jeff here. A share on your SQL Server that EVERYONE can write to just sounds like a recipe for disaster. Putting security concerns aside for...

The one that first caught my eye is the recommendation of using BULK INSERT to insert into a view. I never do this. I'll always load into a...

Hi and welcome to the forums. Starting with the basics, do you have advanced options and xp_cmdshell enabled? What do you get for run_value for the following?

execute sp_configure...

jasona.work (5/5/2015)

---

Lynn Pettis (5/5/2015)

---

jasona.work (5/5/2015)

---

Bloody heck I hate dealing with DISA STIGs!

I'm also surprised that (in my quick Googleing) there aren't more discussions / blog post / articles around the...

Zoo

Add me to the list of people who don't think the relational model is doomed for obsolescence any time soon.

To Gail's point, a system has to be capable of being...

Hogan

Joshua D Gang (5/5/2015)

---

Thanks for all of your help. We will see how it goes. I am meeting with the CIO and SAN/system admin today and see about getting a...

Joshua D Gang (5/5/2015)

---

In a prefect world yes I would test it first in our test environment, except for the fact that they don't have a test environment. As for...

That scenario has worked well for me in the past. It also has the benefit of getting half of the work done during the week. 🙂

Please be sure to...

djj (5/5/2015)

---

Ed Wagner (5/4/2015)

---

Revenant (5/4/2015)

---

Ed Wagner (5/4/2015)

---

djj (5/4/2015)

---

Ed Wagner (5/4/2015)

---

crookj (5/4/2015)

---

Ed Wagner (5/4/2015)

---

Eirikur Eiriksson (5/4/2015)

---

djj (5/4/2015)

---

Eirikur Eiriksson (5/2/2015)

---

TomThomson (5/1/2015)

---

Revenant (5/1/2015)

---

Ed Wagner (5/1/2015)

---

whereisSQL? (5/1/2015)

---

Eirikur Eiriksson (5/1/2015)

---

Ed Wagner (5/1/2015)

---

Eirikur Eiriksson (5/1/2015)

---

crookj (5/1/2015)

---

SQLRNNR...

Sharp

Glad to hear it. Which one was it? Did the user exist or what it a network account?