TDE BYOK and Geo-Replication in Azure SQL DB (2020-07-21)

 SQLServerCentral Newsletter for July 21, 2020 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [TDE BYOK and Geo-Replication in Azure SQL DB]( - [Power BI Incremental Refresh for SQL Sources]( - [From the SQL Server Central Blogs - Refreshing a Power BI Dataset in Azure Data Factory]( - [From the SQL Server Central Blogs - Snowflake – Understanding constraints]( Question of the Day - [Loading Azure Synapse Data With COPY]( The Voice of the DBA  Daily Coping Tip Get the basics right today: eat well, exercise, go to bed on time I also have [a thread at SQLServerCentral]( dealing with coping mechanisms and resources. Feel free to participate. For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from [The Action for Happiness Coping Calendar](. My items will be on [my blog](, feel free to share yours. Adapting Privacy Lawyers will be lawyers.  That's a quote from a piece at Ars Technica on [how and why search engine startup Neeva changed their privacy policy](. They business model relied on users paying them to keep their data private. The goal being a secure platform that considered users privacy. An admirable goal, and one that I might have been welling to fund. There is a lot of data out there, and while I don't mind companies improving their service to me with data about me, I don't like them sharing it.  In this case, Neeva didn't read their terms of service very well. I'm sure they used a recommended legal group who were trying to craft a document that was structured to protect the company and allow for flexibility. Sharing data with affiliates and advertisers would seem to go against their model. If you read the article, you can see how they've adjusted their terms.  As the world grows more digital, and we all deal with an ever increasing number of organizations, data privacy will become more important to some, perhaps many people. The ideas of reducing data retention, limiting transfer of data, and giving users more control is an idea that may take hold, especially if a few companies start to succeed with this business model. We've seen pressure on companies throughout this year cause them to shift their previous stances, sometimes dramatically.  For those of us that work with data, this might mean easier administration in some ways. Certainly we will have to alter our systems for archival or more flexibly data retention policies. We might even need to adapt our data models to include more fields that allow us to easily decide what data to keep, remove, or obfuscate things.  In fact, I wonder if that's the future of privacy. We delink old users by randomly setting values for PII data and keeping other information like sales values or URLs clicked as useful data for aggregation.   Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [TDE BYOK and Geo-Replication in Azure SQL DB]( wagner crivelini from SQLServerCentral 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, […] [Power BI Incremental Refresh for SQL Sources]( Additional Articles from MSSQLTips.com In this article we look at the incremental refresh feature when working with Power BI data sources and how to implement for your reports. From the SQL Server Central Blogs - [Refreshing a Power BI Dataset in Azure Data Factory]( Meagan Longoria from Data Savvy I recently needed to ensure that a Power BI imported dataset would be refreshed after populating data in my data mart. I was already using Azure Data Factory to... From the SQL Server Central Blogs - [Snowflake – Understanding constraints]( jphillips 46546 from Another SQL Geek One of the concepts in Snowflake that I find many struggle with is how constraints are handled. If you come from a traditional database platform such as Microsoft SQL...   Question of the Day Today's question (by Steve Jones - SSC Editor):  Loading Azure Synapse Data With COPY The COPY command in Azure Synapse Analytics allows me to load data from which formats? Think you know the answer? [Click here]( and find out if you are right.    Yesterday's Question of the Day (by Steve Jones - SSC Editor) Restoring Different Sizes I have a large database (1TB) with one MDF file on SQL Server 2019. I want to restore a backup of this to a new instance, but I don't have 1TB of space. The database only uses 300GB, and that is roughly the size of the backup file. Can I restore this backup and change the file size during the process? Answer: No Explanation: No, you cannot change the mdf/ndf/ldf file sizes during the RESTORE process. You can only change the file sizes of restored database with restrictions. Ref: - RESTORE Arguments - - ALTER DATABASE - [Discuss this question and answer on the forums](    Database Pros Who Need Your Help Here's a few of the new posts today on the forums. To see more, [visit the forums](. --------------------------------------------------------------- SQL Server 2017 - Administration [Trying to Make combinations within a bracket in SSMS column]( - This is what the data looks like, I need to break the Column TID prefix as the first letter outside of the brackets needs to be combined with every letter inside the bracket. for example: A[CL] needs to broken down in 2 new rows as AC and AL. Can someone please help me with this? SQL Server 2017 - Development [Separating a string]( - Hi, I have a string that comes into one of my column and I need to create a column for each item. It looks something like this but much longer {"Id":"1bban5d82-23g4c-430ui-b804-4c3awasgec28","RecordType":20,"CreationTime":"2020-07-07T03:39:55"} Thanks Astrid  [Trying to Make combinations within a bracket in SSMS column]( - I have a column in SSMS where I am looking to make different combinations. For example I have a column for names such as A[123] where I need to make combinations such as A1, A2 & A3 where the output will be 3 rows instead of 1 (A[123]) can any one help me with this […] [Trying to Make combinations in SQL]( - I have a column in SSMS where I am looking to make different combinations. For example I have a column for names such as A[123] where I need to make combinations such as A1, A2 & A3. can any one help me with this please? SQL Server 2016 - Administration [Worker thread on SQL 2012 and SQL 2016]( - I migrated SQL 2012 to SQL 2016 with same 4 processor CPU On the SQL 2012 server I don't see worker thread issue but on new Server SQL 2016 I am getting Worker thread issue. Worker thread is set to default on both the SQL server [MultiSubnet AG Listener]( - I have an AG listener set up on two subnets - two nodes are in the same subnet and a third node is on a different subnet in a separate data center. The issue I'm having is that applications are timing out when connecting to the listener. Adding MultiSubnetFailover=True to the connection strings isn't possible […] SQL Server 2016 - Development and T-SQL [Cursors, i completed a group by query with help and sent it along to requestor..]( - but now said requestor is upping the request. i am needing to create a cursor to go thru all the database on an sql instance and then test if the table is in the database and if so then run query and output the results somewhere that he can load up into a spread sheet. […] Development - SQL Server 2014 [sql to find members not contacted in past 18 months]( - I have a table that has ContactNumber (Bigint), MemberNumber(bigInt) and ContactDate(date). The table has millions of records (sample data file attached). I want to get all the records where member has not been contacted for last 18 months. How do I do that using tsql? Your help is highly appreciated.  Thanks.  SQL Server 2019 - Administration [Possible to replicate SQL Server data to Terdata?]( - Is it possible to replicate SQL Server data (using SQL Replication) over to Teradata? If so, are there instructions available? thx in advance [Best Way to Run 1000+ SELECT statements?]( - So I basically have a spreadsheet with five columns of values. Each column represents a different field in my query. For each row in the spreadsheet, I need to execute a query (Oracle) that uses the values from that row and store/output the results. Example query for 1 row of the spreadsheet: SELECT * FROM […] SQL Server 2008 - General [Rebuild or Reorganize index]( - I am using SQL server 2008. The DB is normally used from 9 am-9 pm and the maximum db size is 10 GB. Whether rebuild index offline causes any problem, if it is done during midnight (when no one is using db)? or reorganize is enough for index maintenance in this case? SSRS 2012 [Is there an easy way of moving all controls down the report?]( - I'm working on a report which has a label (it's a TextBox) at the top, in the middle. The label says simply Transaction Report. To the left of that label is our address. To the right are 6 TextBoxes, three are captions and the other three are data elements. Under all of this are several […] Analysis Services [SSAS Actions IF statement]( - Hi All Great forum. I have just joined. Hoping someone can help me please. I have created an Action in SSAS 2014 that can be used to navigate to a URL from within Excel when browsing a cube. It uses MDX. I know very little MDX but managed to get it working. Here is the […] Integration Services [Extract DB2 data into Raw File]( - Hello: I'm trying to generate a Raw file in SSIS using the Raw Destination task but I'm reading from DB2 using ODBC Source. I need to convert this to UTF-8 because the file is automatically generated in ANSI. I used derived column to convert this columns to (DT_STR) but still got the same issue. The […] [SSIS 4 Minute Job Takes Over 19 *Hours* on New Server]( - I have an SSIS package which runs on SQL Server 2008 R2 in about 4 minutes. It's been running successfully for years. We are now migrating to SQL Server 2019. What Works: In addition to running on the old R2 server, the package runs perfectly on my little laptop in Visual Studio Data Tools with […]   [RSS Feed]([Twitter]( This email has been sent to {EMAIL}. To be removed from this list, please click [here](. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com. ©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -