sqlsathistory

Nr: 692

SQLSaturday #692 - Nepal 2017

Start Time (24h)	Speaker	Track	Title
09:00:00	Gogula Aryalingam	BI Platform Architecture, Development Administration	BI for Everyone: Why, What and How of Power BI
10:00:00	Virendra Yaduvanshi	Database Administration	Understanding SQL Server's transaction log and how to manage it.
11:15:00	Jonathan Stewart	BI Platform Architecture, Development Administration	Performance Tuning for the BI Professional
13:30:00	Guy Glantser	Application Database Development	How to Use Parameters Like a Pro and Boost Performance
14:30:00	Anil Maharjan	BI Platform Architecture, Development Administration	PowerBI : Data Visualization SQL Saturday with R
15:45:00	Shree Khanal	Database Administration	SQL Server 2016 Advanced Security

SessionID: 69840

BI for Everyone: Why, What and How of Power BI

Back to calendar

Event Date: 23-12-2017 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Gogula Aryalingam

Title: BI for Everyone: Why, What and How of Power BI

Abstract:

Business Intelligence has been around for a long time, however a lot of BI projects have failed than have succeeded*. Despite knowing its shortcomings, only as of recent, have we had the right tools to make BI succeed. This session will focus on a very short history on how BI came into being and reasons for most failures. We will then look at the new wave of BI concepts and tools, and how it could help build better business intelligence solutions, and why Power BI is a tool of choice out of these. We will finally take a look at how the two main focus groups, business users and technical folk, can make use of Power BI, the part they have to play, and what they need to know, and how together they could build better business intelligence for everyone.

SessionID: 70376

Understanding SQL Server's transaction log and how to manage it.

Back to calendar

Event Date: 23-12-2017 - Session time: 10:00:00 - Track: Database Administration

Speaker: Virendra Yaduvanshi

Title: Understanding SQL Server's transaction log and how to manage it.

Abstract:

let try to understand Internals of SQL Server transaction log and learn how to manage it.

SessionID: 71121

Performance Tuning for the BI Professional

Back to calendar

Event Date: 23-12-2017 - Session time: 11:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jonathan Stewart

Title: Performance Tuning for the BI Professional

Abstract:

Being a BI Professional, you need all the performance tuning the DB folks get and more. In this hour, we will go over important performance tuning tips that you can use to help make your deliverables faster and more effective. We will touch on the MSBI tools of SSIS, SSAS, SSRS and PowerBI.

SessionID: 69753

How to Use Parameters Like a Pro and Boost Performance

Back to calendar

Event Date: 23-12-2017 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Guy Glantser

Title: How to Use Parameters Like a Pro and Boost Performance

Abstract:

Parameters are a fundamental part of T-SQL programming, whether they are used in stored procedures, in dynamic statements or in ad-hoc queries. Although widely used, most people aren't aware of the crucial influence they have on query performance. In fact, wrong use of parameters is one of the common reasons for poor application performance.

In this session we will learn about plan caching and how the query optimizer handles parameters. We will talk about the pros and cons of parameter sniffing as well as about simple vs. forced parameterization. But most important – we will learn how to identify performance problems caused by poor parameter handling, and we will also learn many techniques for solving these problems and boosting your application performance.

SessionID: 69982

PowerBI : Data Visualization SQL Saturday with R

Back to calendar

Event Date: 23-12-2017 - Session time: 14:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Anil Maharjan

Title: PowerBI : Data Visualization SQL Saturday with R

Abstract:

This session is mainly use to learn more about Power BI and R visualization chart. From this session one can learn how can we make some simple and quick visualization using Power BI desktop taking real SQL Saturday data and publish in PowerBI cloud service and also publish those visualization reports to publicly in web. Also, this session mainly helps to tell the story of SQL Saturday by using Power BI and R visualization chart.

Overall, by using Power BI Visualization how one can find out which SQL Saturday is conducted in which state or country in which year and a particular Day along with total sessions conducted. Also one can find SQL Saturday trends year on year and mostly in which month most of SQL Saturday is conducted as per SQL Saturday data history. So, this session will surely help one to learn regarding Power BI and its capabilities and SQL Saturday Stories.

SessionID: 71990

SQL Server 2016 Advanced Security

Back to calendar

Event Date: 23-12-2017 - Session time: 15:45:00 - Track: Database Administration

Speaker: Shree Khanal

Title: SQL Server 2016 Advanced Security

Abstract:

In this session we will review the new enhancement to SQL Server security available in SQL Server 2016 and Azure SQL DB. These include Always Encrypted, Row-Level Security and Dynamic Data Masking as well as whatever else Microsoft has released since I've written this abstract. We'll look at how to set these features up, how to use them, and most importantly when to use them.

This site is open source. Improve this page.