
With a Geo-Replicated Azure SQL DB that is already replicated with ALLOW_CONNECTIONS = ALL, is there a way to alter the replica to ALLOW_CONNECTIONS = NO after it is already setup without a drop and recreate? #sqlhelp
If Azure managed disks are already encrypted at rest by default, would it be overkill to also enable TDE on our IaaS databases using those same managed disks? azure.microsoft.com/en-us/blog/azu… #sqlhelp
azure.microsoft.com
Announcing Storage Service Encryption for Azure Managed Disks | Microsoft Azure Blog
Today, we are excited to announce Azure Storage Service Encryption (SSE) with keys managed by Microsoft for Managed Disks.
#sqlhelp Anyone have any ideas on how to accomplish this? It must still need to hit the primary replica in some manner before being routed to readable secondary.
#sqlhelp Trying to create a login with ONLY access to a database on a readable secondary. I create login on both primary and secondary, deny connect on primary. Connect with readonly intent, and get login failed. verified RO routing is working without DENY connect on primary.
man... Major Azure south central data center outage at the moment... this is fun.
Anyone have any examples or blog posts on how they've setup monitoring & alerting for blocked processes in Azure SQL DB? #sqlhelp
Real quick, is it possible to have an asynchronous secondary act as a readable secondary in an AG? #sqlhelp
They weren't kidding about "sometimes more than 24 hours" to deploy a managed instance for the first time...

Currently listening to Paul Randal talk to us about wait stats. 🔥
Big thanks to @SQLHammer for presenting for us at the NW Arkansas #SQLPASS user group today. He gave a great primer on Azure SQL Data Warehouse.
Tonight Show Music Break: @TheWarOnDrugs performs "Pain" for Studio 6B! youtube.com/watch?v=u6CAq-…
2018 Goal: Be as lazy as possible. More query shortcuts ftw.

🙌🙌🙌
Finally, support for recent SSMS versions downloadable at architectshack.com/PoorMansTSqlFo…. Took long enough, but looks like we made it!
Here's a better picture of the squirrel in data center.

Was just sent a RED ALERT email There's a squirrel loose in the data center. Chewed through some fibre and brought one server offline so far
Boarding flight to SEA-TAC (@ Dallas Fort Worth International Airport in DFW Airport, TX) swarmapp.com/c/5UzUMwqYgvo
First stop of the day en route to #SQLSummit #SqlPass (@ Northwest Arkansas Regional Airport - @flyxna) swarmapp.com/c/9V3wO5SjZvu
United States 趨勢
- 1. Ohtani 204K posts
- 2. Dodgers 249K posts
- 3. Dodgers 249K posts
- 4. Carson Beck 16.2K posts
- 5. $SAWA 1,668 posts
- 6. Miami 99.1K posts
- 7. Louisville 27.8K posts
- 8. Nebraska 17.7K posts
- 9. Brewers 55K posts
- 10. Babe Ruth 3,195 posts
- 11. NLCS 58.1K posts
- 12. Emiru 5,310 posts
- 13. #SmackDown 56.5K posts
- 14. #BostonBlue 7,769 posts
- 15. Rhule 4,578 posts
- 16. Minnesota 47.4K posts
- 17. 3 HRs 10K posts
- 18. George Santos 80.5K posts
- 19. 10 Ks 4,425 posts
- 20. Massie 28.5K posts
Something went wrong.
Something went wrong.