No problem, thanks for your help!

I'll let you know how it goes 😀

Thanks Grant! I'm going to attempt to create a VPN...

I know this isn't SQL related, but do you know of a way to create a VPN in Azure that will...

Thanks for the response Michael. When I say per connection license, I mean per client or device connection, aka CAL.

Thanks Gail for the response.

I don't ever deal with licensing so I don't know much about it....

With that being said, are the only two options for SQL Server 2012 Enterprise...

The new look is great on my Iphone, but horrible on my monitors.

Since Surface Area Configuration was done away with in SQL 2008, I have created a policy for some servers that utilize secure the surface area.

@Everyone

Thanks for all the comments!

@robert Davis

Thanks for the feedback. Coming from a MCM and Author of Pro SQL Server 2008 Mirroring your feedback is very important.

While I agree...

Grant, what's the best way to see if anything is happening behind the scenes? This happens every day....

Craig Farrell (1/18/2011)

---

First thing: Check for some cross database ownership chaining and cross DB calls from your procs. They're waiting, it seems, for access to the pages in memory...

Elliott Whitlow (1/14/2011)

---

This strikes me as a bad practice. Having been on both sides (Dev and admin) I find that Devs should VERY rarely be able to modify a...

Agreed Elliott. Our developers every now and then will write to this database for testing purposes. We have a test server as well but for some reason they need to...

I agree 170GB isn't huge, and yes, I'm sure some of the SSRS queries are not written very well, but the bossman wanted a seperate reporting server so we created...

Hey Steve,

I use the Dell Equallogic which uses the AutoSnapShot Manager which is integrated with SQL. Ugh.

Thanks for the help guys!!

I actually do log ship a few databases to our report server but for these databases that I'm having problems with I can't because they can't be read-only.

We used to...

I think I figured it out.

I make a snapshot from my SAN every night @ 7:05 (which is the time all these NULL backups run) and attach it to my...