Tiago Costa blog

This blog was created for sharing knowledge for Microsoft Developers and Microsoft Certified Trainers about Office 365, Azure, SharePoint and .Net.

MCSA SQL Server 2016

Microsoft just announced the release of 3 new MCSA: SQL Server 2016 certifications. One big difference from these certifications from the previous versions is that now we have 3 MCSA instead of just the current MCSA: SQL Server 2012/2014. Microsoft brought back the MCSA SQL Server Developer Certification. Being most a Developer that uses a lot SQL Server, this makes all the sense. So this is good news for all SQL Server Developers and standard developers that use SQL Server has their main Database system.

So, this are the new certifications:

MCSA: SQL 2016 Database Development

  • 70-761 – Querying Data with Transact-SQL
  • 70-762 – Developing SQL Databases

Note: If you already hold an MCSA: SQL Server 2012/2014 certification can upgrade by taking and passing exam 70-762


MCSA: SQL 2016 Database Administration

  • 70-764 – Administering a SQL Database Infrastructure
  • 70-765 – Provisioning SQL Databases

Note: If you already hold an MCSA: SQL Server 2012/2014 certification can upgrade by taking and passing exam 70-765


MCSA: SQL 2016 Business Intelligence Development

  • 70-767 – Implementing a SQL Data Warehouse
  • 70-768 – Developing SQL Data Models

Note: If you already hold an MCSA: SQL Server 2012/2014 certification can upgrade by taking and passing exam 70-768


All MOC courses to prepare you for this SQL Server 2016 exams are already available. MCSE certifications will be announced later this summer.

Microsoft Azure Dev/test offer renamed

Microsoft had renamed the dev/test offer. The name has changed from MSDN Dev Test Pay-As-You-Go to Pay-As-You-Go Dev/Test. This offer is designer for all teams that need a Dev and/or Test Environment in the Cloud and not only Visual Studio users, like the previous name.

Why I’m writing this post just because of a name change?

Well because I see a lot of customers using standard subscriptions for their Dev and Test environments, when they could just use this type of subscription. Using this subscription customer get better rates and save some budget for other projects. In an IaaS scenario, and at the date of this post active Visual Studio subscribers, will only pay the Linux VM rate, because all the other software: Windows Server, SQL Server, SharePoint, … is included in the Visual Studio Subscription.

“Each active Visual Studio subscriber on your team can use the Microsoft software included with their subscription on Azure Virtual Machines for dev/test at no extra charge—you’ll just pay the Linux rate for VMs you run, even VMs with SQL Server, SharePoint Server, or other software that is normally billed at a higher rate. Upload custom virtual machine images yourself or use one of our pre-configured images from the Azure Gallery.”

You will also can take the advantage of lower rates on Cloud Services, HDInsight, and Web Apps.

More information at: https://azure.microsoft.com/en-us/offers/ms-azr-0023p

ASP.NET 5 is dead!!!! Long live ASP.NET Core 1.0

So, Microsoft has changed some naming on the upcoming Web Development platform.

  • ASP.NET 5 is now ASP.NET Core 1.0
  • .NET Core 5 is now .NET Core 1.0
  • Entity Framework 7 is now Entity Framework Core 1.0

The justification for the new naming is that all this is technology is new and completely re-written. Another reason is that this is not yet finished, ASP.NET Core 1.0 doesn’t have SignalR or Web Pages and it doesn’t support VB.Net of F#.

More info at: http://www.hanselman.com/blog/ASPNET5IsDeadIntroducingASPNETCore10AndNETCore10.aspx

Book: Modern Authentication with Azure Active Directory for Web Applications

Once more Microsoft releases a Book. This time about how to integrate Web Applications Authentication with Azure Active Directory and written by Vittorio Bertocci.

Active Directory has been transformed to reflect the cloud revolution, modern protocols, and today’s newest SaaS paradigms. This is an authoritative, deep-dive guide to building Active Directory authentication solutions for these new environments. Author Vittorio Bertocci drove these technologies from initial concept to general availability, playing key roles in everything from technical design to documentation. In this book, he delivers comprehensive guidance for building complete solutions. For each app type, Bertocci presents high-level scenarios and quick implementation steps, illuminates key concepts in greater depth, and helps you refine your solution to improve performance and reliability. He helps you make sense of highly abstract architectural diagrams and nitty-gritty protocol and implementation details. This is the book for people motivated to become experts.

Book Main topics:

  • Address authentication challenges in the cloud or on-premises
  • Systematically protect apps with Azure AD and AD Federation Services
  • Power sign-in flows with OpenID Connect, Azure AD, and AD libraries
  • Make the most of OpenID Connect’s middleware and supporting classes
  • Work with the Azure AD representation of apps and their relationships
  • Provide fine-grained app access control via roles, groups, and permissions
  • Consume and expose Web APIs protected by Azure AD
  • Understand new authentication protocols without reading complex spec documents

About the Author:

Vittorio Bertocci is a Microsoft Principal Program Manager responsible for developer experience related to identity services, both on premises and in the cloud. As Architect Evangelist at Microsoft, he spent several years helping major enterprises build advanced identity solutions based on new Microsoft technologies. He frequently speaks at international events such as TechEd, PDC, Build, and Ignite, and he blogs on identity topics at www.cloudidentity.com. His books include Programming Windows Identity Foundation.

You can check more information about this Book at: Link