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

Daily Coping Tip

Thank yourself for achieving things you often take for granted

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.

Going Cloud Native

I am constantly surprised at the migration of workloads to the cloud. It seems that many of the customers and clients that I speak with are moving some of their assets to the cloud. Some are moving the majority of their systems, and they are pushing to do this sooner than later, including database assets.

I ran across an article that noted that while many companies love the on-demand provisioning of cloud resources, they don't always get improvement in their software performance. In fact, quite a few might experience worse performance, though often not horribly worse. Instead, what they often get is a bit more unpredictable performance, and sometimes a bigger bill, which makes perfect sense. After all, the cloud is really just someone else's computer, and the one you're using might have other people doing the same thing.

To truly embrace the cloud and get the power of the cloud, you do need to consider being cloud-native, which is often a change in how your software is architected. It is also a change in your entire software lifecycle, meaning not just buying DevOps tools or renaming a team, but also embracing the entire way that DevOps works. Not just fast releases, but experimentation, learning, adapting,  testing, and changing how you build and release software. This is also changing how you manage the teams that build software.

If you think this is just for the Netflixes and Spotifys of the world, that's not true. Stripe and Capital One are financial companies completely in the cloud. There are plenty of other examples as well, and the successful ones, in all industries, are embracing a new way of building and operating software. Docusign has had a lot of success, and quite a bit with a lift-and-shift to IaaS resources as they continue to build and rebuild their software to embrace the cloud and adopt more PaaS services. They didn't move systems and expect everything to just get better. They started a journey that they continue to travel every week. The move is a journey, not a quick move, another item that the article points out and many managers forget.

That being said, not everyone is moving their systems to the cloud. Even organizations that adopt some cloud services, implementing Salesforce as a CRM, might continue to run plenty of systems on-premises. Lots of companies use the cloud for IaaS, but with the architectures and software that used to run in their own data centers. They just moved their  VMs.

The cloud can be successful in many ways, but you need to understand how you adopt the technology, what capabilities can help, and how limitations can hinder your software. There is no magic bullet, but there are a lot of opportunities if your organization takes advantage of them.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

Migrate the SSIS Catalog in Just a Few Clicks

Kunal Rathi from SQLServerCentral

This wizard migrates SSIS Catalog from one server to another in just a few clicks.

External Article

Troy Hunt talks Security and compliance in estate monitoring

Additional Articles from Redgate

Troy Hunt joins Steve Jones to discuss the critical and complex role of monitoring in organizational data security and compliance.

External Article

How to Enable and Disable Full Text Search for SQL Server Databases

Additional Articles from MSSQLTips.com

Learn how to enable or disable full text search for a specific database on a SQL Server instance where the Full Text Search components have been setup.

Blog Post

From the SQL Server Central Blogs - Azure Purview is generally available

James Serra from James Serra's Blog

After a very long public preview (9 months), Azure Purview is finally generally available (GA). I described Purview in a previous blog (New Microsoft data governance product: Azure Purview)....

Blog Post

From the SQL Server Central Blogs - Using SQL Data Compare with Joins

Steve Jones - SSC Editor from The Voice of the DBA

Recently a customer was asking about how they could move data with SQL Data Compare from one server to another. In this case, the customer had a complex join...

 

 Question of the Day

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

 

Change Tracking Default Retention

I turn on change tracking for a database with this code in SQL Server 2019:
ALTER DATABASE Sales
SET CHANGE_TRACKING = ON
What is the default retention period for changes?

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)

Third Party VDI Backup

I am using a third party backup utility that creates backup files from the VDI interface. I install this utility as a sysadmin and it adds extended stored procedures to SQL Server. I then change the software to use a lower privileged login that has db_backupoperator set in each database.

Will the backups run successfully?

Answer: no for all databases

Explanation: This will not work. The VDI interface is a privileged connection, and therefore any utilities that use this require sysadmin privileges. Ref: SQL Server VDI backup and restore operations require Sysadmin privileges - https://support.microsoft.com/en-us/topic/sql-server-vdi-backup-and-restore-operations-require-sysadmin-privileges-4797c4bc-ed60-8f1b-7978-8ee1cc701eab

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
Event log filling up with Sql error - Windows event log filling up with ERROR 1 : "The activated proc '[dbo].[SqlQueryNotificationStoredProcedure-]' running on queue 'test.dbo.SqlQueryNotificationService-' output the following: 'Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission.'" And Error 2: An exception occurred while enqueueing a […]
Informatica -SQL Error - We get a sql connection from host informatica server and the query runs in sql for almost 50 minutes and fails. We see the below information from informatica logs shared. We dont see any resource utilization or error logged in sql at this time frame. Any suggestion on what could be the reason. Waiting for […]
SQL Server 2016 - Administration
SSRS Zero-Day patching? - Hello all, I've been tasked (rather randomly) with finding out if there is somewhere we can specifically find any Microsoft zero-day patches that would need to be applied to SSRS servers.  Mind you, I don't handle patching of any kind for our servers, so I'm at a bit of a loss as to where I […]
Development - SQL Server 2014
Last Successful Completion Date for SQL Job - I am trying to write a query to get a list of all SQL Jobs that have failed.  The part I am having an issue with is getting the "Last Successful Date" the SQL Job completed without errors.  It seems what I am getting is the last "successful step", not the last time the entire […]
SQL 2012 - General
How to remove data and index fragmentation in a table - The picture is showing the results that I used sp_spaceused for OldTable and NewTable, I used "select into NewTable from OldTable", and created the same indexes on newtable with the OldTable, as per the data of the picture, the OldTable taking more space than the NewTable, so seems that the OldTable has many many fragmentation […]
Database Recovery but DB is 7GB and log file is almost 3 - I have had a server crash and although I was able to recover the disks and the contents, the SQL database isn't working when I drop the files into the DATA folder and Attach to them. The database immediately goes into Recovery Mode. I tried all the usual commands to get the database up and […]
SQL Server 2019 - Administration
Splitting table into multiple tables - I have a requirement where we have a table of 1 billion rows, which is causing some performance issues. so we decided to split the table into multiple tables this is the table structure, there are no primary keys, constraints. There is just one clustered columnstore index name(varchar)  date(smalldatetime)  category(varchar) A          […]
AlwaysON on one Node - Hi friends, Is it possible to configure ALwaysON with two instances on one node ?One of them to be Read-Write and other to be Read-Only. Any document reference link as steps would be great.Newbie on AlwaysON.Thank you in advance. Thanks and Regards   Arshad
SQL Server Single Instance FCI - Failover Error - I have the following setup. 3 Node WSFC Cluster hosted on EC2 in three different Subnet Installed Single Node SQL Server FCI on all of the three Server But When I try to move one of the Role from one node to another it gives me the following error: It will be great if someone […]
SQL Server 2019 - Development
CREATING TRIGGER THAT INSERT DATA WHEN A PARTICULAR COLUMN OF A TABLE IS UPDATED - Hello, I am looking for a way whereby a trigger will be created ONLY when a particular column of a table is updated. Take for instance, I have a table with about 5 columns including start column. I want a situation whenever start is updated(from false to true ), some data will be inserted in […]
How to do Join - Hello, I am looking for output where EG_RequestID = 175998968 and Reissue from paymentID = 333333 from above both temp table. I will get multiple reissue payment ID, Can you please help me to write query ?
SQL Azure - Administration
Housekeeping of SQL Azure DB's - Hi all, I have a question for you, as some move into the cloud and on Prem SQL databases become SQL Azure DB's I wonder what housekeeping jobs are required in SQL Azure DB's (by that I mean single db's, elastic pools and serverless - NOT Managed Instances or VM's running SQL in Azure. With […]
Disk Latency in SQL MI - For SQL Managed Instance, disk latency for Reads and Writes, when I query through ssms is very high for the user databases (latency is >300ms). I've been using below query to get the disk latency for Onpremise and SQL MI databases. The Query works fine for Onpremise, but on MI it is showing up high […]
Reporting Services
Disabling all access to the server - Hello everyone! We have a small group of users (4) using MS Access 2000 to run queries on our MS SQL 2000 SP3 server. When specific queries are run, a deadlock is created, disabling all access to the server. We narrowed it down to these specific queries. We've tried setting the queries to "Record Locks: […]
SQL Server 2005 Integration Services
Can't upload all files from the S3 bucket - Hi all, I have a package that uploaded files from S3 bucket. Currently I need to add two another files. All previous files started with the phrase FA. The files that I need to add started from the phrase FARAN. And contain the name of the country in the format "Country_" or "_Counrty". The S3 […]
 

 

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

 

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