Having done both log shipping for DR and availability groups for DR, I would always go for availability groups.

Setup, administration and troubleshooting for AGs is much simpler than log shipping,...

Personally I would start with a new Windows install. This makes sure that the server can be reproduced in the future if it fails.

Also in the past a place where...

Hearding cats is easy compared to managing application development.

Computing has to deal with constant change: business requirements, priorities, costs, budget, available hardware and software, skills, etc. The applications that get...

For me there are two main aspects to this.

The first one is that in computing the only constant is change. A skill that would give top pay in year 1...

The best way to think of FLOAT is it will give you approximately the right answer. It is great when that is the result you need, but not so good...

The first thing you should do is use the query plan to see if new indexes might help. This often helps. My best win on this was when I...

• This reply was modified 3 years, 7 months ago by EdVassie.

I agree with Ken that NOT EXISTS should run faster than NOT IN.

Imagine you have a room full of people wearing various colour shirts, and you want to see...

• This reply was modified 3 years, 7 months ago by EdVassie.

It is too long since I last did replication to remember what is needed to answer your question.

However, I can say your problems will not end when you get this...

I have not come across this issue, but my policy was to never uninstall software if I wanted the server to keep running.

The uninstall process often gets less testing than...

• This reply was modified 3 years, 7 months ago by EdVassie.

Hopefully the department will have built their apps to hold the forms in one Access db and the data in a second Access db.

If not then the first step is...

FOR XML PATH is the only way I know for your version of SQL. The syntax is a bit arcane but you can live on it. It will continue to...

I have never used WinRm so can only give some general troubleshooting advice.

The first step is to isolate the failure, and thr first step in that is to verify you...

Thanks Jeffrey, that was helpful

You are in Synchronous mode with SQL 2012 so how have you done the patching so far. I hope this is not a new install as SQL 2012 is 10...

STATA is a different product to SQL Server. From what I can see on the product site, it has its own database manager and stores its data in a proprietary...