We will present some of the best practices and our experience with Azure virtual machines with SQL Server in order to obtain the maximum performance of the SQL on Azure VM.
Check below the conference sessions schedule for Saturday, May 21st.
Accessing the session details page will allow you to browse the slide deck used for the session (if available). You can also browse all workshops and sessions in the full schedule page.
Embark with us on a voyage through a containerized world! From the beginning of what is a container through swarm-clusters of containerized services.
Azure Resource Manager (ARM) is the technology within the Azure platform which is responsible for provisioning the resources.
The infrastructure for your application is typically made up of many components – maybe a virtual machine, storage account, and virtual network, or a web app, database, database server, and 3rd party services. You do not see these components as separate entities, instead you see them as related and interdependent parts of a single entity. You want to deploy, manage, and monitor them as a group.
In this session we will see how Azure Resource Manager enables us to work with the resources in a solution as a group. We will see how you can deploy, update or delete all of the resources for your solution in a single, coordinated operation.
In the cloud no one can hear you scream… or can they. Even though Microsoft has a tremendous army of gadgets (besides the sharks with freakin lasers that is) in place for defending your environments, sometimes you need that additional little thing. The goal of the session is to provide you some guidance and an overview of Azure’s security measures, either out of the box activated or the additional ones you can foresee. Next to that you’ll get an idea on how to monitor and react to threats that have been noticed or unnoticed. Expect some PowerShell, Azure architecture, and service tweaks which can help you settle at ease in your new condominium with panic room.
IT has evolved. We went from client to client-server to services, and with that we went from hardware to virtualization to … containerized deployments. There’s some new kids in town. The big beast of a whale called Docker (although it has a small footprint, pun intended), a teeny tiny Microsoft solution named Nano (although that flag doesn’t completely cover the cargo container (again pun intended)). The technology that build our virtualized DC’s is now enabling us containerized deployments. Hyper-V at its core and tools that you already have make this an easy entry.
Are relational databases too restrictive for you? Developers want to store data as they get it? Need to store arrays, query as first class citizens instead of performing gymnastics? Yes? then this session is for you. It introduces Microsoft’s Document database. Come see what it is and how it could make your developers happy.
Is your Biml solution starting to remind you of a bowl of tangled spaghetti code? Good! That means you are solving real problems while saving a lot of time. The next step is to make sure that your solution does not grow too complex and confusing – you do not want to waste all that saved time on future maintenance!
Attend this session for an overview of Biml best practices and coding techniques. Step by step, we will simplify and enhance our solution. Learn how to centralize and reuse code with include files and the CallBimlScript method. Make your code easier to read and write by utilizing LINQ (Language-Integrated Queries). Share code between files by using Annotations and ObjectTags. And finally, if standard Biml is not enough to solve your problems, you can create your own C# helper classes and extension methods to implement custom logic.
Start improving your code today and level up your Biml in no time!
If you want to accelerate the testing of your BI solutions, the best strategy is the automation of your tests with the help of a dedicated framework. During this session, we’ll take a look to the features of the open-source framework named “NBi” (www.nbi.io). This framework is providing support for automated tests on the fields of databases, cubes, reports and ETLs, without the need of .Net skills. The demos will show us the best approaches to quickly and effectively assert the quality of BI developments. We’ll go a step further, generating the tests by an interesting system of templates and test-cases sources.
Yes there are plenty of frameworks SSIS, but in the real world we all tend to consolidate the set of best practices that we using in the projects, we have gained with the experience and what has been shared by the community … so nothing to think a little about what a modern integration framework must be right?
Find out what Reporting Services may improve even more your Reporting skills.
How to pin items to Power BI, new HTML 5 Rendering, PowerPoint Export & Rendering, the custom Parameters Pane, are only some of the new cool stuff that you could find in the new version of Reporting Services.
This and a lot more is waiting for you… Come and see for yourself.
You are a secret agent On Her Majesty’s Secret Service, posing as a developer in Portugal.
This is your briefing on how to turn business logic into database objects.
Learn about SQL Server’s data security mechanisms (including SQL Server 2016) and implement multi-tiered data access with business rules and roles, make your app/database immune to infrastructure changes (like scaling from single server into clustered or cloud) and M’s moods in the future, avoid SQL injection and other security and app coding bugs using stored procedures and database server side logic.
Session suited for Developers and Students (Johnny English level).
Disclaimer: No actual state secrets will be revealed. Please do not send agents to my house again.
Azure SQL Data Warehouse is a scale out database service designed to answer your ad hoc queries and questions. By spreading your data across distributions SQL Data Warehouse is designed for analytics at scale. To make the most of your database there are opportunities to tailor your table design and optimize for performance. This session will cover the fundamentals of data distribution, table design and query optimisation; helping you to deliver the best performance for your solution.
Nowadays many companies don’t have dedicated developer positions. Therefore the most of the SQL code has been written by application developers. And they use only a subset of SQL Server features and usually in a suboptimal manner.
I spent last ten years working with application developers and have collected common mistakes and misunderstandings between them and DBAs that increase development, test and deployment costs and reduce the overall quality.
In this session we will cover the most important things they need to know about SQL Server and that cannot be easily or cheap fixed by DBAs or consultants.
SQL Server 2016 enables customers to run analytic queries on in-memory and disk-based OLTP tables with minimal impact on business critical OLTP workloads, requiring no application changes. This session covers various configurations and best practices for achieving significant performance gains with Real-Time Operational Analytics.
With new functionalities for handling JSON text, Azure SQL Database and SQL Server 2016 enable you combine flexibility and agility of NoSQL database with a power and all benefits of SQL relational engine. Now, you can parse JSON text in SQL queries, query both relational data and JSON stored in text columns, index both relational and JSON data with the same indexes, easily format results of SQL queries as JSON text.
In this session we will see some use cases where new JSON functionalities can help you, such as creating REST services, storing data with flexible schema, analyzing log files, etc.
We’ve all dealt with nightmare queries: huge, twisted monsters that somehow work, despite being ugly and unmanageable. The time has come to tame these beasts, and the solution is available now, in SQL Server 2012.
New T-SQL functions offer out-of-the-box solutions for many problems that previously required complex workarounds. Paging, Running totals, Moving aggregates, YTD, and much more comes at the power of your fingertips in SQL Server 2012. The only thing you need to do is learn the syntax. And that is exactly what this session is all about: a thorough description and explanation of the syntax, and loads of demos to demonstrate how you can use all these new features.
Attend this session to boldly take SQL Server where it has never gone before!
Road to database automation addresses the challenges of database inclusion in the Application Lifecycle Management (ALM). The set of processes that enables this inclusion is designated as Database Lifecycle Management. DLM is composed by 3 main parts/phases: database source control, database continuous integration and continuous delivery. This set of processes, where automation is a key factor, enables agile practices that allows to mitigate/manager the gap between applications and databases development.
In this presentation, I will discuss the DLM general concepts and present some strategies and tools (source control tools as Mercurial and Git and database migrations management tools as Flyway) that can be used to overcome the first phase: database source control. This phase will unlock the database continuous integration and delivery.
As SQL Server and Windows availability solutions have reached maturity, their capabilities and interoperability has grown to such an extent that it is no longer clear what technologies to use, when to use them, what they deliver and when things can go wrong.
In this session we will take a look at some of the new features provided by SQL Server and Windows 2016, how existing high availability solutions can benefit from their adoption and when schizophrenic HADR can be bad idea!
Flash storage, in-memory database operations, columnstore indexes, virtualization and converged/hyper-converged infrastructure are each often described as revolutionary for databases.
While the advance of technology may add considerations for storage architects and database administrators alike, these considerations are details in the larger scheme.
This session will cover new considerations in database storage design at the hardware level and database level. System profiling, stress testing, and production system evaluation will be covered.
One of the major problems that every database administrator has in their daily duties is the storage and management of historical data. Knowing that all large and medium-sized businesses face similar problems, Microsoft has released a revolutionary new feature that will facilitate the administration and management of data in addition to a low cost at the end of the month. Stretch Database is a low-cost resource, which requires no changes in the application side and provides security for your data using the Microsoft’s cloud [Microsoft Azure] to store “Cold Data” of your company with less complexity, agility and being fully transparent and integrated with your queries.
Join in this session and you will understand how this new feature can reduce costs, complexity and facilitate the management of historical data making you the big differentiator in your company.
Query Store is a new feature that will be released with SQL Server 2016 that will allow to store history of execution plans of each query with his performance counters. It will allow more easily to fix some performance problems about query plan changes. Join me in this session, to take a look and talk about this new great feature that will change the way we can fix and troubleshoot performance tuning problems.
Released with SQL Server 2014 and improved on 2016, In-memory OLTP (Hekaton) is ready to boost the performance of your database! On this session this technology will be briefly introduced and a step-by-step approach will be shown on how to start up on using this new technology, explaining the basics.
What if migrating SQL Server instances was as simple as executing a single command?
In this presentation, I’ll cover the reasons companies migrate, the ways SQL migrations are usually performed, and the considerations that must be made when performing a migration.
Then I’ll show you how to use the PowerShell dbatools module to simplify your SQL Server migrations. dbatools makes migrating databases, logins, linked servers, credentials, jobs, database mail, and other essential SQL components extremely easy.
SSAS is the technology that enables that business users can build and share advanced information through the use of semantic models.
With SQL 2016 tabular models become a more mature technology that enable advanced modeling like many-to-many, improved use of Direct Query and new DAX functions among other stuff. Multidimensional models also provide new performance improvements.
R is a powerful language to add to the BI, analytics and data science technologies you may already be using. This session circumvents the painful experience of on-boarding a new technology and will give you the foundation needed to use R effectively.
Topics covered will include effective R coding, development best-practices, using R as a reporting tool, and how to build and administer a solid platform for analysis.
This session will cover the basic components of the Azure Data Lake Analytics and HDInsight, starting with the origins and then exploring the architecture and key design points. We’ll then look at how these fit into the overall data services spectrum and how these are used to gain valuable data insights into your data. This demo-heavy session will look at aspects of security and performance and why you need to be looking at these awesome technologies for data insights.
If people think about big data, they always think about Twitter or Facebook. But there are other areas where much more data amounts incurred and the analyzes are more complex. In this talk, we talk about a real example from bioinformatics. We will explain the actual scenario and how the various Microsoft platforms from Excel via SQL Server to Azure Analytics and HDInsight could help us – or not.
Data Mining and Machine Learning are not new. The fact that they are now within the reach of all and every organization is. Every organization in every branch can benefit from Machine Learning. In this session I will introduce the concepts behind Machine Learning and some of the algorithms and their use cases. I will than show you how to build and use a Machine Learning solution using Azure ML.
Over the past years, the explosion of social media have allowed users to express their feelings and attitudes about anything and everything at anytime.
That’s it, a perfect storm of opportunities for customers to improve their services, products or results based on those comments.
During this session we will understand the tremendous value of the Sentiment Analysis and how it could be integrated inside our Big Data solution. Real-time & batch, cloud & onprem scenarios will be shown through demos using PowerBI among other technologies.
In this session Glenn will give an overview on some of the different options to connect on premise resources with the Azure Platform.
We will start by having a look at how ‘classical’ integration is done before there was a cloud by using an example with BizTalk & SAP ERP system.
With the Azure Platform, a whole new set of tools and services was introduced and enables you to connect on premise with the cloud.
You can expect an overview on how to move away from the ‘classic’ integration and leverage all the SAP functionalities to the cloud via Service Bus Relay, Azure App Services and other services available on the Azure Platform.
Integration, as Life, has three rules: Paradox, Humor, and Change.
During this practice session and with real examples, Nino will figure out how to face integration of technologies in very smart way and without waste our money and time.
Azure IoT Suite was announced last year and it seems there are people who tend to believe that it will make real IoT solutions easy to set up and quick to deploy. In this session, you will get an overview of the features and capabilities of Azure IoT Suite. Some interesting demos will show how to register devices, send telemetry information and commands to and from devices. But after the magic, a touch with reality will be held. The various components will be discussed. Extensibility and customization will be shown.
After this session, attendees should get a good understanding of the possibilities of Azure IoT suite. Attendees should also get a better understanding of the possibilities to apply Azure IoT Suite in real world scenarios.
Expect demos and tons of honest feedback.
Integration has progress over the last decade from on premise, main frame to Software as a Service. Means of connecting systems has progressed to connecting anything with everything. In this session you will learn how integration can be done today with a myriad of options varying from BizTalk Server to Logic Apps. Several use cases will be demonstrated to the audience.
It’s critical to use good tools and techniques to produce working solutions as quickly as possible and at the same time, given the increase the requirements and number of applications organizations develop today. But at the same time, it’s also critical to maintain the health of the entire platform. In this session, which I’ll try to be a very interactive session (so be prepared to participate), I’ll address and share some useful BizTalk Server Tips and Tricks (and Workarounds) both for developers and administrators. Covering some topics like Integration Roadmap, RosettaNet, SAP, database maintenance, debatching, out-of-the-box pipelines vs custom pipelines and many more.
Today there are so many options for collaboration, that it is hard to select the right tool for the job. In this session you will learn tips and tricks about multiple collaboration Tools. You will also get information that will help you to make a better selection for the right collaboration tool for you and your users.
External non-employee access to your tenancy is definitely one of the best features of Office 365, but there are many things to consider when using this feature. This session will look at how this feature is enabled, the user experience and various configuration options. It will also consider the experience for external users, and will make the case that support is required for these users.
The session will then look at how an administrator can track and manage external users, and what tools may be required. Throughout practical real world guidance will be given about how organisations have successfully used and managed this feature.
In a cloud world we are seeing enterprises moving from a traditional way of working to a more dynamic and efficient method based on the most recent collaboration innovations like Office 365. This session is built upon the experience of the last years helping customers on deploying, adopting and evolving SharePoint Online.
Join us to learn how to use SharePoint Online to accomplish your business requirements.
This will be a heavy demo based session where we will demonstrate several examples adopted by some of the top Microsoft Office 365 customers.
Last year, Microsoft introduced Office 365 Groups, a new collaboration-focused feature aimed at bringing teams, apps and information together to collaborate better and more efficiently. Office 365 Groups leverages the features of several Office 365 services, such as Exchange Online, SharePoint Online, OneDrive for Business, Skype for Business, Planner, Yammer, Power BI and Dynamics CRM Online, to give teams a choice of collaboration tools and paradigms, while keeping a single version of the truth across all of these.
In this session, we’ll explain the purpose of Office 365 Groups and how they’re exposed by each of the Office 365 services and apps. You’ll learn about the architecture and information flows that support Groups, the several alternatives to manage them and how you can extend and integrate Groups functionality into your custom applications. We’ll finish by discussing the roadmap to Office 365 Groups.
I’ll demonstrate how to leverage the integration between Microsoft Office 365 and Microsoft Dynamics CRM to improve business collaboration, team productivity and make your organization more agile. This combination combines familiar Microsoft Office applications with a powerful customer relationship management solution accessed over the Internet to rapidly improve marketing effectiveness, boost sales productivity, and enrich customer service interactions. Maximize your investments in Office 365, including Office, SharePoint, Yammer, Exchange, and Skype.
Access control for modern Web APIs and applications presents new challenges, such as identity provider based authentication and delegated authorization.
This session presents the protocols, design techniques and technologies to address these challenges.
On the first part we present the OpenID Connect protocol, as an extension to the OAuth 2.0 framework, simultaneously supporting federated authentication and authorization delegation. We also present the JWT (JSON Web Token) format as way to communicate and store authentication and authorization information.
On the second part we present the IdentityServer3 framework and illustrate its usage on implementing authentication and access control to applications and Web APIs implemented on the .NET platform.
If there is a common practice in architecting software systems, it is to have them store the last known state of business entities in a relational database. But while this is widely adopted and effectively supported by existing development tools, this practice trades the easiness of implementation with the cost of losing the history of such entities.
Event Sourcing provides a pivotal solution to this problem, giving systems the capability of restoring the state they had at any given point in time. Furthermore, injecting mock-up events and having them replayed by the business logic allows for an easy implementation of simulations and “what if” scenarios.
In this session, Andrea will demonstrate how to design time travelling systems by examining real-world, production-tested solutions.
Your client calls you and says:
If you are working in backend software development, this has probably happened to you. Due to user workload or data load, the application might not respond as well and quickly as it should.
A careful application design combined with proper monitoring and maintenance should help prevent most of these problems. The purpose of this session is to demonstrate some lessons learned from the past concerning application performance and how some love and care during the development phase can help prevent some headaches.