Start learning Azure SQL

There is a new learning scenario for Azure SQL – starting today. I got that hint from Anna Hoffmann – and I think they produced really great stuff. Especially have a look at the Channel 9 Bootcamp – with the option to get questions answerd by Microsoft directly.

After completing the video series, learning path, or workshop, you will have a foundational knowledge of what to use when, as well as how to configure, secure, monitor, and troubleshoot Azure SQL. 

They provide a learn Azure SQL landing page and some more resources to mention

  1. Microsoft Learn: Azure SQL Fundamentals http://aka.ms/azuresqlfundamentals – 6 course learning path
  2. Youtube: 61 Youtube videos http://aka.ms/azuresql4beginners
  3. Github: 1-2 day workshop Azure SQL including hands-on labs https://aka.ms/sqlworkshops
  4. Channel 9 Live Bootcamp from 17th August to 20th August 4PM – 6PM GMT. http://aka.ms/azuresqlbootcamp
  5. Official announcing tweet
Anna Hoffmann and Bob Ward

PowerShell 7 launch Austria

We’ve had a great PowerShell 7 launch in Austria. See PS7 launch Event Nachlese for more details or see the event video.

Ready for the launch
Steve Lee answering questions

The PowerShell Team also made 10 really good videos for the event. So I really want to mention them:

I hope to see you on future events @ expertslive.at.

PS7 launch Event – #PSUGMUNICH

We, the PowerShell Usergroup Munich, had our first online only Meeting. And it was great! Thank you Sydeny!

I tried to save the hints we got during the session in this Blog Post – it was written while the meeting happend – so there is not too much text.

First: Vote for more than 4 concurrent video streams (Link)

Q&A with Sydney Smith

PowerShell 7 Module Compatibility

Online PowerShell 7 Infos

PowerShell to EXE

Download Ignite

Download all Ignite Sessions with PS7:

Secret Management

Two articles about Secret Management with PS7.1 and above

Jupyter Notebooks

Error View

Link

Azuer Learning

The Barman Microsoft Teams background

ITNetX Service Manager Portal tells “no rights”

After a boot yesterday the ITNetX System Center Service Manager Portal was no longer available. The Website only returned, there are no rights – even as administrator.

The error message – as text at the bottom of this post

The Solution

In the Internet Information Server I changed the Application Pool to .NET CLR Version 4 – restarted IIS and the Website was back again.

Error message as test (english)

You do not have permissions to access this item or perform the requested task. If you believe you receive this message by mistake, please contact your administrator.
Show more… Copy for itnetX Support

Attempted to perform an unauthorized operation.
•Stack Trace
•Request

at System.Security.Principal.WindowsIdentity.get_AuthenticationType() at itnetX.ITSMPortal.Models.SDK.SdkService.RunImpersonated[T](Func`1 action) at itnetX.ITSMPortal.Models.SDK.SdkService.get_IsEndUserOnly() at itnetX.ITSMPortal.Helpers.MVC.TagHelpers.ModeselectorTagHelper.Process(TagHelperContext context, TagHelperOutput output) at Microsoft.AspNetCore.Razor.TagHelpers.TagHelper.ProcessAsync(TagHelperContext context, TagHelperOutput output) at Microsoft.AspNetCore.Razor.Runtime.TagHelpers.TagHelperRunner.d__0.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at AspNetCore._Areas_EndUser_Views_Shared__EndUserHeader_cshtml.d__48.MoveNext() in /Areas/EndUser/Views/Shared/_EndUserHeader.cshtml:line 10 — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.Razor.RazorView.d__14.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.Razor.RazorView.d__13.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.ViewFeatures.HtmlHelper.d__60.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.ViewFeatures.HtmlHelper.d__57.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.Rendering.HtmlHelperPartialExtensions.Partial(IHtmlHelper htmlHelper, String partialViewName, Object model, ViewDataDictionary viewData) at AspNetCore._Areas_EndUser_Views_Shared__LayoutEndUser_cshtml.d__143.MoveNext() in /Areas/EndUser/Views/Shared/_LayoutEndUser.cshtml:line 62 — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.Razor.RazorView.d__14.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.Razor.RazorView.d__13.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.ViewFeatures.ViewExecutor.d__18.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.ViewResult.d__26.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.d__32.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.d__31.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.d__29.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.d__23.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.d__18.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Builder.RouterMiddleware.d__4.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Localization.PortalRequestLocalizationMiddleware.d__5.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Session.SessionMiddleware.d__9.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Microsoft.AspNetCore.Session.SessionMiddleware.d__9.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at itnetX.ITSMPortal.Helpers.ExceptionMiddleware.ExceptionGeneralMiddleware.d__4.MoveNext()

General info:
Method GET
URL /
Query

Headers:
Connection Keep-Alive
Accept text/html, application/xhtml+xml, /
Accept-Encoding gzip, deflate
Accept-Language en-US,en;q=0.5
Host servicedesk.bbrz-gruppe.at
User-Agent Mozilla/5.0 (Windows NT 6.3; WOW64; Trident/7.0; rv:11.0) like Gecko
MS-ASPNETCORE-TOKEN c7873e84-107d-487e-ae85-8e634bb73057
MS-ASPNETCORE-WINAUTHTOKEN 444
X-Original-Proto http
X-Original-For 127.0.0.1:49304

Copyright © itnetX AG. All rights reserved v.3.7.5

Error Message as Text (german)

Sie haben keine Berechtigung, auf dieses Element zuzugreifen. Für weiterführende Informationen kontaktieren Sie bitte den Administrator.

Attempted to perform an unauthorized operation.

at System.Security.Principal.WindowsIdentity.get_AuthenticationType() at itnetX.ITSMPortal.Models.SDK.SdkService.RunImpersonated[T](Func`1 action) at itnetX.ITSMPortal.Models.SDK.SdkService.get_IsEndUserOnly() at itnetX.ITSMPortal.Helpers.MVC.TagHelpers.ModeselectorTagHelper.Process(TagHelperContext context, TagHelperOutput output) at Microsoft.AspNetCore.Razor.TagHelpers.TagHelper.ProcessAsync(TagHelperContext context, TagHelperOutput output) at Microsoft.AspNetCore.Razor.Runtime.TagHelpers.TagHelperRunner.<RunAsync>d__0.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at AspNetCore._Areas_EndUser_Views_Shared__EndUserHeader_cshtml.<ExecuteAsync>d__48.MoveNext() in /Areas/EndUser/Views/Shared/_EndUserHeader.cshtml:line 10 — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.Razor.RazorView.<RenderPageAsync>d__14.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.Razor.RazorView.<RenderAsync>d__13.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.ViewFeatures.HtmlHelper.<RenderPartialCoreAsync>d__60.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.ViewFeatures.HtmlHelper.<PartialAsync>d__57.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.Rendering.HtmlHelperPartialExtensions.Partial(IHtmlHelper htmlHelper, String partialViewName, Object model, ViewDataDictionary viewData) at AspNetCore._Areas_EndUser_Views_Shared__LayoutEndUser_cshtml.<ExecuteAsync>d__143.MoveNext() in /Areas/EndUser/Views/Shared/_LayoutEndUser.cshtml:line 62 — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.Razor.RazorView.<RenderPageAsync>d__14.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.Razor.RazorView.<RenderAsync>d__13.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.ViewFeatures.ViewExecutor.<ExecuteAsync>d__18.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.ViewResult.<ExecuteResultAsync>d__26.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeResultAsync>d__32.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeResultFilterAsync>d__31.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeAllResultFiltersAsync>d__29.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeResourceFilterAsync>d__23.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeAsync>d__18.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Builder.RouterMiddleware.<Invoke>d__4.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Localization.PortalRequestLocalizationMiddleware.<Invoke>d__5.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Session.SessionMiddleware.<Invoke>d__9.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Microsoft.AspNetCore.Session.SessionMiddleware.<Invoke>d__9.MoveNext() — End of stack trace from previous location where exception was thrown — at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at itnetX.ITSMPortal.Helpers.ExceptionMiddleware.ExceptionGeneralMiddleware.<Invoke>d__4.MoveNext()General info:

Copyright © itnetX AG. All rights reserved v.3.7.5

Visiting ExpertsLiveEU

Visiting the ExpertsLiveEu this year with a datacenter automation point of view.

Image
The beginning…

On the way to the hotel I listened to Jeffrey Snover to get me in the mood. (O365 with Graph).

Image
PowerShell is everywhere, even in Vikings

First the news I’m focusing on are from System Center. Some people of the system center team have been to Prague. So what I’ve heard is, that we will get a System Center Update in spring 2020 – but it will not contain the 64bit update for Orchestrator – therefor you will still have to work around. But in the next larger release – the vNext – which will happen in two or three years (or like that), there will be this update. So this also means, Orchestrator (and System Center) will stay on the stage at least for 12 years. There is no urgent need to discuss a replacement here.

There will be some investment for new features in System Center Operations Manger (SCOM) an Virtual Machine Manger (VMM). It does not seem, there will be a lot in the other System Center products (beside SCCM, which is an other story)

So that are the System Center news I’ve heard.

In reference to the “System Center is dead”, Michael Ruüfli provoked with “Azure Automation is dead”. Microsoft employees in the room have denied this. Michael Ruüfli also compared Azure Functions with Azure Automation. In the end, both have their place in the Azure Cloud. Afterwards he presented an example with Microsoft Forms and Azure Functions – looked very exciting. (link)
What changes in Azure can be seen here: https://azurecharts.com/

Saw some other cool stuff, met lot’s of people and had a great time at the conference. Loved to be there. Thanks to Isidora and Marcel – they did a great job organising this conference.

Image
And of course we also took a photo with all Austrians.

SQL Days Munich

At the SQL Days in Munich I held a session about PowerShell in combination with SQL Server. I was thrilled with the event, the participants and the other trainers. It was a great event and I hope to be there again next year.

PowerShell loves SQL on SQL days conference

My participants asked me to put the PowerShell scripts on Github – I’m happy to do so – it’s the first session on Github, but I think some more will follow.

SCORCH XML Paramters

We use System Center Orchestrator with the Orchestrator Integration Pack. In this Integration Pack there is an Activity “Start Runbook”. Which worked like a charm – till now.

We use this “Start Runbook” activity to start a runbook with parameters. We can use any string parameter in any length except XML strings. If the XML Input gets too long, the call fails. (see screenshot below).

The Integration Pack is on Github, but there is no activity beside the initial upload.

MVP Awards 2019

Last year I found an amazing analysis of the MVP award numbers. (See here) I hope he will publish this analysis this year again.

I’d like to save the numbers, so here we go:

Category July 2018 July 2019
Development Technologies 780 644
Office Apps and Services 383 491
Azure 366 409
Data Platform 366 332
Cloud and DataCenter Management 302 232
Business Solutions 184 167
Windows Development 186 119
Enterprise Mobility 122 106
AI ? 84
Windows and Devices for IT ? 57
Office Development ? 47

So the two growing categories are Office Apps and Services and Azure.

(Data according to Patrick Guimonet and MVP Site)

Update: So there is a new site tracking MVP numbers. Have a look.