PostgreSQL Springboot Integration Using JDBC Template (2022-06-03)

SQLServerCentral Newsletter for June 3, 2022 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [PostgreSQL Springboot Integration Using JDBC Template]( - [Azure Data Factory Interview Questions and Answers]( - [Advanced Databricks Lakehouse Capabilities]( - [10 Benefits of Database Monitoring for Business Leaders [Video]]( - [From the SQL Server Central Blogs - Two Percent, Five Percent, More?]( - [From the SQL Server Central Blogs - How can I use the identity column, without knowing identity column’s name.]( Question of the Day - [Changing the TDE Encryption]( The Voice of the DBA  Daily Coping Tip Enjoy new music today. Listen to a recommendation from someone else 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 Nightmare Letter This editorial was originally published on Mar 28, 2018. It is being re-published as Steve is at DataGrillen. I'm not sure if this [imaginary GDPR letter]( is a nightmare, but I do know that in most of the organizations where I've worked, this type of request would result in a crash project for me. I'd be working long hours, contacting lots of people and trying to manage a complex spreadsheet of information about an individual. I'd like to think that I'd compile this information in a general sense to understand our data better and anticipate future requests, building a process that I could repeat, but I know that under pressure that might not always happen. I'm sure I'd grab some data without capturing and saving the metadata or query. I'd probably have to perform duplicate work when the next request came in. GDPR enforcement begins in a couple months, and organizations receiving this type of letter will have 30 days to respond. Companies can also charge a reasonable fee based on administrative costs for information requested. The fee that's reasonable for getting a few of these letters a month might not be sufficient if hundreds or thousands of individuals start requesting this information, and I'm sure companies and authorities will be arguing about the rates. With the focus on privacy in the media, and the mishandling of data regularly by companies, I wouldn't be surprised if there are going to be large numbers of requests by individuals. In fact, I'm wouldn't be surprised if there are scripts or applications being built now to facilitate the ability for lots of individuals to ask for this information from companies about their data processing. Really all of this information should be documented and any decisions made about securing sensitive data should always be followed. Any organization should know how they handle data, where it's stored, and how it's secured. This is just practical and good administrative practice. The items about how data is processed and used are good business knowledge points. After all, should we be processing data without some justification for the resources involved? I think too often a company decides to implement some process without evaluating if it makes sense in the context of their mission. If it does, we should know why it does and be able to measure that. If it doesn't, we ought to stop. If you do business in the EU or with EU citizens, you might wish to start ensuring you have a way to export the information requested in this letter. Being prepared for some of these items might make it much easier to respond to any or all of these requests. Whether you think this might happen to your organization or not, you might want to just save a copy of this letter. I know I will, with the idea that I might send this off to companies that store my data. Knowledge can help me protect myself by being aware of what's being done with information related to me. If there are issues, having this information might help ensure my rights are protected. I'll also be sure that I have a form letter to ask for removal of information. I've felt this wasn't possible in the past, but at least in the EU, where I regularly travel, I can exert some control over my data. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [PostgreSQL Springboot Integration Using JDBC Template]( Shivayan Mukherjee from SQLServerCentral Learn how you can use Springboot to automatically make data changes for a new database in an application. [SQLServerCentral Article]( [Azure Data Factory Interview Questions and Answers]( Randheer from SQLServerCentral Get a few common questions and possible answers about Azure Data Factory that you may encounter in an interview. [External Article]( [Advanced Databricks Lakehouse Capabilities]( Additional Articles from MSSQLTips.com Learn about several different aspects of Databricks Lakehouse such as encryption, row level security, visually viewing query plans, SQL merge, change data capture and more. [External Article]( [10 Benefits of Database Monitoring for Business Leaders [Video]]( Additional Articles from Redgate A third-party database monitoring tool is an investment that drives enormous value for the bottom line of your business in ten key ways. Here's how a tool like Redgate SQL Monitor can save you money, time and assist with security and compliance concerns. [Blog Post]( From the SQL Server Central Blogs - [Two Percent, Five Percent, More?]( K. Brian Kelley from Databases – Infrastructure – Security I was reading Seth Godin today and he makes this claim: If 2% of a population takes coordinated action, it makes a difference. If 5% do, it can change... [Blog Post]( From the SQL Server Central Blogs - [How can I use the identity column, without knowing identity column’s name.]( Kenneth.Fisher from SQLStudies One of the most fun parts of blogging is when you learn something completely unexpected while writing a blog. The ... Continue reading   Question of the Day Today's question (by Steve Jones - SSC Editor):  Changing the TDE Encryption I have a SQL Server 2019 database protected with TDE. I want to change the algorithm used by the DEK from TRIPLE_DES_3KEY to AES_256. How can I do this easily? 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) Dirty Pages What is a dirty page? Answer: A page of data in memory that has been changed in some way and has not been written back to disk Explanation: When a page is read from disk and changed (insert, update, or delete), then it is considered dirty. The log record for this transaction must be written to disk before this page is removed from the buffer cache. A dirty page may be a part of a committed transaction. Ref: Writing pages - [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 [Migrating Always On cluster to new Domain and cluster]( - We are in the process of migrating to new Windows AD. What would be the best approach for this with minimal down time?  Essentially we have several databases in AG on different nodes and a single listener name. The idea is to move to new Windows AD/new servers and retain the listener name. Normally if […] SQL Server 2017 - Development [Rules based updates]( - I found an article that is very similar to how I would like to apply business rules to update my table. I will have 4 colname values I would like to use: Channel,ShipFrom,ProdLine,CustType Channel -- Will be only 2 values ShipFrom - Could be single entry, or ALL, or ALL except(xx,xx,xx) Prodline -- All(*), or […] [Missing abstrophe in dynamic SQL]( - Hello , I haven't been able since morning to find how to add the missing abstrophe in my procedure that uses dynamic SQL I added a print in my script to display the exec instruction and I have a missing apstrophe in the name of the proc Anyone have an idea please? USE [test] GO […] SQL Server 2016 - Administration ['Alert- Sev17 Error:Fatal error in resource limit exceed occurred' on server]( - Hello! I have setup SQL Audit and it is writing to the Security log in the Event viewer. It is working but getting this error message below few times a day. "SQL Server Audit could not write in security log". What can be done to resolve this alert?  Thanks.  [SQL Audit in Always On Availability Group]( - Hello! I have setup SQL Audit in Always on Availability group (2 node) for ddl and dml to write to Event viewer. I have configured on both nodes using the same GUID. It writes to Event viewer in the Primary node (1) or when I fail primary and  and make secondary primary, it works. But, […] SQL Server 2016 - Development and T-SQL [Filetred index]( - \hello Guys,  Mayyou help wuth the corect index filetred creation using modulo?  The query need to assist is select col1,col2,......... WHERE ISRECNUM % 20 = 1 and i wish to create a filtered index on ISRECNUM column which is INT   like WHERE ISRECNUM % 20 = 1  . Thanks, Best Regards, […] [Disabling backup Jobs]( - I've not done a lot with disabling jobs with script, I need to read the job names from a text a disable them or enable them on all servers within the environment? Is there any good examples for doing this? [Rows won't return using where with one of the columns]( - Select * from tablea where comt_dim_id = 3947804 -- returns no rows Select count(1) from tablea where comt_dim_id = 3947804 -- returns count = 32  Why? How?  There are no current locks in the database. The column datatype = INT. Selecting these 32 rows based on a different column value works and shows the comt_dim_id […] SQL Server 2019 - Administration [PBALP User in SQL Server]( - Hi Everyone, Currently looking at tidying up some SQL servers and i have a number of local users (PBALP) being one of them i would like to drop. Is there a way i can check to see what if anything is dependant on that user?   [Hi everyone!]( - I'm Johnson, and I've just joined these forums. I was looking on Google for SQL Server Forums and found forums.sqlservercentral.com. I just wanted to say hello to everyone to start. Once I feel like I belong, I will talk more on the forum. @SQL Server Forums Munchkin Cats [Monitor SQL Server Job Failures]( - Ahoi, i am usually working with SSIS and SSAS, but since there is no one else i am also "in charge" if adminsitration it seems. We have multiple SQL Servers + Instances. Now i am looking for a good/central way to monitor Job failures across the entire scope of servers/instances. Since the guy who was […] [Notify with backup file name]( - Hello, I have the tlog bkp job that runs in every 5 mins. There is another monitoring job which checks if the tlog backup job runs for more than 30 mins and if yes, it should notify the same to dba via agent alerts (notifying via email). Unable to find a method to notify the […] SQL Server 2019 - Development [DateDiff - Data Type conversion Issues]( - Hi Experts Not able to do DATEDIFF between two dates, but it works when these dates are part of ( a.ClosingDate, calc.maxDate ) CTE and in select I use DATEDIFF , My result is taking forever so I was trying to get rid of CTE so I encounter this issue. Any help please. I attempted […] Integration Services [Data Collection from restful web call]( - First off. Sorry for formatting - on a mobile device. —————— So a little back sorry - I know almost nothing about this topic, so forgive me if I use a phrase out of turn. I’m looking at being able to pull data from a training platform and dumping it into my local database so […] Anything that is NOT about SQL! [Building a front end for a database]( - Hello everyone! I'm a beginner with databases and I'm getting started with building a front end for my database so that end users can add/edit data. I've been trying to find information about this online but I guess I'm not searching the right words because I can't seem to get a hit. I'd really appreciate […]   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -