Recently a customer asked me for help with setting up a test of an Azure SQL Database in the single database tier with Geo-Replication to work with Transparent Data Encryption (TDE) with a customer-managed key, also known as Bring Your Own Key (BYOK). It is very simple to do it when you use service-managed keys, […]
2020-07-21
1,860 reads
Active Geo-location is powerful magic for ensuring the high availability of a Azure SQL database, and for disaster-recovery. In choosing the best options, you need to accurately understand the value that the business places on the service you're running, long it will take for a secondary replica to be in synch with the primary replica, the importance of spreading the location of replicas widely, and the maximum tolerable unscheduled downtime. Just clicking all the options could prove to be expensive.
2016-10-27
3,361 reads
This article will discuss geo-replication for an Azure SQL Database (PaaS) and the steps required for setup via the Azure portal and TSQL.
2016-06-27
1,394 reads
This paper provides IT pros with an in-depth look at the tests conducted by the MSCOM Ops team, insight into the results, and technical analysis of the enhancements to Windows Server 2008 and SQL Server 2008 that enable wide area network (WAN)–based geo-replication.
2009-06-12
2,093 reads
Hi list,Does anybody have an idea where SQL server keeps the information about database recovery modes (full, simple, etc) rather then looking up in EM.Maybe someone has a script to get all modes for all databases on the server.Thank you,JP
2004-11-15
2 reads
On one of our databases we have a table on which data in appended whenever we have a problem in that database. Normally we check the table from time to time to look for addition of data. But I would like to create a trigger to notify a user (net send operator) on our network […]
2004-10-21
1 reads
Hi,I am sorry to post my answer accidentally before I am done:(Continued) . delete the temporary tableAll of the 4 steps above can be in one stored procedure. If you want, you can even:-modify step #2, replace any comma by ~-create a macro in excel to convert all '~' to ',' then set it up to […]
2004-10-15
quote: Supplying the password in sp_change_users_login is new with SP3. I guess to be completely up to date they should have included that. Ahh... now that makes sense. Looking at an old test server I see that the SP3 changes are not there. Doesn't pay to keep things current I guess. I agree the Update_One […]
2003-06-17
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers