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

Cloud Migration Challenges

Like many of the trends in technology, I've been skeptical of the movement to the cloud. Quite a few people that I have discussed this with across the last five years have had concerns, and real challenges with latency, performance, and cost. The cloud hasn't always been cheaper, with more than a few people having larger bills than expected.

Across the last couple years, the trend seems to be changing, which is certainly reflected in the growing revenue Azure, AWS, and other providers are reporting in their annual reports. More and more companies are finding the cloud valuable, and the cost to be acceptable. While the cost still might appear to be larger than on premises, the lack of commitment and the change from capital expenditures to operating costs seems to be worth the move.

Moving to the cloud, however, takes some work. Certainly your applications might need to change, but as compliance becomes a bigger concern for organizations, there is some good advice in this piece about secure cloud migrations. I think understanding your current security and how this can be improved or adapted to a cloud vendor's architecture is important. Far too many people think about security after infrastructure is in place, which often results in poor security.

This is one place I think the cloud can be more secure. Since the vendors don't want issues between their customers, and certainly try to avoid issues on their own networks, the cloud platforms inherently ask for more security as you provision and deploy systems. Certainly there are companies that just open up all networking to get systems to work, and I hope this is the minority. Anyone moving applications to the cloud should configure secure networking, and limit access between resources wherever possible. Just like we don't want applications using "sa" to log in, we don't want every machine able to access every other machine. We certainly don't want every user or application able to connect to every other one.

I do think the cloud plays a part in the future of most organizations. Not all, but most, with any type of workload and application you may have. The performance continues to improve with new offerings, as well as the flexibility. The costs rise and fall, but the ability to scale up and down can make this option very attractive. DR is superior to what most of us can build on-premises, certainly in any short period of time, and there are sufficient security options that work very well for almost all of us. The challenge for most of us, and our organizations, is learning to implement them correctly.

Steve Jones - SSC Editor

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

Redgate SQL Provision
 
 Featured Contents

SQL Agent in Level 5 of the Stairway of SQL Server on Linux

Danilo Dominici from SQLServerCentral

In this level of the Stairway to SQL Server on Linux, we learn how to set up and use SQL Agent.

Data privacy. Don’t look forward. Look back.

Additional Articles from Redgate

With all the talk about new data privacy legislation, we don’t stop to think about existing laws. Legislation like the GDPR kick-started the way the world views data privacy, and this blog post explores how existing laws are being used in new ways around the globe to enforce similar protection.

What are Columnstore Indexes?

Additional Articles from SimpleTalk

Microsoft continues to enhance the performance of SQL Server with new features. In this article, Monica Rathbun explains how to work with columnstore indexes, a different way to store tables that can drastically improve the performance of specific workloads.

From the SQL Server Central Blogs - Azure Service Logging in the Modern Data Warehouse

Rolf Tesmer (Mr. Fox SQL) from Mr. Fox SQL

[read this post on Mr. Fox SQL blog] The “modern data platform” architecture is becoming more and more popular as organisations shift towards identifying, collecting and centralising their data...

From the SQL Server Central Blogs - Short circuiting an AND

Kenneth.Fisher from SQLStudies

The other day I did a post on how an OR short circuts. It was a somewhat unusual type of ... Continue reading

 

 Question of the Day

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

 

The Executable Synonym

I run this code:
USE sandbox
GO
CREATE OR ALTER PROCEDURE dbo.GetDB
AS
BEGIN
    SELECT DB_NAME()
END
This sets up a proc in my database. when I run this, I get "sandbox" as a result. Now I run this code:
USE CIDemo
GO
CREATE SYNONYM dbo.MyDB FOR sandbox.dbo.GetDB
GO
EXEC dbo.MyDB
What is returned?

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)

SQL Server Container Editions

I want to run a Docker container of SQL Server 2017. I know I can to specify an edition as a parameter. The main editions of SQL Server 2017 are:

  • Evaluation
  • Developer
  • Express
  • Web
  • Standard
  • Enterprise

What can I specify for the MSSQL_PID environment variable?

Answer: Any of the above values or you can put a product key in place of the edition

Explanation: Any of these are valid values for the variable, but developer can not be used in production. A product key can be used in place of the edition name. Ref:  Configure SQL Server settings with environment variables on Linux - https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-configure-environment-variables?view=sql-server-2017

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
Suspend-ClusterNode -Drain && move-clusterGroup - Hello everyone , if I proceed to do a suspended from the main node of my cluster Suspend-ClusterNode -Drain Are all resources automatically transferred to the second node or I have to do Move-ClusterGroup thanks
File Integrity Monitoring system and Database Server - Looking to find if it is a feasible idea to install FIM system on a SQL Server. It is a sensitive and highly transnational system and I dont feel comfortable.   For people who do not know what FIM is please read the below link.   https://en.wikipedia.org/wiki/File_integrity_monitoring     It may end up messing stuff. […]
SQL Server 2017 - Development
Data quality improvement - Hi I am exploring ideas of improving data quality in new organisation i joined. The issue is it is not straight forward as to re-write things and improve as there are 100s of dataset we process every weeks. I checked few tables for basic checks and found about 40 tables with duplicates. They are actual […]
SQL Server 2016 - Administration
Stored procedure getting results from views that are joining several tables - Hi, We have a stored procedure  which is executing during a batch job and it is taking 7 seconds to complete and that batch job runs hours to complete. And I'm seeing this procedure called continuously during the batch job and each RPC:completed is taking 7 seconds and returing same rows Started troubleshooting this procedure […]
Resulted of SP_Monitor with Packet Erros. - Detected which were sent or received by SQL Server since the SQL Server last started. The number is high. I remember that the number 4 errors by month it´s normal, but in this case  show me 90...123. What can I do to solve this problem, please.
From SSMS, how to see the deleted records in output window - Hi I'm deleting rows from a table and I want to see them in output window. But I'm just getting like  (2834 row(s) affected). How to see the actual records it is deleted? Is this possible from SSMS?
SQL Server 2016 - Development and T-SQL
trying to get all data to line up - Hello, first, thank you all who helped or took the time to look at my last issue, but now i got 1 more, and its a tough this time for me so my 2 tables are: declare @Employees TAble ( employeeID int, employeename varchar(256), Hoursworked decimal(18,2), PayrollDate date ) insert into @Employees(employeeID,employeename,Hoursworked,PayrollDate) values(1,'bob',3.0,'05/01/2019') insert […]
SQL 2012 - General
Deny Permissions to Schema Owner (assign read only) and deny to Linked Servers - We are running SQL Server 2012 SP4 EE on Windows Server 2008 R2 Standard. We had a developer who moved to another department. We would like to give the developer 'read only' access to the database before eventually disabling his account. We added the developer to the db_datareader database role. I want to make sure […]
data file .mdf datetime stamp on windows file system when running DBCC CheckDB - I'm trying to find out what causes the timestamp to change on the data file when running DBCC CheckDB.  I have confirmed that auto grow, auto shrink, open, close or a restart did not occur. What exactly would DBCC CheckDB be doing that it would need to change the date timestamp on the data file?
T-SQL (SS2K8)
Convert Rows into Columns - Hello All, I'm trying to convert rows in table to columns as per the example i.e create one long string of data for every occurrence of ID column. Could anyone please help in achieving it in best way. /** Build up a Table to work with. **/ DECLARE @T TABLE ( ID INT NOT NULL […]
Convert Rows into Columns - Hello All, I'm trying to convert rows in table to columns as per the example i.e create one long string of data for every occurrence of ID column. Could anyone please help in achieving it in best way. /** Build up a Table to work with. **/ DECLARE @T TABLE ( ID INT NOT NULL […]
Reporting Services
Grouping - Hi, I'm trying to create a report (using a Dynamics 365 Fetch) of all completed bookings grouped by week number, day and account.  So far, I've got this: What I want is to group by week number, day name and account so that you expand the week number to reveal a list of accounts with […]
SSRS 2012
SSRS 2012 converting Data field - How do you convert a Data field that is feet to miles on a expression. For instance the name of the field is PipeLen.value
Analysis Services
I have a query mdx that where it doesn't filter - I can't find the reason because a query that has in 'with member' an attribute of a dimensio that is key does not filter with where, if I put another attribute that is not key if it works ?. Dimension FE6 FE6 is key (int) FE6b (int) Descripción (character)   WITH SET [FILAS] AS EXCEPT([FE6].[FE6].[FE6].members, […]
Article Discussions by Author
Making Good Use of SQL Server Auditing - Comments posted to this topic are about the item Making Good Use of SQL Server Auditing.
 

 

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

 

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