Ken Davis (1/7/2015)

---

Hello,

I have a SQL Agent job that needs to run every 5 minutes throughout the week but not run during the Sunday morning maintenance window. It would...

Here is an example python module I have created for uploading \ deleting and downloading files from S3:

import boto

import os

from boto.s3.connection import S3Connection

from boto.s3.key import Key

#############################################################################

#### Create a function to...

There is a few ways of doing this, three methods I have used is:

1. Download and install the AWS SDK for powershell and then use the Powershell commands...

One other way to do it then is to have the headers turned off and have the first first row of your select the column names, something like:

SELECT 'COLUMN1',...

Try setting this parameter to 0:

From msdn:

[ @query_result_header= ] query_result_header

Specifies whether the query results include column headers. The query_result_header value is of type bit. When the value is 1, query...

We believe we have identified the root cause of this issue. We have articles published more than once in different publications, not many mind you but its been an...

We are hoping we can identify this ourselves as although we are a MS gold partner, this particular environment is so secure only employees of our company and a...

SQL_Baby (11/21/2014)

---

OK so your server is Publisher, Distributor and Subscriber? Wow that is a LOT of Jobs on one server. Have you got deadlock tracing turned on? Maybe there is...

Answers in bold below:

SQL_Baby (11/21/2014)

---

hmmm thats in interesting one. Are you using Push or Pull replication? What version of SQL Server is this? Are the Subscriptions going to different servers?...

As has already been asked how are you generating your csv file? This dictates what can or cannot be done to remove the headers and dashes.

For example running a...

However to load a file to a db direct from S3 you would need to use powershell to retrieve the file and pipe the file into a cmdlet to load...

The easiest way to programmatically get files in and out of S3 is using the AWS SDK for your chosen language such as powershell or python.

Here is an example of...

RDS does not support auto scaling. You can however spin up read replicas on demand. But they are exactly that, read only copies of the RDS instance that...

How familiar are you with powershell or even command line programing as this can be easily achieved by creating either a powershell script and utilising the sql server modules or...

Bill Dykstra (10/16/2014)

---

Thanks for the feedback on this.

I wondered about that (using the same log shipping files). I like the idea, especially since the backup files have already been copied...