Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type

Sessions Found: 21
Mi az a végrehajtási terv? Miért hozza létre és mire használja az SQL Server? Mik azok az operátorok? Mi a különbség a logikai és fizikai operátorok között? Mit jelent az index seek és az index scan, melyik a jobb? Van-e tábla seek? Hogyan kell jól olvasni a végrehajtási terveket? Az eloadás ezekre a kérdésekre ad választ. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
01 Magyar nyelvu szekcio

Level: Intermedia

Session Code:

Date: March 01

Time: 12:00 AM - 1:00 AM

Room: TBD

Egy általános adatbányászatba történo bevezetést követoen áttekintjük az SQL Server Analysis Services nyújtotta adatbányászati lehetoségeket. Végignézzük a rendelkezésünkre álló algoritmusokat, valamint azt, hogy melyiket mire lehet használni. Egy konkrét példán kereszül végigmegyünk az adatbányászati struktúra és modell létrehozásának folyamatán, modellt processzálunk és értelmezzük az elért eredményeket. Kicsit elmélyülünk a klaszterezésben, és megmutatjuk azt is, hogyan lehet lekérdezni és integrálni egy adatbányászati modellt.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
01 Magyar nyelvu szekcio

Level: Beginner

Session Code:

Date: March 01

Time: 12:00 AM - 1:00 AM

Room: TBD

Microsoft released SQL Azure more than two years ago - that's enough time for testing (I hope!). So, are you ready to move your data to the Cloud? If you’re considering a business (i.e. a production environment) in the Cloud, you need to think about methods for backing up your data, a backup plan for your data and, eventually, restoring with Red Gate Cloud Services (and not only). In this session, you’ll see the differences, functionality, restrictions, and opportunities in SQL Azure and On-Premise SQL Server 2008/2008 R2/2012. We’ll consider topics such as how to be prepared for backup and restore, and which parts of a cloud environment are most important: keys, triggers, indexes, prices, security, service level agreements, etc.
Speaker:

Session Type:
Regular Session

Track:
02 Data Platform Track 1

Level: Beginner

Session Code:

Date: March 01

Time: 12:00 AM - 1:00 AM

Room: TBD

Introducing the role of datastewards in Power BI. How to share, track and control data assest inside the organization with Power Query and the Data Management Gateway.
Speaker:

Session Type:
Regular Session

Track:
01 Magyar nyelvu szekcio

Level: Beginner

Session Code:

Date: March 01

Time: 12:00 AM - 1:00 AM

Room: TBD

Illustrate how multipurpose queries can lead to issues with scalability and performance. Show a few alternatives that will work for smaller and simpler queries while highlighting their limitations for more complex queries. Then work through building a dynamic search query to resolve the identified performance issues. Touching on: • Testing. • Tuning each part of the query in isolation. • Plan cache re-use • Security – SQL injection attacks and authorisation / code signing. • Possibly, mentioning greater re-use and extendibility.
Speaker:

Session Type:
Regular Session

Track:
02 Data Platform Track 1

Level: Intermedia

Session Code:

Date: March 01

Time: 12:00 AM - 1:00 AM

Room: TBD

This talk is about new features in Microsoft Entity Framework 6 - the new major release of EF. In December 2012 Entity Framework 6 beta was announced and made publicly available. In October 2013 were released EF 6.00 (major release) and EF 6.01. This is the first new version of EF since the announcement in 2012 that the product would be Open Sourced. Entity Framework is hosted on CodePlex. This presentation is about the new features, included in EF 6: Async Query and Save, Custom Code First Conventions, Multi-Tenant Migrations, Configurable Migrations History Table, Code-Based Configuration, Dependency Resolution, Updated Provider Model, Enums, Spatial and Better Performance on .NET 4.x, Stored Procedures & Functions in Code First, Connecti
Speaker:

Session Type:
Regular Session

Track:
02 Data Platform Track 1

Level: Intermedia

Session Code:

Date: March 01

Time: 12:00 AM - 1:00 AM

Room: TBD

This presentation introduces the upgraded features of SQL Server 2012 Master Data Services (MDS) and the new service, SQL Server 2012 Data Quality Services (DQS).

MDS is a solution for master data management. First released in SQL Server 2008 R2, this upgraded version includes many new features and enhancements, including a new web interface developed with Silverlight, an Excel add-in to support simplified model creation and easier data updates and management.

DQS is a new knowledge-driven data cleansing solution, and it supports building knowledge bases that provide correction and de-duplication of data.
Speaker:

Session Type:
Regular Session

Track:
04 BI Track

Level: Intermedia

Session Code:

Date: March 01

Time: 12:00 AM - 1:00 AM

Room: TBD

In this fun session, we will use Microsoft's Big Data and PowerBI tools to learn about Hungary! We will mix and mashup data from a variety of sources such as 'The Spirit Level' by Prof Richard Wilkinson, UNICEF, the World Bank and even the CIA to learn more about Hungary. Business Intelligence professionals need to tackle ever-increasing sources of data that are increasing in volume, velocity and variety. Let's look at fun example of global data about Hungary to look at common data storytelling by BI and BA professionals: analysing open data with varying degrees of data quality, business puzzles versus business mysteries, and deciding on which chart or graph to use when presenting data. If the 'too much data, too little information' scenario is familiar, then come to this session, which isn't just for the international visitors visiting SQLSaturday Budapest like myself! Uncover surprising facts as we mashup, slice and dice the data, and look at Big Data and Data Visualisation along the
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
04 BI Track

Level: Beginner

Session Code:

Date: March 01

Time: 12:00 AM - 1:00 AM

Room: TBD

Ever deployed an Analysis Services cube that worked perfectly well with one user on the development server, only to find that it doesn't meet the required volumes of user concurrency?
 
This session focuses on tools and methodology to load test Analysis Services in highly concurrent environments. Including how to locate resource bottlenecks and the appropriate configuration settings that can help improve performance.
 
Sample source code will be supplied to help you load test analysis services. We will be focused on the MOLAP engine, but techniques are equally applicable to the  tabular model.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
04 BI Track

Level: Advanced

Session Code:

Date: March 01

Time: 12:00 AM - 1:00 AM

Room: TBD

This session explores the seven CUBE functions that are natively available in Excel. Unknown to many business analysts, these useful functions can be used to retrieve data model members and values to create parameter-driven report designs.The session topics will introduce each of the seven functions. Demonstrations will range from the simple, to the more sophisticated involving dynamic expressions, MDX expressions, integration of data from multiple data models, and macro-driven layouts.This session is a must for those looking to drive more from Excel when reporting from the BI Semantic Model. Much of the content presented in this session is applicable to Excel 2007, 2010 and 2013.
Speaker:

Session Type:
Regular Session

Track:
04 BI Track

Level: Intermedia

Session Code:

Date: March 01

Time: 12:00 AM - 1:00 AM

Room: TBD

Having a SQL Server solution for a problem does not mean the job is done. Of course, the next immediate issue is the performance. Temporal queries that involve intervals are typically very IO and CPU intensive. For example, a test for overlapping intervals was solved with inefficient queries for years. However, a handful of solutions with fast queries was developed lately. This high-level technical session introduces five different methods to get efficient queries that search for overlapping intervals. Of course, these solutions can be implemented on other temporal problems as well. Actually, the test for overlapping intervals is one of the most complex temporal problems.
Speaker:

Session Type:
Regular Session

Track:
03 Data Platform Track 2

Level: Advanced

Session Code:

Date: March 01

Time: 12:00 AM - 1:00 AM

Room: TBD

Sometimes you really need an EAV model. In most cases they are ugly and slow.
After this session you will have gained new insights how to turn your old, slow, EAV model into a slim superfast model.

There will be real life examples from a recent project. With the techniques displayed in the presentation, I cut the execution time down from 134 days down to 0.5 seconds and cut the storage need from 550GB to 45GB.
Speaker:

Session Type:
Regular Session

Track:
03 Data Platform Track 2

Level: Intermedia

Session Code:

Date: March 01

Time: 12:00 AM - 1:00 AM

Room: TBD

In SQL Server 2014 query processing has been improved. What we can expect from new cardinality estimator? Does it really estimate better? Will our execution plans be better after migration to 2014? All of them? Is the key ascending column statistics problem solved in new version? Do we finally can have more than 200 steps in the statistics histogram per table? What about column correlation and cardinality estimates - are the predicates still completely independent?

This session will answers all these questions and will demonstrate new query processing capabilities and compare them with those from SQL Server2012.
Speaker:

Session Type:
Regular Session

Track:
03 Data Platform Track 2

Level: Advanced

Session Code:

Date: March 01

Time: 12:00 AM - 1:00 AM

Room: TBD

Vajon miért beszélnek az emberek viszonylag keveset a tranzakcionális replikációról? Miért találunk nagyobb eséllyel nyitott kérdéseket ebben a témában egy fórumon, mint például mirroringban vagy mentésben? 

És mire jó a tranzakcionális replikáció egyáltalán, és mire nem? És hogyan lehet svájcibicskát csinálni belole? Ezt próbálom meg körüljárni az összejövetel során.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
01 Magyar nyelvu szekcio

Level: Intermedia

Session Code:

Date: March 01

Time: 12:00 AM - 1:00 AM

Room: TBD

This session is based on participation of the audience for a great movie about SQL Server internals. This session will demonstrate complicated inernal db engine operatoins by using the audience as "objects" replaying each simple task.

So FUN should be the primaray target but step by step the audience will get familiar with the tremendous work SQL Server has to to when "simple" operations may occur
Speaker:

Session Type:
Regular Session

Track:
03 Data Platform Track 2

Level: Beginner

Session Code:

Date: March 01

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server 2012 Integration Services introduces a new SSIS project deployment model. With the new model comes a completely new SSIS project management solution, named SSIS Server. In this session you will learn about the SSISDB Catalog, the new SSIS data store, and how to deploy, maintain and monitor SSIS project and package executions on SQL Server 2012. There are several significant changes in the way SSIS solutions are administered in SQL Server 2012 compared to previous versions, and you should be familiar with them before using them in production.
Speaker:

Session Type:
Regular Session

Track:
04 BI Track

Level: Advanced

Session Code:

Date: March 01

Time: 12:00 AM - 1:00 AM

Room: TBD

Everybody knows that use of stored procedures offers a number of benefits over issuing T-SQL code directly from an application. In this demo heavy session I am going to explain to you:
1. Why plan caching and reuse is a good thing.
2. How to avoid unnecessary recompilations for plan stability-related reasons.
3. How to avoid unnecessary recompilations for plan optimality-related reasons.
4. When plan reusing is not a good thing and how you can deal with this “Parameter Sniffing” problem.
5. Why you should evade conditional logic inside stored procedures that do data access.
Speaker:

Session Type:
Regular Session

Track:
03 Data Platform Track 2

Level: Advanced

Session Code:

Date: March 01

Time: 12:00 AM - 1:00 AM

Room: TBD

I am sure you all know that troubleshooting problems related to locking and blocking (hey, sometimes there are deadlocks too) can be a real nightmare! In this session, you will be able to see and understand why and how locking actually works, what problems it causes and how can we use isolation levels and various other techniques to resolve them!
Speaker:

Session Type:
Regular Session

Track:
02 Data Platform Track 1

Level: Intermedia

Session Code:

Date: March 01

Time: 12:00 AM - 1:00 AM

Room: TBD

Szeretném bemutatni a T-SQL nyelv által biztosított hibakezelési eljárásokat, parancsokat és az elmúlt években szerzett tapasztalatokat. Itt nem csak a trry/catch és a throw használata, hanem az alábbi témakörök kerülnének lefedésre:
- alapveto hibakezelések: kell, nem kell?
- tranzakciók és a hibák
- XACT_ABORT hatása a hibákra és a tranzakciókra
- deadlock hibák kezelése
- hibák logolása

A prezentáció nagy hangsúlyt feketet a demókra, inkább gyakorlati, mint sem ppt alapú.
Speaker:

Session Type:
Regular Session

Track:
01 Magyar nyelvu szekcio

Level: Intermedia

Session Code:

Date: March 01

Time: 12:00 AM - 1:00 AM

Room: TBD

Leveraging Buffer Pool Extension and In-Memory OLTP in SQL Server 2014 with Fusion’s ioDrive2 product line increases database performance by allowing solid state storage to exist alongside DRAM. Fusion’s memory-like performance helps reduce costs by enabling organizations to scale with NAND flash versus DRAM.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
02 Data Platform Track 1

Level: Intermedia

Session Code:

Date: March 01

Time: 12:00 AM - 1:00 AM

Room: TBD

Sessions Found: 21
SQLSaturday