I started using python about 6 months ago as we started using Amazon Web Services to support some of our online sites as well as the traditional onsite SQL servers,...

8 hours should be plenty providing your not dealing with TB's of logs to replay. In our setup we have 7 servers all with highly transactional databases that all...

Given that your talking about reporting purposes how up to date does the data need to be and how long a window can you have where the DB is unavailable...

As clustering requires shared storage which is not specific to a single node when you failover the disks will be detached from the current node and attached to the new...

As the others have mentioned your wait stats will help identify the exact issue.

Without that detail and going on the symptoms it sounds like you most likely have IO contention....

thephillgreggan (1/26/2015)

---

hi

i have a C# windows app trying to access database based the connection string stored in teh app.config file

Here is my app.config parameters

<?xml version="1.0" encoding="utf-8" ?>

<configuration>

<connectionStrings>

...

Is there any particular reason it has to be powershell?

Its easy enough to read from a txt file with a list of Servers and call a query against the dmv...

Have a read of this:

http://msdn.microsoft.com/en-us/library/aa394587(v=vs.85).aspx

You can write your application to use WMI to retrieve all the info you need from the OS providing its a windows machine.

Manie Verster (1/20/2015)

---

Hi guys,

I am taking a long shot here and this might seem highly irregular what I am trying to do but please hear me out. I need to...

guaro5555 (1/16/2015)

---

Hi gurus

I am in need of some serious help, and I hope you gurus can help me.

I have a sql server with one instance and I can connect to...

Sorry for the slow reply.

How about this:

1. Create a staging database on InstanceA.

2. Copy the tables you require from Database1 into the staging database

3. Use tablediff to...

I'm still a bit unclear on what actually you need. This is my understanding:

You have 3 SQL Instances lets call them A, B and C.

Instance A and B...

Duran (1/12/2015)

---

Hello, again thanks for getting back, yes your right it is 2008, I had just read about the CDC splitter and you are of right, its for 2012.

Where will...

See answers inline:

Duran (1/11/2015)

---

Hello,

I got a slightly more up to date version of what it is I need to do.

I need to take the latest changes out of a SQL...

Duran (1/6/2015)

---

Hello and Happy New Year!

I'd like to be able to run a utility that will look at specific tables from to different databases on two different servers (same domain),...