Removing TDE from a Database: Level 4 of the Stairway to TDE (2020-08-26)

 SQLServerCentral Newsletter for August 26, 2020 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Removing TDE from a Database: Level 4 of the Stairway to TDE]( - [SQL Server Interview Questions for Developers on Querying]( - [Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA]( - [From the SQL Server Central Blogs - Your First Databricks Notebook]( - [From the SQL Server Central Blogs - SQL Clone Works with FILESTREAM]( Question of the Day - [Connecting to SQL Server from Python]( The Voice of the DBA  Daily Coping Tip Take time to forgive someone who hurt you in the past 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. Better Government Security Through DevOps Most teams building software go a little too fast to ensure their code is both secure and of high quality. I don't think it really matters whether you are working in a waterfall process, agile, lean, or any other methodology. Whether fast or slow, humans will make mistakes, new code can introduce a vulnerability. Even if you follow great practices, it seems that hackers and criminals find new attack vectors all the time. Those of us working as data professionals know that protecting the data in our databases is important. We are reluctant to allow too much change too quickly, especially when there might be changes that affect security. However, is limiting change the best idea? I'd argue no. DevOps preaches the ability to update on demand, and often, as soon as code is complete. This doesn't mean we don't test or pen test or run security scans or anything else. It does try to limit the work in progress, which means that we aim to allow updates to our lives systems regularly. An [article for CIOs]( notes this that DevOps helps us improve security, precisely because we can fix things quickly. This might be especially important in high security environments, like government systems. The ability to patch, correct faulty code immediately, and respond to threats is important. There could be breakage from fast moving code, but another part of DevOps is improving your knowledge and skills, working to improve not only the quality of existing code, but also the quality of all future, first written code. I would rather manage database systems that backed applications being updated on demand in a DevOps flow. I'd rather be able to patch and update libraries, platforms, and frameworks quickly. We've seen the problems in systems that aren't updated with [the Equifax breach](. We should learn from this incident and ensure we can patch and update systems on demand, whenever we need to do so. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [Stairway to TDE icon]( [Removing TDE from a Database: Level 4 of the Stairway to TDE]( Steve Jones - SSC Editor from SQLServerCentral.com Learn how to remove TDE from a database and return it to a normal state. [SQL Server Interview Questions for Developers on Querying]( Additional Articles from MSSQLTips.com In this article we look at some simple ways to test a SQL Server developers T-SQL skills with some query questions and answers. [Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA]( Press Release from Redgate Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks". From the SQL Server Central Blogs - [Your First Databricks Notebook]( Steve Hughes from DataOnWheels On August 4, 2020, I presented this on the weekly Pragmatic Works webinar series. You can view that presentation here. As part of that presentation, I committed to give... From the SQL Server Central Blogs - [SQL Clone Works with FILESTREAM]( Steve Jones - SSC Editor from The Voice of the DBA SQL Clone is an amazing product that virtualizes your data, allowing multiple instances to share a read only image, but still produce writeable databases that look normal to SQL...   Question of the Day Today's question (by Steve Jones - SSC Editor):  Connecting to SQL Server from Python I want to connect to SQL Server from my Python script. How can I do this? 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) Replacing sysconfigures I was refactoring an old query that was looking at the sysconfigures system table. To use a more modern DMV, what should I query?  Answer: sys.configurations Explanation: The DMV, sys.configurations, replaces sysconfigures. Ref: Mapping System Tables to System Views (Transact-SQL) - [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 [Cannot connect to SSRS from SSMS]( - Hello,  I just install SSRS 2017 Reporting Service and have configure Report Server from Report Server Configuration Manager. Report Server Status is Started, mode is Native. I have setup all necessary setting like Service account, Web Service URL, Database, and Web Portal URL.  I can access Web portal URL from my browser, but […] SQL Server 2017 - Development [Convert Access IIF with Switch in MSACCESS to SQL Server]( - I am in the process of converting an access query to T-SQL. There is an IIf statement which I am having trouble translating. SUM (LOTOSMIS_ACC_TYPE.sing_ind * LOTOSMIS_RET_DAILY.grs_amn * iif( gm_cd in (1105, 2123, 2124, 2150, 2152, 2191, 2192, 5143, 5145, 5146, 5245, 5253 ), switch(LOTOSMIS_RET_DAILY.gm_var=1, 0, TRUE, 1), 0)) AS RegSales What I gave tried […] [How to calculate future CostPrice value based on two other columns please...]( - Hello All Good Evening, Can you please help with this Issue --- Sample Data Begins Create Table #SampleData (DriverMon DATE, CostPrice Numeric, CurrentPercentage int, MonthtobeConsider Date,expensetype varchar2(20), LessorID int) Insert Into #SampleData Values(TO_DATE('01/01/2021', 'DD/MM/YYYY'),150,4,TO_DATE('19/10/2017', 'DD/MM/YYYY'), 'Lease', '4343') Insert Into #SampleData Values(TO_DATE('01/02/2021', 'DD/MM/YYYY'),120,4,TO_DATE('19/10/2017', 'DD/MM/YYYY'), 'Lease', '4343') Insert Into #SampleData Values(TO_DATE('01/03/2021', 'DD/MM/YYYY'),110,4,TO_DATE('19/10/2017', 'DD/MM/YYYY'), 'Lease', '4343') Insert Into […] [smtp in store procedure]( - vDear Team, it is regarding store procedure query for sending an email. i am unable to find the smtp codes like we used to do earlier. could you someone assist me how to smtp confuguration in it ac USE [msdb] GO /****** Object: StoredProcedure [dbo].[sp_send_dbmail] Script Date: 19/08/2020 12:33:29 ******/ SET ANSI_NULLS ON GO SET […] SQL Server 2016 - Administration [CDC Setup wrapper functions - missing column __$command_id]( - Running SQL 2016 Standard SP2 CU14 (the most recent version) I see a lot about this issue and best i can tell its just a bug that Microsoft isn't going to fix. It seems there are different opinions of what to do. The wrapper function creates scripts for other functions that will return change data […] SQL Server 2016 - Development and T-SQL [What am I doing wrong? OR with AND logic]( - I need help with my where clause. The criteria below works except source_ID '100' keeps showing up in my data. Basically I have 2 OR's and 1 AND. What is the best way to use these together? Im sure I must be doing this incorrectly. FROM table1 WHERE (APPLE_IND = 1 OR GRAPES_IND = 1) […] Administration - SQL Server 2014 [AG recovery following disaster]( - Hi All. I'm looking for suggestions on the best way to recover from a disaster. Setup is an AG (asynchronous commit) on a two node cluster (one production, one DR). Forced failover with data loss following abrupt unplanned outage at production data centre. Have been in DR with production unavailable for a week. Lots of […] SQL Server 2019 - Administration [Explanation of SQL Code]( - hi, can someone help me what does this code mean/do step by step. thank you so much, i understand the basics but what are the two dotes and the first line select distinct left(a.unq_id_src_stm,13) partija_13,a.unq_id_src_stm, b.cl_val_id into #t1 from tez_bdw_tut..sor_pd_ar a join TEZ_BDW_TUT..sor_ar_x_cl b on a.PD_AR_ID = b.AR_ID where b.cl_scm_id = 63 and 20200806 between […] [Error 1105 filegroup full]( - Hello community, I currently emptying ndf file to other ndf files (with SSMS) and I get the error 1105 filegroup full for that particular database I am working on. But if I check the filegroup and the other ndf/mdf files there's plenty of enough space left. So I can't figure out which filegroup is full. […] [Data transfer from sqlserver to Oracle]( - Hi , Source : SQL Server Table ; Destination : Oracle Table What is the best way to schedule the data transfer when new record inserted in source(sql server table). Thank you for your suggestions. Thanks. SQL Server 2019 - Development [In Both Tables, In Table #1 But Not Table #2, In Table #2 But Not Table#1]( - I've two tables and each has a key set. Each table has a user first name and a user last name and a 'key' which is lastname + firstname. I know that isn't ideal, but given the underlying data, that is the best that can be done. I'd like to show a report that shows […] SQL Azure - Administration [Azure Loadbalancers]( - This is more of a quick question.  So Setting up Availability groups cross region in Azure. all of the networking is in place, the VNET Peers, etc. My question is about the load balancers. In the past, I have only ever provisioned 1 ag group cross-region and therefore 1 x Standard Azure Load balancer […] Reporting Services [lookup do not bring both amount from one account]( - 0 Votes"0 Ysa8989-0610 asked · 0 secs agoActions Lookup do not bring amount Hello There I have to datasets one for expenses and one for revenues, it is partially working because the lookup is bringing one amount only it should be bring all amount sitting there. Therefore I am out balance. The money is sitting there but my […] SSRS 2014 [Setting Start Date]( - I have a parameter in my report to put the sunday date in of the current week =DATEADD("d" ,7-DATEPART(DateInterval.WeekDay,Today(),FirstDayOfWeek.Monday),Today()) so for this week would put the date as 23/08/2020 I need to set a start date that puts in the Monday Date from 11 weeks ago based on the end of week date above so […] SSDT [redirect row on truncation]( - I kind of have this working, but for my test row, it did not output to the file. It is at least creating the files. So employeenumber is nvarchar(15) example data is 123456@mysub.ourdomain.us what gets inserted is the first 15 123456@mysub.ou I have this set for the table:  I do have a couple of […]   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -