Database Deployment with Terraform - The Basics (2022-10-17)

SQLServerCentral Newsletter for October 17, 2022 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Database Deployment with Terraform - The Basics]( - [SQL Server Internals: Reading Pages]( - [Load Data Asynchronously to SQL Server via an API and Python]( - [From the SQL Server Central Blogs - Tales From The Field Weekly Wrap Up]( - [From the SQL Server Central Blogs - Restore HEADERONLY and FILELISTONLY]( Question of the Day - [Autocommit Transactions]( The Voice of the DBA  Daily Coping Tip Make progress on a project or task you have been avoiding 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. The Digital World Remaking the Analog One I got a taxi at Heathrow in the UK recently to go from one terminal to the other. I know, there are buses and trains, but it was late, I had my wife with a lot of luggage and I was worried the restaurant in the hotel would close before we managed another method of transport. As we were making our way over the driver noted there was a £5 charge to drop off at a terminal. That sounds silly, but I saw a billboard noting this and there is [a link that this charge applies to almost all vehicles]( entering the airport terminal areas. You might agree or disagree with the charge, or concern yourself with whether the airport authority or local government can (or should) add this as a little tax to those that drive to terminals. That isn't my focus today. Instead, I thought this was a somewhat amazing, DevOps experiment of how the digital world is remaking the real, analog one. Making this decision in the past would require a lot of infrastructure, some gates, people to man them or automated systems to take payment. In this new world there cameras needed, and software that must be built, but this can also re-use payments systems online and take advantage of computing power to assess this charge. The costs might even be lower as the government might absorb some of the camera cost and maintenance as a part of their security concerns. Maybe more importantly, adjusting the charge or eliminating this is a decision and a small software or data change. We can remake the way the world works without much effort at all, similar to how we might remake the digital one when we change code. The world of software is only limited by the imagination of developers. That seems to be bleeding into the physical one. I find more and more places where software is changing and affecting the physical world. We saw digital menus replace physical ones during the pandemic. While some places have returned to physical ones, others have used hardware tablets to not only present menus, but take orders and payment. In a recent trip to the UK, many places allow complete self service where a patron enters a table number and someone brings their order without any other interaction. I don't know I think this is better, but it is changing the way the physical world works. It's not just payments and charges, but there are more and more places where software helps manage traffic flows (people or veihcles) without infrastructure. Just directions that people follow, and perhaps get fined when they don't. I see live translations of text changing the need for producing signage in multiple languages. There are plenty of examples, especially as AI/ML systems can help adjust our interactions in the physical world with less hands-on coding from human developers. Something that becomes more important as we are struggling to find developer talent in the modern world. Whether you like this or not, the world is changing. We might not like it, and we might try to convince others to build software we prefer, but we will be interacting with software more in ways that changes how we interact with the physical world. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [Database Deployment with Terraform - The Basics]( wagner crivelini from SQLServerCentral Learn the basics of using Terraform to declaratively specify how to configure resources in infrastructure. [Technical Article]( [SQL Server Internals: Reading Pages]( Additional Articles from SQLServerCentral The I/O from an instance of the SQL Server Database Engine includes logical and physical reads. A logical read occurs every time the Database Engine requests a page from the buffer cache. If the page is not currently in the buffer cache, a physical read first copies the page from disk into the cache. [External Article]( [Load Data Asynchronously to SQL Server via an API and Python]( Additional Articles from MSSQLTips.com Learn how to consume multiple API calls to load data to a SQL Server database using Python. From the SQL Server Central Blogs - [Tales From The Field Weekly Wrap Up]( SQLBalls from SQLBalls  Hello Dear Reader! It's been a while. I've been busy working with a few colleagues on our show Tales from the Field. This has been a learning experience.  I've had to... [Blog Post]( From the SQL Server Central Blogs - [Restore HEADERONLY and FILELISTONLY]( gbargsley from GarryBargsley Good day reader. This post is coming to you from a busy week in Texas, where the heat is starting to subside. The week’s topic will cover two options...   Question of the Day Today's question (by Steve Jones - SSC Editor):  Autocommit Transactions If I have a transaction that commits immediately after the execution of the T-SQL DML statement, which type of transaction is 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) Disabling the CEIP Under what situations can I disable the CEIP service? Answer: This can only be disabled in paid versions Explanation: This can only be disabled in paid versions. Ref: Configure usage and diagnostic data collection for SQL Server (CEIP) - [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 [Relaying denied email error]( - Hello ,  On the SQL server database I am experiencing  " server response was: 5.7.1 xxxxx  " Relaying denied. IP name lookup failed " error upon sending an email. kindly advise. [MDP/CTP values]( - Hi All, We have a server with 8 cpus. Some times Thread count is higher than 576(Max worker threads). Noticed some deadlock issue at the same time. Most of the wait types are CX packets (Above 35%). CTP is set to 5 & MDP is 0. Best recommended values to change MDP and/or CTP? Planning […] SQL Server 2016 - Development and T-SQL [Ranking functions]( - I need a second set of eyes to help with my lunacy/stupidity/senility. I've got a set of interview questions, the categories of the questions, and the interview guide that "packages" them together. I want each question category within an interview guide to be numbered, and each question within each category to be numbered. Like this: […] [remove unwanted rows]( - I have a query that returns 9 rows of data. I want to remove the rows that cancel each other out by the amt column. See current results below and desired results. I am using RefDocNum and AcctDocNum1 as my key fields. The LocDbtAmt is the column I want to use to remove rows that […] [How to Modify a Field when doing a Inner Join]( -  I have tables and I would like to join on two fields. Unfortunately, in one table a field for website address appears as www.unilever.com, whereas the website address in the other table appears as . Therefore, naturally if I attempt to do a Inner Join on those fields there won't be a match. The […] SQL Server 2019 - Administration [R3eplication emergency question Please help]( - exec sp_replicationdboption @dbname = N'Life', @OPTNAME ='publish',@value = N'false' exec sp_replicationdboption @dbname = N'Life', @OPTNAME ='publish',@value = N'true'  everything is gone all my replication jobs how can I restore them?   [Replication fix with temp db]( - Hello,  I changed temp db from c drive to another drive, everythink ok on server,but my replication job is failing now,how can that be fix? Only temp db was changed,error message: Replication-Replication Transaction-Log Reader Subsystem: agent SQL-TEMP-RMCMSLogs-3 failed. Login failed for user 'sa'.  [SPN / SSPI Context error even though SPN exists]( - Hello experts, I've been dealing with a maddening issue. I am getting the familiar error "The target principal name is incorrect. Cannot generate SSPI context" when I try to connect to a SQL 2019 instance from a remote SSMS session. Connecting on the server itself via RDP is fine. But that does not use Kerberos. […] SQL Server 2019 - Development [T-SCRIPT XML]( - Hi All, I have this sample xml data with subgroups. I have identified the fields in the source data. I wanted to check if anyone can give me some idea, how can I get the xml output like these from those data. Or someone can point me to the url where I can generate such […] [Get data from daterange]( - Hi Team, I've below requirement. The source has date in YYYYMM format. If I run job in 2022, it should extract data between 202108 and 202206 If I run job in 2023, it should extract data between 202207 and 202306 If I run job in 2024, it should extract data between 202307 and 202406 and […] [IF Column THEN Value AS Name.]( - Hello everyone First, I want you all to know that I always search for an answer before posting here. I really don't like to bother other people with my problems. That's what happen when I'm learning SQL. But one thing is for sure: I'm saving all those queries for later to use. This time, I'm […] [Concatenate 3 text columns]( - Hello all I know it's Sunday and we're all supposed to be resting for the week to come. But this issue is intriguing me. In my SQL code, after the selected fields I've made two CASE WHEN. After, I'd like to concatenate those two and another column, Year so I can have my date field. […] [SSRS report execution details]( - hello guys need to create SSRS report that shows execution run time for existing ssrs and subscription reports report name report type ( adhoc or subscription report ) report run time in seconds report owner report owner permission level report run by Thanks [Extracting first characters in a string]( - Hi All, How could I can extract all the first characters in the string using SQL Server query Reporting Services [Hitting enter DOES NOT render report]( - Opening a report with inputs (dropdowns, date inputs) on hitting enter the report is not rendered, instead it does nothing. How can I add that the Report is always rendered when hitting the ENTER key?   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -