In the old format, when I was in Forums, there was a My Posts link at the top.  Does that exist now? If so where is it?

-SQLBill

They need connection rights to Master - just connection rights. Once they have that, they need to be added to xp_cmdshell (Master database > programmability > Extended Stored Procedures...

JnrDbaK (11/16/2016)

---

Hello ALL,

<some comments snipped out>

Well basically what I'm saying it's if you have any tips on how you've become a full, snr or principal DBA etc, what I...

Brandie Tarvin (1/10/2017)

---

Wow. I haven't talked to any of you guys since last year. Happy New Year, I hope everyone is doing well.

Quick question(s). Does anyone here hold a CISSP...

Jeff Moden (1/9/2017)

---

I used to think it odd that people that people I've interviewed with more than 5 years of "experience" with SQL Server that made the claim of being...

There is one answer that struck me. The final line of that one says: "A bottom tier developer should probably stop being a developer." This is a place I'd disagree....

jasona.work (12/27/2016)

---

Nah, its still got 4 more days to go and it wants to eat the soul...

There is a default trace that might help depending on when you last rebooted the server.

DECLARE @tracepath VARCHAR(1000)

SELECT @tracepath = [PATH] FROM sys.traces WHERE is_default =1

SELECT @starttime, endtime, textdate, databasename,...

mcfarlandparkway (10/26/2016)

---

I have a table of ssisconfig table where I stored all the connection strings with a type column.

In the package I took execute sql task and queried with ssis...

Let's say your hardware crashes badly and you have to rebuild. Then you reattach the SAN drives and get everything running again. However, all your error logs were...

We need facts to be able to give you good advice. Things such as:

are you backing up to disk or tape?

are you backing up on the same server?

if...