I think I agree with John. Its an "it depends" answer. A DBA may or may not get involved with schema design of data warehouse might fall to a data...

Why is the database being put into Single_user mode?

Hi Sue,
Thanks for the reply Sue, I did get a similar response on the #sqlhelp hashtag on twitter too
That is what I was looking for, thanks for posting...

You have to look after the EC2 instance like any other virtual machine running SQL Server. So, depending on the version of SQL Server I would definitely set perform volume...

Could you use a subscription and render the report from the snapshot to shared location as PDF?

That should do it automatically for you

You could also use...

Have to agree, it depends on the area of SQL Server you are interested in - i have a list of books I like and recommend for Admin, TSQL Coding...

Hi Gail

yYes it was the primary databases. I have now moved them to the correct location with no issue on log shipping

Thanks for the help and...

Thanks Sue, that's what I thought but wasn't 100% 

Thanks for taking the time to reply

Geth

Brain, it's a very good and informative series. I have enjoyed reading your articles.

I went to a SQL Saturday in Philadelphia back in 2013. It was combined with a work commitment in Washington DC. However google tells me the distance between Philly and...

Technology does evolve and in some cases it evolves quickly. As an IT/Data professional keeping abreast and up to date of the changes that impact your job is vital...

Yes, I think it was one of the Forbes ones

You have several options for maintaining multiple copies of a database in 2012

Availability Groups

Mirroring - Which I think is deprecated but you can still use it

Log Shipping

Replication

I read an interesting piece a while - It was posted on Twitter (I can't find the link). It called for Ballmer to go basically saying he has not a...

Are you still looking for articles/stories on this topic Steve? I can see it was posted last November. If so I might have one to contribute but it will need...