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,...

I'm not sure if this is intentional, but it's probably an artifact of the way in which Azure has evolved. The subscription people have tended to be in charge of...

As Grant said, this is different in Azure. You treat the system as a database service, meaning you connect to a database and see the objects, but that's it. There...

You might not need a full day's, but I'd roll one of those full's each day (first/last) to another disk.

Grumpy DBA (2/11/2016)

---

Thanks Steve, just read some...

Always, always, always keep two fulls and the logs from the earliest one forward.

You never know when you will lose a file or have disk corruption on that file.