Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
The Voice of the DBA
 

Flexing for the Cloud

Many of us in technology regularly experiment with new tools and technology. We often do this to adopt new skills when we need to solve a problem or we have inherited some code that needs enhancement. The cloud is in many ways no different than things we've done before, but the way we do them, or maybe the way the cloud handles some things, means that we need to change how we view a task or perform our jobs.

Migrating to the cloud is something that many of us have had to tackle at some point. I've seen a good amount of lift-and-shift, including many companies who just mandated moves to the cloud without much planning. As mentioned in this article, that was cloud migration 1.0. Really, I think this was something that's been going on for years, and continues to occur today. Lots of management are seduced by the promises of the cloud to make their organization's IT systems better, so they move everything without thinking.

Then many run into cloud migration 2.0, or maybe that's coming. I see plenty of customers with things in the cloud they complain about much in the same way they did on-premises. Nothing has changed with regards to how their systems work, and they are likely spending more money on the same services they had on-premises. With the same people. They didn't plan well, didn't provision well, and they haven't changed anything but their costs.

Cloud migration 3.0 is what many tech professionals would like to see. Evaluate apps, decide which benefit from the cloud, and leave the rest alone. Leave them on-premises in a familiar environment. That's hybrid, but that's fine.

What many tech professionals worry about are their jobs, so they don't often consider where the cloud can provide benefits from some apps. The flexibility and scalability are undeniable. You just need to ensure that you understand where the cloud fits, where cloud-native can benefit your org, and then make sensible recommendations.

No matter how your organization approaches the cloud, likely you'll have engineers from the provider or third-party consultants involved. Do what I do with people I've hired: ask a lot of questions. You'll learn something, flex your knowledge, and even if you never work in the cloud yourself, you'll be better prepared to make recommendations and evaluate future choices.

Steve Jones - SSC Editor

Join the debate, and respond to today's editorial on the forums

 
 Featured Contents
SQLServerCentral Article

How Effective Is Your Data Load Monitoring in SQL and Python?

sankul.seth@gmail.com from SQLServerCentral

Learn how you can use monitor your data warehouse load process with Python code and a structured process.

External Article

PostgreSQL Basics: Getting started with psql

Additional Articles from SimpleTalk

PostgreSQL has a separate command-line tool that’s been available for decades and is included with any installation of PostgreSQL. Many long-term PostgreSQL users, developers, and administrators rely on psql to help them quickly connect to databases, examine the schema, and execute SQL queries.

Knowing how to install and use basic psql commands is an essential skill to have for anyone that will connect to PostgreSQL.

Technical Article

GPT Base, GPT-3.5 Turbo & GPT-4: What's the difference?

Additional Articles from PluralSight

A breakdown of OpenAI models, including their strengths, weaknesses, and cost. We also cover lesser-known AI models like Whisper and Embeddings.

From the SQL Server Central Blogs - Introduction to IaC: Deploying Data infrastructure to Azure using Terraform (Part 3 - Azure SQL Database)

epivaral from SQL Guatemala

In Part 1, we explain the basics and prerrequisites to work with Terraform.In Part 2, we created our first Azure resource.On this post we will create an Azure SQL...

From the SQL Server Central Blogs - Introduction to IaC: Deploying Data infrastructure to Azure using Terraform (Part 2 - our first Azure resource)

epivaral from SQL Guatemala

Continuing our Part 1, we already set up our environment, we can now setup our very first example (do not worry if is too simple at this point, but...

Expert Performance Indexing in Azure SQL and SQL Server 2022

Expert Performance Indexing in Azure SQL and SQL Server 2022

Site Owners from SQLServerCentral

Take a deep dive into perhaps the single most important facet of query performance―indexes―and how to best use them. Newly updated for SQL Server 2022 and Azure SQL, this fourth edition includes new guidance and features related to columnstore indexes, improved and consolidated content on Query Store, deeper content around Intelligent Query Processing, and other […]

 

 Question of the Day

Today's question (by Steve Jones - SSC Editor):

 

Opening Multiple Symmetric Keys

Can I open multiple symmetric keys at once? As with this code:
OPEN SYMMETRIC KEY PIIKey DECRYPTION BY PASSWORD =  'MyS3cr#tP@ssword'
OPEN SYMMETRIC KEY PIINewKey DECRYPTION BY PASSWORD =  'MyS3cr#tP@ssword2'

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 Upgraded Stored Procedure

I had a SQL Server 2014 database. In it, I created this function:

CREATE FUNCTION OPENJSON
(@json varchar(1000))
RETURNS TABLE
AS
RETURN
SELECT CASE
         WHEN SUBSTRING (@json, 1, 1) = '{' THEN
           1
         ELSE
           0
       END AS json_string;

This works, and this call:

SELECT * FROM OPENJSON('{ "key":1 }')

Returns this result:

json_string
--------------
1

Now I restore this database on a SQL Server 2019 instance and set the compatibility level to 150. I run this code:

SELECT * FROM OPENJSON('{ "key":1 }')

What happens?

Answer: I set a result with one row and three columns

Explanation: When you change the compat level, the OPENJSON() built in function is activated. This code will return the results from that function, which is 1 row with three columns. Ref:

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
Rebuild index for system database - I do check database integrity for system db,is there need to do system rebuild index if yes what is fragmentation?
shrinking a large data file - Hi All, One of our drive got filled (E: drive) and we decided to shrink the data file from 1.6TB to 500GB. While trying to shrink the file with didnt work. USE [dbname] GO DBCC SHRINKFILE (N'db_name_dat' , 0, TRUNCATEONLY) GO it completed successfully but it didnt release any space to OS. --then, tried below. […]
unable to see job history for some jobs - Hi All, I am unable to see job history for some jobs. Usually, we run some maintenance jobs. for example) index maintenance and updating stats. Why it is not showing up? anything needs to be changed in SQL Agent Properties?   Regards, Sam
Administration - SQL Server 2014
HI need latest service pack or latest cu update in 2014 ,2012 sqlserver - HI need latest service pack or latest cu update in 2014 ,2012 sqlserver Microsoft SQL Server 2014 (SP3-CU4-GDR) (KB4583462) --Need link for latest service pack or CU upadate for this Microsoft SQL Server 2012 (SP4-OD) (KB4091266) -- Need link for  latest service pack or CU update for this  
SQL Server 2019 - Administration
RAM on the SQL Instance - Hi everybody, I have a 500 GB highly transactional database on the SQL 2019 Enterprise instance, running on a Windows Server 2019 box with two Intel Xeon 2.20 GHz processors. All the other databases on the instance are tiny and do not take resources. This is a SQL Server box; nothing else is running on […]
Non-yielding Scheduler every 30 days - I have problem with SQL Server 2019. Of course I have new update 2019.150.4322.2 from August 2023 but problem stil exist. SQL Server 2019 Standard. OS Windows 11 PRO. Machine Dell 7910 2xXeon(R) CPU E5-2695 v4 @ 2.10GHz. Dozen cores. Database size about 1GB (about 20 users). Every month between 26th and 28th without any […]
SQL Server 2019 - Development
Conversion failed when converting the nvarchar value to data type int on insert - I have a table with an Int column.. this is being loaded with a JSON file...containing various values One of this is a numerical value which i have found a bug My code as follows: DROP TABLE IF EXISTS [#ReturnItemsCalibration_Points] CREATE TABLE [#ReturnItemsCalibration_Points]( [ReturnItemsCalibration_PointsID] [int] IDENTITY(1,1) NOT NULL, [ReturnItemsCalibration_ChannelsID] [int] NOT NULL, [Points] [int] NULL […]
SQL Azure - Administration
Azure SQL database: How additional storage (beyond 250GB) being charged? - Hi All, I have a question on how additional storage (beyond 250GB) will be charged for Azure SQL databases. Is it charged based on Max storage limit (MAXSIZE) or is it based on Allocated space? Thanks.
Reporting Services
Tables and Stored Procedure not showing up in while adding the dataset - Hi, I am using VS2022 Reporting Service Project. In that I am using Oracle Datasource. When I am trying to add a new dataset to the project , It is not showing tables and stored procedures in the dropdown. Let me know where is the problem.
Tabs in SSRS Report - Hi, I have 2 tabs created in SSRS Report.There is calendar Day prompt in the report. By Selecting the Calendar Day Prompt the 2nd tab displayed in the report varies from 2nd Page and 3rd page. Is there any option to display the 2nd tab of the Report to display in 3rd page irrespective of […]
SSRS 2019 Custom Authentication: error occurred when invoking the authorization - Hi, I am upgrading SSRS 2014 to 2019 and custom form based authentication is implemented with SSRS 2014. I followed the steps https://github.com/microsoft/Reporting-Services/tree/master/CustomSecuritySample and implemented same for SSRS 2019. While Web Service URL works fine but while accessing Web Portal URL I am getting below error and the web page displays. The service is not available. An […]
SSRS 2016
Migrating SSRS power bi version 15 database to new server - Hello, I seen many articles, one such as this: https://www.mssqltips.com/sqlservertip/2692/migrating-sql-reporting-services-to-a-new-server-by-moving-the-reporting-services-databases/ and its pretty straight forward, backup database, restore, backup keys, restore, and point database to new location... got it... my biggest concern... and worry especially to the user, is the subscriptions... will the subscriptions come over to the new server.. I have about 100+ subscriptions, […]
SQL Server 2022 - Administration
issue with backup cleanup step - I have a maintenance plan for my nightly backups.  It consists of three steps:  Back up my databases to a folder on another server - in this case it's literally just a Windows server with a lot of drive space.  Run DBCC check db against my databases.  Cleanup - delete any backups older than five […]
SQL Server 2022 - Development
User does not have access to reports - Hello, I would like advice on how to allow users to open reports.  So far, we have the home folder (which users cannot view), two sub folders, one of which users can view.  This one contains three reports.  They can see the reports exist but cannot open them.  The users have permission to Browse and […]
SQL2022 UPDATED FROM SQL2014 - PARALLELISM ISSUES - Hi We just updated from SQL2014 to SQL2022. Most everything went fairly well - except I have about 6 stored procs that move allot of data around that are suddenly not working. When looking at whoisactive they are generating CX waits. They stall all day with no results. They ran fine in SQL2014. I enabled […]
 

 

RSS FeedTwitter

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

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -