Below is a link to a 15 line sample Powershell script that prompts for input parameters, and then connects to SQL Server and executes stored procedure using those parameters.

It...

Not unless there is a SSMS AddIn out there to hide or disable certain menu options and object explorer details. When you consider all the sysadmin related functionality that's in...

Just make sure the contractor has access to only the specific database they need. They can't grant themselves role membership or permissions at server level or another database, unless you...

OUTER APPLY (

SELECT items

FROM dbo.SplitString(ISNULL(DAV.Value1, ''),...

The next time the SAN goes down, I'm just going to take a week PTO while the vendor straightens the mess out. My personal backyp plan will be a couple...

So, I'm guessing SOX regulators required them to have an alternate business continuity process on standby. In the event the application...

Steve Jones - SSC Editor (8/18/2015)

---

Stuart Davies (8/18/2015)

---

I don't think it is a straight forwards as it would be for a photographer for example. Confidentiality and copyright could come into...

Perhaps the following:

Create a string variable to hold the SQL command, and have it's value derived from a dynamic Expression. On the OLE DB Source, set Data Access Mode to...

Like I said earlier, if estimating is part guesswork, then the business should be the one providing the guesses. The business should define what is a Sale and then estimate...

I think IT folks in general have never really took...

... However the front page of your blog, with the last 5-10 posts you've written on some random topics might not be the image you want to present. Perhaps you...

Yeah, nothing like hearing the jet engines suddenly...

Jeff Moden (8/18/2015)

---

Iwas Bornready (8/18/2015)

---

Though I have used a tally table a few times, it really is rare for me. I've heard so many people say how great they are...

Ed Wagner (8/12/2015)

---

I also suffer from the "forgotten" requirement and "just one more thing" at the last minute that's never been heard of before, but it's what they wanted all...

Jeff Moden (8/18/2015)

---

Alan.B (8/17/2015)

---

Jeff Moden (8/14/2015)

---

Alan.B (8/14/2015)

---

BobAtDBS (8/14/2015)

---

I have read Jeff's article, both in the past and an hour ago. His examples aren't things we do at the TSQL...