SQLSaturday #549 - Singapore 2016
Secrets of SQL Server - Database Worst Practices
Event Date: 20-08-2016 - Session time: 09:40:00 - Track: Database Administration
Speaker: Pinal Dave
Title: Secrets of SQL Server - Database Worst Practices
“OMG! What did I do?” Chances are you have heard, or even uttered, this expression. This demo-oriented session will show many examples where database professionals were dumbfounded by their own mistakes, and could even bring back memories of your own early DBA days. The goal of this session is to expose the small details that can be dangerous to the production environment and SQL Server as a whole, as well as talk about worst practices and how to avoid them. In this session we will focus on some of the common errors and their resolution. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session.
Data Storage and Analytics with Azure Data Lake
Event Date: 20-08-2016 - Session time: 09:40:00 - Track: Analytics, Azure and Big Data
Speaker: Glenn Morris
Title: Data Storage and Analytics with Azure Data Lake
With all the capabilities required to make life for developers, data scientists, and analysts a tad simpler this session will investigate how we can use Azure Data Lake to store data of any size, shape and speed, and do all types of processing and analytics across platforms and languages.
A demo rich session we will see how we can use Azure Data Lake to solve many of the productivity and scalability challenges that prevent you from maximizing the value of your data assets.
Know What Your Code is Doing to SQL Server!
Event Date: 20-08-2016 - Session time: 09:40:00 - Track: Database Development
Speaker: Kevin Boles
Title: Know What Your Code is Doing to SQL Server!
ORMs - oh how I LOVE them! As a consultant when I see them in play at a client I go KACHIIINNNNGGGG!! :-D Seriously though, they can provide some substantial benefits for coding throughput. But if you don't Read The Fine Manual and do some things right and avoid some major gotchas you will fall prey to one of my favorite Guruisms: "Anything that allows developers to slap code together more quickly is inversely proportional to the performance and scalability you will get from that code"! Although this talk is based on Entity Framework, most ORMs suffer from a lot of the same flaws.
Think work like a Data Scientist with SQL 2016 R
Event Date: 20-08-2016 - Session time: 11:00:00 - Track: Analytics, Azure and Big Data
Speaker: Dr. Subramani Paramasivam
Title: Think work like a Data Scientist with SQL 2016 R
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.
SQL Server 2016 – The Evolution of In-Memory Technologies
Event Date: 20-08-2016 - Session time: 11:00:00 - Track: Database Development
Speaker: Andreas Wolter
Title: SQL Server 2016 – The Evolution of In-Memory Technologies
For SQL Server 2014 a completely new In-Memory Engine for memory optimized table indexes was integrated into SQL Server with in fact very limited functionality.
For SQL Server 2016 the In-Memory engine is being extensively improved in terms of both scalability as well as T-SQL language support. Moreover the ColumnStore index technology has been improved and can now even be combined with memory-optimized tables.
In this session, Microsoft Certified Master Andreas Wolter, will provide an overview of the new possibilities and demonstrate where a particular technology may help – or where you cannot expect benefits. If you are planning to go on SQL Server 2016 any time soon, this session shows you two of the most important features that SQL Server 2016 brings.
SQL Server 2016 Stretch Database: top to bottom
Event Date: 20-08-2016 - Session time: 11:00:00 - Track: Database Administration
Speaker: Joe Yong
Title: SQL Server 2016 Stretch Database: top to bottom
Got tables with millions or billions of rows but can't truncate or archive to reduce their sizes? How is that affecting your maintenance window, performance and availability? Is your CIO/CFO mandating DBAs to leverage "cheap", "elastic compute/storage capacity" and "infinite scale" capabilities of the cloud after reading the glossy brochures? Do your users want all data, including cold/archive data always online? All this while IT budgets remain flat or are being reduced?
Find out how StretchDB can help solve some of these problems by leveraging Azure without requiring application changes in most cases. We will cover core StretchDB scenarios, recommended use cases and non-use cases. We walk through key tasks involved in enabling a database for stretch, query behavior, security model and impact to existing high availability and disaster recovery processes. We will then review existing limitations, workarounds and some recommended practices based on lessons learned from early adopters.
Creating High Performance Tabular Models
Event Date: 20-08-2016 - Session time: 13:30:00 - Track: Analytics, Azure and Big Data
Speaker: James Beresford
Title: Creating High Performance Tabular Models
In this session James will use his experience building large cubes for large organisations and show how you can optimise all aspects of the process - preparing data for load, processing tips and how to get the thing to perform as users expect.
Bleed Blue for the clouds – SQL Azure
Event Date: 20-08-2016 - Session time: 13:30:00 - Track: Database Administration
Speaker: Krishna Deepak Chamana
Title: Bleed Blue for the clouds – SQL Azure
Event Date: 20-08-2016 - Session time: 13:30:00 - Track: Database Development
Speaker: Denny Cherry
Title: Index Internals
In this session we'll dig into the internal structures of indexes. We will look at how SQL Server Navigates through the index. We'll look at the various types of pages within the index and how SQL Server uses these different pages to access your data. We'll look at what happens within the index as data changes. There will be lots of demos using undocumented commands as we dive into the depths of the database pages.
Security with SQL Server - Things you never knew
Event Date: 20-08-2016 - Session time: 15:20:00 - Track: Database Administration
Speaker: Vinod Kumar M
Title: Security with SQL Server - Things you never knew
Compliance and auditing are some of the core tenants around which SQL Server based applications can be built. But understanding the intracacies of each of these fundamentals is critical to both developers and administrators alike. Come to this fun filled, demo centric and interesting session where we unearth some of these fine prints in understanding why we use SQL Server the way we use it and build the system is the most secure and locked down mode. Some of the enhancements with SQL Server 2016 make it even more compelling to look at SQL Server from a security standpoint.
Automated and Repeatable Test Cases for SQL Server Development.
Event Date: 20-08-2016 - Session time: 15:20:00 - Track: Database Development
Speaker: Stefan Riedel
Title: Automated and Repeatable Test Cases for SQL Server Development.
Power BI - Bring your data to life
Event Date: 20-08-2016 - Session time: 15:20:00 - Track: Analytics, Azure and Big Data
Speaker: Harminder Sethi
Title: Power BI - Bring your data to life
Power BI is a cloud-based business analytics service that enables anyone to visualize and analyze data with greater speed, efficiency, and understanding. It connects users to a broad range of live data through easy-to-use dashboards, provides interactive reports, and delivers compelling visualizations that bring data to life. In this session we will cover:
Power BI Architecture
Power BI Security
Power BI Desktop Service
Data Cleansing and Data Modelling capabilities
How to create Dashboards and Reports
Natural Language Query Support
The session is also complimented with end-to-end demo.
Common TSQL Mistakes
Event Date: 20-08-2016 - Session time: 16:55:00 - Track: Database Development
Speaker: Kevin Boles
Title: Common TSQL Mistakes
We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application's performance. I have given this talk over SEVENTY times now and it is always very highly rated!
Rock Your Reports with SSRS 2016
Event Date: 20-08-2016 - Session time: 16:55:00 - Track: Analytics, Azure and Big Data
Speaker: Khilitchandra Prajapati
Title: Rock Your Reports with SSRS 2016
SQL Server Reporting Services has really come a long way with great changes and overhauls. New capabilities features introduced with release of SQL Server 2016 are just amazing. In this session, we would touch base some of the top features capabilities offered by SSRS 2016. We will see how much we can do with it to make our Reporting simple and powerful.
SQL Server Performance Tuning - Parallelism
Event Date: 20-08-2016 - Session time: 16:55:00 - Track: Database Administration
Speaker: Dharmendra Keshari
Title: SQL Server Performance Tuning - Parallelism
During query optimization, SQL Server is looking for queries or index operations that might benefit from parallel execution. This session will give you a better understanding of parallelism in SQL Server. The default server configurations are no longer enough for controlling parallelism, as a DBA, you need to know how to tweak the settings to make it run optimally. When parallelism goes wrong, it can cause performance problems to SQL Server. Sometimes only for a particular query, sometimes it can hurt performance server-wide. What is best practices to MAXDOP.