some of the benefits of ITIL as a basis is that it has created a standard language throughout groups, via organising both simple terminology and the techniques they define. It additionally provides tips companies can use to assess themselves against (do you meet/exceed the top of the line practices being described) or from which they can create improvement classes.
The basis can also lengthen beyond the ITIL framework itself. In a contemporary security Operations assignment, I compared the tips safety management approaches against frameworks designed primarily for security Operations, finding that the basis provided by using ITIL became adequate to be mindful, consider and work with individuals in an adjoining business, drawing on abilities won via ITIL.
with the aid of providing a base from which IT gurus can operate, it gives us the way to talk with one one more and permits consultants like myself to go into a shopper firm and speak about premier practice with out spending a lot of time constructing a thesaurus or realizing of what service management entails.2. How has ITIL made a change for your organization, or agencies you have got worked with?
ITIL made a tremendous difference in my closing position as a direct contributor. i was the ITIL champion for the greatest automobile dealership neighborhood in the US. in spite of the fact that we were the largest, organizationally we had been fairly younger. Adopting the ITIL v2 framework made an incredible change in our system and repair availability in a brief duration of time, at first through decreasing the incidence of repetitive issues and also through chopping down the affects of imposing adjustments to the atmosphere. Our preliminary efforts all started during Y2K remediation and via 2004 we had reached the bounds of what the framework offered on the time and started cobbling collectively some building and satisfactory assurance procedures to create a robust operations framework, which turned into practically what we now see in ITIL v3 and 2011. All new or significantly modified capabilities had been presented by way of our PMO and assessed strategically, then fully designed and vetted before they had been constructed, then becoming a member of the transition/operations pieces of the framework.
Our first 12 months after adopting ITIL the savings had been calculated via Alan Nance, working with our CIO, and totaled approximately $465K. reductions in downtime persevered to be significant and the use/maturation of the framework enabled us to begin centralizing field aid, including an additional $2M in discount rates to the total.three. How critical is ITIL nowadays and the way do you consider it enhances different frameworks?
I agree with the framework is still vital today and that it complements other frameworks. The challenge I see besides the fact that children, is that practitioners in lots of companies don’t be mindful the complete lifecycle and that adoption commonly ends at carrier Operation and repair Transition with a bit CSI. Many corporations not ever really undertake the company-dealing with aspects of the framework after which flow onto the latest/finest framework to remedy the issues ITIL certainly not helped them with. The problem is not the framework, it’s mastering the entire lifecycle and performing the organizational alternate administration crucial to be triumphant.
I feel an outreach program is required to help americans see that there's greater than a foundational level of realizing essential and that in the event you cease practising after one or two intermediate classes, you’re no longer definitely getting informed within the complete framework. because of this, when adopting most effective to that stage, you’ll see some incremental merits in system and repair availability, but will never see the level of enterprise alignment and strategic engagement that come from realizing and adopting the entire framework.
extra to the aspect, using automation more effectively to carry ITIL tactics greater correctly starts to allow organizations to have the people work more strategically. This creates the time we need to really step lower back and begin enticing the enterprise, taking them along for the ride, as opposed to pretending they don’t exist and doing ITIL for ITIL’s sake, which is loads of what I see in organizations nowadays.
See our more than meets the I web page for extra suggestions.
examine Phyllis Drucker's previous AXELOS blog publish, ITIL® Misconceptions: “ITIL doesn’t require any formal practicing, it is simply usual sense or a tool so as to fix it all”.extra posts in our greater than meets the I collection
greater than meets the I: How ITIL makes a change in Mergers and Acquisitions endeavor
HOUSTON--(business WIRE)--BMC application (NASDAQ:BMC) proven its IT management management by way of taking part in the newest alterations to the IT Infrastructure Library® (ITIL), which is being showcased this week at itSMF Fusion 2011 in Washington, D.C.
Anthony Orr, director with BMC’s workplace of the CTO and member of the ITIL® authoring group, performed a big role in developing the latest ITIL requisites. Orr is the simple writer of “The Introduction to the ITIL® service Lifecycle,” one of the most books on the new adjustments.
“Between the changes going on within the global business environment and people happening inside IT, reminiscent of cloud computing and specifically SaaS, PaaS and IaaS adoption, ITIL standards have under no circumstances been greater vital to ensuring it is excessive-performing and conscious of customer wants,” referred to Orr. “agencies that do not embody ITIL ideas will probably discover that assignment initiatives for provider agility, corresponding to cloud computing, should be larger possibility endeavors and miss the possibility to leverage and extend their latest service management practices.”
ITIL is the most generally adopted approach for IT provider administration (ITSM) and offers a realistic framework for deciding on, planning, offering and helping IT functions to the enterprise. Amidst probably the most impulsively changing technology and company environment, the refinements in ITIL supply stability and a point of reference for IT to respond to demands placed on expertise to tackle superior enterprise needs. BMC’s enterprise service administration (BSM) method offers the greatest strategic management platform for leveraging tips present in all releases of ITIL, which is evidenced by means of the company’s lengthy history of ITIL-compliant items.
“ITIL initiatives need to be justified with certain ambitions linked to organizational strategic priorities and enterprise price,” spoke of Tapati Bandopadhyay, predominant research analyst at Gartner. “the usage of a strategy map, the initiatives can also be planned and managed in an effective and effective manner, thereby enabling IT operations to leverage ITIL to continuously increase the IT capabilities in terms of first-class and enterprise alignment.”
among the key adjustments in ITIL 2011 is a vital clarification involving the differing nature of company and IT method and the role that method plays in assisting the business. BMC’s purchasers have recommended this clarification to improve IT’s function as a key enabler of enterprise innovation.
for example, in carrier operation, the price of incident pattern cognizance and matching for positive difficulty management and determination shows how software options, such because the BMC treatment IT service management Suite, can underpin and automate lots of the brand new ITIL assistance.
The emerging challenges within the manage and optimization of cloud computing environments also get hold of new center of attention in the ITIL 2011 replace. BMC’s approach and assisting solutions for the lifecycle administration of cloud environments enable consumers to unlock the benefits of cloud technology, whereas enjoying the peace of intellect afforded throughout the computerized enforcement of ITIL-aligned most effective practice.
business Runs on IT. IT Runs on BMC application.
business flourishes when IT runs smarter, quicker and more advantageous. That’s why probably the most worrying IT corporations on the earth rely on BMC application throughout dispensed, mainframe, digital and cloud environments. recognized because the chief in enterprise provider administration, BMC presents a complete approach and unified platform that helps IT groups reduce charge, cut back possibility and power company earnings. For the 4 fiscal quarters ended June 30, 2011, BMC income became about $2.1 billion. seek advice from www.bmc.com for more suggestions.
BMC, BMC utility, and the BMC software emblem are the exclusive properties of BMC application Inc., are registered with the U.S. Patent and Trademark workplace, and might be registered or pending registration in different nations. All other BMC trademarks, provider marks, and logos may well be registered or pending registration in the U.S. or in other countries. All different emblems or registered trademarks are the property of their respective owners. © Copyright 2011 BMC software, Inc.
ITIL® is a Registered trade Mark of the workplace of executive Commerce in the uk and other countries.
IT Infrastructure Library® is a registered trademark of the office of executive Commerce and is used right here by means of BMC application, Inc., below license from and with the permission of OGC.
This yr corporation Sprintzeal declares party of its 5th anniversary in Chicago As a be counted of remarkable delight to share the success a milestone, which indeed is an extra usual accomplishment and resolution for lasting success of a company that has labored effortlessly providing the surest among international functions to its purchasers. Sprintzeal has embraced an outstanding value equipment in in the hunt for high aspirations, and obtain greater than what you will ever idea changed into possible.
Sprintzeal a corporate practising provider is a world classification practicing center for gurus it is a company that gives training and Certification assistance with conviction. In trendy dynamic world of studying, education or office stressful for speedy pace in accordance with rising applied sciences. usual, formal and scheduled practising methods have given strategy to extra informal and on demand forms of gaining knowledge of, At Sprintzeal, we help with the capabilities to hastily reply to these new demands for flexibility in strategies. World classification practising Institute not handiest focal point on providing you with top-quality offers on lessons like PMP, SSGB, SSBB, Scrum grasp, ITIL basis. but also guides a artful direction in attaining a fine profession.
continual training or learning upgrading talents assist businesses dwell at the reducing-edge of altering work fashion. considering the fact that its initiation in 2011 until Date, Sprintzeal has proven itself as a leading expert corporate working towards and consulting provider company. delivering superb value on innovation, functional method to gaining knowledge of.
Sprintzeal has a world classification experienced trainers who has most advantageous records in assuring one hundred% flow assure on their expertise they deliver, and present practising courses at terrific pleasant locations with clever actions and interesting classes.
The founding father of enterprise is impassioned young entrepreneurs, who are motivated by means of the need to fill a spot in the IT practising industry for authorities international. To stay enlightened with the ever altering technologies in researching industry. Our industry focus on to dwell abreast with the ever altering applied sciences within the industry, also to support continued authorities improve among aspiring IT managers and executives particular person. Sprintzeal strives to make it ease for every corporation to enroll with us on presents and a variety of approved practising programs.
Sprintzeal is a long options associate to businesses looking for consulting or practicing functions to boost group of workers performance and power company success.As include call for a social gathering of 5 years of uninterrupted carrier to the community, we take this possibility to Thank all of you for assisting us attain our milestone and reside linked for the a long time upfront of success and to ask you to join us in a get together of this accomplishment and get advantage of excellent offers.
when you are searching up for practicing lessons for PMP, Scrum grasp, ITIL basis and moreThen here's a right time to enroll for practicing as Sprintzeal is making a gift Apple ipad as a complimentary for enrolling among the classes. To seize the offerYou can register your self click on on link bellow:
Contact particulars - +1 - 315 675 7776
email - email@example.com
web page - https://www.sprintzeal.com/
as soon as once again, thanks for helping us make the previous 5 years so a success. We seem to be ahead to greet you as our particular guest.
This merchandise become posted via a community contributor. To read extra about community contributors, click on here.
Whilst it is very hard task to choose reliable exam questions / answers resources regarding review, reputation and validity because people get ripoff due to choosing incorrect service. Killexams. com make it certain to provide its clients far better to their resources with respect to exam dumps update and validity. Most of other peoples ripoff report complaint clients come to us for the brain dumps and pass their exams enjoyably and easily. We never compromise on our review, reputation and quality because killexams review, killexams reputation and killexams client self confidence is important to all of us. Specially we manage killexams.com review, killexams.com reputation, killexams.com ripoff report complaint, killexams.com trust, killexams.com validity, killexams.com report and killexams.com scam. If perhaps you see any bogus report posted by our competitor with the name killexams ripoff report complaint internet, killexams.com ripoff report, killexams.com scam, killexams.com complaint or something like this, just keep in mind that there are always bad people damaging reputation of good services due to their benefits. There are a large number of satisfied customers that pass their exams using killexams.com brain dumps, killexams PDF questions, killexams practice questions, killexams exam simulator. Visit Killexams.com, our test questions and sample brain dumps, our exam simulator and you will definitely know that killexams.com is the best brain dumps site.
Killexams 650-665 braindump | Killexams HP2-896 Q&A | Killexams 1Y0-A06 test prep | Killexams 1Z0-874 practical test | Killexams 000-891 exam dumps | Killexams 000-904 practice questions | Killexams 642-996 real questions | Killexams LOT-912 test questions | Killexams 000-421 brain dump | Killexams MAT past exams | Killexams 190-822 sample test | Killexams FN0-100 exam questions | Killexams COG-702 practice questions | Killexams 000-M233 real test | Killexams 000-034 sample questions | Killexams HP0-656 Practice Test | Killexams EX0-105 | Killexams 000-153 | Killexams HP0-698 | Killexams SABE201 |
Ensure your success with this PC0-001 question bank
killexams.com PEOPLECERT Certification contemplate guides are setup by IT experts. Bunches of understudies have been whining that there are an excessive number of questions in such a significant number of training exams and study aid, and they are recently worn out to manage the cost of any more. Seeing killexams.com specialists work out this far reaching rendition while still assurance that all the learning is secured after profound research and examination.
Is it true that you are searching for PEOPLECERT PC0-001 Dumps containing real exams questions and answers for the ITIL 2011 Foundation Exam prep? killexams.com is here to give you one most refreshed and quality wellspring of PC0-001 Dumps that is http://Killexams.com/pass4sure/exam-detail/PC0-001. We have aggregated a database of PC0-001 Dumps questions from real exams with a specific end goal to give you a chance to get ready and pass PC0-001 exam on the principal endeavor.
Killexams.com Huge Discount Coupons and Promo Codes are as under;
WC2017 : 60% Discount Coupon for all exams on website
PROF17 : 10% Discount Coupon for Orders greater than $69
DEAL17 : 15% Discount Coupon for Orders greater than $99
DECSPECIAL : 10% Special Discount Coupon for All Orders
In the event that would you say you are befuddled how to pass your PEOPLECERT PC0-001 Exam? With the assistance of the confirmed killexams.com PEOPLECERT PC0-001 Testing Engine you will figure out how to build your abilities. Most of the understudies begin making sense of when they discover that they need to show up in IT accreditation. Our cerebrum dumps are thorough and to the point. The PEOPLECERT PC0-001 PDF documents make your vision immense and help you a ton in readiness of the confirmation exam.
killexams.com top rate PC0-001 Exam Testing Tool is extremely encouraging for our clients for the exam readiness. Immensely vital highlights, points and definitions are featured in mind dumps pdf. Social occasion the information in one place is a genuine help and causes you get ready for the IT accreditation exam inside a brief timeframe traverse. The PC0-001 confirmation offers key focuses. The killexams.com pass4sure dumps retains the essential highlights or ideas of the PC0-001 affirmation
At killexams.com, we give completely surveyed PEOPLECERT PC0-001 preparing assets which are the best to clear PC0-001 test, and to get affirmed by PEOPLECERT. It is a best decision to quicken your vocation as an expert in the Information Technology industry. We are pleased with our notoriety of helping individuals clear the PC0-001 test in their first endeavors. Our prosperity rates in the previous two years have been completely great, because of our upbeat clients who are currently ready to impel their vocations in the fast track. killexams.com is the main decision among IT experts, particularly the ones who are hoping to move up the progression levels quicker in their individual associations. PEOPLECERT is the business pioneer in data innovation, and getting affirmed by them is an ensured approach to prevail with IT vocations. We enable you to do precisely that with our superb PEOPLECERT PC0-001 preparing materials.
PEOPLECERT PC0-001 is ubiquitous all around the globe, and the business and programming arrangements gave by them are being grasped by every one of the organizations. They have helped in driving a large number of organizations on the beyond any doubt shot way of achievement. Far reaching learning of PEOPLECERT items are viewed as a critical capability, and the experts confirmed by them are exceptionally esteemed in all associations.
We give genuine PC0-001 pdf exam inquiries and answers braindumps in two arrangements. Download PDF and Practice Tests. Pass PEOPLECERT PC0-001 book Exam rapidly and effectively. The PC0-001 syllabus PDF sort is accessible for perusing and printing. You can print increasingly and rehearse ordinarily. Our pass rate is high to 98.9% and the comparability rate between our PC0-001 syllabus think about guide and genuine exam is 90% in light of our seven-year teaching background. Do you need accomplishments in the PC0-001 exam in only one attempt? I am right now examining for the PEOPLECERT PC0-001 syllabus exam.
Cause the only thing that is in any way important here is passing the PEOPLECERT PC0-001 exam. Cause all that you require is a high score of PEOPLECERT PC0-001 exam. The just a single thing you have to do is downloading Examcollection PC0-001 exam consider directs now. We won't let you down with our unconditional promise. The experts likewise keep pace with the most up and coming exam so as to give the greater part of refreshed materials. One year free access to have the capacity to them through the date of purchase. Each applicant may bear the cost of the PEOPLECERT exam dumps through killexams.com at a low cost. Frequently there is a markdown for anybody all.
Within the sight of the genuine exam substance of the mind dumps at killexams.com you can without much of a stretch build up your specialty. For the IT experts, it is essential to improve their abilities as indicated by their vocation necessity. We make it simple for our clients to bring affirmation exam with the assistance of killexams.com confirmed and genuine exam material. For a splendid future in its realm, our mind dumps are the best choice.
A best dumps composing is an imperative component that makes it simple for you to take PEOPLECERT accreditations. Be that as it may, PEOPLECERT braindumps PDF offers accommodation for applicants. The IT affirmation is a significant troublesome undertaking in the event that one doesn't discover legitimate direction as true asset material. Consequently, we have real and refreshed substance for the planning of confirmation exam.
It is essential to assemble to the guide material on the off chance that one needs toward spare time. As you require bunches of time to search for refreshed and true investigation material for taking the IT accreditation exam. In the event that you find that at one place, what could be superior to this? It's just killexams.com that has what you require. You can spare time and avoid bother on the off chance that you purchase Adobe IT accreditation from our site.
You ought to get the most refreshed PEOPLECERT PC0-001 Braindumps with the right answers, which are set up by killexams.com experts, enabling the possibility to get a handle on learning about their PC0-001 confirmation course in the greatest, you won't discover PC0-001 results of such quality anyplace in the market. Our PEOPLECERT PC0-001 Practice Dumps are given to applicants at performing 100% in their exam. Our PEOPLECERT PC0-001 test dumps are most recent in the market, allowing you to get ready for your PC0-001 exam in the correct way.
Killexams.com Huge Discount Coupons and Promo Codes are as under;
WC2017 : 60% Discount Coupon for all exams on website
PROF17 : 10% Discount Coupon for Orders greater than $69
DEAL17 : 15% Discount Coupon for Orders greater than $99
DECSPECIAL : 10% Special Discount Coupon for All Orders
In the event that you are occupied with effectively finishing the PEOPLECERT PC0-001 Certification to begin procuring? killexams.com has driving edge created PEOPLECERT exam addresses that will guarantee you pass this PC0-001 exam! killexams.com conveys you the most exact, present and most recent refreshed PC0-001 Certification exam questions and accessible with a 100% unconditional promise guarantee. There are many organizations that give PC0-001 mind dumps yet those are not precise and most recent ones. Arrangement with killexams.com PC0-001 new inquiries is a most ideal approach to pass this affirmation exam in simple way.
Killexams EADA10 Q&A | Killexams C9520-928 braindump | Killexams P2090-739 past exams | Killexams P3OF practical test | Killexams NS0-154 brain dump | Killexams M2020-620 practice questions | Killexams 1Z0-450 test prep | Killexams 250-314 exam dumps | Killexams 000-M234 practice questions | Killexams 000-017 test questions | Killexams HP0-J52 exam questions | Killexams 190-840 Practice Test | Killexams HP0-065 sample questions | Killexams NS0-141 real test | Killexams HP0-553 sample test | Killexams 310-101 real questions | Killexams HP2-H22 | Killexams MOS-OXP | Killexams 1Z0-068 | Killexams 70-473 |
I feel very assured with the aid of getting ready PC0-001 real take a look at questions.
I passed the PC0-001 exam today and scored 100%! Never thought I could do it, but killexams.com turned out to be a gem in exam preparation. I had a good feeling about it as it seemed to cover all topics, and there have been lots of questions provided. Yet, I didnt expect to see all the same questions in the actual exam. Very pleasant surprise, and I highly recommend using Killexams.
How a great deal does it price PC0-001 qustions bank with real dumps
thanks to killexams.com group who gives very treasured practice question bank with factors. i have cleared PC0-001 examination with 73.five% score. Thank U very a whole lot for your offerings. i have subcribed to numerous question banks of killexams.com like PC0-001. The query banks have been very helpful for me to clear those exams. Your mock checks helped loads in clearing my PC0-001 examination with 73.five%. To the factor, particular and well defined answers. preserve up the good work.
I want to clear PC0-001 examination, What should I do?
I wanted to have certification in take a look at PC0-001 and i am getting it with killexams. best sample of new modules facilitate me to try all the 38 questions inside the given time frame. I rating extra than 87. I need to say that I may want to in no way ever have achieved it on my own what i was able to achieve with killexams.com Q&A. killexams.com Q&A provide the present day module of questions and cowl the associated topics. thanks to killexams.com Q&A.
Can I find braindumps Q & A of PC0-001 exam?
Never ever thought of passing the PC0-001 exam answering all questions correctly. Hats off to you killexams. I wouldnt have achieved this success without the help of your question and answer. It helped me grasp the concepts and I could answer even the unknown questions. It is the genuine customized material which met my necessity during preparation. Found 90 percent questions common to the guide and answered them quickly to save time for the unknown questions and it worked. Thank you killexams.
Just These PC0-001 Latest dumps and study guide is required to pass the test.
Its concise solutions helped me to accomplish top marks noting all questions below the stipulated time in PC0-001. Being an IT master, my competencies with respect are so forth need to be precise. now not withstanding, proceeding with a standard employment with giant obligations, it changed into no longer easy for me to take a stable making plans. At that point, i discovered out approximately the usually organized question and solution aide of killexams.com dumps.
These PC0-001 Questions/Answers provide good knowledge of topics.
A rating of 86% turned into beyond my desire noting all of the inquiries inside due time I got around ninety% inquiries practically equal to the killexams.com dumps. My readiness become maximum notably awful with the complex topics i used to be looking down some solid easy substances for the examination PC0-001. I commenced perusing the Dumps and killexams.com repaired my troubles.
Belive me or no longer! This resource of PC0-001 questions is actual.
i was approximately to surrender examination PC0-001 because I wasnt confident in whether or not i might pass or no longer. With just a week final I decided to switch to killexams.com QA for my examination coaching. by no means conceptthat the subjects that I had always run far from could be so much fun to study; its clean and brief manner of getting to the factors made my guidance lot simpler. All thanks to killexams.com QA, I by no means notion i'd bypass my exam howeverI did bypass with flying colors.
I found a very good source of PC0-001 material.
It clarified the subjects in a rearranged manner. In the true exam, I scored a 81% without much hardship, finishing the PC0-001 exam in 75 minutes I additionally read a great deal of fascinating books and it served to pass well. My achievement in the exam was the commitment of the killexams.com dumps. I could without much of a stretch finish its decently arranged substance inside 2 week time. Much obliged to you.
These PC0-001 Questions/Answers provide good knowledge of topics.
A few good men cant bring an alteration to the worlds way but they can only tell you whether you have been the only guy who knew how to do this and I want to be known in this world and make my own mark and I have been so lame my whole way but I know now that I wanted to get a pass in my PC0-001 and this could make me famous maybe and yes I am short of glory but passing my A+ exams with killexams.com was my morning and night glory.
Dont forget to try these braindumps questions for PC0-001 examination.
Failure to lie in those meaning that it was those very moments that we couldnt learn to forget but now we all know that whether or not there was some cause to the little thing that we couldnt not see just yet those stuff that we werent supposed to know so now you must know that I cleared my PC0-001 test and it was better than anything and yes I did with Killexams.com and it wasnt such a bad thing at all to study online for a change and not sulk at home with my books.
Killexams 920-245 real questions | Killexams PGCES-02 exam dumps | Killexams 3000-3 past exams | Killexams HP0-J26 practice questions | Killexams A2040-407 test prep | Killexams 1Y0-371 brain dump | Killexams 000-355 test questions | Killexams S10-201 braindump | Killexams JK0-802 practice questions | Killexams HP0-Y16 real test | Killexams C2040-409 sample questions | Killexams EADA10 practical test | Killexams E10-110 Q&A | Killexams 1Z0-238 exam questions | Killexams C9560-507 Practice Test | Killexams 650-621 sample test | Killexams 250-401 | Killexams 00M-246 | Killexams C2140-135 | Killexams CQE |
3COM [8 Certification Exam(s) ]
AccessData [1 Certification Exam(s) ]
ACFE [1 Certification Exam(s) ]
ACI [3 Certification Exam(s) ]
Acme-Packet [1 Certification Exam(s) ]
ACSM [4 Certification Exam(s) ]
ACT [1 Certification Exam(s) ]
Administrat [1 Certification Exam(s) ]
Admission-Tests [12 Certification Exam(s) ]
ADOBE [90 Certification Exam(s) ]
AFP [1 Certification Exam(s) ]
AICPA [1 Certification Exam(s) ]
AIIM [1 Certification Exam(s) ]
Alcatel-Lucent [13 Certification Exam(s) ]
Alfresco [1 Certification Exam(s) ]
Altiris [3 Certification Exam(s) ]
American-College [2 Certification Exam(s) ]
Android [4 Certification Exam(s) ]
APC [2 Certification Exam(s) ]
APICS [1 Certification Exam(s) ]
Apple [69 Certification Exam(s) ]
Arizona-Education [1 Certification Exam(s) ]
ARM [1 Certification Exam(s) ]
Aruba [6 Certification Exam(s) ]
ASIS [2 Certification Exam(s) ]
ASQ [3 Certification Exam(s) ]
ASTQB [6 Certification Exam(s) ]
Autodesk [2 Certification Exam(s) ]
Avaya [85 Certification Exam(s) ]
Axis [1 Certification Exam(s) ]
Banking [1 Certification Exam(s) ]
BEA [5 Certification Exam(s) ]
BICSI [2 Certification Exam(s) ]
BlackBerry [17 Certification Exam(s) ]
BlueCoat [2 Certification Exam(s) ]
Business-Objects [11 Certification Exam(s) ]
Business-Tests [4 Certification Exam(s) ]
CA-Technologies [20 Certification Exam(s) ]
Certification-Board [9 Certification Exam(s) ]
Certiport [3 Certification Exam(s) ]
CheckPoint [31 Certification Exam(s) ]
CIPS [4 Certification Exam(s) ]
Cisco [270 Certification Exam(s) ]
Citrix [35 Certification Exam(s) ]
CIW [17 Certification Exam(s) ]
Cloudera [10 Certification Exam(s) ]
Cognos [19 Certification Exam(s) ]
College-Board [2 Certification Exam(s) ]
CompTIA [33 Certification Exam(s) ]
ComputerAssociates [6 Certification Exam(s) ]
CPP-Institute [1 Certification Exam(s) ]
CWNP [12 Certification Exam(s) ]
Dassault [2 Certification Exam(s) ]
DELL [7 Certification Exam(s) ]
DMI [1 Certification Exam(s) ]
ECCouncil [18 Certification Exam(s) ]
ECDL [1 Certification Exam(s) ]
EMC [122 Certification Exam(s) ]
Enterasys [13 Certification Exam(s) ]
Ericsson [5 Certification Exam(s) ]
Esri [2 Certification Exam(s) ]
ExamExpress [15 Certification Exam(s) ]
Exin [39 Certification Exam(s) ]
ExtremeNetworks [3 Certification Exam(s) ]
F5-Networks [19 Certification Exam(s) ]
Filemaker [9 Certification Exam(s) ]
Financial [35 Certification Exam(s) ]
Fortinet [10 Certification Exam(s) ]
Foundry [6 Certification Exam(s) ]
Fujitsu [2 Certification Exam(s) ]
GAQM [7 Certification Exam(s) ]
Genesys [4 Certification Exam(s) ]
Google [4 Certification Exam(s) ]
GuidanceSoftware [2 Certification Exam(s) ]
H3C [1 Certification Exam(s) ]
HDI [9 Certification Exam(s) ]
Healthcare [3 Certification Exam(s) ]
HIPAA [2 Certification Exam(s) ]
Hitachi [27 Certification Exam(s) ]
Hortonworks [1 Certification Exam(s) ]
Hospitality [2 Certification Exam(s) ]
HP [712 Certification Exam(s) ]
HR [1 Certification Exam(s) ]
HRCI [1 Certification Exam(s) ]
Huawei [20 Certification Exam(s) ]
Hyperion [10 Certification Exam(s) ]
IBM [1491 Certification Exam(s) ]
IBQH [1 Certification Exam(s) ]
ICDL [6 Certification Exam(s) ]
IEEE [1 Certification Exam(s) ]
IELTS [1 Certification Exam(s) ]
IFPUG [1 Certification Exam(s) ]
IIBA [2 Certification Exam(s) ]
IISFA [1 Certification Exam(s) ]
Informatica [2 Certification Exam(s) ]
Intel [2 Certification Exam(s) ]
IQN [1 Certification Exam(s) ]
IRS [1 Certification Exam(s) ]
ISACA [4 Certification Exam(s) ]
ISC2 [6 Certification Exam(s) ]
ISEB [24 Certification Exam(s) ]
Isilon [4 Certification Exam(s) ]
ISM [6 Certification Exam(s) ]
iSQI [7 Certification Exam(s) ]
Juniper [54 Certification Exam(s) ]
Legato [5 Certification Exam(s) ]
Liferay [1 Certification Exam(s) ]
Lotus [66 Certification Exam(s) ]
LPI [21 Certification Exam(s) ]
LSI [3 Certification Exam(s) ]
Magento [3 Certification Exam(s) ]
Maintenance [2 Certification Exam(s) ]
McAfee [8 Certification Exam(s) ]
McData [3 Certification Exam(s) ]
Medical [25 Certification Exam(s) ]
Microsoft [228 Certification Exam(s) ]
Mile2 [2 Certification Exam(s) ]
Military [1 Certification Exam(s) ]
Motorola [7 Certification Exam(s) ]
mySQL [4 Certification Exam(s) ]
Network-General [12 Certification Exam(s) ]
NetworkAppliance [35 Certification Exam(s) ]
NI [1 Certification Exam(s) ]
Nokia [2 Certification Exam(s) ]
Nortel [130 Certification Exam(s) ]
Novell [37 Certification Exam(s) ]
OMG [9 Certification Exam(s) ]
Oracle [232 Certification Exam(s) ]
P&C [1 Certification Exam(s) ]
Palo-Alto [3 Certification Exam(s) ]
PARCC [1 Certification Exam(s) ]
PayPal [1 Certification Exam(s) ]
Pegasystems [10 Certification Exam(s) ]
PEOPLECERT [4 Certification Exam(s) ]
PMI [15 Certification Exam(s) ]
Polycom [2 Certification Exam(s) ]
PostgreSQL-CE [1 Certification Exam(s) ]
Prince2 [6 Certification Exam(s) ]
PRMIA [1 Certification Exam(s) ]
PTCB [2 Certification Exam(s) ]
QAI [1 Certification Exam(s) ]
QlikView [1 Certification Exam(s) ]
Quality-Assurance [7 Certification Exam(s) ]
RACC [1 Certification Exam(s) ]
Real-Estate [1 Certification Exam(s) ]
RedHat [8 Certification Exam(s) ]
RES [5 Certification Exam(s) ]
Riverbed [8 Certification Exam(s) ]
RSA [13 Certification Exam(s) ]
Sair [8 Certification Exam(s) ]
Salesforce [3 Certification Exam(s) ]
SANS [1 Certification Exam(s) ]
SAP [78 Certification Exam(s) ]
SASInstitute [15 Certification Exam(s) ]
SAT [1 Certification Exam(s) ]
SCO [9 Certification Exam(s) ]
SCP [6 Certification Exam(s) ]
SDI [3 Certification Exam(s) ]
See-Beyond [1 Certification Exam(s) ]
Siemens [1 Certification Exam(s) ]
Snia [6 Certification Exam(s) ]
SOA [15 Certification Exam(s) ]
Social-Work-Board [1 Certification Exam(s) ]
SUN [63 Certification Exam(s) ]
SUSE [1 Certification Exam(s) ]
Sybase [17 Certification Exam(s) ]
Symantec [132 Certification Exam(s) ]
Teacher-Certification [3 Certification Exam(s) ]
The-Open-Group [8 Certification Exam(s) ]
TIA [3 Certification Exam(s) ]
Tibco [18 Certification Exam(s) ]
Trend [1 Certification Exam(s) ]
TruSecure [1 Certification Exam(s) ]
USMLE [1 Certification Exam(s) ]
VCE [5 Certification Exam(s) ]
Veeam [2 Certification Exam(s) ]
Veritas [25 Certification Exam(s) ]
Vmware [51 Certification Exam(s) ]
Wonderlic [1 Certification Exam(s) ]
XML-Master [3 Certification Exam(s) ]
Zend [5 Certification Exam(s) ]
Get Unlimited Access to all ExamCollection's PREMIUM files!
Enter Your Email Address to Receive Your 30% Off Discount Code
Please enter a correct email to Get your Discount Code
Download Free Demo of VCEExam Simulator
Experience Avanset VCE Exam Simulator for yourself.
Simply submit your e-mail address below to get started with our interactive software demo of your free trial.
This is the second post about SQL Azure Federation. In my first post I described a little bit about the theory of data partitioning, included the different between the horizontal partitioning and the vertical partitioning. I also talked about the features need to be done when we implemented the horizontal partitioning. And finally, I described some basic concept about SQL Azure Federation.
In this post, I will demonstrate how to use SQL Azure Federation in the SQL Server Management Studio (SSMS). I will also demonstrate the benefit of using SQL Azure Federation to build the multi-tenant data solution.
Create Federation and Tables
SQL Azure Federation is officially available for every Windows Azure data centers. There no additional register or sign up process. When we create a new server or database in SQL Azure, we can use SQL Azure Federation. For example, I had created a new database in my SQL Azure server which located in East Asia data center. Then I can open my SSMS and connect to this SQL Azure server and use SQL Azure Federation.
Do not forget to set the SQL Azure firewall before you connect to the server from local tools such as SSMS.
In this post I would like to take a very simple scenario as the example. Assuming we have a multi-tenant CRM system which contains accounts, contacts for each tenants. We also have some lookup data such as countries and titles. We also have one table contains some metadata for each tenants. So the database diagram would be like this.
In SQL Azure Federation, if we decided to split some tables we must have the federation ready, then create the tables that wanted to be federated based on the federation. There is no way in SQL Azure Federation to switch tables between the federated and non-federated or reference. So before we start to create the tables we need to firstly define the federation.
Since we decided to have the tenant ID as the key when splitting the database, the federation distribution should be INT type, which is the same as the type of TenantID in the tables.
In order to create the federation, in SSMS connect to the database and execute the T-SQL below.
1: CREATE FEDERATION Tenant_Fed (TID INT RANGE) 2: GO
There’s nothing special happened after we executed this T-SQL in SSMS. But in SQL Azure fabric, it created a database which represent our first federation member. The federation member database name was specified by SQL Azure which was a GUID with “system-” prefixed. And the original database, which we created and are connecting now, became the root database.
After that, all tables in our system should be in one of these three types.
Table Type Description Where Federated Table Tables that will be split based on the federation and their federation columns. Federation Members Reference Table Tables that will not be split, but should be referred by the federated table. These tables will be copied across all federation members. Federation Members Centre Table Tables that will not be split, and very rarely join-select with the tables in federation members. Federation Root
For the federated table and reference table, we need to create them in a federation member, so that when we split this member, SQL Azure Federation will help us to create them in the new member. In order to connect to a federation member we need to execute the T-SQL below.
1: USE FEDERATION Tenant_Fed (TID = 0) WITH RESET, FILTERING = OFF 2: GO
If you are familiar with SQL Azure you should be already know that the USE keyword doesn’t work in SQL Azure. But if we specify the FEDERATION keyword and the federation name it will switch our connection to the federation member database, which contains the distribution key value we specified here (TID = 0). And if we connected to this federation member we can retrieve the database name by using the db_name() function. As you can see in my workstation my first federation member database name was “system-06d60081-6737-413e-85b1-df65cb55f1c9”.
Now we have been connecting to the federation member and the next step is to create the federated tables. Based on our design the Account and table should be partitioning by their TenantID column so let’s create them by the following T-SQL.
1: CREATE TABLE [dbo].[Account]( 2: [ID] [int] NOT NULL, 3: [TenantID] [int] NOT NULL, 4: [Name] [varchar](50) NOT NULL, 5: [CountryID] [int] NOT NULL, 6: CONSTRAINT [PK_Account] PRIMARY KEY CLUSTERED 7: ( 8: [ID] ASC 9: )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF) 10: ) 11: FEDERATED ON (TID = TenantID) 12: GO
In the T-SQL above we are going to create the Account table with fields and primary key. And at the end of the statement we defined that the TenantID column is the federated column of this table. This means, when SQL Azure Federation split the table it will look up the value of TenantID, decided which rows should be in which member.
But when we executed we will get an error that the primary key index could not be created since the index doesn’t contain the federated column.
This is a limitation in SQL Azure Federation. The federated column in a federated table must be the clustered index, or be in the clustered index. Since we defined the ID as the primary key of the Account table, to satisfied this limitation we must include the TenantID as the primary key as well. So our T-SQL should be like this.
1: CREATE TABLE [dbo].[Account]( 2: [ID] [int] NOT NULL, 3: [TenantID] [int] NOT NULL, 4: [Name] [varchar](50) NOT NULL, 5: [CountryID] [int] NOT NULL, 6: CONSTRAINT [PK_Account] PRIMARY KEY CLUSTERED 7: ( 8: [ID] ASC, 9: [TenantID] ASC 10: )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF) 11: ) 12: FEDERATED ON (TID = TenantID) 13: GO
And similarly, in table we also need to add the TenantID column as the primary key. We also need to amend the foreign keys as well. The T-SQL should be like this.
There is no constraint that the federation column name should be the same in each federated tables. We can specify the federation key to the different columns that has different names in each federated tables when created the tables. For example in Account table we link TID = TenantID while in table we link TID = Tenant_ID or TID = T_ID, etc..
1: CREATE TABLE [dbo].( 2: [ID] [int] NOT NULL, 3: [TenantID] [int] NOT NULL, 4: [AccountID] [int] NOT NULL, 5: [Name] [varchar](50) NOT NULL, 6: [TitleID] [int] NOT NULL, 7: CONSTRAINT [PK_] PRIMARY KEY CLUSTERED 8: ( 9: [ID] ASC, 10: [TenantID] ASC 11: )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF) 12: ) 13: FEDERATED ON (TID = [TenantID]) 14: GO 15: 16: ALTER TABLE [dbo].[Account] WITH CHECK ADD CONSTRAINT [FK_Account_Country] FOREIGN KEY([CountryID]) 17: REFERENCES [dbo].[Country] ([ID]) 18: GO 19: ALTER TABLE [dbo].[Account] CHECK CONSTRAINT [FK_Account_Country] 20: GO 21: ALTER TABLE [dbo]. WITH CHECK ADD CONSTRAINT [FK__Account] FOREIGN KEY([AccountID], [TenantID]) 22: REFERENCES [dbo].[Account] ([ID], [TenantID]) 23: GO 24: ALTER TABLE [dbo]. CHECK CONSTRAINT [FK__Account] 25: GO 26: ALTER TABLE [dbo]. WITH CHECK ADD CONSTRAINT [FK__Title] FOREIGN KEY([TitleID]) 27: REFERENCES [dbo].[Title] ([ID]) 28: GO 29: ALTER TABLE [dbo]. CHECK CONSTRAINT [FK__Title] 30: GO
Now we have the federated tables created in our first federation member. Next let’s create the reference tables. In this case the reference tables are County and Title. They don’t have the column related with the federation distribution key, which is the tenant ID in our example. But they need to be selected alone with the federated tables. For example we might need to retrieve the account information for a tenant with the country name. So they need to be added as reference tables.
To create a reference table in a federation member would be the same as what we did on a normal database, no need to specify the federated column in the CREATE TABLE statement.
1: CREATE TABLE [dbo].[Title]( 2: [ID] [int] NOT NULL, 3: [Title] [varchar](50) NOT NULL, 4: CONSTRAINT [PK_Title] PRIMARY KEY CLUSTERED 5: ( 6: [ID] ASC 7: )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF) 8: ) 9: GO 10: 11: CREATE TABLE [dbo].[Country]( 12: [ID] [int] NOT NULL, 13: [Country] [varchar](50) NOT NULL, 14: CONSTRAINT [PK_Country] PRIMARY KEY CLUSTERED 15: ( 16: [ID] ASC 17: )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF) 18: ) 19: GO 20: 21: ALTER TABLE [dbo].[Account] WITH CHECK ADD CONSTRAINT [FK_Account_Country] FOREIGN KEY([CountryID]) 22: REFERENCES [dbo].[Country] ([ID]) 23: GO 24: ALTER TABLE [dbo].[Account] CHECK CONSTRAINT [FK_Account_Country] 25: GO 26: 27: ALTER TABLE [dbo]. WITH CHECK ADD CONSTRAINT [FK__Title] FOREIGN KEY([TitleID]) 28: REFERENCES [dbo].[Title] ([ID]) 29: GO 30: ALTER TABLE [dbo]. CHECK CONSTRAINT [FK__Title] 31: GO
And in the T-SQL above we also added the foreign keys between the reference tables and federated tables. It’s possible to add the foreign keys between the federated tables, like what we added between the Account and . It’s possible to add the foreign key from the federated table to reference table, like the key between Account and Country. But it’s not allowed to add the foreign key from a non-federated table to a federated table. For example we cannot add a foreign key between the Account to a table in the federation root.
Now we have all tables and keys ready in our first federation member. Let’s add some sample data.
1: INSERT INTO Country VALUES (1, 'China') 2: INSERT INTO Country VALUES (2, 'US') 3: INSERT INTO Country VALUES (3, 'UK') 4: 5: INSERT INTO Title VALUES (1, 'Mr') 6: INSERT INTO Title VALUES (2, 'Ms') 7: 8: INSERT INTO Account VALUES (1, 1, 'Tenant 1 - Account 1', 1) 9: INSERT INTO Account VALUES (2, 1, 'Tenant 1 - Account 2', 2) 10: INSERT INTO Account VALUES (3, 2, 'Tenant 2 - Account 3', 3) 11: INSERT INTO Account VALUES (4, 2, 'Tenant 2 - Account 4', 1) 12: INSERT INTO Account VALUES (5, 3, 'Tenant 3 - Account 5', 2) 13: INSERT INTO Account VALUES (6, 3, 'Tenant 3 - Account 6', 3) 14: INSERT INTO Account VALUES (7, 4, 'Tenant 4 - Account 7', 1) 15: INSERT INTO Account VALUES (8, 4, 'Tenant 4 - Account 8', 2) 16: INSERT INTO Account VALUES (9, 5, 'Tenant 5 - Account 9', 3) 17: INSERT INTO Account VALUES (10, 5, 'Tenant 5 - Account 10', 1) 18: 19: 20: INSERT INTO VALUES (1, 1, 1, 'Tenant 1 - Account 1 - 1', 1) 21: INSERT INTO VALUES (2, 1, 1, 'Tenant 1 - Account 1 - 2', 2) 22: INSERT INTO VALUES (3, 1, 1, 'Tenant 1 - Account 1 - 3', 1) 23: INSERT INTO VALUES (4, 1, 2, 'Tenant 1 - Account 2 - 4', 2) 24: INSERT INTO VALUES (5, 1, 2, 'Tenant 1 - Account 2 - 5', 1) 25: INSERT INTO VALUES (6, 1, 2, 'Tenant 1 - Account 2 - 6', 2) 26: INSERT INTO VALUES (7, 2, 3, 'Tenant 2 - Account 3 - 7', 1) 27: INSERT INTO VALUES (8, 2, 3, 'Tenant 2 - Account 3 - 8', 2) 28: INSERT INTO VALUES (9, 2, 3, 'Tenant 2 - Account 3 - 9', 1) 29: INSERT INTO VALUES (10, 2, 4, 'Tenant 2 - Account 4 - 10', 2) 30: INSERT INTO VALUES (11, 2, 4, 'Tenant 2 - Account 4 - 11', 1) 31: INSERT INTO VALUES (12, 2, 4, 'Tenant 2 - Account 4 - 12', 2) 32: INSERT INTO VALUES (13, 3, 5, 'Tenant 3 - Account 5 - 13', 1) 33: INSERT INTO VALUES (14, 3, 5, 'Tenant 3 - Account 5 - 14', 2) 34: INSERT INTO VALUES (15, 3, 5, 'Tenant 3 - Account 5 - 15', 1) 35: INSERT INTO VALUES (16, 3, 6, 'Tenant 3 - Account 6 - 16', 2) 36: INSERT INTO VALUES (17, 3, 6, 'Tenant 3 - Account 6 - 17', 1) 37: INSERT INTO VALUES (18, 3, 6, 'Tenant 3 - Account 6 - 18', 2) 38: INSERT INTO VALUES (19, 4, 7, 'Tenant 4 - Account 7 - 19', 1) 39: INSERT INTO VALUES (20, 4, 7, 'Tenant 4 - Account 7 - 20', 2) 40: INSERT INTO VALUES (21, 4, 7, 'Tenant 4 - Account 7 - 21', 1) 41: INSERT INTO VALUES (22, 4, 8, 'Tenant 4 - Account 8 - 22', 2) 42: INSERT INTO VALUES (23, 4, 8, 'Tenant 4 - Account 8 - 23', 1) 43: INSERT INTO VALUES (24, 4, 8, 'Tenant 4 - Account 8 - 24', 2) 44: INSERT INTO VALUES (25, 5, 9, 'Tenant 5 - Account 9 - 25', 1) 45: INSERT INTO VALUES (26, 5, 9, 'Tenant 5 - Account 9 - 26', 2) 46: INSERT INTO VALUES (27, 5, 9, 'Tenant 5 - Account 9 - 27', 1) 47: INSERT INTO VALUES (28, 5, 10, 'Tenant 5 - Account 10 - 28', 2) 48: INSERT INTO VALUES (29, 5, 10, 'Tenant 5 - Account 10 - 29', 1) 49: INSERT INTO VALUES (30, 5, 10, 'Tenant 5 - Account 10 - 30', 2)
After executed these T-SQL we had put all data in our first federation member. It contains two references tables (Country, Title) and two federated tables (Account, ), and some foreign keys between the reference table and federated table.
And we can select the data in this federation member with the tables joining, for example the T-SQL below will list all accounts and contacts information.
1: SELECT Account.Name, Country.Country, .Name, Title.Title FROM 2: LEFT JOIN Account ON AccountID = Account.ID 3: LEFT JOIN Country ON Account.CountryID = Country.ID 4: LEFT JOIN Title ON .TitleID = Title.ID Split Federation Member
The key feature of SQL Azure Federation is to split a federation member into two based on the federated value specified without any downtime. Since we have inserted some data in our first federation member, let’s split it into two.
Split a federation member is very easy. We use the ALTER FEDERATION command and specify from what value of the distribution key to split. For example, since the federation distribution key is the TID (tenant ID), we will split all federated tables based on their federated column value at 3. This means all data that the tenant ID is less than 3 will be in the federation member 1 while others will be in the federation member 2.
In order to split the federation we need to firstly connect to the federation root, and then execute the ALTER FEDERATION command specifying the boundary value.
1: USE FEDERATION ROOT WITH RESET 2: GO 3: 4: ALTER FEDERATION Tenant_Fed SPLIT AT (TID = 3) 5: GO
When execute this command the SQL Azure engine will perform the operations listed below.
After the split command finished we can connect one federation member by using the USE FEDERATION command. In SQL Azure Federation we cannot connect to a member database by specifying its database name, instead we need to tell the SQL Azure Federation the value of the distribution key we want to us, then SQL Azure Federation will rout us to that member database. For example, we split our data at tenant ID = 3, then if we want to read the data of tenant 4 we can use the T-SQL below.
1: USE FEDERATION Tenant_Fed (TID = 4) WITH RESET, FILTERING = OFF 2: GO
Then execute the command we had just preformed before to see the data in this federation member.
1: SELECT Account.Name, Country.Country, .Name, Title.Title 2: FROM 3: LEFT JOIN Account ON AccountID = Account.ID 4: LEFT JOIN Country ON Account.CountryID = Country.ID 5: LEFT JOIN Title ON .TitleID = Title.ID
And as you can see, the SSMS returned the data that the tenant ID is equal or more than 4.
And if we want to see the data in the first member, we can just specify the TID = 0, 1 or 2, any value less than the boundary value of that federation member.
Connect to Atomic Unit
When we connected to a federation member we use the USE FEDERATION command. There’s a clause in this T-SQL statement which is FILTERING = OFF. In the example above we can select all data in the federation member unless we didn’t put any criteria in WHERE clause in SELECT command. This is because we utilized FILTERING = OFF. It will make the connection scope set to the full range covered by the federation member containing the specified key value. The connection behaves the same if it were connected to the member through its physical federation member name (the database name).
SQL Azure Federation provides another valuable feature that can force the connection scope set to the federation key instance (federation key value) in a federation member rather than to the full range of federation member, by using FILTERING = ON clause.
So let’s have a try and to see what will happen if we set the FILTERING = ON. At this time we still specify the SSMS to use federation where the key equals to 2 but specify the FILTERING = ON, and select the data without any criteria.
1: USE FEDERATION Tenant_Fed (TID = 2) WITH RESET, FILTERING = ON 2: GO 3: 4: SELECT Account.Name, Country.Country, .Name, Title.Title 5: FROM 6: LEFT JOIN Account ON AccountID = Account.ID 7: LEFT JOIN Country ON Account.CountryID = Country.ID 8: LEFT JOIN Title ON .TitleID = Title.ID
Now we can see that only the records that the TenantID = 2 were returned. We didn’t provide anything in the WHERE clause in SELECT command but it worked as if we specified WHERE TenantID = 2. This is the benefit that using the FILTERING = ON in the USE FEDERATION command.
We mentioned in the previous post, in SQL Azure Federation all records that related with the same federation key value in a federation member is called an Atomic Unit. In the case above we connected to the federation member’s atomic unit which the value is TenantID = 2, by using the FILTERING = ON clause.
This feature is very useful especially when we need to migrate a single tenant application to multi-tenant style. As you know we might need to add the tenant identity column in the tables that tenant-award when migrating, but this might lead us to rewrite all related SQL scripts. For example if we have a SQL script that retrieves all data in table Order, it might look like this in single tenant application.
1: SELECT Order.ID, Order.Name FROM Order
But if we implemented the multi-tenant feature we have to add the TenantID column in this table to indicate which tenant the order is. And accordingly we have to rewrite the SQL script if a participant tenant user is currently logging on.
1: SELECT Order.ID, Order.Name FROM Order 2: WHERE Order.TenantID = UserTenentID
Assuming that we have 50 tables that are tenant-award and 10 scripts for each table. Then we need to amend 50 * 10 = 500 SQL scripts. And almost all changes are very similar.
But if we are using SQL Azure Federation we can make the tenant ID as the federation distribution key and let the tables split based on their TenantID column. Then if we have an user logged in under a tenant, we can invoke the USE FEDERATION statement specifying the TenantID value with FILTERING = ON before any data command, then all following SQL scripts will no need to be changed since the SQL Azure Federation helped us to filter the connection scope to this tenant. This can be done very easily by using AOP.
In this post I demonstrated how to use SQL Azure Federation. We talked about how to create federation, federation members and tables. And we demonstrated how to split a federation member, which is horizontal data partitioning without any downtime.
I also talked about the feature of FILTERING = ON in USE FEDERATION statement and the benefit in multi-tenant solution.
SQL Azure Federation is a very powerful tool for us to build scale-out andor multi-tenant application. In the coming few posts I would like to discuss the metadata system of the federation, the pricing and how to split the federation members based on the data size or record count.
And I would like to introduce on how to implement our own horizontal partitioning data access layer without SQL Azure Federation available.
Hope this helps,
All documents and related graphics, codes are provided "AS IS" without warranty of any kind. Shaun Ziyan Xu. This work is licensed under the Creative Commons License.