未加星标

T-SQL Tuesday #89 : Roll with the Changes

字体大小 | |
[数据库(mssql) 所属分类 数据库(mssql) | 发布者 店小二04 | 时间 2017 | 作者 红领巾 ] 0人收藏点击收藏

T-SQL Tuesday #89 : Roll with the Changes

So if you're tired of the same old story

Oh, turn some pages

I will be here when you are ready

To roll with the changes

No, this post isn't about REO Speedwagon . Koen Verbeeck ( @Ko_Ver |blog

) is hosting this month's T-SQL Tuesday, where he asks if we feel threatened by advances in our industry I picked the cloud from his examples as the one most likely to resonate with others.

Let me be absolutely blunt about this:

The cloud doesn't scare me.

To start, the cloud isn't for everyone . Plenty of businesses across plenty of verticals, and in plenty of countries have all kinds of restrictions that prevent them from moving their SQL Server estates into someone else's data centers. While more companies are gradually starting to dip their toes into the cloud, this isn't happening overnight; for a substantial portion of the market, it might never happen at all.

I am less a DBA than I was 10 years ago, and to be honest even for the folks that are hardcore DBAs today, and whose employers have bought into the cloud the cloud isn't taking your jobs. I think the biggest parts of instance management that the cloud absolves you from have been gradually moving away from you already, starting years before the first time you heard the "Azure" brand. Storage shifted to SANs, clustering was handled by windows admins, virtualization has its own set of experts, and even backups and patching were often taken off your hands (not always for the better).

There is still plenty to do. If your business thinks it can make you redundant by moving your databases to the cloud, it has another thing coming. You don't just fire up an Azure SQL Database and then look for something else to do. You still need capacity planning. You still need to deal with complex applications that span more than a single database, or the work required to consolidate those. You still need to handle design choices, application interfaces (e.g. stored procedures), index maintenance, query tuning, performance troubleshooting, and yes, even backups .

Yes, some of your options for high availability and disaster recovery have changed, and your response to performance issues will change as well. But don't be afraid of this. I've barely touched the surface here, but if the cloud makes you nervous, I do urge you to read Kendra Little's post . Embrace it, study it, and be prepared… the worst that could happen is that you might not need those skills yourself, in which case you can still use them to help others.

本文数据库(mssql)相关术语:熊片数据库 mssql数据库 oracle数据库 pubmed数据库 access数据库 万方数据库

主题: SQLWindowsSQL Server
tags: cloud,your,still,SQL
分页:12
转载请注明
本文标题:T-SQL Tuesday #89 : Roll with the Changes
本站链接:http://www.codesec.net/view/558569.html
分享请点击:


1.凡CodeSecTeam转载的文章,均出自其它媒体或其他官网介绍,目的在于传递更多的信息,并不代表本站赞同其观点和其真实性负责;
2.转载的文章仅代表原创作者观点,与本站无关。其原创性以及文中陈述文字和内容未经本站证实,本站对该文以及其中全部或者部分内容、文字的真实性、完整性、及时性,不作出任何保证或承若;
3.如本站转载稿涉及版权等问题,请作者及时联系本站,我们会及时处理。
登录后可拥有收藏文章、关注作者等权限...
技术大类 技术大类 | 数据库(mssql) | 评论(0) | 阅读(97)