[EN] Welcome Back MCT!

The beginning of April. Every year since April 2011. Still don’t understand why I have to renew my MCT status on every April if I passed my MCT Exam in July 2010, but.. I always do it in the last possible moment.

This year everything was the same. Almost. I just been surprised about increasing price for renewing my status. Of cours – for all ‘well informed folks’ – I should be prepared, because informations about increasing prices has been publisher over year ago, but… as human nature we are always surprise in the time of payment. Anyway, I just make bank transfer payment and got really nice message in my xobni (yes i missed fantastic xobni stuff).

First and most important advantage from this progmar for me is right to provide trainings with Microsoft Official Course and in some countries other courses – because Microsoft Certified Trainer status is equivalent for some other trainers/teachers programs. And it’s really cool! Other advantages are still really cool. My newest just for MCTs:

  • Access to the MCT Member site. The MCT member site offers exclusive program information, access to the Microsoft Learning Download Center, digitized logos for download, and many other benefits and special offers. It also gives you the ability to update your personal information and print or share your transcript. |http://bit.ly/1PCryVO|
  • Access to content. You have access to our full library of courseware through the Microsoft Learning Download Center and the Courseware Marketplace. |http://bit.ly/1FNH6R3|
  • Connect with the MCT Community MCT Central is a dedicated hub designed to help you succeed as a MCT including tools to support you: acquiring knowledge, getting prepared, staying current and engaging with the community. |http://bit.ly/1JDbi2P|
  • Reach out to your Regional Leads They represent a group of active and experienced trainers around the world. We encourage you to reach out to the Regional Lead in your area by accessing the Regional Lead map on MCT Central.
  • my Welcome Kit  that identifies you as a MCT Program member. You can customize your MCT Welcome Kit by selecting items you’d like to include. |http://bit.ly/1CHaW52|

But mycoolest and most powerfull benefits are allittle different than resources above. I got yearly free subscriptions for:

  • Software downloads | Over 11 terabytes of Microsoft Products are available for my any test, check, play, install, destroy projects
  • Microsoft Azure Free Subscription | up to 100 USD monthly for playng with Microsoft Azure stuff {virtual machines, sql databases, websites , hadoop, mobile push, media streaming, active directory, everything else…}
  • Microsoft Office 365 Enterprise | One year free trial subscription for Microsoft Offfice 365 subscription on Enterprise E3 level {mail, calendar, people, newsfeed, onedrive, sharepoint online, taksk, delve, word-excel-powerpoint-onenote online}

Anyway. Welcome back to Microsoft Certified Trainer Program is a fact. Now it’s time for planning some trainings!

[EN] The Redgate Way in AD 2015

LOGO__FORG2015I’m very very happy to be Friend Of Redgate. I’m member of this fantastic program for last three/four years. My first “Friends of Redgate” sencence appears in my mailbox in fall of 2011. Since this moment I’m trying to be active in this way. My stardard job as Friend is part of evangelization – not as good as my friends Grant Fritchey {TWITTER|BLOG} or Steve Jones {TWITTER|BLOG}, but because they both always inspiring me, I’m trying to be better year by year – is speaking and talking about arround, with Redgate’s ingeniously simple stuff. Speaking continuosly need improvement. Session writing, demo testing, then presenting and collecting opinions is a hard job. Sometimes I failed, sometime I rocking. But improving my session is my primary goal for this year. Not only by quantity but with quality.

In next two weeks I will spend almost three days in Redgate Headquarter in Cambridge. First day will be oriented for two main focus:

     >> Friends of Redgate Things: opinions, ideas, project team exchange, project and product managers talk, constructive advices and more

     >> Business Perspectives: because I just moved to England, hope that collaboration with Redgate could be alittle closer than before

Next two days it will be focusing for intensive learning workshops in Database Lifecycle Management (DLM) Training mode:

    Database Source Control – If you want to take the first step in improving your database development process with DLM, this is the workshop for you. You’ll learn how to: || Source control your database – the first step in any DLM process || Deploy your databases from source control || Monitor and track database changes across development, testing, and production environments. Workshop outline:
              – Introduction to Database Lifecycle Management (DLM)
              – Source control: an overview
              – SQL Source Control & Redgate DLM tools
              – Lunch
              – Deploying from source control
              – Branching and merging
              – Migration scripts for complex changes
              – Tracking changes across environments with DLM Dashboard
              – Networking and beer!

    Database Continuous Integration – Ready to do database continuous integration (CI) as part of Database Lifecycle Management? Then this is the workshop for you. You’ll learn how to: || Link your source control repository to a build system || Trigger database builds automatically when you make a change || Use Redgate’s DLM tools to test your database changes || Lay the foundations for package-based deployment of your database. Workshop outline
              – Introduction to Database Lifecycle Management (DLM)
              – Continuous integration (CI): an overview
              – CI & Redgate DLM tools
              – Automating builds
              – Lunch
              – The SQL CI plugin
              – Introduction to SQL Test
              – How to automate tests
              – Tracking changes across environments with DLM Dashboard
              – Networking and beer!

Both workshops will be provided by one of two Redgate DLM Trainer Tom Austin >>  Tom has spent the last 7 years working at Redgate, focusing on our DLM tools. He’s worked closely with customers from many different industries to improve efficiency and productivity in their development environments. Recently he has been involved in webinars focusing on database versioning using SQL Source Control
sing SQL Source Control. You can still register for one of those workshops plus another one named: Automated Database Deployment not only in United Kingdom but in United States (of America) too:

          – April 10 2015 | Database Continuous Integration | LA, USA | $500 | Ike Ellis | REGISTER

          – April 22 2015 | Database Source Control | Cambridge, UK | £300 | Tom Austin | REGISTER

          – April 23 2015 | Database Continuous Integration | Cambridge, UK | £300 | Tom Austin | REGISTER

          – April 24 2015 | Automated Database Deployment | Exeter, UK | £300 | Alex Yates | REGISTER

          – May 15 2015 | Database Continuous Integration |Bellevue, WA | $500 | Northwest Cadence | REGISTER

          – May 20 2015 | Automated Database Deployment | London, UK | £300 | Alex Yates | REGISTER

Learning? Yes, definitely very good planned two April’s days. Teaching? Yes, definitely more sessions with those subjects at User Groups, Saturday Conferences and middle-week conference in future months. If you will go to Cambridge, stop and say hello (or bring excellent coffe from Redgate’s Level Zero Cafeteria.

[EN] How To Do It? Enable Versioning on Site Collections

In this series I occasionally (yes, too occasionally) writing about small useful advices, which are answers for my colleagues, students and sometimes customers. I know that many of this kind advices are well known for many of technical blog readers, but from my perspective it’s very helpful for me. Why? Sometimes I need solution on demand and sometimes I don’t remember how something simple do. But I remember: “Wait, bastard! You wrote about it on blog!” Now I’m writing about Site Collection Versioning in SharePoint 2013.

One of my client asked me about enabling versioning for brand new SharePoint 2013 farm with few separate site collections, and sites, lists, libraries inside. First point for solve this request is going to Central Administration… where I spend half an hour to find simple answer: how to enable versioning on ALL site collections. And the answer is simple – this feature is not working on Farm Level, just on Site Collection level. That means: If I have four, five, ten Site Collections – I need to enable versioning on all site collection manually separately. Does not make sense and it’s really boring.

But… I have Power! I can use PowerShell with one simple script for enabling versioning on all my site collections and libraries and list if I need. The original post has been written by Keith Tuomi (Canadian SharePoint MVP) here, but is worth to be partially quoted and re-discover.

image

Pict.1 Whole script for enabling versioning on all site collections.

If I need I can enabling versioning with Major and Minor levels fon all Document Libraries on my SharePoint Farm (in this example 5 major and 10 Minor versions). Script have two parameters:
1. Required: Site collection URL e.g. http://intranet.company.com (specifies the site collection to operate on)
Example 1 – run the script in report mode only (no changes effected):
   c:sharepointadminaccount.Enable-Versioning.ps1 http://intranet.company.com

2. Optional: execute Script runs in report mode only unless you add the word execute
Example 2 – run the script in execute mode:
    c:sharepointadminaccount.Enable-Versioning.ps1 http://intranet.company.com execute

Easy? Yes! And it works. As additional advice – it’s possible to add this script for Windows Task manager for run on regular basis to be shure that all new site collection, site, library, list are versioning. Script you can downolad from resources page.