Pages

Wednesday, November 6, 2019

Ignite 2019 - TMS10 - What's new with Microsoft Teams: The hub for teamwork in Microsoft 365


Presented by: Anne Michels, Marissa Salazar

Session summary:
Join us to learn how Microsoft Teams, the hub for collaboration and intelligent communications, is transforming the way people work at Contoso. We showcase some of the big feature innovations we’ve made in the last year and give you a sneak peek at some of the exciting new innovations coming to Microsoft Teams. This demo-rich session highlights the best Teams has to offer!

My Notes:

A recap of what has been done since last Ignite and a look at what is coming next.

Studies show that it takes 23 minutes for an average worker to get back on track again once disturbed by "something else".

A video about how L'Oreal is using Teams to connect people and assets globally was shown.

Next, came demos (in order of appearance)

  • Priority notifications
  • Multiple windows
  • Announcement messages
  • Post in multiple channels
  • Pinning Teams
  • Read receipt
  • Sharing a conversation between Outlook and Teams
  • Yammer app pinned to the left rail
  • Tasks
  • Custom backgrounds
  • Message extension
  • Screen sharing
  • Meetings scheduling / Meet now
  • Whiteboard
  • App with Image recognition
  • App for approvals
  • Power BI in a tab
  • FLW Off-shift access
  • FLW Global sign-out
  • FLW Delegated user management
  • FLW SMS sign-in
  • FLW Patient Coordination
  • FLW Virtual Consults


 New message extensions coming to Teams.

Other news

Tuesday, November 5, 2019

Ignite 2019 - BRK009 - Microsoft Teams


Presented by: Jared Spataro

Session summary
If you are tasked with transforming workplace collaboration, this session is for you! Jared Spataro, CVP Microsoft 365, focuses on how Microsoft Teams can help you, sharing new updates in Teams, demonstrating how your peers are integrating their business processes with Teams, and discussing how to lead a successful deployment of Teams in your organization.

My Notes:
There are two main takeaways from this session.

  • How you can transform workplace collaboration.
  • Teams is a platform for apps and business processes.

"Teams is to the new Microsoft what Windows was to the old."

Next, came demos of chat, files, teams with external users, tabs and continued with the seven top new features requested by customers.

  • Private channels
  • Multiwindow experience
  • Tasks
  • Yammer app pinned to the left rail
  • Share a conversation between Outlook and Teams
  • Custom backgrounds
  • Live captions in meetings

Multiwindows are coming to Teams!

Four announcements on meetings

  • New devices - collaboration bars
  • Cloud Video Interoperability adding Cisco
  • Direct guest join, Zoom and Webex
  • Managed meeting rooms


Three management areas with improvements

  • Deployment of Teams - Advisor for Teams - step by step guidance to move workloads
  • Security & Compliance - ATP Safe Links in Teams, Audit log search, Information Barriers (ethical walls) also for filesharing, one-day retention policies
  • Manageability - PowerShell, bulk updates with single commands. A certified app catalogue linked from the Admin center. MTR management in the Admin center. 


Teams as a platform, there are now engineering resources available to go out to customers to find opportunities to simplify with Teams.

First Line Workers

  • Shift digitizes the classical work schedule board
  • Taking pictures, annotate and the picture will not be stored on the device.
  • Record and send an audio message.


New features coming in Shifts are

  • Delegated user management
  • SMS sign-in
  • Global sign-out
  • Off-shift access


Customer videos featuring KONE, Uniper, Wavemaker, Clifton, St Lukes, M&S and Fedex. Telstra from Australia came on stage and talked about how they are using Teams FLW solutions.


So much more news from the first day of Ignite...

Monday, November 4, 2019

Microsoft Ignite 2019 - Keynote

Satya Nadella started with welcoming and thanking the 30,000 people who made it to Ignite or was listening in remote. The keynote was about "Tech Intensity" = (Tech Adoption X Tech Capability)^trust. It started out with discussing the Intelligent cloud and Intelligent edge and how it "empower every person and every organization on the planet to achieve more".

Microsoft will start building 100% renewable energy, Zero-waste operations datacenters and is starting with the ones in Sweden!

The Swedish DCs will be great, and clean!

Satya went on in high speed talking about.


63 minutes Microsoft Teams were first mentioned in the keynote

Teams is "The hub for teamwork" with Private Channels and Multiwindow coming now.

Project Cortex - takes data to knowledge and is used to enhance collaboration.
Introducing Project Cortex Project Cortex is Graph + AI + people + context that will build a knowledge network.

Demos of

  • AI to block out background noise
  • Eye gaze
  • Custom backgrounds
  • Intelligent content capture
  • Natural language search in Outlook
  • Image to table
  • Fluid framework
  • Surface laptop 3
  • Surface Neo & Duo coming late 2020

Teams in healthcare

  • Taking pictures that are not stored on the phone.
  • Patient experience app
  • Virtual consults

The future of the web - Edge and Bing - The new Edge browser built on Chromium and runs on iOS, Android, Mac and Windows 10 is faster, works with more webpages and have tracking prevention and inPrivate search. Demo of Bing searches that will not be stored in the engine and Searches in internal data using Graph API knowledge. The Release candidate of Edge is available now


And so much more news is sipping out of Ignite already…


Here are some of the news items mentioned in the article above.
  • Private Channels
  • Multiwindow
  • Teams client for Linux
  • New messaging extensions
  • Pinned Channels
  • New integration between Outlook and Teams
  • Tasks in Teams
  • Yammer app for Teams
  • Microsoft Whiteboard
  • Live Captions
  • New presenter and attendee controls
  • Citrix VDI
  • Cloud Video Interop (CVI) partnership with Cisco
  • MTR direct guest join capability to Cisco and Zoom
  • SMS Sign-In for FLW
  • FLW Off shift access
  • Graph API enhancements
  • New certified app catalogue
  • Safe Links in Microsoft Teams
  • Integrate Microsoft Teams and Power Platform
  • Power BI interactive cards
 
So much more…

Thursday, October 24, 2019

Swedish SQL Server User Group

Tonight I stepped out of my comfort zone and joined a meeting with the Swedish SQL Server User Group. About 40 people joined the meeting in central Stockholm and people from Göteborg, Malmö and Helsingborg joined online via Zoom (hmmm...)

The main reason for me listening to this is that my cousin’s cousin Magnus Ahlkvist presented at the meeting.

Databases,beard and beer - does it get better than this?

Title: RBAR bad. Sets good.
Presented by: Magnus Ahlkvist (@MagnusAhlkvist)

Session summary:
In this session, I will go over some way too common uses of RBAR (Row by Agonizing Row) processing and show different examples of how they can be replaced with a set based approach. We will look at performance comparisons and talk about code maintainability. Most of the examples are war stories from my 20 years working with databases. Unfortunately, many of the bad examples come from my own code. Fortunately, many of the good examples also comes from my own code, fixing the bad code.

My Notes:
RBAR stands for "Row By Agonizing Row" and means we did not do something in an optimal way. We should not deal with a database row-by-row rather by set-by-set.

RBAR by T-SQL loops

Don't do loops in T-SQL

Populating 1000 rows with weekdays using a loop took 812 ms with some example code.

Using Tally Tables and window functions the same operation (or result) took 505 ms.

Running all commands in one single transaction brought down the time to 16 ms.

RBAR by T-SQL functions

To split strings have been tricky with T-SQL, but in SQL Server 2016 a STRING_SPLIT function was added. T-SQL is not an optimal language to do string manipulations.

RBAR in optimization plans

The session was basically several demos of T-SQL code explaining how to optimize the code to make the queries run faster and more efficient. Even though I did not understand all the examples and all the code the presentation and demos seemed very appreciated by the audience present.

If you would like to look at the scripts in detail you can find them at Magnus blog.

Good job Magnus!

After the session we had a good time hanging with some hardcore DBA nerds telling jokes such as: In the nineties everyone was chatting on IRC - except Lotta who was using UTF-8 (it only makes sense in Swedish - but it was super funny!!!)