SQLServerCentral - www.sqlservercentral.com

A community of more than 1,600,000 database professionals and growing

Featured Contents

The Voice of the DBA

A View of the Cloud

Amazon has been an amazing digital company in the last twenty years. I remember making my first order from them, unsure of whether the online bookstore would work better than browsing locally, or if I'd even get my books. I watched them transform into a great shipping company that could sell anything, to a digital reading company with the Kindle, and even an amazing cloud hosting provider with world class programming platforms. At each stage, Amazon has grown to become even more efficient and seductive, slowly gaining more of my business over the years.

Whether you like the business model and practices of Amazon or not, part of the reason Amazon has become a successful company is that they have an incredible software development process and great developers, both of which have produced a software stack that is very impressive. Apart from their web site, which is impressive, they host their Amazon Web Services, which is a dizzying array of services that can be purchased by anyone, at any time, and get some software up and running quickly. Even if you look at their free tier, it's very impressive in the number and type of services, including database access.

I ran across a piece on the 10 year anniversary of AWS that contains some software development lessons from Werner Vogels, CTO of Amazon. It's a good list, and while some might not apply to your particular environment in the same way, it's a good list of principles to follow. Certainly planning to evolve and to handle failures is something that most of us need to consider. Including security from the ground up, however, is one thing that many of us know, but don't have good patterns, practices, or habits to follow. Even those companies that work in security conscious areas often leave security concerns until they are well into, or even finished, with their core software development.

The one area that I think is going to become more important for all of us in the future is understanding resource usage. Certainly we've needed to know some baselines and expected growth in the past to plan for upgrades and future needs. However, with the move to VMs and cloud services, how many of us really know what resource usage we would require for peak workloads and when. I suspect most people don't really know how to map their instance resource usage across different virtual systems, much less evaluate whether their system would be cost effective in a cloud scenario. A better understanding of what resources we really use is something that more and more organizations are going to expect from their technical professionals. I only hope we get some tools to help us here as this is a complex topic.

The move to cloud services is going to happen for many of us. We might not move all our data, or even much of it, but as we experiment with new platforms, as companies work to avoid capital expenditures, and as the platforms and services mature, more of us will end up with some cloud platform in a portion of our organization. During your journey, or even while you still work with on-premise systems, I'd keep the principles in Mr. Vogels' article in mind. They'll help you to build better software in the future.

Steve Jones from SQLServerCentral.com

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


The Voice of the DBA Podcast

Listen to the MP3 Audio ( 4.9MB) podcast or subscribe to the feed at iTunes and Libsyn. feed

The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music.

ADVERTISEMENT
Database DevOps

State of Database DevOps Report

Learn how teams are extending DevOps practices to SQL Server databases. Get the report.

Featured Contents

 

Create and Connect to an Azure SQL Database

Thomas Liddle from SQLServerCentral.com

Demonstration on how to create and connect to a Microsoft Azure SQL Database with Microsoft Management Studio (SSMS) and Powershell More »


 

Estimated Number of Rows to be Read

Additional Articles from SQLPerformance.com

Rob Farley uses this month's T-SQL Tuesday to show off the results of one of his Connect items : Estimated Number of Rows to be Read. More »


 

From the SQLServerCentral Blogs - DBA 101: Altering a column

Daniel Janik from SQLServerCentral Blogs

People always ask me what tools I use. Mostly this question comes from the topic of monitoring. I can honestly... More »


 

From the SQLServerCentral Blogs - GitLab for SQL Server Projects

The Database Avenger from SQLServerCentral Blogs

This is the seventh part in the series: SQL Server and Continuous Integration. This post demonstrates the use of GitLab to build... More »

Question of the Day

Today's Question (by Steve Jones):

What permissions are included when someone is granted the BULKADMIN server role?

Think you know the answer? Click here, and find out if you are right.


We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: BULKADMIN.

We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center.

ADVERTISEMENT

Pro Power BI Desktop

This book shows how to deliver eye-catching Business Intelligence with Microsoft Power BI Desktop. You can now take data from virtually any source and use it to produce stunning dashboards and compelling reports that will seize your audience’s attention. Slice and dice the data with remarkable ease then add metrics and KPIs to project the insights that create your competitive advantage.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

What improvement in SQL Server 2016 allows for better Always On encryption of the log stream?

Answer: If the hardware supports AES_NI encryption, the instance uses it.

Explanation:

If the hardware supports AES-NI, the SQL Server instance will automatically use this for when sending encrypted log data to the secondaries.

Ref: SQL 2016 – It Just Runs Faster – AlwaysOn AES-NI Encryption - https://blogs.msdn.microsoft.com/psssql/2016/05/05/sql-2016-it-just-runs-faster-alwayson-aes-ni-encryption/


» 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 : SQL Server 2016 - Administration

Failover Cluster - Better option - Hi, We've 2 instances we want to cluster with FCI (without Always ON). There are 4 servers available to carry out...


SQL Server 2016 : SQL Server 2016 - Development and T-SQL

Select List from xml - I have xml like this : DECLARE @x XML = '<revieves> <recievemessages>   <message>test</message>   <to>111111</to>   <froms>   <from>123</from>   <from>546</from>   </froms> </rec

Newbie Help - SQL Query - Hi all, I am in desperate need of some help please.  I'm not a SQL expert but am trying to write...

1 Tb is How many rows in a databse - How many rows does a database contain in 1TeraByte?


SQL Server 2014 : Administration - SQL Server 2014

MSDB Corruption - My msdb database went into suspect mode. How can i find the root cause of the issue?

Sync Prod to Non-Prod - Our Production sits in a very strict environment and different subnet from Non-Prod environment and is in a different subnet....

TDE after restoring to a Different Instance - Hi Experts, I have a TDE enabled database and i successfully restored it to another instance of SQL after restoring the...


SQL Server 2014 : Development - SQL Server 2014

Need to determine number of days between dates - getting strange return - I'm trying to develop a purchasing calendar. I have a starting date that is static and a number of cycle days...


SQL Server 2008 : SQL Server 2008 - General

DBCC CheckDB vs DBCC CheckFileGroup - Hi All, We have some circa 5TB databases that take an age to run DBCC CHECKDB against.  Quite often we get...

Truncating transaction logs - I have a MS SQL 2008 database, remote hosted. Recently the host upgraded the server platform and the new CP...


Data Warehousing : Integration Services

SQL Server Agent: Deploying a job mid-execution - Effects - Hello all, I have one specific question, but please feel free to include as much related information as desired! The main...


Database Design : Design Ideas and Questions

Just an observation: It seems odd that foreign keys cannot be references to unconstrained superkeys...* - "Academic" description first, then a specific example. Given two tables, A and B, where... * k is defined as the primary key...


SQL Server 2005 : Administering

LCK_M_IX waittype is found in SQL SERVER - Hi Experts, What is the reason for the LCK_M_IX wait type.. Actually what this waittype refers too..What is the solution for...

This email has been sent to newsletter@newslettercollector.com. 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.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.
This transmission is ©2015 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com