Get Hygge with it – Your 5 Step Guide to #ESPC18

ESPC18-Speaker-Graphic-Jennifer

I’m excited to be presenting at the European Sharepoint, Office365 and Azure Conference in Copenhagen on 26th – 29th November. The conference has great content delivered by Microsoft MVPs, Regional Directors and Microsoft team members. It’s a great place to get all of your Microsoft content and news to help you with your current technical estates, as well as plan for the future. I’d recommend attending since it is THE European conference for these topics and there are thousands of attendees going along to learn, so why aren’t you?

BOOK YOUR TICKET today and use coupon code ESPC18SPK to receive a €100 discount.

I’m delighted to be giving the Artificial Intelligence keynote: Artificial Intelligence: Winning the Red Queen’s Race.

To help you to navigate the conference, here’s a set of handy tips. I hope to see you there!

PLAN Your Sessions

Explore the ESPC18 SCHEDULE to identify what sessions you’d like to attend. Create your own schedule suited to you. If you are travelling with colleagues, divide and conquer by  attending different sessions. Afterwards swap notes to increase your learning.
Don’t have time to delve through our 120+ conference schedule? We have created dedicated pages to save you time. Check out the ESPC conference schedule based on IT PRODEVBDMAZURE or MICROSOFT SESSIONS.

CONNECT with Your Peers

Join the ESPC18 App (Login details announced in the coming weeks) & follow the hashtag #ESPC18 to find out whose attending. Why not make your presence known by sending out a tweet introducing yourself. Arrange to meet new individuals at ESPC – you never know what you might discover! Helpful tip: Carry some business cards with you to share with the new people you meet.

LEARN, Learn, Learn

Before arriving at ESPC, take some time to identify what questions you want answered. Prepare them advance to ask during a session Q&A. Why not take a break from sessions and advance your skills at the ESPC labs or check out the Ask the Experts session. Remember, it’s good practice to note three important key takeaways from each session.

Have Fun

With 2,000 delegates expected to attend, ESPC offers a host of exciting day and night experiences. Check out the WOMEN IN TECHNOLOGY LUNCH, a jam packed EXPO HALL or challenge other delegates and the ESPC team to some fun games in the Community Area.
Not enough? Be sure to join the EXPO drinks on Tuesday evening or enjoy a magical night at the sell-out ESPC18 PARTY: A NIGHT AT THE CIRCUS.

SHARE with your Team

Schedule a meeting post conference to share your key learnings with your fellow co-workers. Impress colleagues with your advanced knowledge while maximizing value for your company. Share your inspiration and make plans to implement what you learned.

Still undecided about attending The leading European SharePoint, Office 365 & Azure Conference? Visit 10 REASONS TO ATTEND ESPC18 to see why you need to be there.

BOOK YOUR TICKET today and use coupon code ESPC18SPK to receive a €100 discount.

Microsoft Ignite interview with Kevin Farlee on Azure SQL Database Hyperscale

Azure SQL Database is introducing two new features to cost-effectively migrate workloads to the cloud. SQL Database Hyperscale for single databases, available in preview, is a highly scalable service tier that adapts on demand to workload needs. It auto-scales up to 100 TB per database to significantly expand potential for app growth.
What does this mean? It’s one of the most fundamental changes to SQL Server storage since 7pm. So this is big: big news, and very big data stores. I am very lucky because I got to interviewe Kevin Farlee of the SQL Server team about the latest news, and you can find the video below.

I am sorry about the sound quality and I have blogged so that the message is clear. When I find the Ignite sessions published, I will add in a link as well.
What problem are the SQL Server team solving, with Hyperscale? The fundamental problem is how do you deal with very large databases in the cloud. VLDBs is the problems that people want to do with normal operations. All the problems with VLDBs occur due to the sheer size of data, such as backups, restores, maintenance operations, scaling. Sometimes these can take days to conduct these activities, and the business will not wait for these downtimes.  If you are talking tens of terabytes, that takes day and ultimately Microsoft needed a new way to protect data and VLDBs. The SQL Team did something really smart and rethought very creatively on how they do storage, in order to take care of the issues with VLDBs in the cloud.
So, the Azure SQL Server team did something that is completely in line with one of the main benefits and key features of cloud architecture: they split out the storage engine from the relational engine. Storage implementation was completely rethought and remastered from the ground up. They took the viewpoint over how you would go about architecting, designing and building for these solutions in the cloud, if you were to start from scratch?
The Azure SQL Server database team did a smart thing: Azure SQL Server is using microservices to handle VLDBs.
The compute engine is one microservice which is taking care of it’s role, and then another microservice that is taking care of the logging, and then a series of microservices that handle data. These are called page servers, and they interface at the page level. The page servers host and maintain the data files. Each page server handles about a terabyte of data pages. You can add on as many as you need.
Ultimately, compute and storage are decoupled so you can scale compute without moving the data. This means it’s possible to keep adding more and more data, and it also means that you don’t have to deal with the movement of data. Moving data around when there are terabytes and terabytes of data isn’t a trivial task. The page servers have about a terabyte of data each, and the page servers have about a terabyte’s worth of SSD cache.
The ultimate storage is Azure Blob Storage, because blob storage is multiply redundant and it has features like snapshots, so this means that they can do simultaneous backups by just doing a snapshot across all of the blobs. This has no impact on workload.
Restores
Restores are just instantiating a new set of writeable disks from a set of snapshots, and works with the the page servers and the compute engine to take care of it, working in symphony. Since you’re not moving the data, it is faster.
I’m personally very impressed with the work that the team they’ve done, and I’d like to thank Kevin Farlee for his time. Kevin explains things exceptionally well.
It’s worth watching the video to understand it. As well as the video here, Kevin goes into detail in his Microsoft Ignite sessions, and I will publish more links when I have them.
Community
One advantage in doing the MIcrosoft Community Reporter role is that I get to learn from the experts, and I enjoyed learning from Kevin throughout the video.
It seems to me that the Azure SQL database team have really heard the voice of their technical audience and they’ve worked passionately and hard to tackle these real life issues. I don’t know if it is always very clear that Microsoft is listening but I wanted to blog about it, since I can see how much the teams take on board the technical ‘voice’ from the people who care about their solutions, and who care enough to share their opinions and thoughts so that Microsoft can improve their solutions.
From the Azure architecture perspective, it works perfectly with the cloud computing concept of decoupling the compute and the storage. I love watching the data story unfold for Azure and I’m excited by this news.

Microsoft Ignite interview with Executive Team on #ArtificialIntelligence, #Data, #OpenSource and #Cloud

There were a number of announcements across Azure Data + AI at Microsoft Ignite, and Im delighted to say that I had the opportunity to interview Rohan Kumar, Corporate Vice President, Azure Data at Microsoft, and Eric Boyd, Corporate Vice President, AI at Microsoft.

In the interview, Rohan Kumar and Eric Boyd give their opinions and thoughts to myself and Cathrine Wilhelmsen on the big picture across Data & AI.  I was super excited since it was the first time that these Microsoft executives had been interviewed together and I was particularly interested to see how Rohan and Eric cross-reference each other’s areas. It’s clear that they are working in orchestration as a team, and I’m glad to see that because I do see that data and Artificial Intelligence impact one another so much.

Rohan and Eric talk about the announcements that excited them both, and there was also a good discussion on the role of Open Source at Microsoft, and what role it plays in Microsoft’s Data and Artificial Intelligence story.

There was a great discussion on Eric and Rohan’s thoughts on its role in making insights, Artificial Intelligence and insight-driven analysis real for organizations. Every organization on the planet has got data, and Microsoft are carving a path for the organizations that want to make use of it.

I’m personally interested in Amara’s Law, which states that “We tend to overestimate the effect of a technology in the short run and underestimate the effect in the long run.” So I was interested in Rohan and Eric’s perspectives on what aspects of AI are real versus hype. What is Microsoft doing to make AI real and actionable for customers?

amara

We wrapped up with a great conversation on the Microsoft and Facebook collaboration?, which I personally find interesting.

It was  real life-achievement for me to participate in the Microsoft Ignite Community Reporter team, and it was a real achievement for me to interview the Microsoft Executives. I’d like to thank Rohan Kumar and Eric Boyd for their time and for sharing their wisdom and insights.

I was also glad to be on board with Cathrine Wilhelmsen. Cathrine was a wonderful friend and support throughout the week and she’s not just an expert in her domain, but she’s a very giving person in terms of her friendship and support. So the interview holds special meaning for me since I was glad to have the opportunity to work with her.

Learnings and Takeaways from my #Diversity and Inclusion Unconference at Microsoft Ignite #MSIgnite

On Thursday 27th September, I held an Unconference at Microsoft Ignite which was aimed at Diversity and Inclusion. I was incredibly lucky to be supported by the Diversity and Inclusion initiative by Microsoft, who have put it at front-and-centre of everything that they do. Although it is only one event, I was told that my event had the highest proportion of male attendees at the event. I had 80 people turn up in the end, and I was too busy facilitating the conference to take a note for myself but I was pleased that everyone turned out to join us. I want to say thank you to everyone who attended.

Introducing Collaboration through an Unconference

The Unconference really means that people can engage, connect and share themselves rather than having a speaker talk to them. It’s collaborative and energetic, with a free-form fluid style. There are lots of different ways to implement it, and you can find more information on how to prepare an Unconference for yourself here.

Diversity and Inclusion Unconference

To encourage participation, I didn’t want to use a traditional top-down lecture session and I wanted to have a collaborative, open, honest and innovative event that meant people would have a great time meeting other attendees, plus engage with each other. Ignite is a large event at 30,000 people and it is very easy to get lost, and not talk to anyone all week. Unconferences are a more relevant, engaging, and interactive event format.

It also means that there is room for the introvert, the extrovert, or for people who don’t feel that they have got anything to say. Feeling ‘idealess’ is horrible and it’s important for people to learn about diversity, so I wanted to create a space for people who felt awkward about contributing as well as those who were happy to take centre stage. Ultimately, I wanted people to feel as if they could be themselves.

How did I do it? Here are some practical takeaways for you to try at your own events. I learned from Jackson Katz, a prominent Diversity speaker who gives a message which resonates strongly with me. I have put Jackson Katz’ Ted Talk here because he gives very strong messages about gender violence. As a survivor, it was initially very important to me that a gentleman spoke out, because people will listen to him in a way that they won’t listen to me, and I’d like to thank Jackson Katz for his work. Katz posits that the language of diversity can mean that white men get erased from a conversation that fundamentally includes them, too.

Diversity can be perceived as a women’s issue that some good men help out with. We need to change that.

Diversity impacts everyone and it is the only thing that we have in common. By focusing on women, it can mean that men get an excuse not to listen. The gentlemen who take the excuse not to listen are the ones that we want to reach.

Ensure your Abstract is aimed at Everyone: Not just Women

My title was called: Diversity and Inclusion: Why is it important, and what can we do about it? The abstract went as follows:

For people who want to build careers and manage teams, it is crucial to understand diversity and how it impacts your organization. Increasing the role of women in technology has a direct impact on the women working in hi-tech, but the effects can go far beyond that. How do female tech workers influence innovation and product development? How do men benefit from having more women working in technology? Can the presence of women in tech affect a company’s profit? Join a lively discussion on diversity, and hear proactive steps that individuals and companies can take in order to make diversity and inclusion part of the organizational DNA.

Be Inclusive – and that means men, too

I talked about being proactive, and what we could do. I believed that this language would speak to men and women alike. Speaking with men, they often ask what they can do to help and they want proactive prescriptive steps. They can sometimes feel that they can’t help in any diversity scenario since they don’t know what to do, or how to start. By putting this in the abstract, my intuition was borne out by having so many men turn up by making them feel included. I was helping them by giving them something actionable that they could do, and making diversity accessible through steps and sequences and patterns to follow.

Don’t make it into a Pity Party

Some WIT panels can turn into a pity party where we talk about how terrible everything is, and that’s the only topic on show. I have had some awful experiences and I am not meek in sharing them. However, I don’t feel I need to rail on about it, because that can make people feel that’s all I can talk about when, in fact, I talk about technology and successful projects and solutions instead.  So try to be balanced; Explain why it’s important, but also make sure that the topics cover solutions, too.

Topics we covered

We focused on women in technology, and the conversations naturally moved onto issues of colour, and particularly issues for women of colour. Since it was an Unconference, the topics move along naturally and it was great to see that the attendees took the Unconference idea to heart, and they ran with it. The summary was as follows:

The attendees believed that STEM Programs in schools would help to encourage everyone into science and tech.

At work, we should take a risk in getting to know and work beside people who are outside of our groups. This means right from the recruitment steps, and organizations can ‘screen in’ candidates rather than ‘screen out’ – for example, by giving room and doing a second run through CVs for evidence of soft skills.

We should also give support, and build people up; not tear them down. Women can view each other as competitors, and we need to create a safe culture and honestly support each other. Teach often, and teach early.

Some people suggested books to read, and here are a few. Click on the book to go to Amazon:

41lwsxm9npl-_sx331_bo1204203200_
51nizqflvjl-_sx322_bo1204203200_

 

I recommend the Invisible Man since it is incredibly powerful; it is an American classic, actually.

I haven’t read Whistling Vivaldi but it is my Audible audiobook this month.

Things I’d change for next time

I needed a scribe who would take notes for the Unconference. A scribe would have helped to keep note of the ideas.

I would have loved an artist to draw up the ideas as we went. One of my keynotes (held at a private, invite-only industry event held by a partner organization of Data Relish) actually had an artist, and he drew my keynote speech as we went along. It was amazing!

Conclusion

I believe that the Unconference seems to really work for Diversity and Inclusion topics, and the session feedback so far has been awesome. If you have any questions or thoughts, please leave a comment and I’ll be glad to hear from you.

 

 

 

 

 

 

Roundup of Azure #CosmosDB Sessions at #MSIgnite

If you are at Microsoft Ignite this week in Orlando, FL, don’t miss these Azure Cosmos DB database sessions and all the Cosmic Announcements. Here’s a list of the Azure Cosmos DB sessions below. You can find out more details on Azure Cosmos DB sessions over at the Schedule Builder here.

Here’s a great slideshare presentation about Azure Cosmos DB over at SlideShare to help you get started.

Azure Cosmos Timetable.png

If you can’t make it to Ignite, be sure to watch the keynotes. You can be sure that there are great news and insights coming along, so be sure to watch!

What I’m doing this week at #MSIgnite

I’m delighted to say that I’m doing the Community Reporter role for Microsoft Ignite. This means I get to interview the Microsoft Executive Team, such as Amir Netz, James Phillips and Joseph Sirosh. I have complete stars in my eyes! I don’t often get the chance to speak with them so I’m delighted to get to do that. Also, they are very interesting and they have a lot to say on topics I’m passionate about, so make sure and tune in for those. I’ll release more details about times and how you can watch as soon as I can.

What does a Community Reporter do? During Microsoft Ignite, the Community Reporters will be your go-to’s for live event updates. If you aren’t attending the conference this year, these reporters will be a great way to see what’s happening on-the-ground in Orlando. Check out my content on my blog here and on Twitter and LinkedIn follow me on social to stay up-to-date on all things Microsoft Ignite!

I’d also like to meet some of you so when I get the chance, I’ll tweet out to see if any introverted people fancy sitting at a table with me for breakfast or lunch to talk about all things data.

I am also speaking at Ignite so here are the details:

When? Thursday, September 27 4:30 PM – 5:15 PM
Where? Room W330 West 2 

Artificial intelligence is popularized in fictional films, but the reality is that AI is becoming a part of our daily lives, with virtual assistants like Cortana using the technology to empower productivity and make search easier. What does this mean for organizations that are running the Red Queen’s race not just to win, but to survive in a world where AI is becoming the present and future of technology? How can organizations evolve, adapt, and succeed using AI to stay at the forefront of the competition? What are the potential issues, complications, and benefits that AI could bring to us and our organizations? In this session, we discuss the relevance of AI to organizations, along with the path to success.

 

Microsoft Power BI, Microsoft R and SQL Server are being used to help tackle homelessness in London by providing actionable insights to improve the prevention of homelessness as well as the processes in place to help victims. Join this session to see how Microsoft technologies are helping a data science department to make a difference to the lives of families, by revealing insights into the contributors of homelessness in families in London and the surrounding area. Join this session to understand more about finding stories in data. The case study also demonstrates the practicalities of using Microsoft technologies to help some of the UK’s most vulnerable people using data science for social good.

When? Thursday, September 27 2:15 PM – 3:30 PM
Where? OCCC W222

For people who want to build careers and manage teams, it is crucial to understand diversity and how it impacts your organization. Increasing the role of women in technology has a direct impact on the women working in hi-tech, but the effects can go far beyond that. How do female tech workers influence innovation and product development? How do men benefit from having more women working in technology? Can the presence of women in tech affect a company’s profit? Join a lively discussion on diversity, and hear proactive steps that individuals and companies can take in order to make diversity and inclusion part of the organizational DNA.

One last thing!

Remember to download the Microsoft Ignite app to have your information handy on-the-go!

See you there!

 

 

Why I changed my mind about #PowerApps and became a fan… and why you should, too

This blog post title was initially titled ‘Why I disregarded PowerApps but now I radically changed my mind’. I changed my mind and I now think that PowerApps is a very powerful tool and basically it does a lot of the app form functions that Access does but way better. I get it now and I want to explain how I changed my mind about PowerApps.

PowerApps performs the same function as Access can do: building the business apps you need and extend or customize the apps you already use. Only, PowerApps does it way better because it has the robustness, scalability, security and performance of the Azure cloud with Office365 inbuilt in the app from the start.

In this blog post, I’ll set out where I think PowerApps fits in the business, and why it’s way better than Access. There are plenty of PowerApps templates but I hope that this post will convince you to give it a try.

TL;DR – I care about producing business-friendly solutions that are maintainable, robust, perform well, have potential for scale, and that I can hand off to an IT support team. PowerApps gives me these things. Access does not because it is not always backed up, or placed on a network so people can update it, and it is not always secured properly. So you can think about migrating your Access apps to Power Apps, for example. In this blog post, we will answer the following questions:

  • What can PowerApps do for you?
  • How do you get started with PowerApps?
  • What I’d like to see PowerApps do next

contact-icon
Any questions, please let me know or get in touch to schedule some time to talk further.

 

What can PowerApps do for you?

PowerApps allows you to design, create, use and share custom business apps with your team and organization. PowerApps installation means that you can use apps that have been shared with you, and it also means that you can create your own apps.

What kind of apps can you create? Intelligent laziness is very important! The automation of tasks means that you can focus on the activities that are more meaningful and add more value to the organization. If you are leading a team, then it means that you and your team can work wherever you happen to be, on any device.

What kind of apps can you create? Many Access forms could be redone in PowerApps since they involve data entry. Here are some examples:

  • Connect apps to your existing data, such as SharePoint, Salesforce, Dropbox, Google Drive and more
  • Create and update customer invoice, receipt and order forms
  • Create Helpdesk apps
  • Create Expense apps

As a BI person, I have spent time curing businesses from cottage industry Access databases and Access forms. Often, in my experience of rescuing Access databases and forms, I find that they proliferate through the business, usually unmonitored, untested properly and aren’t always production ready. They are often built in an ad-hoc fashion. In short, when I find some Access, I perform an internal sigh and I immediately start to mastermind it’s replacement. Access is often a the sticking plaster to solve a genuine business problem and it is quick to produce something quick. As Brent Ozar puts it, Access has Play-Doh factor. Yes, it’s an old post from Brent Ozar ( b ¦ t ) but it is still holding true.

play-doh-3308885_1920

So when I saw PowerApps at first, my reaction was ‘Oh no, it’s the new Access’. My initial vision was that developers would hate it, and I’d spend my life running around chasing after apps as well as Access to make them production ready.

So here’s what I found:

PowerApps has the IT guardian role built in

PowerApps solves the Access problem of scaleability, robustness and performance. PowerApps is built in Azure as part of Office365 so that means that Azure takes care of these factors for you. For me, this is a massive relief because I care about producing solutions that are maintainable, robust, perform well, have potential for scale, and that I can hand off to an IT support team. When I leave site, I want to leave with a job well done. I don’t intend to be there forever; it’s not what I do. So I like to enable others and bring people on a journey that they can continue without me. So what does PowerApps mean for the small business?

 keyboard-2553530_1920

PowerApps for the Small Business 

PowerApps is robust and secure. If you are using Access or Excel to run your business, then you should consider PowerApps. It provides a much more robust way for small companies to track data and projects than Excel or Word because it is in the cloud so you don’t need to worry about losing or screwing up your Excel spreadsheet of inventory, orders and so on. Also, it means that you can be more confident that your data is secure because it is in the cloud, and not on a USB.

PowerApps is mobile. It is also an easy way to mobilise apps as well. The functionality is built in. This is another big win over Access, in my book. This means that PowerApps has the most value added for tracking your organization in terms of projects, budgets, and growth.

PowerApps lets IT do their job more easily. PowerApps will give your IT people an easier way to manage your business-built apps rather than having them hidden on a laptop somewhere. PowerApps lets IT do their job, of being the guardian of the data and the IT function. It’s easy to maintain, which is idea for the organic business user turned power user turned ad-hoc techie. The idea of creating databases and trying to maintain them seems like an unnecessary use of resources; however, for small businesses, PowerApps creates a database for you so you can focus on what you need to do for your organization: managing growth and delivering success.

PowerApps has Play-Doh factor but in a good way. Creating apps in PowerApps allows a business to customize its own apps, thereby streamlining business processes. For example, you can use it to track crucial business information for each customer, including contact information, addresses, order information, invoices, and payments. Since it is in the Azure cloud, team members can access and update it, so the information can stay current and secured. Since the frm is a central idea to Power Apps, this helps small businesses ensure that employees enter data accurately and consistently so your data is cleaner at source.

How do you get started with PowerApps?

At a high level, here are the steps:

  • Choose from professionally designed templates to start quickly
  • Start with a blank canvas, and customize to suit your needs
  • Add business logic and intelligence using the power of Excel-like expressions
  • Create interactive visuals and media to build unique, professional apps

PowerApps is an easy jump for the BI Developer who already knows DAX. To create more custom apps, PowerApps has some object-oriented ‘formula’ that you can change, configure and set. It also has intellisense so you are guided to program correctly.

PowerApps is constantly being updated. For information about what’s new in this release, please see this topic: https://aka.ms/powerapps-releasenotes