sqlsathistory

Nr: 565

Back to Main list

SQLSaturday #565 - Bucuresti 2016

Start Time (24h) Speaker Track Title
10:00:00 Satya Jayanty Enterprise Database Administration Deployment 2,4,8 16 - Upgrade your journey with SQL Server
10:00:00 Dr. Subramani Paramasivam BI Information Delivery Think work like a Data Scientist with SQL 2016 R
10:00:00 Bogdan Curca Application Database Development Productivity tips for Sql Server Management Studio
11:15:00 Kaloyan Kosev Application Database Development AlwaysOn Availability Groups for Developers
11:15:00 Alexandra Ciortea Strategy and Architecture New Security Features in SQL Server 2016
11:15:00 Cristian Lefter Application Database Development Troubleshooting Performance in SQL Server 2016
12:30:00 Cezar Ionescu Enterprise Database Administration Deployment SQL Server Azure VMs - your databases in the cloud
12:30:00 Sam Lester BI Information Delivery Power BI Desktop – Leveraging the magic of Power BI - ON-PREM
12:30:00 Remus Rusanu Enterprise Database Administration Deployment How to monitor efficiently your SQL Server instances
15:00:00 Liviu Ieran Application Database Development SQL Server 2016 - Execution Plan Analysis
15:00:00 Andrada Nastasie Enterprise Database Administration Deployment SQL Server Consolidation
15:00:00 Catalin Gheorghiu Professional Development IoT Duel - Cloud vs. on Premises Solutions
16:15:00 LEONEL ABREU Enterprise Database Administration Deployment A time travel with temporal tables
16:15:00 Kevin Boles Application Database Development Query Plan Deep Drive

SessionID: 50844

2,4,8 16 - Upgrade your journey with SQL Server

Back to calendar

Event Date: 24-09-2016 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Satya Jayanty

Title: 2,4,8 16 - Upgrade your journey with SQL Server

Abstract:

2,4,8 16 - these aren't just numbers to count or calculate. These are years that how SQL Server evolved as number of years!

Why Upgrade? Data Platform Upgrade topic has been a popular session that I've presented in major conferences like Microsoft Tech-Ed (North America, Europe India) and SQLbits since 2008.

In this session, we will overview in depth end-to-end upgrade process that covers the essential phases, steps and issues involved in upgrading SQL Server (2000 to 2012), SQL Server 2014 (with a good overview on 2016 too) by using best practices and available resources.

What to-do and what not-to-do?

A popular session that I have been presenting since the year 2008, in MS Tech-Ed, SQL Saturday SQLbits UK. We will cover the complete upgrade cycle, including the preparation tasks, upgrade tasks, and post-upgrade tasks. Real-world examples from my Consulting experience expanding on why how such a solution.

SessionID: 50883

Think work like a Data Scientist with SQL 2016 R

Back to calendar

Event Date: 24-09-2016 - Session time: 10:00:00 - Track: BI Information Delivery

Speaker: Dr. Subramani Paramasivam

Title: Think work like a Data Scientist with SQL 2016 R

Abstract:

What are these DATA Scientists up to? How can we see their statistical model in our day to day familiar tool like Microsoft SQL Server?

You now have answers to these questions and thanks to Microsoft for integrating R Revolution within new SQL Server 2016. We all now have the opportunity to use R packages and see the results within SQL 2016.

In this session, you will definitely take away a breakthrough concept of Advanced R Analytics within SQL 2016 and get ready to kick your creative horse, and go beyond your imagination on how you can build advanced analytics and impress your employers/customers.

SessionID: 54042

Productivity tips for Sql Server Management Studio

Back to calendar

Event Date: 24-09-2016 - Session time: 10:00:00 - Track: Application Database Development

Speaker: Bogdan Curca

Title: Productivity tips for Sql Server Management Studio

Abstract:

Have you ever wondered how you can improve your productivity while using Sql Serve Management Studio?

I would like to share with you some tips tricks I discovered along my ride with Sql Server and also present you a few free 3rd party tools from Sql Server ecosystem that will help you increase your speed and improve your development experience.

SessionID: 50903

AlwaysOn Availability Groups for Developers

Back to calendar

Event Date: 24-09-2016 - Session time: 11:15:00 - Track: Application Database Development

Speaker: Kaloyan Kosev

Title: AlwaysOn Availability Groups for Developers

Abstract:

It's often difficult to choose a high-availability solution and to build your applications around it,

Come join me in a session focused on AlwaysOn Availability Groups - how they actually work, how to get the most of them, learn the benefits they provide and the limitations they have. Or at least put a DB Administrator on the interrogation table.

SessionID: 53066

New Security Features in SQL Server 2016

Back to calendar

Event Date: 24-09-2016 - Session time: 11:15:00 - Track: Strategy and Architecture

Speaker: Alexandra Ciortea

Title: New Security Features in SQL Server 2016

Abstract:

New Security Features and Best Practices with SQL Server 2016

The session will cover Dynamic Data Masking, Row Level Security, Always Encrypted, Cell Level Security

SessionID: 53079

Troubleshooting Performance in SQL Server 2016

Back to calendar

Event Date: 24-09-2016 - Session time: 11:15:00 - Track: Application Database Development

Speaker: Cristian Lefter

Title: Troubleshooting Performance in SQL Server 2016

Abstract:

The SQL Server Query Store is one of the most known features of SQL Server 2016 that provides insight on query plan choice and performance. It simplifies performance troubleshooting by enabling you to quickly find performance differences caused by changes in query plans.

However in this session we will explore not just Query Store but also additional features that allow performance troubleshooting in SQL Server 2016.

SessionID: 52728

SQL Server Azure VMs - your databases in the cloud

Back to calendar

Event Date: 24-09-2016 - Session time: 12:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Cezar Ionescu

Title: SQL Server Azure VMs - your databases in the cloud

Abstract:

While Microsoft Azure SQL Database can be an option for moving our databases to the cloud, as DBAs we still want to have full control on the SQL Server instances and on the resources we have available, so moving our databases to a SQL Server Azure VM is the way to go.

Let's have a look at what the Azure IaaS has to offer when it comes to migrating the SQL Server to the cloud and what are some of the best practices when you decide to do so, while touching both on the pros and cons of such a decision. We will be covering the details of setting up a SQL Server Azure VM, emphasizing what are the requirements for a highly available and high performance system.

SessionID: 52754

Power BI Desktop – Leveraging the magic of Power BI - ON-PREM

Back to calendar

Event Date: 24-09-2016 - Session time: 12:30:00 - Track: BI Information Delivery

Speaker: Sam Lester

Title: Power BI Desktop – Leveraging the magic of Power BI - ON-PREM

Abstract:

It won’t be long before we host the majority of our data, compute power, reporting, and BI visualizations in the cloud, but we’re not all there quite yet. In this presentation, we will discuss ONLY those options that are available on-premises, covering functionality differences between Power BI and Power BI Desktop as well as the critical integration of .pbix dashboards and visualizations with other enterprise reporting and collaboration tools, such as SharePoint, PowerPoint, Excel, and SQL Server Reporting Services. We’ll also highlight the Microsoft BI roadmap for SQL Server 2016, SSRS, Power BI, Mobile Reports, and what it means specifically for on-premise customers.

SessionID: 53038

How to monitor efficiently your SQL Server instances

Back to calendar

Event Date: 24-09-2016 - Session time: 12:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Remus Rusanu

Title: How to monitor efficiently your SQL Server instances

Abstract:

Do you plan to start monitoring your SQL Server instances soon and asking yourself what should you measure? Are you questioning if your existing monitoring data can detect and alert if a performance problem occurs? Is the data you collected from monitoring enough to pinpoint the cause of your next performance problem?

I have worked with SQL Server as a developer in the Redmond team for more than 12 years and during this time I've investigated countless performance problems. In time I developed a strategy on how to use the performance monitoring data to analyze problems and identify the root cause. This session is going to to show you how I monitor SQL Server, what data do I look for, and how I interpret the collected data to analyze performance issues. Going beside the obvious CPU, Memory and IO counters, I will show you how to identify typical performance issues from monitoring data, all without overwhelming the captured data volume.

SessionID: 52722

SQL Server 2016 - Execution Plan Analysis

Back to calendar

Event Date: 24-09-2016 - Session time: 15:00:00 - Track: Application Database Development

Speaker: Liviu Ieran

Title: SQL Server 2016 - Execution Plan Analysis

Abstract:

How to capture execution plans and how to read an execution plan.

Quick overview of the most encountered operators. What kind of informations you can find in an execution plan and what conclusions can you draw by looking at this information. How to takle a bad plan - patterns to look out for.

SessionID: 52726

SQL Server Consolidation

Back to calendar

Event Date: 24-09-2016 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Andrada Nastasie

Title: SQL Server Consolidation

Abstract:

Roadmaps for SQL Server consolidation and version upgrade. Consolidation options covered include: multi-database single-instance servers, multi-instance on one or more physical servers, and finally reduction of physical servers through virtualization (Hyper-V) or cloud based technologies.

SessionID: 53686

IoT Duel - Cloud vs. on Premises Solutions

Back to calendar

Event Date: 24-09-2016 - Session time: 15:00:00 - Track: Professional Development

Speaker: Catalin Gheorghiu

Title: IoT Duel - Cloud vs. on Premises Solutions

Abstract:

This talk is a parallel, between IoT solutions, based on premise and systems, build with Microsoft Azure components. The presentation will cover the architecture, technology stack, implementation and best practices. We will consider plusses and deltas in different cases, using both approaches. You will see also many demos, which will help you to build own cloud based or on premises Internet of Things systems.

SessionID: 50834

A time travel with temporal tables

Back to calendar

Event Date: 24-09-2016 - Session time: 16:15:00 - Track: Enterprise Database Administration Deployment

Speaker: LEONEL ABREU

Title: A time travel with temporal tables

Abstract:

Temporal Tables is a new feature in SQL Server 2016, that allows to see the data (in one or more tables) exactly as they were in a point of time ago.

In this session will be shown the most useful scenarios:

  1. Recovering from an undesired data change
  2. Auditing efects
  3. Trending Analytics

SessionID: 52571

Query Plan Deep Drive

Back to calendar

Event Date: 24-09-2016 - Session time: 16:15:00 - Track: Application Database Development

Speaker: Kevin Boles

Title: Query Plan Deep Drive

Abstract:

Another in TheSQLGuru's Deep Dive series! Query plans - the roadmaps of how your query will be handled by the engine. TONs of information for the asute SQL Server user. Lets dig into them and see what we can learn from and about them and also talk about how they can be used to aid our query tuning efforts.