| A community of more than 1,600,000 database professionals and growing |
| | 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.comJoin 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. 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 | | 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 |
|
|
|
| | | 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 » |
| 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 » |
| 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 » |
| 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 » |
| 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 » |
|
|
| | 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. |
|
|
| |
ADVERTISEMENT | 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: barplot(MyQBs$TD) 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)) Explanation: 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. 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... 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... 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... 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... 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... 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... 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... Mortgage amortization table - *** EDIT 2015-03-04: please be advised the code I posted originally below was in need of some improvement, and Solomon... 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... 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 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... 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 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 ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. Contact: webmaster@sqlservercentral.com |
|
|