24 Hours of PASS 2016

    March turned out to be surprisingly eventful. SQL Server 2016 RC0 did not have time to exit , as it is already available to download RC1 . There are not many innovations in the latter, so alas, an interesting review will not work.

    Nevertheless, in order to pass the time advantageously, while waiting for the release of SQL Server 2016 , I propose to read the reports of 24 Hours of PASS , which took place on March 16-17.

    For those who hear about 24 Hours of PASS for the first time ... this is an annual online conference dedicated to SQL Server and lasting 24 hours. Speakers from different parts of the world succeed each other and tell a lot of interesting things about SQL Server . There are several versions24HOP . The Russian version of this event has been held for many years by the efforts of Andrei Korshikov.

    In order not to languish in anticipation, the list of video reports that are available under the cut:

    • SQL Server Transaction log . Internal organization and problem solving ( Andrey Zavadsky )
    • XML , XQuery and Performance Tricks ( Sergey Syrovatchenko )
    • Azure ML . Determination of the most effective classification algorithm for a selected data source ( Konstantin Khomyakov )
    • SQL Server In-Memory OLTP : Custom Use Cases ( Dmitry Korotkevich )
    • SQL Server Extended Properties as the easiest way to document databases ( Vyacheslav Mirugin )
    • SQL Server 2016 Reporting Services . Quick start ( Andrey Korshikov )
    • Support for large databases on MS SQL Server ( Kirill Panov )
    • SQL Server 2016 . Temporal Tables ( Alexey Knyazev )
    • 1 + 1 = 10. Using bit masks in databases ( Elena Smolyak )
    • SSAS Tabular 2016 ( Eugene Polonichko )
    • Inside the query optimizer: Query Store (in 2 parts) ( Dmitry Pilyugin )
    • PowerBI : Real-time Data Visualization ( Sergey Lunyakin )
    • Performance analysis of Windows applications using SQL Server as an example using standard operating system functionality ( Mikhail Komarov )

    SQL Server Transaction log. Internal device and problem solving


    Andrey Zavadsky :
    This report will examine the internal structure of the SQL Server transaction log , its logical and physical architecture, and transaction logging processes. Incorrect configuration or maintenance of the transaction log can lead not only to problems in data recovery, but also reduce the overall performance of the database server.

    We will look at why this happens and how you can solve the most common incidents, such as transaction log overflows, fragmentation and reduction of the log file size. We will also learn about the innovations in SQL Server 2014 that relate to the transaction log.



    XML, XQuery, and Performance Tricks


    Sergey Syrovatchenko :
    When working with XML and XQuery, there are so many pitfalls that can lead to tricky performance issues. The report will discuss general recommendations on how to efficiently create, store and process XML .



    Azure ML. Determining the most effective classification algorithm for a selected data source


    Konstantin Khomyakov :
    The purpose of the report will be to determine the most effective classification algorithm for the
    data source used. Algorithms will be tested on Poison mushrooms data . During the report, a simple model will be built using classification algorithms; Azure Machine Learning , SQL Azure and Power BI will be used .

    The results of the algorithms will be stored in SQL Azure , and then this source will be used to build Dashboards in PowerBI , which will show the effectiveness of each algorithm. The work of ML with client applications using web services will also be shown .



    SQL Server In-Memory OLTP: Custom Usage Scenarios


    Dmitry Korotkevich :
    We all know that In-Memory OLTP can significantly improve the performance of OLTP systems. Unfortunately, the implementation of this technology in SQL Server includes a large number of restrictions that prevent its widespread use. Despite this, the components of In-Memory OLTP can be useful in solving everyday tasks even in cases where the full use of technology is not rational.

    This session will talk about custom scenarios for using In-Memory in SQL Server . I’ll show you how to improve system performance by replacing temporary tables and table parameters with In-Memory OLTP objects, I will consider the performance issues of memory-optimized tables in ETL processes and natively compiled stored procedures in mathematical calculations. In addition, I will show several ways to circumvent the limitations of technology in the process of migration of existing systems.



    SQL Server Extended Properties as the easiest way to document databases


    Vyacheslav Mirugin :
    Are you a SQL Server developer, administrator, group leader, or even a project manager?
    Have you ever heard of Extended Properties ?
    Have you ever used them in your database?
    You don’t know how easy it is to create Extended Properties for your database objects?
    You don’t know how easy it is to use Extended Properties to document your database?
    If all the statements are correct, then it is also true that it will be very useful for you to take part in the presentation about Extended Properties .



    SQL Server 2016 Reporting Services. Fast start


    Andrey Korshikov :
    The new version of SQL Server 2016 Service Reporting Services has received a lot of improvements and additions. We will consider not only new products, but also how to get started with SSRS



    Large database support on MS SQL Server


    Kirill Panov :
    When you maintain very large VLDB databases, you encounter problems that you encounter in the same way when you maintain not-so-large databases.

    We will discuss:
    • Optimal SQL Server Startup Settings
    • Using SQL Server Always On Group
    • Database Maintenance Operations
    • Partitioning Tables and Indexes
    • Data compression
    • Using Data Collection



    SQL Server 2016. Temporal Tables


    Alexey Knyazev :
    Temporal Tables is one of the new features that will appear in SQL Server 2016 . In the report, we will take a closer look at this technology, talk about the benefits of using it using real-life tasks as an example.

    Compare with other methods of tracking changes, such as logging using DML triggers, Change Tracking ( CT ) and Change Data Capture ( CDC ).



    1 + 1 = 10. Using bit masks in databases


    Elena Smolyak :
    I’ll tell you what a bit mask is, the pros and cons of its use and how, in my opinion, it is optimal to use it with a database



    SSAS Tabular 2016


    Evgeny Polonichko :
    What has Microsoft done in the Tabular Model ( SSAS ) in SQL Server 2016 ? What is super dax ? In the report, I will talk about new features in the tab, about new features.



    Inside the query optimizer: Query Store


    Dmitry Pilyugin :
    Many of us, trying to understand why the request suddenly began to work slowly, probably would like to turn back the clock and get a plan for this request when it was executed quickly. It’s much easier to understand the reason for the slowdown, having two query plans on hand: “fast” and “slow”. It would be even better if you could tell the optimizer to use the “fast” plan while we look for the reason in the “slow” one. The good news is that SQL Server 2016 and the Query Store mechanism allow you to solve both the first and second tasks.

    The report will provide an overview of the Query Store mechanism in the SQL Server structure.and several scenarios of its use for solving performance problems. The report also touches on some internal features of the architecture and implementation of the Query Store in order to better understand how this mechanism works and what place it occupies in the overall optimization process.




    PowerBI: Real-time Data Visualization


    Sergey Lunyakin :
    PowerBI allows you to create beautiful and informative Dashboard, you can use various sources to obtain data, connectors to which are available in PowerBI . But data can be obtained directly from sources providing data constantly, in real time. For example, monitoring systems, sensors, sites, etc. In the report, we ’ll look at how to use the PowerBI REST API to build Dashboards that will display data from such sources.



    Performance analysis of Windows applications using SQL Server as an example using standard operating system functionality


    Mikhail Komarov :
    Performance analysis of Windows applications using SQL Server as an example using standard OS functionality. This report demonstrates how to collect and analyze data about the performance of the host and SQL Server itself using standard Windows functionality and several free utilities .



    Thanks to all! Enjoy watching :)

    Now a few words about the events for the spring-summer

    Soon we are expecting two SQL Saturday conferences : May 21 in Kiev and June 4 in Krasnodar .

    Also popular now: