Running SQL Server on Oracle and Google Cloud (2022-02-18)

SQLServerCentral Newsletter for February 18, 2022 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Running SQL Server on Oracle and Google Cloud]( - [Learn Python Complex Built-in Data Types including List, Tuple, Range, Dictionary and Set]( - [ICYMI: What's behind the explosive growth in data?]( - [From the SQL Server Central Blogs - Who do you contact before an upgrade? : T-SQL Tuesday #147]( - [From the SQL Server Central Blogs - A Hard Drive Retrospective – SQL Server Edition]( Question of the Day - [Managed Instance Backups]( The Voice of the DBA  Daily Coping Tip Support a local business with a positive review or friendly message 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. An Active Job Search I caught this in a [Brent Ozar newsletter](. It's [a post from Alice Goldfuss noting she's on the market for hiring](. Not that she's looking for a job, but rather, saying she's willing to talk to you if you want to hire her. Bold, but she's quite a talent that many organizations might want. I don't know that many of us could post something and have companies come find you, but I did like the list of items she lays out for a hiring conversation. These are the types of questions that you might keep handy, or even as notes, for your next interview. I've often had a series of questions like this that I use when I go into an interview for a job. I've learned that I need to be curious and careful if I want a successful position for both me and the company. Both of us are trying to put our best foot forward, sometimes stretching the positives and minimizing the downsides. That means that both sides can be surprised later by how the relationship actually proceeds. Many of us proceed from job to job, often taking the first offer we get whenever we need a job. That usually occurs because we need to make money and cover bills. The timing of job interviews and offers usually means that we can't often consider two at once. Sometimes we can, but it's been rare for me. My view has been that the best time to find a new job is when you have a job. If you are unhappy, or you feel that you want a better position/challenge/compensation/etc., then look for alternatives. If for no other reason, you should know how your current job compares to others. It's easy to get complacent and not realize that the world of employment has changed dramatically. At the same time, I also ask you to actively think about the things that you like and don't like about your job. Think about what you really want from employment. It could be the compensation, the hours, the challenge, the colleagues, the benefits, or anything else. Make a real list, and then assign some weights to these factors and decide what is important to you. I actually like the [Thymometrics]( that Redgate uses to track employee satisfaction, and I take the data I've entered and use that to evaluate my own satisfaction with employment. I do this every year, making an evaluation of my own position and then making a conscious decision to stay. I've [written about the service](, and I love it. For 14 years I've made the decision to stay in my position, usually because I don't find other positions offering a better balance of the things important to me. I could make more money, but I'd have to change other things, and I haven't found the overall value from alternatives to be worth me making a move. I hope you can say the same, but in order to do that, make sure you are actively thinking about what you want from employment, evaluating your current environment, and then actively managing your career in the way the direction that matters to you. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [Running SQL Server on Oracle and Google Cloud]( Arun Yadav from SQLServerCentral In this article, we will analyze the various out-of-the-box deployment options Oracle Cloud Infrastructure and Google Cloud Platform offers to host a Microsoft SQL Server database. This information can prove to be handy while deciding on the best cloud provider to host a given application or database. [External Article]( [Learn Python Complex Built-in Data Types including List, Tuple, Range, Dictionary and Set]( Additional Articles from MSSQLTips.com In this article we present complex built-in data types in Python along with several examples of how to use complex data types. [External Article]( [ICYMI: What's behind the explosive growth in data?]( Additional Articles from Redgate In case you missed it: IDC’s recent Global DataSphere Forecast, 2021-2025, predicts that global data creation and replication will experience a compound annual growth rate (CAGR) of 23% over the forecast period. But what’s causing the growth? Where will all of that extra data be stored? And how should we, as data professionals, prepare for it? [Blog Post]( From the SQL Server Central Blogs - [Who do you contact before an upgrade? : T-SQL Tuesday #147]( Kenneth.Fisher from SQLStudies I haven’t been blogging as much recently as I’d like and I’m trying to get back into it. One excellent ... Continue reading [Blog Post]( From the SQL Server Central Blogs - [A Hard Drive Retrospective – SQL Server Edition]( sqlrider from Sqlrider - Speed enthusiast Sometimes it’s good to look back and appreciate what we have and how far we’ve come. This applies to many things, but today I’m talking about the humble hard...   Question of the Day Today's question (by Steve Jones - SSC Editor):  Managed Instance Backups What type of backups can be made on an Azure SQL Database Managed Instance? 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) Log File Architecture Pages and Extents are used to store data in data files, with rows being stored on the pages. For a log file, how many log records in SQL Server fit on a page? Answer: The log file doesn't use pages. Explanation: The log file doesn't use pages. Log information is just stored in log records. These are strung together in the log file. Ref: - SQL Server Transaction Log Architecture and Management Guide - - Pages and Extents Architecture Guide - [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 2016 - Administration [Communication link failure but only once per week]( - Hello experts, I'm helping to troubleshoot an issue where the following error happens on an AOAG cluster, which disconnects applications from the database: SQL State: [08S01] SQL Error: [[Microsoft][ODBC Driver 13 for SQL Server]Communication link failure] I have seen various posts while Googling this error. The thing is, as far as the customer can tell […] SQL 2012 - General [Noob SQLServer 2012 Question]( - Let me preface this with I am a sysadmin working on an SCOM 2016 install and have a question regarding an error message that keeps getting thrown via application event logs. An exception occurred while enqueueing a message in the target queue. Error: 15404, State: 19. Could not obtain information about Windows NT group/user 'DOMAIN\ACCESSACCOUNT', […] SQL Server 2012 - T-SQL [Show only once repeated value in result a set]( - Hello Everyone, Here again I came with a question. Below is my query for a report that I want. It's working fine with no issues. SELECT TP.Location, TE.Name, TEI.imp_amount_approved_by_finance AS Amount, CONVERT(DATE, TEI.imp_fin_appr_date, 103) AS PaidDate FROM tbl_emp_imprest TEI JOIN tbl_Projects TP ON TP.Sno = TEI.imp_emp_location JOIN tbl_Employee TE ON TE.Sno = TEI.imp_id WHERE imp_amount_approved_by_finance […] SQL Server 2019 - Administration [Need to extract all queries used across all packages]( - A developer is asking me to provide a list of all the "queries" (aka sqlcommand) as it is in the tables there.  He is asking for ALL of the queries from ALL of the packages... Is there an extract I can run against the SSISDB to render this list of queries?  (the developer was pulling […] SQL Server 2019 - Development [Beginner Query SQL]( - I have a 120gig database. I want to analyse it with Power BI. (It's way to Large) This is data from a machine at a sampling rate of 0.5 sec. To do my analysis, 1 min to 15 min sampling rate would be ok. How can I make a query to do this? Or what’s […] [How to handle rolling back changes if there is an error?]( - Hi everyone I have two stored procedures that update two tables. If one of the updates fails then I don't want either of the two stored procedures to run. If one was run then it needs to be rolled back. What is the best way to accomplish this? Should I handle that in the stored […] [Print Statements]( - Hi I am creating SSIS pacakges to automate data collection. I want to print out statements to the console. I tried below but they are not working. Nothing shows up in the output window in Visual Studio 2019.  How exactly do I get them to work? System.Diagnostics.Debug.WriteLine("debug"); Console.WriteLine("console"); Thank you [extract columns from a string column]( - I would like to extract a street address to separate columns. For example, I have street fake data only these two patterns, I want to separate them to different columns. all the street name has one word house number, one word streetname, one word street type, and some of them has an apartment number, that […] [Compare 2 rows in the same table and output result when conditions are met]( - I am newbie to SQL, tried searching for answers for similar question but couldn't find any. Sorry, if this type of question was asked before. I have a temp table as below: Drop TABLE if EXISTS #temp Create table #temp(ID int, Country VARCHAR(40), ItemCount int, DeliveryDate Date, Itemtype VARCHAR(40) ) insert #temp(id,Country,itemCount,DeliveryDate,Itemtype) Select 3012111,'Dublin', 100, […] [Compare 2 rows in the same table and output result when conditions are met]( - I am newbie to SQL, tried searching for answers for similar question but couldn't find any. Sorry, if this type of question was asked before. I have a temp table as below: Drop TABLE if EXISTS #temp Create table #temp(ID int, Country VARCHAR(40), ItemCount int, DeliveryDate Date, Itemtype VARCHAR(40) ) insert #temp(id,Country,itemCount,DeliveryDate,Itemtype) Select 3012111,'Dublin', 100, […] [Bulk Insert C# Code Error]( - I figured out the issue. Please ignore post. T-SQL (SS2K8) [running OPENROWSET from sql function with parameter]( - Following function works if the parameter to harcoded as shown below. But i would like to replace the value with parameter. PO12345 - should be replaced by @IpRef. I am not able to figure out how to do that. --select * from dbo.ki_GetSupplyUsage ('PO12345') alter FUNCTION ki_GetSupplyUsage(@IpRef VARCHAR(100)) RETURNS TABLE AS return SELECT * FROM […] General Cloud Computing Questions [What's your opinion about Google Cloud SQL?]( - Hii I wonder what your opinion about Google Cloud SQL is! We are a small company running our MySQL server on one of our vServer and everything runs fine. But we have a few concerns about our project in the future: Backups - we did not implement them yet and I don't want to keep […] General [Python Pattern best practice]( - Ahoi, anyone can tell me if there is a pattern/best practice to handle this type of request handling? I am trying to handle the execution of functions by name. I found a pattern for classes using a dicitionary but i couldnt make it work like this. What i have i have made work is […] Integration Services [Issue with Execute SQL Task in Sequence container returning 0 results]( - I'm working on a package to update some local tables from a datalake we access. I've been able to write individual incremental update packages for each table. The general flow of the package is "Get Now" (UTC) - Get Max Modified Utc from local table, get list of changed ids from source table where modified […]   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -