Amazon EC2 | Creating a Connection to an Amazon RDS Instance (2022-12-05)

SQLServerCentral Newsletter for December 5, 2022 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Amazon EC2 | Creating a Connection to an Amazon RDS Instance]( - [SQL Server 2022 Paid Editions Require a Licensing Key]( - [Exploring Hive Tables with Spark SQL]( - [From the SQL Server Central Blogs - My SQL Server Encryption book has just been published!]( - [From the SQL Server Central Blogs - How to Store Normalized SQL Server Data into Azure Cosmos DB]( Question of the Day - [The DAX Text Contatenation]( The Voice of the DBA  Daily Coping Tip Look for new reasons to be hopeful, even in tough times 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. Does Speed Compromise Quality? This editorial was originally published on Apr 11, 2017. It is being re-run as Steve is out of town. One of the parts of DevOps that is often hyped is the speed and frequency of releases. Starting with [Flickr and their 10 deployments a day](, to [Etsy deploying 50 times a day](, we've seen companies showcasing their deployment frequency. Amazon has reported [they deploy code every 11.7 seconds on average](. That seems crazy, but with so many applications and lots of developers, not to mention each change being smaller, perhaps it's not completely crazy. With the forum upgrade here at SQLServerCentral, we had two developers (with occasional other sets of eyes reviewing code changes), and while we were bug fixing, we deployed multiple times per day. Is that a good idea? Does a rapid set of changes mean that quality is lower and more bugs are released? It certainly can. In fact, if you're a development shop that struggles with releases and code quality, producing software faster is not going to help you. In fact, if management pressures you to adopt DevOps, and deliver code faster without culture change, without implementing automated testing, including for your database code, and using automated scripts, tools, or something to deploy software, then you are going to get more bugs out faster. You'll still get to change direction quicker if you find you're building the wrong software, but you'll still end up becoming more inefficient because of bugs (And technical debt). There's [a fantastic video (long) about refactoring code in two minutes](. A bit of an oxymoron since the presentation is nearly two hours long, but the video is from a real project. However, their approach is that good unit testing allows them to refactor code, to change things, without introducing bugs. That's a big part of the [#DevOps]( philosophy. I always note in my DevOps presentations that if you can't implement unit testing, meaning you won't bother, then you don't get much benefit from CI, CD, or any DevOps ideas. Tests protect you from yourself (and others). In many of the DevOps reports, companies that release faster report fewer bugs and less downtime. Since Amazon has increased their speed, they have 75% fewer outages across the last decade, 90% fewer time down, and many, many fewer deployments causing issues. [Turbotax made over 100 production changes during tax season]( and increased their conversion rates. The State of DevOps reports bear this out ([2016 here](). Thousands of responses show that speed doesn't cause more bugs. Because they work differently. If your management won't let you change the way you work, if you don't implement automated unit tests (and other types of tests), if you don't take advantage of version control, if you don't ensure every change is scripted, then you won't work differently, and speed will bring bugs. You can do better. Your company can do better. Will they? Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [Amazon EC2 | Creating a Connection to an Amazon RDS Instance]( Br. Kenneth Igiri from SQLServerCentral In a previous article, we showed how to expose an Amazon RDS instance to the public internet securely for direct access to the database. In this article we shall configure an Amazon EC2 instance for network access to an existing Amazon RDS instance. The purpose of this would be to make sure that if we deploy an application to this EC2 instance, communication from the client to the RDS instance would be smooth. [Technical Article]( [SQL Server 2022 Paid Editions Require a Licensing Key]( Additional Articles from SQLServerCentral For the final release of SQL Server 2022, Microsoft popped a surprise that wasn’t in the release candidates [External Article]( [Exploring Hive Tables with Spark SQL]( Additional Articles from MSSQLTips.com In this article, we will look at how to use an Azure Databricks Workspace to explore Hive tables using Spark SQL along with several examples. [Blog Post]( From the SQL Server Central Blogs - [My SQL Server Encryption book has just been published!]( Matthew McGiffen from Matthew McGiffen DBA It’s been a long journey, but I got the email from Apress yesterday to say that my book “Pro Encryption is SQL Server 2022” has now been published. You... [Blog Post]( From the SQL Server Central Blogs - [How to Store Normalized SQL Server Data into Azure Cosmos DB]( Koen Verbeeck from Koen Verbeeck Recently I got a hold of my Untappd data. For those who don’t know the app, it’s a rating app for beers. You can check-in a beer each time...   Question of the Day Today's question (by Steve Jones - SSC Editor):  The DAX Text Contatenation I have two columns in a Power BI data model. They are: Assists[Event] and Assists[Opponent]. These are text values and I want to put them together with a hyphen. Which DAX formula will work? 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) The Last Valid Restore Time In SQL Server 2022, there is a last_valid_restore_time column in sys.backupset. What is this used for? Answer: This is the last valid STOPAT time for a restore using this transaction log backup. Explanation: This represents the last valid STOPAT time for a transaction log backup. Ref: sys.backupset - [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 [Does the db_ddladmin database role permissions apply to db system object?]( - The db_ddladmin is another powerful role because it allows a user to create, drop, or modify any objects within a database, regardless of who owns it. (. Question1, it states it allows a user to create, drop, or modify 'any objects' within a database, does this include 'system objects' or just 'user objects' within the […] SQL Server 2016 - Administration [Batch Requests/sec ; FROM sys.dm_os_performance_counters -how to get SUM /hour?]( - Is it possible to query the SUM(cntr_value) for the previous hour ? (for example, to compare it with Sum of the current hour?) (or any other time period, for that matter?) SELECT cntr_value,* FROM master.sys.dm_os_performance_counters WHERE counter_name='Batch Requests/sec'; Administration - SQL Server 2014 [Replacing Physical Server]( - Hi We are going to update our old SQL physical servers to brand new machines. In the planning in my head stage but need some advice. Thinking I can setup the new hardware with the exact same OS, SQL version, instance name but with a different server name. Then when the new server is setup […] SQL Server 2019 - Administration [Is it best practice to the password for distributor_admin?]( - Hello, Our audit team has decreed that all logins should password policy turned on for all SQL Server logins. They also decreed that the login password needs to be 32 characters. I found the command to change the password: sp_changedistributor_password The question that I have, is this something that is going to break my replication? […] [how to minimize prevent sql injection]( - Hi All, We are having sql injection from website. The login used in the connection having only data reader and execute all SP. We use SP, view and function, no adhoc query. To find we are running server side trace. From that, I have found someone executed SP where this sp do number of items […] [tran log won't grow. i can't understand why.]( - My tran log is set to autogrow, by 256 mb, to unlimited. I fill the log but it doesn't grow. I can grow it manually. Why is it not autogrowing? If it's relevant, it's in a 4 replica AG. This is a test db / issue so we're talking small numbers here, MBs. SQL Server 2019 - Development [SQL Developer]( - ISDATE(OPS_PROJ_FMIS.STATE_OPTION_2) = True Trying evaluate if this OPS_PROJ_FMIS.STATE_OPTION_2 date and keep getting an error How Do I used IsDate Funtions in this?  [Get all StudentIds for each consecutive date]( - I have a table wherein each student submits their assignment. I need to write a query to get all the students who submitted their assignments each day. So from the table shown, StudentId 1 and 2 submitted their assignments on all 3 days. The output should be 1 and 2. Any hint will be helpful. Amazon AWS and other cloud vendors [AWS CDK | Multi-repository serverless project structure]( - Hello, everyone I'm trying to split my huge serverless CDK project into separate repositories/services. Everything is fine except one thing: I don't understand how to deal with shared API Gateway. Those multiple separated services should be exposed via one particular API Gateway. Do I need to separate shared resources to different git repository as well […] General Cloud Computing Questions [Is there a reason to use Cloud SQL rather than BigQuery?]( - I'm studying for the GCP exam and the text made it pretty clear that BigQuery was for large analytics datasets and cloud sql made more sense for small transactional data. But the pricing for BQ just seems insanely lower than cloud sql for smaller data too. I'm working on a personal project that will have […] Reporting Services [Empty Field is causing entire Page to be blank]( - I'm a little new to SSRS and am running into a strange issue. I have a Table tied to a data source. Essentially, it is just a letter with text and two fields from the dataset ([Salutation] and [FullName]). The [Fullname] is a field that defines the Associate for the record and it may be […] [Empty Field is causing entire Page to be blank]( - I'm a little new to SSRS and am running into a strange issue. I have a Table tied to a data source. Essentially, it is just a letter with text and two fields from the dataset ([Salutation] and [FullName]). The [Fullname] is a field that defines the Associate for the record and it may be […] [update the SSRS branding files]( - i'd like to update the SSRS branding files. I was wondering if there is a copy of the default branding files that i could download to use as a back up, just in case anything goes wrong? or how can i download and back up the existing branding files in use? If I just add […] General [Partial dependency]( - A partial dependency occurs when fields are indirectly or partially reliant on the main key but are also dependent on other keys that depend on the primary so that if the field on which another field depends is deleted, that field will still exist owing to its dependence on the primary key. I'm not sure […] Integration Services [Retrieving Active Directory information]( - I have a requirement to process AD information through an SSIS package and have hit a problem with the "objectClass" attribute. The ADO.NET source is configured as: and the package has converted all of the output data types to NTEXT. This isn't an issue for most of them as I've converted them to DT_STR using […]   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -