sqlsathistory

Nr: 430

Back to Main list

SQLSaturday #430 - Sofia 2015

Start Time (24h)	Speaker	Track	Title
10:15:00	Boriana Petrova	BIPrograming	Funky reports with Power BI for Excel and Office 365
10:15:00	Leonard Lobel	Azure	Introduction to Azure DocumentDB
10:15:00	Uwe Ricken	DBA	Mastering indexing maintenance with DMO like a PRO
10:15:00	Marcin Szeliga	Database development	Easy ETL with Biml
11:30:00	Leonard Lobel	Database development	Native File Streaming with SQL Server
11:30:00	Regis Baccaro	Azure	Azure Data Factory vs SSIS, the Ins and Outs.
11:30:00	Dr. Subramani Paramasivam	BIPrograming	Advanced Reporting Techniques Managing Reports
11:30:00	Ivan Donev	DBA	Are your SQL Server indexes effective?
13:15:00	Catalin Gheorghiu	BIPrograming	IoT and SQL (Server)
13:15:00	Margarita Naumova	Database development	The top 8 reasons for your transaction performance problems
13:15:00	Todor Peev	BIPrograming	Pros and cons of stored procedures and clr
13:15:00	Tsvetozar Ivanov	DBA	Microsoft SQL Server Transaction Log Inside
14:30:00	Markus Ehrenmueller-Jensen	BIPrograming	Boosting DWH-Performance with SQL Server 2016
14:30:00	Boris Hristov	DBA	Exploring Optimistic Concurrency
14:30:00	Ivelin Andreev	Database development	When SQL is not enough… there it comes Elasticsearch
14:30:00	Daniel Joskovski	BIPrograming	Implement Forecasting in C# with ADOMD in real application
16:00:00	Markus Ehrenmueller-Jensen	BIPrograming	My Favorite Pie (Chart)
16:00:00	Regis Baccaro	Database development	Continuous Integration with Sql Server Data Tool and Team Foundation Server
16:00:00	Miroslav Dimitrov	DBA	Tips and Tricks for Maintenance Optimization
16:00:00	Ivan Donev	Azure	Datawarehouse in the Cloud with Azure
17:15:00	Kaloyan Kosev	DBA	Backup and Recovery - Basics, tips, tricks and optimization
17:15:00	Stefan Damyanov	BIPrograming	A highway through the mountains of data with the SQL Server Tabular Model
17:15:00	Denis Reznik	Database development	Hidden gems of SQL Server 2014
17:15:00	Miroslav Lessev	Azure	Data Science in the Cloud

SessionID: 35621

Funky reports with Power BI for Excel and Office 365

Back to calendar

Event Date: 10-10-2015 - Session time: 10:15:00 - Track: BIPrograming

Speaker: Boriana Petrova

Title: Funky reports with Power BI for Excel and Office 365

Abstract:

The session will show how to prepare cool reports with Excel and publish them to Office 365.

SessionID: 36090

Introduction to Azure DocumentDB

Back to calendar

Event Date: 10-10-2015 - Session time: 10:15:00 - Track: Azure

Speaker: Leonard Lobel

Title: Introduction to Azure DocumentDB

Abstract:

Azure DocumentDB is a new highly-scalable NoSQL database platform on Microsoft Azure, designed as a fully managed cloud service for modern web and mobile applications. Like other NoSQL platforms, DocumentDB supports schema-free designs, and scales across replicas with fast write performance and eventual consistency. But DocumentDB also offers several unique features that make it a compelling candidate for NoSQL scenarios, which you will learn about in this session. The platform is based on HTTP/REST, embraces JSON as a standard document format, and is supported by a wide range of SDKs for .NET, JavaScript, Java, Python, and Node.js. Without defining any index paths, new documents are queryable within milliseconds, using SQL grammar or LINQ. Learn these and other capabilities, including server-side JavaScript-based stored procedures, user-defined functions, triggers, tunable consistency, and more.

SessionID: 37475

Mastering indexing maintenance with DMO like a PRO

Back to calendar

Event Date: 10-10-2015 - Session time: 10:15:00 - Track: DBA

Speaker: Uwe Ricken

Title: Mastering indexing maintenance with DMO like a PRO

Abstract:

Make your business happy with well performing databases. To master these approaches you are responsible for well performing indexes which may not harm the daily business of your customers. With a handy toolset of common database management objects (DMO) you can become the superstar in your SQL Server team. Impress your team members when you detect common indexing issues like a pro with dmo's.

SessionID: 38029

Easy ETL with Biml

Back to calendar

Event Date: 10-10-2015 - Session time: 10:15:00 - Track: Database development

Speaker: Marcin Szeliga

Title: Easy ETL with Biml

Abstract:

Can ETL be fun? Unfortunately, very often creation of ETL layer is time-consuming, tedious, error-prone task. What’s more, any change in requirement needs most of the work to be redone. In our session we’ll present new approach to creating BI solutions using Biml language and Mist programming environment. They greatly simplify the process, allowing for amazing flexibility, and make the ETL work more pleasant. We will show real examples of how Biml and C# generates hundreds of usable SSIS packages in just couple of minutes. We will also cover integration of ETL with TFS and CI for ETL. Everything with 100% compatibility with unmodified SQL Server. Join us and see how BI just became fun again

SessionID: 36091

Native File Streaming with SQL Server

Back to calendar

Event Date: 10-10-2015 - Session time: 11:30:00 - Track: Database development

Speaker: Leonard Lobel

Title: Native File Streaming with SQL Server

Abstract:

In this dynamic session, Lenni will teach you the ins-and-outs of unstructured data storage and native file streaming with FILESTREAM (introduced in SQL Server 2008) and FileTable (new in SQL Server 2012). Learn how to program FILESTREAM using T-SQL and, for maximum performance, using the OpenSqlFileStream API in C#. We’ll also cover the hierarchyid data type, which casts a hierarchical structure over every FileTable, and wrap up with the full-text search improvements and new Statistical Semantic Search in SQL Server 2012 that you can leverage to get the most out of unstructured documents contained in your databases.

SessionID: 37422

Azure Data Factory vs SSIS, the Ins and Outs.

Back to calendar

Event Date: 10-10-2015 - Session time: 11:30:00 - Track: Azure

Speaker: Regis Baccaro

Title: Azure Data Factory vs SSIS, the Ins and Outs.

Abstract:

ADF provides a managed way to orchestrate the collection, movement and transformation of structured and semi-structured data together. It works both with on-premises and cloud data and it has - of course - a powershell interface, enabling you to manage it without the bling of the Azure portal. But is it useful, is it fast, is it easy and powerful to use ? And most of all is Azure Data Factory the new SSIS ?

These are some of the questions that might arise, when reading about this new PaaS and that we will answer together in this demo packed session where will we go through orchestration, consumption and administration of data through the ADF pipeline.

SessionID: 39495

Advanced Reporting Techniques Managing Reports

Back to calendar

Event Date: 10-10-2015 - Session time: 11:30:00 - Track: BIPrograming

Speaker: Dr. Subramani Paramasivam

Title: Advanced Reporting Techniques Managing Reports

Abstract:

Any data that we have today is delivered to end users as reports and dashboards.

=gt; When it is more than 50 reports, 10 departments, 300 users, how to manage the department categories by folders, reports, users, groups security? =gt; What are the techniques to implement linked reports, subscriptions, report history, snapshot options? =gt; How to edit reports using browser based Report Builder and reuse some of the report parts? =gt; How to build a report that is very simple to use but has advanced capabilities? =gt; How do I see the subscription information that stores data in XML format within ReportServer database? =gt; How to take ownership of a deployed report(s) using T-SQL and is it healthy modifying the data using T-SQL directly on the DB?

There are plenty of things that we can do with Reporting services, Report Manager and you can find answers for all above questions in this session.

This session also helps you identify the performance bottleneck in poor performing SSRS s

SessionID: 39756

Are your SQL Server indexes effective?

Back to calendar

Event Date: 10-10-2015 - Session time: 11:30:00 - Track: DBA

Speaker: Ivan Donev

Title: Are your SQL Server indexes effective?

Abstract:

Indexes are important! They can make your life easy, but they can be a huge performance killer. No matter your role - DBA or DEV, you need to design effective indexing strategy and most importantly - know if those indexes are really effective. SQL Server gives you number of possibilities to track the use of your indexes and suggest you new ones. But what else we need to be careful for? How to keep our SQL Server in proper index shape? Join me for this one-hour session where we will have real fun on indexes and I promise you, you will leave with plenty of ideas for improving your index environment!

SessionID: 39131

IoT and SQL (Server)

Back to calendar

Event Date: 10-10-2015 - Session time: 13:15:00 - Track: BIPrograming

Speaker: Catalin Gheorghiu

Title: IoT and SQL (Server)

Abstract:

Or IoT for DBAs

And we are not talking about Oracle Index Organized Tables, we are talking about Internet of Things. This buzzword you hear almost everywhere, and for sure needs databases. So let’s take the Microsoft vision of IoT and see the database side of it. We will talk about the vision of IoT and the real world practicalities of it. The presentation goal is to provide a DBA all he/she needs to know to support an IoT application. And to make you curious we will cover topics such SQL 2014 for Embedded Systems or the Azure offerings (and their SQL connections), and I will try full demos with IoT hardware.

SessionID: 40279

The top 8 reasons for your transaction performance problems

Back to calendar

Event Date: 10-10-2015 - Session time: 13:15:00 - Track: Database development

Speaker: Margarita Naumova

Title: The top 8 reasons for your transaction performance problems

Abstract:

Transaction is running slow! How many times you have seen this on your production system, how many times you heard have this from your users? It’s time to isolate issues and get them resolved!

There are common reasons for transaction delays like slow transaction log, page splits, blocking, over-indexing, and even some configuration settings of your database and/or instance. Query tuning tips are slightly different than those for transactions, this session is about OLTP performance troubleshooting. I will show you some typical scenarios of transaction delays and the reasons behind them. This will definitely help you in your performance troubleshooting efforts and will give you a good level of confidence.

SessionID: 41078

Pros and cons of stored procedures and clr

Back to calendar

Event Date: 10-10-2015 - Session time: 13:15:00 - Track: BIPrograming

Speaker: Todor Peev

Title: Pros and cons of stored procedures and clr

Abstract:

During the session we will review definitions of stored procedures, clr and orm, and will inspect some simple code examples.Then we will discuss practical and philosophical aspects of choice and/or combinations of these options, how they affect design and performance of databases and apps. Fun for everybody!

SessionID: 41251

Microsoft SQL Server Transaction Log Inside

Back to calendar

Event Date: 10-10-2015 - Session time: 13:15:00 - Track: DBA

Speaker: Tsvetozar Ivanov

Title: Microsoft SQL Server Transaction Log Inside

Abstract:

We will present in this session the concept of the transaction log, its importance and the roles it plays inside the database engine. We will look at how logging and recovery works, the checkpoint process, write-ahead logging, and steps we need to perform as a DBA to ensure proper management of the transaction log for a SQL Server database.

SessionID: 37582

Boosting DWH-Performance with SQL Server 2016

Back to calendar

Event Date: 10-10-2015 - Session time: 14:30:00 - Track: BIPrograming

Speaker: Markus Ehrenmueller-Jensen

Title: Boosting DWH-Performance with SQL Server 2016

Abstract:

SQL Server 2016 brings the topic "in-memory" to a new level. Not that previous versions did not hold as much as data as possible inside of memory through caching, but now we enter a new era: in-memory row stores, in-memory column stores and compiled stored procedures are different from what we have seen so far. In this session, you will see how you can leverage those new features and how you can come by existing limitations. Come back to office with the knowledge how to boost the performance of your ETL, queries and reports into the new era.

SessionID: 40040

Exploring Optimistic Concurrency

Back to calendar

Event Date: 10-10-2015 - Session time: 14:30:00 - Track: DBA

Speaker: Boris Hristov

Title: Exploring Optimistic Concurrency

Abstract:

The topic of SQL Server concurrency is for sure one of the most complex ones in the field. Locking, blocking, timeouts and performance issues are just some of the consequences of not choosing the proper isolation level for our applications. In this demo-intensive session we will not only talk, but actually go deep into optimistic concurrency and the two isolation levels it offers to us - Read Committed Snapshot and Snapshot isolation level. We will see how they work, how much they can help for the performance and scalability of our applications and what are the little gotchas we need to be aware of.

SessionID: 40499

When SQL is not enough… there it comes Elasticsearch

Back to calendar

Event Date: 10-10-2015 - Session time: 14:30:00 - Track: Database development

Speaker: Ivelin Andreev

Title: When SQL is not enough… there it comes Elasticsearch

Abstract:

Elasticsearch doubled its popularity during the last year and this is just one of the signs that something good is happening there. Yet this DB stays far behind the usual suspects like SQL Server and MySQL but there are areas where different technologies fit much better. One of these is complex and real-time search.

Elasticsearch builds on the top of the well-known Apache Lucene but is designed to easily scale and lay the foundation for modern search intensive applications. This session will draw your path into this relatively new technology, provide guidelines on its usage and practical advice on integration with your existing SQL Server solutions.

SessionID: 40906

Implement Forecasting in C# with ADOMD in real application

Back to calendar

Event Date: 10-10-2015 - Session time: 14:30:00 - Track: BIPrograming

Speaker: Daniel Joskovski

Title: Implement Forecasting in C# with ADOMD in real application

Abstract:

In this presentation we will start with description of the Data Mining Process, then we will Introduce the Microsoft Time Series Algorithm for Forecasting. Then we will demonstrate production of forecast by: SQL Server Data Tools (SSDT) Project. And we will show how to implement complete process as part of your application by using ADOMD on real data.

SessionID: 37581

My Favorite Pie (Chart)

Back to calendar

Event Date: 10-10-2015 - Session time: 16:00:00 - Track: BIPrograming

Speaker: Markus Ehrenmueller-Jensen

Title: My Favorite Pie (Chart)

Abstract:

Pies are definitely fine for dessert :-) – but sometimes also used for reports, even if their real use case is very narrow. Do you want deliver information in an effective and efficient way? Do you think, this is crucial for you a business’ success? Even when attractiveness of a report is important, beauty is in the eye of the beholder. Research shows that we can help end-users to understand the message of the data quickly by following some simple rules. You will see how you can implement those rules with Microsoft Excel's Tables and Charts and the Power View add-on – ending up with effective and efficient information delivering through beautiful dashboards. You will learn how to identify suboptimal dashboards and what you can do to improve them.

SessionID: 38753

Continuous Integration with Sql Server Data Tool and Team Foundation Server

Back to calendar

Event Date: 10-10-2015 - Session time: 16:00:00 - Track: Database development

Speaker: Regis Baccaro

Title: Continuous Integration with Sql Server Data Tool and Team Foundation Server

Abstract:

Keep your DBAs happy. Sounds like an impossible task ? In this session we are going to walkthrough different scenarios based on the interaction between SSDT and Team Foundation Server. Developing locally and publishing the changes to an on-premises instance of SQL Server. We will walkthrough several scenarios to get an idea of what works when and what doesn’t. At the end of this session you will be able to know how to get the best out of TFS and where the limitations are. You will also be able to pinpoint several other solutions for doing Continuous Integration with SSDT without compromising the flexibility.

SessionID: 40015

Tips and Tricks for Maintenance Optimization

Back to calendar

Event Date: 10-10-2015 - Session time: 16:00:00 - Track: DBA

Speaker: Miroslav Dimitrov

Title: Tips and Tricks for Maintenance Optimization

Abstract:

Probably, all of us have received a notice that the performance of their SQL Server is not running at the expected level. There are hundreds of reasons why this is the case but we need to start our check with the most simple one - how is our maintenance organized? Are we using the most suitable schedule and setup? We will explore how you can improve your maintenance's efficiency and explore some tricks for VLDBs.

SessionID: 41212

Datawarehouse in the Cloud with Azure

Back to calendar

Event Date: 10-10-2015 - Session time: 16:00:00 - Track: Azure

Speaker: Ivan Donev

Title: Datawarehouse in the Cloud with Azure

Abstract:

Azure SQL Datawarehouse is the latest SQL related cloud service, Microsoft released in Preview. It uses Microsoft’s massive parallel processing (MPP) architecture where you pay for time-to-insight, not hardware, based on performance objectives for fundamental data warehousing operations like scanning, loading, and query processing. Quickly deployable, it is definitely one of the services that will change the gear in the datawarehoue world. Join me in the session where I will provide a quick overview of the service and show you how easily you can migrate and start using it.

SessionID: 40042

Backup and Recovery - Basics, tips, tricks and optimization

Back to calendar

Event Date: 10-10-2015 - Session time: 17:15:00 - Track: DBA

Speaker: Kaloyan Kosev

Title: Backup and Recovery - Basics, tips, tricks and optimization

Abstract:

Backup and Recovery are some of the most important DBA tasks. All in all it is the data that matters and having an optimized backup strategy and a great recovery plan will save your day! Let's dive into the basics and the tips and tricks you will need to optimize your SQL Server backups and restores.

SessionID: 40697

A highway through the mountains of data with the SQL Server Tabular Model

Back to calendar

Event Date: 10-10-2015 - Session time: 17:15:00 - Track: BIPrograming

Speaker: Stefan Damyanov

Title: A highway through the mountains of data with the SQL Server Tabular Model

Abstract:

Do you know your data?

Let's go on a journey into the mountains of data and see if we can reach the peak!

What instruments will we use on this journey and how will we transform our data to help ourselves make the right decisions? Be prepared to see transformations of your data from a different point of view with the latest technology in this field, the Tabular Data Model. In this presentation, we will cover the main features of the Tabular Data Model, the usage of the standard reporting package, some useful applications / utilization through Share Point and exciting new features of Excel. We are enthusiastic facilitators of knowledge sharing, idea brainstorming, training and mentoring in the MS area of expertise. We are sure you will enjoy this presentation to the fullest and will get the maximum of useful tips for your everyday work!

Will you accept the challenge...?

SessionID: 40898

Hidden gems of SQL Server 2014

Back to calendar

Event Date: 10-10-2015 - Session time: 17:15:00 - Track: Database development

Speaker: Denis Reznik

Title: Hidden gems of SQL Server 2014

Abstract:

SQL Server 2014 is full of new features and improvements. Some of them are "Killer" features like InMemory OLTP, Clustered Columnstore Indexes, Buffer Pool Extensions, etc., which are discussed a lot and we always can get a lot of information about them. And in the same time, SQL Server 2014 have several fantastic features and improvements, which are more hidden from our sight. In this session we will talk in details about these features and improvements. Query Fingerprints, Cardinality Estimator, Tempdb improvements, and more features will be covered in this session.

SessionID: 41239

Data Science in the Cloud

Back to calendar

Event Date: 10-10-2015 - Session time: 17:15:00 - Track: Azure

Speaker: Miroslav Lessev

Title: Data Science in the Cloud

Abstract:

An overview of Data Science in cloud

This site is open source. Improve this page.