Nr: 646
SQLSaturday #646 - Singapore 2017
SessionID: 62915
Beginning Data Science-From Novice to Professional
Event Date: 26-08-2017 - Session time: 10:00:00 - Track: Track 4
Speaker: Dr. Subramani Paramasivam
Title: Beginning Data Science-From Novice to Professional
Abstract:
Where to begin the step 1 of data science to become a Data scientist? What are these Data Scientists up to? This is an initial data science session, for a novice and learn how easily you can step in to Data Science and start to become a professional.
How can we see and try using a data scientist statistical model in our day to day familiar tool like Microsoft SQL Server?
Thanks to Microsoft for integrating R Revolution within SQL Server 2016. We all now have the opportunity to use R packages and see the results within SQL 2016 and also to utilize it for any applications and/or Reporting services.
SessionID: 66598
Cloud Data Warehousing: Azure SQL Data Warehouse
Event Date: 26-08-2017 - Session time: 10:00:00 - Track: Track 2
Speaker: Dinesh Priyankara
Title: Cloud Data Warehousing: Azure SQL Data Warehouse
Abstract:
The heart of almost all Business Intelligence solutions; Relational Data Warehouse, has been servicing us for decades making the implementation is complete and success. It was always an On-Premises database, but now it is available as a Database-as-a-Service with Microsoft Azure, called Azure SQL Data Warehouse. It is a MPP cloud-based, scale-out relational database that supports workloads from few hundred gigabytes to petabytes of data and it addresses all modern requirements in data warehousing. Let’s talk about traditional On-Premises data warehouse little bit and then discuss about Azure SQL Data Warehouse and implementation of it.
SessionID: 67918
Event Date: 26-08-2017 - Session time: 10:00:00 - Track: Track 3
Speaker: Vinod Kumar M
Abstract:
SessionID: 68525
Upgrade to SQL Server 2017: Intelligent Diagnostics Just Built-In
Event Date: 26-08-2017 - Session time: 10:00:00 - Track: Track 1
Speaker: Parikshit Savjani
Title: Upgrade to SQL Server 2017: Intelligent Diagnostics Just Built-In
Abstract:
SQL Server 2016 and SQL Server 2017 Just Works! But if you are a IT Professional you want to be armed with all the right diagnostics to react to a mission critical problem or tune the engine to the needs for your business. Dev-Ops also requires the right tools to build and tune queries for maximum performance. SQL Server 2016 and 2017 have all the diagnostics you need just built-in to the product. These are the foundation for great tools from vendors such as SentryOne, RedGate, SolarWinds, and Idera. We also have intelligence built-into the engine based on these diagnostics to automate, learn, and adapt. In this session we will show you the wide variety of these diagnostics with testimonies from vendors and SQL MVPs. You will learn why SQL Server diagnostics are the best in the industry, built-in, and spans all platforms across SQL Server, Azure, and Linux
SessionID: 62999
2,4,8 16 - Upgrade your journey with SQL Server
Event Date: 26-08-2017 - Session time: 11:15:00 - Track: Track 2
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: 63316
Zombie Attack Against Clustered Indexes - Who really need them!
Event Date: 26-08-2017 - Session time: 11:15:00 - Track: Track 3
Speaker: Uwe Ricken
Title: Zombie Attack Against Clustered Indexes - Who really need them!
Abstract:
Clustered Index zombies come out of their graves to make the peace loving Heaps to one of them in your databases. Try to attack them or find a fair way to make them living together in peaceful harmony.
If you ask experts about using a clustered index you will in most cases hear the following statements: Yes, you need a narrow and contiguous clustered index for your table for good performance. Last but not least Microsoft Azure Databases requires clustered indexes but there might be situations when workloads and queries will suffer from wrong implemented clustered indexes.
Watch the demos which show in an impressive way that clustered indexes are not always the best choice. Build your clustered indexes wise or - as the demos will show - forgo for it for a better scaling. Become aware of the pros and cons of Clustered Indexes and make a wise decision when to use clustered indexes and the correct key attributes for it.
SessionID: 63459
Building a Centralised Database Maintenance and Monitoring Solution
Event Date: 26-08-2017 - Session time: 11:15:00 - Track: Track 4
Speaker: Manohar Punna
Title: Building a Centralised Database Maintenance and Monitoring Solution
Abstract:
Database Professional is always challenged with monitoring and maintenance across the environment. Be it 10 server or a 1000 servers, would it be easier to have a centralised solution?
In this session I will walk you through the simple steps of building a centralised database maintenance and monitoring solution. This solution will help a database professional to query all the monitored instances, collect performance metrics, run customized scripts and any maintenance task a database professional needs to perform across the database environment.
Talk about a easy DBA life, this is a definite simple solution you should build.
SessionID: 66610
Event Date: 26-08-2017 - Session time: 11:15:00 - Track: Track 1
Speaker: Tejas Shah
Abstract:
SessionID: 66620
In memory OLTP - what can it do for me?
Event Date: 26-08-2017 - Session time: 13:30:00 - Track: Track 4
Speaker: Martin Catherall
Title: In memory OLTP - what can it do for me?
Abstract:
In Memory OLTP came along in SQL Server 2014 along with several limitations.
It was still really useful – as long as your use case suited the limitations.
SQL Server 2016 removes several of these limitations and widens the use cases of in-memory OLTP.
For example, even if you are not taking advantage of in-memory tables, you can probably leverage performance improvements by replacing traditional table variables and both local and global temporary tables with in memory implementations. Now you’ll be able to say that table variable is truly in memory!
Come along to this session and learn about some of features of in memory OLTP - or Hekaton as a lot of people refer to this - and how you may be able to leverage these high performance features in both new and existing applications.
SessionID: 63000
Big Data with Azure: where to begin? Concepts and best practices
Event Date: 26-08-2017 - Session time: 13:45:00 - Track: Track 2
Speaker: Satya Jayanty
Title: Big Data with Azure: where to begin? Concepts and best practices
Abstract:
Microsoft Azure has the ability to move, store and analyze data within the cloud. It is essential to evaluate multiple opportunities and options with Microsoft Azure data insights. In this session let us talk about strategies on data storage, data partitioning and availability options with Azure. A tour on how best these Azure components can help you achieve success for your Big Data platform.
SessionID: 64071
Event Date: 26-08-2017 - Session time: 13:45:00 - Track: Track 3
Speaker: Denny Cherry
Abstract:
SessionID: 64548
Using Power Query to Tell Your Story from Your Facebook Data
Event Date: 26-08-2017 - Session time: 13:45:00 - Track: Track 2
Speaker: Anil Maharjan
Title: Using Power Query to Tell Your Story from Your Facebook Data
Abstract:
The session is mainly for the one who is trying to extract the story behind their Facebook data by using Power Query. By using Power Query you can extract your Facebook data easily and do analysis your own story by using your own Facebook data. Talking about Power Query: Microsoft Power Query for Excel is an Excel add-in that enhances the self- service Business Intelligence experience in Excel by simplifying data discovery, access and collaboration. Power Query can connect data across a wide variety of sources, where Facebook is one of the data source. This session helps you to learn about the Power Query, Power View, and Power BI and mainly helps you to do self-service BI by using your own Facebook data with the help of Power Query, Power View ,MS-Excel 2013 and Power BI.
SessionID: 65324
1 Database, Many Data Models: Database Designers and Azure Cosmos DB
Event Date: 26-08-2017 - Session time: 13:45:00 - Track: Track 1
Speaker: Karen Lopez
Title: 1 Database, Many Data Models: Database Designers and Azure Cosmos DB
Abstract:
Azure Cosmos DB is Microsoft's globally-distributed database as a service which supports multiple database models such as graph, key value, and document data models -- with the ability to add new models in the future.
In this hands-on session, attendees will learn about and use the features of Azure Cosmos DB, with these topics highlighted:
- Key Value Features
- Graph Features
- Document Features
- Column Family
- Scalability Elasticity
- Global Distribution
- Tunable Consistency
It is the first cloud database to natively support a multitude of data models and popular query APIs, is built on a novel database engine capable of ingesting sustained volumes of data and provides blazing-fast queries – all without having to deal with schema or index management. And it is the first cloud database to offer five well-defined consistency models so you can choose just the right one for your app.
SessionID: 69062
Graph Data processing with SQL Server 2017
Event Date: 26-08-2017 - Session time: 13:45:00 - Track: Track 4
Speaker: Prakash Sawant
Title: Graph Data processing with SQL Server 2017
Abstract:
SessionID: 64002
Data Quality and the BI Life Cycle
Event Date: 26-08-2017 - Session time: 14:45:00 - Track: Track 4
Speaker: Robert Blaas
Title: Data Quality and the BI Life Cycle
Abstract:
SessionID: 64235
DevOPs and the DBA
Event Date: 26-08-2017 - Session time: 14:45:00 - Track: Track 2
Speaker: Hamish Watson
Title: DevOPs and the DBA
Abstract:
You may have heard the word "DevOps" and wondered whether it is just another buzzword and/or what it can do for you.
In this session I will demystify the concepts of DevOps and we will look at two aspects of DevOps - Continuous Integration Continuous Delivery.
Continuous Integration is the practice in which software developers frequently integrate their work with that of other members of the development team.It also involves automating tests around the integrated work
Continuous Delivery is the next step after Continuous Integration in the deployment pipeline and is the process of automating the deployment of software to test, staging, and production environments.
Database migrations/changes are an area that may not be typically automated or utilise Continuous Delivery.
Through the use of a comprehensive live demo to a running production database the audience will learn the benefits and how to implement Continuous Delivery in their database systems deployment pipelin
SessionID: 64334
SQL Server on Linux--Linux for the SQL DBA
Event Date: 26-08-2017 - Session time: 14:45:00 - Track: Track 1
Speaker: Joseph D'Antoni
Title: SQL Server on Linux--Linux for the SQL DBA
Abstract:
In this session you will learn about the new release of SQL Server on Linux. You will learn about how to choose Windows versus Linux, the changes needed to make SQL Server run on Linux, and high availability and disaster recovery solutions.
SessionID: 69134
An Introduction to SQL Server 2017
Event Date: 26-08-2017 - Session time: 14:45:00 - Track: Track 3
Speaker: Warwick Rudd
Title: An Introduction to SQL Server 2017
Abstract:
SQL Server 2017 being released brings to the table some new features and improvements in quick succession from SQL Server 2016. In this session we will look at a subset of the new /or improved features that SQL Server 2017 brings to the table.
From Analytics, Availability, Configuration and Performance there is something for everyone in this session to introduce you to the latest version of SQL Server.
SessionID: 66649
SQL Server 2017: Better HA DR
Event Date: 26-08-2017 - Session time: 16:00:00 - Track: Track 1
Speaker: Andreas Wolter
Title: SQL Server 2017: Better HA DR
Abstract:
SessionID: 67972
SQL Server 2016 Query Store
Event Date: 26-08-2017 - Session time: 16:00:00 - Track: Track 2
Speaker: Dharmendra Keshari
Title: SQL Server 2016 Query Store
Abstract:
During this session we will take a thorough look at the Query Store, its architecture, the build-in reporting, DMVs and the performance impact of enabling the Query Store. No matter if you are a DBA or developer, the Query Store has information that can help you
SessionID: 68526
Event Date: 26-08-2017 - Session time: 16:00:00 - Track: Track 3
Speaker: Sarbjit Singh
Abstract:
One of the main drivers for digital transformation reported in the survey was optimizing customer experiences and engagement. More than 60 percent of executives identified delivering a superior experience for customers and creating new sources of customer value as important factors in determining an organization’s success as a digital business. These goals aren’t just pipedreams either – organizations are backing this assertion with serious budgetary investment, with half of respondents planning to invest in building applications in the next year that support the customer engagement model. So what role does data play in achieving these goals through a successful digital transformation? I will present details of the answer to this questions. I will cover how the data a company collects can be analyzed for insights that help the company personalize its interactions with customers. Data can be used to find trends around a customer’s habits, which is typically indicative of their future
SessionID: 69052
SQL Server Unknown Mysteries: The Case of Transparent Data Encryp
Event Date: 26-08-2017 - Session time: 16:00:00 - Track: Track 1
Speaker: Mohit Niranwal
Title: SQL Server Unknown Mysteries: The Case of Transparent Data Encryp
Abstract:
Basic Overview of Encryption concepts supported by SQL Server like HASHES, ASYMMETRIC KEYS, SYMMETRIC KEYS, CERTIFICATES, ENCRYPTION ALGORITHMS, Service Master Key (SMK), Database Master Key (DMK), Database Encryption Key (DEK).
Then we will work through TDE Overview, Availability, What is encrypted/not encrypted and Implementation steps and best practices.
Finally, we will explore hidden mysteries of TDE and decryption pitfall.