sqlsathistory

Nr: 378

SQLSaturday #378 - Curacao 2015

Start Time (24h)	Speaker	Track	Title
09:00:00	Rodney Landrum	Track 1	Analytics and the DBA – Using BI Power tools to visualize your SQL Infrastructure
09:00:00	Roy Ernest	Track 2	In Memory OLTP
10:15:00	Murilo Miranda	Track 2	Buffer Pool Extension (BPE) - How it works?
10:15:00	Rohan Joackhim	Track 2	SQL Server 2012 AlwaysON (HADR) for dummies
11:15:00	Luan Moreno Medeiros Maciel	Track 2	Troubleshooting SQL ServerBasics
11:15:00	Joseph D'Antoni	Track 1	Power BI in the Fast Lane--Visualizing Formula 1
13:30:00	Luan Moreno Medeiros Maciel	Track 2	Protecting SQL Server against Hackers [Best Practices]
14:45:00	Joseph D'Antoni	Track 2	5 Steps to Being a Top DBA--Learning Automation in SQL Server
15:45:00	Murilo Miranda	Track 2	Super Hybrid 2014

SessionID: 23391

Analytics and the DBA – Using BI Power tools to visualize your SQL Infrastructure

Back to calendar

Event Date: 23-05-2015 - Session time: 09:00:00 - Track: Track 1

Speaker: Rodney Landrum

Title: Analytics and the DBA – Using BI Power tools to visualize your SQL Infrastructure

Abstract:

DBAs do not always have time to work with some of the amazing visual data tools that are becoming common place now for analysts. In this presentation I will show how in just a few very easy steps you can learn more than the basics of PowerView, PowerPivot and Data Mining using data you are already familiar with as a DBA, your SQL Server installation data. We will look at new and interesting way to load, transform, merge and analyze configuration and performance data for many servers simultaneously. I will also demonstrate how to best utilize that data for reports in Excel, SSRS and Visio to get the most out of automation, standardization and visualization with the new Power tools.

SessionID: 23484

In Memory OLTP

Back to calendar

Event Date: 23-05-2015 - Session time: 09:00:00 - Track: Track 2

Speaker: Roy Ernest

Title: In Memory OLTP

Abstract:

If you have had waits due to high disk IO, come see this session where you will be introduced to In-Memory objects. In this session we will learn how In-Memory object will reduce the disk IO, what are the two types of memory tables, how to create them and how to maintain them. We will also see how we can manage memory for these In-Memory objects.

SessionID: 21196

Buffer Pool Extension (BPE) - How it works?

Back to calendar

Event Date: 23-05-2015 - Session time: 10:15:00 - Track: Track 2

Speaker: Murilo Miranda

Title: Buffer Pool Extension (BPE) - How it works?

Abstract:

A new feature of SQL Server 2014, Buffer Pool Extension (BPE) promises improvement on OLTP workload like systems, taking advantage of fast persistent disks.

On this session we will enter in some theoretical details regarding this new technology, as well as some demos.

SessionID: 21281

SQL Server 2012 AlwaysON (HADR) for dummies

Back to calendar

Event Date: 23-05-2015 - Session time: 10:15:00 - Track: Track 2

Speaker: Rohan Joackhim

Title: SQL Server 2012 AlwaysON (HADR) for dummies

Abstract:

SQL Server 2012 introduced a new High availability concept Always ON. Always ON Availability Groups allows you to configure failover for one database, a set of databases or the entire instance again something you could not do with database mirroring.This session will cover the HADR from the basics to how to implement SQL Server 2012 Always On feature.

SessionID: 19275

Troubleshooting SQL ServerBasics

Back to calendar

Event Date: 23-05-2015 - Session time: 11:15:00 - Track: Track 2

Speaker: Luan Moreno Medeiros Maciel

Title: Troubleshooting SQL ServerBasics

Abstract:

Discover in this session how to create a line of investigation in SQL Server. You will be able to find the root cause of the problems and solve them learning how to analyze the historical and live data in SQL Server. Download in the final of the presentation the SeatBelt kit with all the scripts to use in your environment.

SessionID: 36508

Power BI in the Fast Lane--Visualizing Formula 1

Back to calendar

Event Date: 23-05-2015 - Session time: 11:15:00 - Track: Track 1

Speaker: Joseph D'Antoni

Title: Power BI in the Fast Lane--Visualizing Formula 1

Abstract:

Power BI provides a great toolkit for building data models and doing rapid analysis of data. When you combine the broad capabilities of Power Query to gather external data through a wide variety of data sources and Open APIs. In this session, you will learn about the entire Power BI toolset using data from the current Formula 1 season. You will learn how to use graphics (track maps) as icons for filtering in Power View. You will learn how to relate data in a Power Pivot data model to build complex visualizations. You will learn about Power BI QA and how it can provide answers from your data.

SessionID: 19277

Protecting SQL Server against Hackers [Best Practices]

Back to calendar

Event Date: 23-05-2015 - Session time: 13:30:00 - Track: Track 2

Speaker: Luan Moreno Medeiros Maciel

Title: Protecting SQL Server against Hackers [Best Practices]

Abstract:

In this session you will learn how to protect the various forms of attacks that are carried out in SQL Server, this session will teach the best security practices, lest's dig at the thought of a hacker and learn how he can access SQL Server of course after the session we will avoid such achievement Ready to learn how a hacker can break into your SQL Server? Join me in this internal session of SQL Server + Kali Linux.

SessionID: 36507

5 Steps to Being a Top DBA--Learning Automation in SQL Server

Back to calendar

Event Date: 23-05-2015 - Session time: 14:45:00 - Track: Track 2

Speaker: Joseph D'Antoni

Title: 5 Steps to Being a Top DBA--Learning Automation in SQL Server

Abstract:

Being a DBA is tough job--there are on call situations to deal with, and managing a large amount of servers with less resources is a constant challenge in corporate environments. In this session you will learn techniques to reduce the amount of manual effort in your job, and keep you three steps ahead of your users. Learn techniques such as:

• Fully Automating SQL Server Installations
• Dynamically Adding Databases to an Availability Group
• Syncing jobs and logins between Availability Group members
• Patching SQL Servers automatically
• Other techniques for process automation

This session will benefit both Junior and Senior DBAs, as well as anyone who wants to automate themselves into a promotion.

SessionID: 21197

Super Hybrid 2014

Back to calendar

Event Date: 23-05-2015 - Session time: 15:45:00 - Track: Track 2

Speaker: Murilo Miranda

Title: Super Hybrid 2014

Abstract:

Most SQL Servers run on-premises. This one runs on the Cloud (too).

More and more, Microsoft is betting in the Cloud and hybrid environments are already a reality. We already have few different options to integrate on-premises with cloud environments, which opens a new horizon of possibilities. On this session, we will explore the available options and understand how could we take advantage of this option, as well as show some action - with some demos.

This site is open source. Improve this page.