Start with Brent Ozar's worksheet on HA/DR for a starting point of discussion.

http://www.brentozar.com/archive/2014/05/new-high-availability-planning-worksheet/

If you like your job, then the best thing you can do is try to work within the...

I'm not really sure this is possible. The issue is that in a domain with active directory, you have a third server (the domain controller) that validates the user to...

djacobos (9/16/2015)

---

I have SQL Server 2012 Standard installed on Windows Server 2008 R2 Datacenter. SQL is set to allow mix mode sql/windows authentication.

I have a requirement to...

Assuming your databases are stored on a SAN like most of the people out there, I wouldn't worry that much about fragmentation. Fragmentation really only matters if your disk can...

shorton2 (9/10/2015)

---

So I got close to getting this to work, but still having one last problem...

If I place the excel file literally ON the Windows Server that SQL server is...

shorton2 (9/1/2015)

---

Hi guys, Not sure if I picked the correct sub-forum, please point me if not.

I am in a corporate environment with IT managed SQL servers. "My" 2014 SQL...

You have converted the date to a VARCHAR, so now it's sorting alphabetically instead of by date. In other words, alphabetically would be 1, 11, 12, 2, 3 ...

Easy solution...

I use xp_CmdShell for 2 different things.

One is to export csv reports for end users.

The other one is to export and then FTP files to a third party...

arrjay (2/24/2015)

---

Hi there - I run this code on several environments successfully but when on run it on a different environment it fails.

Its very strange as the user...

Hard to say without seeing the stored procedures, but my first thought is that you have some bad parameter sniffing. There are many posts elsewhere about it if you want...

You have to be careful with something like this. You also have to ask what you want to happen if your change cannot be replicated to Father. Do you want...

mw112009 (1/27/2015)

---

I thought you could only have one clutstered key and that one should be the primary key ? Right/Wrong ?

Sorry, my bad vision, now I see in the image...

drew.georgopulos (1/26/2015)

---

The problem we are trying to solve is how to distinguish one thing from another. It never was an issue because things had been processed in silos, but in...

I think you'd be better off using something like powershell to monitor drive space on a different server. Though I suppose if you wanted to, you could have the SQL...

The first thing I think of is permissions issue. SSIS is probably not running under an account that has permissions to access the file in Sharepoint.

It's been a long time...