Cloud computing is growing fast. The leader, Amazon and Microsoft, continue to show more and more customers using their platforms every quarter. I do truly think that an increasing number of organizations are thinking cloud first for application development. That doesn't mean all systems, nor does it mean that they won't opt to bring their code back on premises, but they are considering the cloud.
Will this trend continue? For most of my life, I've seen trends come and go, but the popular ones continue to evolve and grow. I suspect that for now, cloud computing is attractive in many ways, not the least of which is a shift from a large up-front investment to a small pay as you go charge. Lots of finance people would rather see this as a way of investing in computing for their organization, knowing they can cancel and switch their investment elsewhere.
I think clearly the cloud will continue to grow for now, but will companies ever reverse the trend and move things back on premises? I wonder. It does seem that many people try to move to the cloud and struggle with the application changes, the unexpectedly high monthly costs, and the wandering performance levels of their systems. For executives used to knowing what the predictable level of performance was, even if poor, having systems (appear to) run randomly slower or faster can be maddening. I think some of this is the lack of understanding of cloud paradigms and programming practices for many developers as well as poor application architectures. But that's the state of the world, so if systems don't run well, why would you move away from your current data center?
The major cloud providers are providing lots of services and incentives, and certainly they are working hard to sell you computing resources. For some technologies, this makes perfect sense. I'd never set up an email server or system again, relying on a service like GMail or O365. I' not sure I'd even want to host a web server again, expecting that something like App Services is just out there, and I can drop my code in a location and I'll have a running website. And, of course, I love VSTS. If I were a developer starting a company, or a project, I'd consider using something like VSTS or a TeamCity suite with a cloud VCS. I mean, why invest and manage servers? I just want services.
There are issues with cloud computing, and certainly your flexibility can be limited. Security offerings are both better and worse, and pricing can be steep as you scale up. Of course, if you scale down you haven't spent a bunch of money on extra hardware. Overall, I think there are some sweet spots for cloud computing, and even though some workloads don't make sense, I'd expect that it's worth considering the cloud first.
I do expect that some services, such as email, may never come back on premises. I also think some of the skills and tools we use will change, evolve, or disappear. For everyone, I'd suggest you experiment and learn some things about the cloud. Get a free account to experiment with, download emulators, or just watch a lot of presentations and content on the cloud. Whether you have plans to move or feel pressure now, I'm sure you'll have to deal with the cloud at some point in the next ten years, so be prepared.
The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music.
Write, format, and refactor SQL effortlessly with SQL Prompt
Writing SQL is 50% faster with SQL Prompt. Your SQL code can be formatted just the way you like it, you can create and share snippets with your team, and with tab coloring you’ll never deploy to the wrong environment again. Download your free trial
How to track every change to your SQL Server database
See who’s changing your database, alongside affected objects, date, time, and reason for the change with SQL Source Control. Get a full change history in your source control system. Learn more
Redgate are running a survey to better understand trends in adoption of different technologies and platforms. Completing this survey will take just a few minutes, and as a thank you for your time, they will be giving away a $100 Amazon gift card to one randomly selected participant who completes the survey by October 10. More »
If you’ve been following along with the previous 10 Database Fundamentals blog posts, you have a SQL Server installed and... More »
Question of the Day
Today's Question (by Steve Jones):
I have a database with a Database Master Key created in it. How do I back up the key?
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: T-SQL.
We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the
Design and configure SQL Server instances and databases in support of high-throughput applications that are mission-critical and provide consistent response times in the face of variations in user numbers and query volumes. Learn to configure SQL Server and design your databases to support a given instance and workload.
Pick up your copy of this great book today at Amazon today.
Yesterday's Question of the Day
(by Steve Jones):
I have a data set of football players and the total touchdown passes they threw in 2016. My data set looks like this:
> MyQBs[, c("Name", "TD"), drop=FALSE]
1 Drew Brees 37
2 Joe Flacco 20
3 Blake Bortles 23
4 Aaron Rodgers 40
5 Carson Wentz 16
6 Kirk Cousins 25
7 Eli Manning 26
8 Carson Palmer 26
9 Matthew Stafford 24
10 Philip Rivers 33
11 Jameis Winston 28
12 Andy Dalton 18
13 Derek Carr 28
14 Sam Bradford 20
15 Russell Wilson 21
16 Andrew Luck 31
17 Matt Ryan+ 38
18 Cam Newton 19
19 Brock Osweiler 15
20 Ben Roethlisberger 29
21 Alex Smith 15
22 Trevor Siemian 18
23 Dak Prescott 23
24 Marcus Mariota 26
25 Tyrod Taylor 17
26 Tom Brady 28
27 Ryan Fitzpatrick 12
28 Ryan Tannehill 19
29 Colin Kaepernick 16
I plot these values with:
I get an image like this:
How do I add a horizontal line at the median TD value to the plot?
The median value is added to the plot with the abline function. The h lets the plot know this is a horizontal line, with the value equal to the median.
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.