Sorry, meant to post this. We have a Stairway to help you get started: http://www.sqlservercentral.com/articles/134869/

Second vote for extended events. This is lightweight and you can leave the session running.

Could the user be orphaned? I might double check.

Make another job step, same user, capture suser_sname() and user_name(), try to understand where permissions might be broken.

I'm with Grant. Get backups going first, and test restores. Make sure you can actually recover the db.

My second task is usually to look at security and assert some...

I've started to get in the habit of shutting off email and computer time on the weekends, just to get away from work, but also let them know I'm not...

Grumpy DBA (2/12/2016)

---

We will be transitioning to "mountain time". Wake up, breakfast, try to get first chair, snowboard/ski until hungry, grab a quick bite, snowboard/ski until the lifts close,...

ZZartin (2/12/2016)

---

TUellner (2/12/2016)

---

Tony++ (2/12/2016)

---

You said April 12, 2016 as a date to be out of compliance, but didn't give any details on what makes that date important.

Can you share more...

I finished the video, and it appears as of now, the Azure pack merely sits over your existing instances, so I'm pretty sure Stretch DB won't work here. This is...

PCI Standards, section 5: https://www.pcisecuritystandards.org/documents/pci_dss_v2.pdf

6.2 has been mentioned, but 6.1 notes you must install vendor patches. I have had auditors say that if the vendor no longer supports the software,...

From midnight on. As in, these are ongoing. I'm not sure why wouldn't think that log backups occur every 15 minutes, on every hour of every day. So 96 times...

EdVassie (2/12/2016)

---

A little rant... I worked on mainframe systems, and they are documented to the same standards as systems written for...

Are you using Azure SQL Database or SQL Databases in an Azure VM? If the former, I don't believe resource pools apply. There are elastic database pools, but I thought...

Are you running VMs, IaaS servers in the cloud?

Really you have to do this yourself in that case, and it's the same as on premise. You need to create more...

sys.database_connection_Stats

http://blogs.msdn.com/b/wayneb/archive/2012/11/02/introducing-sys-database-connection-stats-for-troubleshooting-windows-azure-sql-database.aspx

Maybe a count from here, wanting this to be > 2 (one will be your connection)

I think the idea of Stretch with Azure pack on prem is great. This allows me to use older, even slower hardware, consolidated together as a "cloud" in my DC,...