SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

The Voice of the DBA

The Avalanche of Cloud Computing

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.

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 ( 5.0MB) 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.

SQL Prompt

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

SQL Source Control

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

Featured Contents


SQL Server 2016 SSIS Basics - Install SQL Server Data Tools

nivek-224024 nivek-224024 from SQLServerCentral.com

Step-by-step instructions for downloading and installing SQL Server Data Tools (SSDT) for SQL Server 2016. More »


Purging Old Database Mail Items

Additional Articles from Database Journal

Are you purging the old database mail items stored in msdb? In this tip, Greg Larsen shows you how to purge database mail. More »


Use SQL Server? Redgate would like to hear from you

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 »


From the SQLServerCentral Blogs - Running for the PASS Board of Directors #PASSelections

CYates from SQLServerCentral Blogs

This year I decided to take “someday” to heart and do something that has been on my mind for awhile... More »


From the SQLServerCentral Blogs - Database Fundamentals #11: Why Learn T-SQL

Grant Fritchey from SQLServerCentral Blogs

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 Contribution Center.


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

Yesterday's Question (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]
                 Name TD
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?

Answer: abline(h=median(MyQBs$TD))


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.

Ref: abline = click here

» 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

Do I have to use an AlwaysOn listener if using asynch mode - Hi all I am setting up an AlwaysOn AG in asynch mode to create a DR replica for an existing Production...

Partitioning Data on First Character - Evening Guys, Let's say I have a table with a couple of billion rows of data. That I want to partition....

Best way to keep users/logins/mappings syncrhronized in HAG between primary and secondary replicas? - We recently had a network issue and the availability groups failed over from the primary to the secondary.  The next...

Scripting out schema permissions - Hi all Help please!   Why does it seem so complicated to script out schema permissions in SQL? I've got various scripts...

SQL Server 2016 on Windows Server 2016 Core - Error Accessing Configuration Manager - Hi, Background: Windows Server 2016 Core SQL Server 2016 Enterprise (obviously 64-bit) Windows Failover Cluster SQL Failover Cluster I am attempting to connect to SQL Server...

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

Challenge: Insert a specific number of rows based on an integer column in one query! - I am creating promo codes. They are issued simply by inserting a record for the customer into the PromoCode table....

.bat file fails in SSIS - I have created a Execute Process task that runs a .bat file. This bat file creates a very small .txt...

Assign group identifer to records with Cursor - Hi, Can you please help with this? I have a table called HelpDesk with two fields(RowID and Name), And, I am...

SQL Server 2014 : Administration - SQL Server 2014

AlwaysOn Secondary backup (Full & Log) - Primary T-Log not shrinking - Hi All, We recently changed to AlwaysOn, running SQL Server 2012, 2014 and 2016 clusters in AlwaysOn config. Our backups are running...

SQL Server 2014 : Development - SQL Server 2014

How to encrypt Credit Card numbers? - We have now finally moved all our customers to SQL 2014 from old or very old SQL versions and I...

SQL Server 2012 : SQL 2012 - General

disk space after deleting records. - I was running out of space so I ended up deleting some records from one of the biggest table I...

SQL Server 2012 : SQL Server 2012 - T-SQL

Return parents for children with certain condition - Ok, so here is my sample data I am testing against... declare @t table (   Id  int ,   Section int,   DateOccured DATE,     Missed int ); insert into...

SQL error - Hi friends, I get the below error from this sql select (serno * 100) /  (100 - bargain) from yachtm Msg 8134, Level 16, State...

SQL Server 2008 : SQL Server 2008 - General

HIERARCHYID DataType and Referential Integrity - Hi all, I had assumed this would have been an easily answered question, but after quite a bit of searching, I was...

view time out - I am having a view on mutiple tables across 4 databases, and one of the table is having 6 million...

SQL Server 2008 : T-SQL (SS2K8)

Mortgage amortization table - *** EDIT 2015-03-04: please be advised the code I posted originally below was in need of some improvement, and Solomon...

Database Design : Design Ideas and Questions

Column Arrangement - Hello, I would like to understand about column arrangement in multi table relationship as mentioned below 1. Job Planning Header 2. Job Planning...

SQLServerCentral.com : SQLServerCentral.com Website Issues

A user you are following, "...", has posted new content: but I'm not following this user - Today I received an email A user you are following, "...", has posted new content:but I'm not following this user "Thom A", has...

SQL Server 2005 : Administering

SQL Server Agent stopping automatically in SQL Server 2016 Cluster - Hi Team, i have windows 2012 R2 cluster set up node1 and node2, on that i have installed SQL 2012 instances...

Microsoft Access : Microsoft Access

best practices for Access to SQl conversion - One our network we have an Access front end and back end.  The front end contains the queries, forms and...

This email has been sent to {user_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.
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 ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com