#MSIgnite 2017: BRK1039 - Windows Server Software Defined

BRK1039 - Windows Server Software DefinedThe fastest route to the benefits of hyper-converged infrastructure WinSrv 2016, “Most cloud ready OS”, “Security” etc Talking about how WS2016 makes it possible to define Network, Compute and Storage in software, as virtual machines/Applicances. WSSDMicrosoft defines reference architecture, Solution vendors make and certify hardware packages, customers use and get rekommendations from Microsoft and vendors. Benefits Pre-validated Partner validated against reference architecture Time to value Up and running quickly Optimized OOB Less guesswork Tuned for the hardware solution Hardware Choice Select best match from vendors Converged StorageVMs on SMB3 on S2D on SOFS Cluster

#MSIgnite 2017: GS01 - Microsoft for the Modern Data Estate

GS01 - Microsoft for the modern data estateSep 25, 2:15 pm – 3:30 pm Quick Notes Massive and growing amounts of data. Companies that out-develop themselves. Some companies have learned to leverage and gain from the data, like Honeywell, DocuSign and Jet. Hybrid is the way to go. Quick hands-up: Almost no companies believe all-public is even possible Almost all see a hybrid solution is the thing. SQL 2017 GA 2017-10-02: Available on: Windows Linux Docker Kubernetes… *applause* Gives superb compatibility over many platforms and distributions. 2+ million docker pulls. Lots of focus on performance and security. has the smallest amount of vulnerabilities. Only commercial dB with AI built in. R and Python support OOB. BI included in license; web, desktop and mobile. Support for graph data and queries. Advanced machine learning with R + Python. Native TSQL scoring. Adaptive query processing and Automatic plan correction. Special pricing (30%) for SQL on Red hat Azure SQL Managed Instance Like a SQL instance on premise, in the cloud. without the server. Easy to migrate as it’s the same thing. Management using the same tools as always. SQL SA customers get discounts on Azure SQL. Other stuff Vulnerability assessment for GDPR. Intelligent insights into performance.

#MSIgnite 2017: TK01 - Create a Modern Workplace with Microsoft 365

TK01 - Create a modern workplace with Microsoft 365Sep 25, 10:45 am – 12:15 pm UNSTRUCTURED NOTES AWARENESS NOTICE!Also written on phone, will come back and refine Arrived late due to escalators being bottlenecks.Something about 3d objects in office, PowerPoint.Showing a photo with mixed reality, rotating 3d-space. OfficeWindows Inkdeleting stuff with pen, highlights etcSeems fairly intuitive. Would like to test soon. Wordaccessibility, colour blindness, proofing with patterns.language improvements. suggestions about better wordings. ExcelConnects to external data sources, trying to figure out context and provide help.

#MSIgnite 2017: KEY01 - Vision Keynote

KEY01 - Vision KeynoteSep 25, 9:00 am – 10:00 am UNSTRUCTURED NOTES! Also, mixed Swedish and English, sorry for that.Will update at a later time O365, all in one place…Live sändning med AI översättning.What’s the actual purpose of technology, why do we do this? How can we use it to do better. how to ensure privacy while at it.how do we give the power of technology to everyone?Assume everything will be multi device.serverless computing, edge distribution, management.Empower, Engage, Optimize, Transform. Microsoft 365 (not Office).Mixed reality. Holo lens, Oasis Headsets.Holo lens cameras for presentation, on github.Notes saved with spatial information for review.Microsoft mixed reality headsets.Conversations can be replayed and reviewed in teams. Microsoft graph is extensible, for example with LinkedIn.Outlook connected LimkedIn, better searches for… everything?Bing for business, can search graph as well.Nice integration with any applications extending graph. Pairs well with machine learning and AI/Fuzzy Search to parse both data and meta data on context. Admin portal gives insight and analytics into what’s searched for further optimization. Also connects with Cortana. Business applicationsDynamics 365. Also extends graph.AI First. Virtual Agent demo. App&Infra / AIAzure. Intelligent Cloud, intelligent creativity.Machine reading and comprehension. Quantum computing… ?MS seems to be trying hard to build one.VS gets tools for developing and debugging and testing qbits.

Set-SCOMMaintenanceMode Deluxe ed. [#opsmgr #powershell]

Untimely, perhapsWhile most of us are waiting for SCOM 2016 RTM to be generally available i’ve completely forgot to blog about my little Set-SCOMMaintenanceModeDeluxe.ps1 script I wrote a while ago. It is pretty much a small extension to the regular Set-SCOMMaintenanceMode cmdlet that allows you to set Computers, Groups or specific Windows Services into maintenance mode.I have yet to make it a proper module (although I have promised myself to do so) so you’d still have to manually download the script and execute it the old-fashioned way. I’ve uploaded it as a public gist on github, so feel free to add adapt it to your needs. Here’s the gist

Resize all images in a Word document with #vbs #macro

TLDRQuick and dirty macro to resize all images in a word document to 145 mm. I am lazy like that. Get the gist of it here. The “Why”Ok, so. I am a consultant, as you may know. And as a consultant, people pay me to do stuff and expect me to be efficient and deliver with high quality.Part of that entails writing documentation containing how I do stuff, where I do it and often why I do it.This documentation is expected to be detailed enough to make sure my customers will be able to follow the steps and produce a copy of my work. Most of the timethese document are a big part of the disaster recovery processes and might have to be executed by the on-call staff with no previous knowledge of the product. This means screenshots. Lots of screenshots.And while templates are nice and help me out a lot, the screenshots have to be from the actual installation and not some copy-pasta from a previous assignment.To help me out, I use the excellent free program Greenshot to quickly generate screenshots into a WIP-folder (or directly into Word if that is appropriate) and that makes it possible tograb snapshots of the process without having to pause all the time to PrtScn-Alt+Tab-Ctrl+V-Crop-Ctrl+C-Alt+Tab-Ctrl+C. I simply press PrtScn and go on with the installation. Being a bit pedantic, doesn’t help me out here though as I find myself selecting and resizing all the images in the Word document I have produced. This is a very time-consuming process and not the most exact one either.I want all images to be of scaled, if necessary, to an equal maximum width that fits comfortably withing the margins of the document template my company has prepared for me. So I created a fairly simple macro to do it for me. The “How”If you are un-familiar with macros in Word, you will find them under the “View” tab.Clicking on “Macros” will give you the option to execute the ones you have, or you can create your own using VBA (Visual Basic for Applications).To create one, select where you want it saved (normal.dotx in my case, as I want it readily available) and enter a name for it.This will bring up the Visual Basic for Applications IDE, where you can write your own fun stuff.

PoSH Grid Dashboard for RDSH [#opsmgr]

TLDRCustomer wanted to see all RDS Host servers in a view with their current total session count. Decided to use a powershell grid dashboard, and share the script. Here’s the gist of it: SCOM_RDSH_TotalSession_PoSHWidget.ps1 How ToKeeping it fairly short this time. Pre-requisites are: System Center 2012 R2 with UR2 or later Microsoft RDS Management Pack Microsoft Windows Core OS Management Pack Create a dashboard Rightclick and create a new view somewhere, make it a Dashboard View Enter Name and Description Select Grid type, and layout

In transit, again

We’re moving!Yep. Again. Although, it’s been a year or two since the last time. The reason(s)Ok, so I’ve using Wordpress for quite a long time now and it’s been good. Mostly.It’s a fairly solid platform and has a whole slew of feautures that work nicely. Before Wordpress I used Textpattern, a very slimmed, minimalistic authoring experience and my first contact with textile andsimilar markup/writing/notation languages. For those unaware, textile is not unlike markdown.Or should we say that markdown is not unlike textile? Considering that textile was invented by Dean Allen two years before markdown.Anyhow. Both work pretty much as good as the other, allowing the author to write in any text-editor, using easily readable and fairly logical formatting. Before that I used Movable Type, and prior to that either Dreamweaver or… well, notepad or vim. Problem with all of those platforms, however, is that they require dynamically generated webpages and technologies like PHP, Perl, .NET, Java and whatnot.That, in itself, has been a very minor issue until lately. Sure, it requires servers with logics, engines, add-ons, execution rights to the local filesystem etc, butstill a minor nuisance. Mostly a financial nuisance really as active servers tend to cost money while finding static hosting for free is still pretty easy.Hell! I could put a webserver on a RaspberryPi and get good performance for a small-ish blog like mine if all I am using is static content. But, again. Not a major problem in itself. The main instigating factors to move away from Wordpress are the increasing size of the package, the lack of personal control,the lack of ease to extend my platform due to ever-expanding APIs and the fact that it is so popular that every “hacker” and it’s mother knows how to find exploits on it.My webhost, NFSN has been very good at detecting probing and brute-force attempts and automatically block public access to stuff like the login-pages and XML-RPC interfaces when that happens.I am just so sick and tired of having to constantly be on top of it with software updates, plugin updates, theme updates, security updates, spam-filtering, re-enabling the login page… Back to the basicsTeknoglot.se will be served statically from now on, and it will be hosted for free on Github Pages.Using Hexo.io I can write my posts using markdown, then with a simple hexo generate --deploy generate and update the static files and publish them.No login pages to hack, no dynamic pages to exploit, no server security to worry about.

Event Id 4001 – “Cannot Add Type” in [#SQL] MP for [#OpsMgr2012]

Was troubleshooting this little error message for a customer after deploying the SQL Server Management Pack version The event is the generic “Health Service Script” with id 4001. Management Group: REDACTED. Script: Main Module: CPUUsagePercentDataSource.ps1 :Computer Name = "REDACTED.redacted.com" WMI = "ComputerManagement11" Service Name = "MSSQLSERVER" SQL Instance Name = "MSSQLSERVER"Error occured during CPU Usage for SQL Instances data source executing.Computer: REDACTEDReason: Cannot add type. Compilation errors occurred.Position:256Offset:21Detailed error output: Cannot add type. Compilation errors occurred.--------(0) : No source files specified(1) : using System;--------(0) : Source file "C:\Windows\TEMP\njdqtgfb.0.cs" could not be found(1) : using System; There are some known errors to the version of the SQL management packs, and one of them does mention “Cannot add type. Compilation errors occured.”In a thread on the Technet Forums it was suggested that it has to do with rights, but focusing mainly on the SQL instance. What caught our eyes, however, was the fact that the script is using the C:\Windows\TEMP folder instead of its private one. And this seems to be because it is using a few .Net components that do some sort of JIT compilation.We took a quick look using procmon, filtered on C:\Windows\TEMP\ and yes indeed. The monitoring account used is trying to create and delete its temporary files in that very folder. A wild work-around appears!The work-around is simple, but cumbersome. Just make sure that the assigned RunAs account have read/write/delete rights on C:\Windows\TEMP.Now you just have to manage this on all your SQL-servers! (yaaaay)

OpsMgr 2012 R2 UR4 - Field Notes [#opsmgr]

Quick and unrefined notes on Update Roll-up 4 for System Center 2012 R2 -Operations Manager PreparationThe usual routine applies. Check the KB for instructions and take not ofknown issues. Check if Kevin Holman has written something about it. As thisis an update roll up, I pre-emptively expect that gotchas in UR3 mayapply. Remember to open the update catalog in IE as the downloader is notworking in other browsers. Download, unpack, toss what languages that does not apply to your organization. It is advised to disable any mail-generating alert subscriptions during theupgrade process to avoid unnecessary spammage. Issues - So Far[updated: 2014-11-03] Got a few problems with cross-platform monitoring templates not working after the update. This was due to missing files in the update package. Make sure you download the updated version! Have not updated a customer using gateways yet, so unless theyhave fixed the issues in UR3, expect an update to this section soon. Planning