Removing TDE from a Database: Level 4 of the Stairway to TDE (2024-10-09)

SQLServerCentral Newsletter for October 9, 2024 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Removing TDE from a Database: Level 4 of the Stairway to TDE]( - [Identify CPU Intensive SQL Server Queries from an Implicit Conversion]( - [Microsoft to Headline PASS Data Summit 2024 as Sapphire Sponsor]( - [From the SQL Server Central Blogs - Analytics vs. Advanced Analytics]( - [From the SQL Server Central Blogs - Additional Use for sp_statement_completed]( - [Azure SQL Revealed: A Guide to the Cloud for SQL Server]( Question of the Day - [Starting to Estimate Disk Storage for Memory-Optimized Tables]( The Voice of the DBA  Keep. It. Simple. I get a tech newsletter most days, which has news that I enjoy, but interspersed among the news and ads are projects, frameworks, or repos, most of which I've never heard of before. I used to read these, but it seems that there is an endless list of these, which all have marketing descriptions that somehow claim this set of code solves problems that others don't or that this code is easy to use and integrate with, or well, I don't know what other promises. I'm usually turned off by the end of the first sentence. The thing I've noticed is that there are so many projects out there. Even in the database space, if I happen to read a discussion on some aspect of databases, such as database deployment frameworks, I'll see links to technologies I've never heard of in my life. Some are small projects, and some are small companies, but there is an amazing variety of solutions for any tech problem. I'm not sure most of them are much different from the others, but the Not Invented Here syndrome seems to be everywhere. These observations also remind me of just how vast the world is and how little I see of it on a daily basis. I ran across [an article recently on simplifying the way we build software](. In this instance, the authors focused on the complexity of JavaScript frameworks, with a number of authors/developers/consultants saying they limit their use of frameworks and try to keep to simple technologies. There is a quote that I find myself agreeing with and disagreeing with at the same time from [David Heinemeier Hansson]( "The merchants of complexity will try to convince you that you can't do anything yourself these days. You can't do auth, you can't do scale, you can't run a database, you can't connect a computer to the internet. You're a helpless peon who should just buy their wares. No. Reject." I do think that many frameworks, products, etc. are very complex and there is a cost to using them. They can be overwhelming and hard to teach to others, and those costs can outweigh the benefits. The costs could be actual money or they could be the time it takes to learn, integrate, and teach the technology to others. Any change you make to your architecture will have impacts that you haven't considered, and it will slow down your agility. Adding new technology does the same thing. At the same time, some things are hard. Auth is hard. Lots of people struggle with this and Troy Hunt has made a good living at [( pointing out all the poor decisions people have made. Including a bunch of them that use the auth provided by some tech stack. Running databases is hard. Can you run one? Sure. Will you run it well as your app grows? Experience shows me most of you can't. Can you set up a simple backup strategy? Of course, but that doesn't matter. You being able to restore things is what matters. There are plenty more examples of tech problems or failures that companies run into as they build and scale software. There are also plenty of examples where using a framework saves a bunch of time for development teams. Look at mobile apps, most of them are based on some framework because learning all the ins and outs of iOS and Android is too hard for most people. For. Most. People. DNN can do a lot of things that most people can't. He's very talented and smart. Lots of organizations have one or two very talented people, but they also have a lot of average people. They struggle to teach and train them things, and ultimately, they don't want to spend time teaching everyone about how to manage CSS or auth a user from a service or deploy changes to a database. They want a framework that makes it simple for the ever-changing staff to get work done related to their business, which is more often than not building software. They need to build software, but they need the software built to serve their customers in some way. That's their goal, serving customers. I am all for keeping things simple. I want to minimize the number of technologies we use, and I want to limit the training time it takes to get people productive. However, I don't want to build everything myself because I'm not sure I can, and I certainly know I don't to go to that much effort. 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]( VishnuGupthanSQLPowershellDBA from SQLServerCentral.com Learn how to remove TDE from a database and return it to a normal state. [External Article]( [Identify CPU Intensive SQL Server Queries from an Implicit Conversion]( Additional Articles from MSSQLTips.com Learn how to use the SQL Server Query Store to find CPU-intensive queries and how you can use Query Store to resolve these issues. [Technical Article]( [Microsoft to Headline PASS Data Summit 2024 as Sapphire Sponsor]( Press Release from SQLServerCentral Join Microsoft at PASS Summit 2024 to explore the latest database innovations and how Azure solutions enhance app performance, security, and scalability in the AI era. Learn new SQL database capabilities, connect with Microsoft engineering leaders, and attend expert-led sessions on topics from database migration to modernization. [Blog Post]( From the SQL Server Central Blogs - [Analytics vs. Advanced Analytics]( Joyful Craftsmen from Joyful Craftsmen Blog The post Analytics vs. Advanced Analytics appeared first on Joyful Craftsmen. [Blog Post]( From the SQL Server Central Blogs - [Additional Use for sp_statement_completed]( Grant Fritchey from The Scary DBA Another discussion in Gothenburg (such a great group of people) around Extended Events lead to a (admittedly, tiny) idea for an additional use for sp_statement_completed. The basics for sp_statement_completed... [Azure SQL Revealed]( [Azure SQL Revealed: A Guide to the Cloud for SQL Server]( Site Owners from SQLServerCentral Access detailed content and examples on Azure SQL, a set of cloud services that allows for SQL Server to be deployed in the cloud. This book teaches the fundamentals of deployment, configuration, security, performance, and availability of Azure SQL from the perspective of these same tasks and capabilities in SQL Server. This distinct approach makes this book an ideal learning platform for readers familiar with SQL Server on-premises who want to migrate their skills toward providing cloud solutions to an enterprise market that is increasingly cloud-focused.   Question of the Day Today's question (by Steve Jones - SSC Editor):  Starting to Estimate Disk Storage for Memory-Optimized Tables If I have durable memory-optimized tables, what is the starting point for estimating storage space? 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) Data Migration Assistant Targets In the current (2024) version of the Data Migration Assistant, which on-premises targets are available? Answer: SQL Server 2012-SQL Server 2022 on Windows and Linux (SQL 2017+) Explanation: The targets for the Data Migration Assistant are SQL Server 2012-2016 on Windows and SQL Server 2017-2022 on Windows and Linux. Ref: [Supported source and target versions]( - [ [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 [Object-level permissions on dbo]( - I'm in a bit of a pickle. I had to remove all user permissions from a database but when a user tested to verify, they could still see everything. My first thought was that the public role had permissions on everything, but no, it's clean. Finally I noticed that the user dbo has object-level permissions […] SQL Server 2016 - Development and T-SQL [Help with index rebuild]( - Hi there! This should make some eyes roll for some of you DBA's out there. Disclaimer: I am not a DBA and shouldn't be trying to play one. I desperately need help in trying to remedy a problem I caused on our 2016 SQL Server (Std Edition). We realized that the weekly maintenance job hadn't […] SQL Server 2019 - Administration [Does Denticore Really Work- Denticore Reviews And Complaints]( - A healthy smile is not just an aesthetic asset; it plays a vital role in your overall health and well-being. Poor dental hygiene can lead to a range of serious health issues, including heart disease and diabetes, emphasizing the need for proper oral care. Regular dental check-ups and cleanings are integral to preventing complications that […] [sql service account]( - We are trying to update a sqlservice account from a user account to a domain account. The service runs fine under the user account but when we update it to a domain account we face the following error and the sqlservice does not start. Error: SQL Server is attempting to register a Service Principal Name […] [Calling Invoke-Sqlcmd from powershell and passing an object containing a '-']( - Invoke-Sqlcmd -Query "ALTER AVAILABILITY GROUP $AAG REMOVE DATABASE $DB " -ServerInstance $Instance Invoke-Sqlcmd : Incorrect syntax near '-'. Msg 102, Level 15, State 1, Procedure , Line 1. Hello all, As you can see from the sample above $AAG contains 'MY-AG' (not the real AG name but the hyphen is in the name) results in […] [SSMS V20 encryption vs SQL Server SSL Encryption]( - I assume SSMS V20 encryption and SQL Server SSL encryption are different. I have a few queries. Please see below. Do these two encryptions conflict? Can we make 'SQL Server SSL Encryption' optional? So we can control which applications to bypass SSL and force others? Is there any other things we should be aware of […] [List of objects that require VIEW SERVER STATE permission]( - Hi all, I need a list of objects (DMV's and probably other objects) that require VIEW SERVER STATE permission. Our DB security team is asking me why I need it. I can only recall sys.dm_exec_requests from the top of my head. Will appreciate of somebody would paste a whole list. Thanks [sql monitoring tool]( - Has anybody had any experience with Nagios as a SQLServer monitoring tool. What were the pros and cons you had faced while using it. Please advise. SQL Server 2019 - Development [running in a circle looking for ibm db2 connector]( - hi i seem to be running in a circle trying to find a db2 connector for windows where my dw sql server is running.  the links say to go to their web console. but there isnt anything on their web console that looks like a download for that purpose. their virtual assistant asked if i […] SQL Azure - Administration [Azure Managed Instance Backup Schedule with SQL Job]( - Lets do configure backups in my own in Azure Managed Instance......My Lead has directed me to configure regular backups scheduled as like in traditional SQL Server...Please suggest how to make this possible to create Job that will take backups daily/weekly in Azure Managed Instance. Analysis Services [Cannot connect to Analysis Services via Excel]( - For myself this seems to work and for other users they receive this error: Errors in the OLE DB provide. We could not establish a connection to the "Server/Instance" Analysis Services server. Please verify that you can connect to this server, and that the SQL Browser redirector service is enabled. This a 2016 SSAS Tabluar […] SQL Server 2022 - Administration [Memory grants pending root cause]( - Recently I got sql alerts from one of QA servers, every 2 or 3 hours. DESCRIPTION:  The SQL Server performance counter 'Memory Grants Pending' (instance 'N/A') of object 'Memory Manager' is now above the threshold of 0.00 (the current value is 1.00).COMMENT:       Ideally there should be no processes waiting for memory and this should = […] [SQLExternalMonitoring what is it in sp_who2 result]( - If I run sp_who2, one of item in the list is showing using program SQLExternalMonitoring , what is it? it uses quite a bit cpu and ram. 70 sleeping NT AUTHORITY\SYSTEM SNOCSMASQP01 . master AWAITING COMMAND 170846212 57458731 09/26 10:31:41 SQLExternalMonitoring 70 0  Thanks, [Linked Server to SAP HANA database.]( - Greetings all. It's been a very long time, but I'm back. Does anyone have experience with setting up a linked server to a SAP HANA database? I have hanaclient-2.8.20-windows-x64 installed and a DSN created using the HDBODBC driver that comes with the client install. I am able to use the DSN to connect with generic […] SQL Server 2022 - Development [Check sequential order of status of items]( - There is a table tblItems with below structure ( i cannot change the below table structure) Objective is to check if the sequential order of the statuses is correct or not. Order of the statuses should be in this sequence : QualityCheck, Printing, Labelling, Packing, Dispatch If the status is not in this order for […]   [RSS Feed]( 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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -