Build Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type

Sessions Found: 19
A DBA mindennapi munkája során sokszor szembesülhet olyan problémákkal, melyek megoldása sokkal egyszrubb lenne, ha az SQL Server aktuális állapotát, teljesítmény adatait össze tudná hasonlítani egy korábbi állapottal, az úgynevezett baseline-al. Az eloadás során megvizsgáljuk, hogy milyen adatokat érdemes gyujteni, valamint bemutatásra kerül egy ingyenes scriptgyujtemény, mely segítségével ezt könnyen meg is tehetjük.
Speaker:

Session Type:
Regular Session

Track:
Magyar nyelvű előadások

Level: Intermedia

Session Code:

Date: April 18

Time: 1:15 PM - 2:15 PM

Room: Room 1

Microsoft Azure SQL Database is a relational database-as-a-service that delivers predictable performance, scalability, business continuity and data protection for cloud developers. Azure SQL Database service is built on shared resources from thousands of physical machines at Microsoft Data Centers. Each physical machine host many databases; availability and performance for each database can vary based on other activities on the physical machine. Azure SQL Database uses some techniques to manage resources and provide a stable system with optimal usage of physical servers.
I will overview the architectural layers and internals of Azure SQL Database and then focus on resource management techniques like load balancing, engine throttling, using resource governor to isolate load on physical machines. We will go over resource limitations on Azure SQL Database like memory usage, database size, transaction duration and Temp DB usage. Finally, we will conclude with best practices
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Recommended for DBAs

Level: Intermedia

Session Code:

Date: April 18

Time: 2:30 PM - 3:30 PM

Room: Room 4

Ebben a prezentációban az SQL Server által biztosított magas rendelkezésre állási megoldásokat szeretném bemutatni. Ez az eloadás leginkább azoknak szól, akik most kezdtek az SQL Server-rel foglalkozni, illetve döntéshozóknak, akik szeretnék látni a lehetoségeket, költségeket.
Az alábbiak kerülnek bemutatásra:
- DBM
- FCI
- AAG
- Log Shipping


Demos:
- Log Shipping: basic setup
- DBM: basic setup 
- AAG: basic setup 
Speaker:

Session Type:
Regular Session

Track:
Magyar nyelvű előadások

Level: Beginner

Session Code:

Date: April 18

Time: 2:30 PM - 3:30 PM

Room: Room 1

Let's build a Powershell script together that will use Remoting to run whatever script you like in parallel on any number of servers. We'll talk about remoting, remoting across domains or even without, how to run scripts in the background and in parallel. I'll show you how to store the results and report on it across all your servers in one go.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Recommended for DBAs

Level: Advanced

Session Code:

Date: April 18

Time: 10:00 AM - 11:00 AM

Room: Room 4

This all demo session will take you through a case of how to build a completely meta-driven SSIS solution relaying on BIML and MDS to do the hard-work for you. Being able to do this and have the system finding the fastest way to load data automatically using system stored procedures enables you to offer near real-time reporting to your users.
Topics covered in the session
* BIML & SSIS
* MDS
* System SPs (especially sp_depends)
* Near Real-time reporting, what it takes and how to do it.
Speaker:

Session Type:
Regular Session

Track:
Recommended for BI professionals

Level: Intermedia

Session Code:

Date: April 18

Time: 11:15 AM - 12:15 PM

Room: Room 2

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!
Speaker:

Session Type:
Regular Session

Track:
Recommended for developers

Level: Intermedia

Session Code:

Date: April 18

Time: 2:30 PM - 3:30 PM

Room: Room 3

SQL Server Database Engine has so many business intelligence improvements that it might become your primary analytical database system. However, in order to get the maximum out of these features, you need to learn how to properly use them. This in-depth session shows some extremely efficient inventive algorithms for the statistical queries. The queries use Window functions, CLR aggregate functions, and other SQL Server capabilities. The session also explains the formulas and usage of those statistical procedures. This session is useful not only for BI developers; database and other developers can successfully learn how to write efficient queries as well.
Speaker:

Session Type:
Regular Session

Track:
Recommended for developers

Level: Advanced

Session Code:

Date: April 18

Time: 3:45 PM - 4:45 PM

Room: Room 3

From time to time on the forums emerge people in really tough situation: data is deleted, database is in SIMPLE recovery model, and as a cherry on top - there is no backup! It might be boss's private database that nobody has put into backup scheme yet, or some new database that was missing from the backup scheme.
It is nearly impossible to recover the lost data from that situation. But I will show you at least three methods. After this presentation, you will be prepared to solve such a tough case. It is really important to know two simple steps you must do really fast, and after that you can relax and extract the data with peace of mind and without time pressure.
Speaker:

Session Type:
Regular Session

Track:
Recommended for DBAs

Level: Advanced

Session Code:

Date: April 18

Time: 1:15 PM - 2:15 PM

Room: Room 4

A jól ismert mondás a végrehajtási tervekkel kapcsolatban is igaznak bizonyul. Statisztikailag az SQL Server az esetek többségében jó végrehajtási tervet készít, viszont van amikor bodületesen rosszat. A Query Optimizer felelos a végrehajtási tervek optimalizálásáért. Az elküldött SQL utasításokból ez a komponens állít elo egy "elég jó" végrehajtási tervet. Nem a legeslegjobbat. Végignéz néhány lehetséges változatot és azokból próbálja megbecsülni, hogy melyik lesz elég jó. Ha a becslés nem csúszik félre, akkor jó tervet kaphatunk, ha viszont igen, akkor nagyon átverve szoktuk érezni magunkat.

Az eloadásban azt fogjuk megnézni, hogy milyen szerepük van az indexeknek és a statisztikáknak a becslésben és a végrehajtási terv kiválasztásában.
Speaker:

Session Type:
Regular Session

Track:
Magyar nyelvű előadások

Level: Intermedia

Session Code:

Date: April 18

Time: 10:00 AM - 11:00 AM

Room: Room 1

Eloadásomban szó lesz a licenszelés alapjairól, mely konstrukciók közül választhatunk, ha Microsoft SQL bevezetésére adjuk a fejünket, majd megvizsgáljuk, szolgáltatóként milyen opciók állnak rendelkezésre. Részletesebben átbeszéljük, virtuális környezetben hogyan lehet az SQL Servert licenszelni, milyen esetben milyen szabályokat tudunk követni, milyen logikára épül az SQL licenszelése, majd zárásképpen néhány egyszerubb topológián keresztül mutatom be, mikor milyen licenszekre van szükség.
Speaker:

Session Type:
Regular Session

Track:
Magyar nyelvű előadások

Level: Beginner

Session Code:

Date: April 18

Time: 3:45 PM - 4:45 PM

Room: Room 1

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 different tools of Microsoft’s BI stack – 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.
Speaker:

Session Type:
Regular Session

Track:
Recommended for BI professionals

Level: Intermedia

Session Code:

Date: April 18

Time: 2:30 PM - 3:30 PM

Room: Room 2

When you are standing in line at the grocery store you know exactly what you’re waiting for, paying the things you intend to buy. In SQL Server things aren’t usually so simple and many times you have to wait for more than only the length of the queue or the speed of the cashier. Thankfully SQL Server gathers the exact time you have been waiting and what resource you have been waiting on. In this session we will take a look at how SQL Server gathers this information and how it can help you identify, troubleshoot and proactively solve performance issues.
Speaker:

Session Type:
Regular Session

Track:
Recommended for DBAs

Level: Intermedia

Session Code:

Date: April 18

Time: 3:45 PM - 4:45 PM

Room: Room 4

Az önkiszolgáló BI (Self Service BI) napjaink egyik legfelkapottabb üzleti intelligencia trendje. De vajon mi van mögötte? Valós innováció, vagy csak egy újabb marketing kifejezés? Tényleg lehet Excellel több tízmillió soros döntéstámogató rendszert építeni vagy csak az Excel felhasználók játékszerét misztifikálják túl? Az eloadáson választ keresünk ezekre a kérdésekre és közben az üzleti felhasználók szemüvegén keresztül vizsgáljuk meg azt, hogy milyen lehetoségeket nyújt Nekik az Excel Power Pivot bovítményébe rejtett oszlopalapú, memóriában futó adatbázis kezelo.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Magyar nyelvű előadások

Level: Beginner

Session Code:

Date: April 18

Time: 11:15 AM - 12:15 PM

Room: Room 1

Your stored procedure is slow in the application, but works perfect in SSMS! In this presentation it will be clarified why this happens and why parameter sniffing is a problem in SQL Server stored procedures. Of course we will offer several solutions for this problem and discuss which solution is applicable in which scenario.
Speaker:

Session Type:
Regular Session

Track:
Recommended for developers

Level: Intermedia

Session Code:

Date: April 18

Time: 11:15 AM - 12:15 PM

Room: Room 3

As we get more and more data, we are moving more and more data.  Extracting and Transforming more and more data. Loading more and more data.  One thing we do not have more of, is time.  Learn how to address your growing data problem within your same amount of ETL time windows.  We will discuss challenges such as ETL across continents and across Clouds.
Demos will be done on SQL Server 2014, and we will learn what is coming in SQL v.Next for improvements.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Recommended for BI professionals

Level: Intermedia

Session Code:

Date: April 18

Time: 3:45 PM - 4:45 PM

Room: Room 2

A lot of companies have a philosophy of "ship early with as many features as possible.” Security is an afterthought since it isn't fun to do and no one will attack them anyway. However, the dark side never sleeps, and security breaches have always happened, often leaving companies severely exposed or even bankrupt.
In this session we'll look at a few attack vectors that can be used against your company, and what you as a developer can and should do to protect against them. It will involve a good mix of security conscious SQL Server and application development, because you care about your work and nobody messes with you.
Speaker:

Session Type:
Regular Session

Track:
Recommended for developers

Level: Intermedia

Session Code:

Date: April 18

Time: 1:15 PM - 2:15 PM

Room: Room 3

SQL Server Integration Services (SSIS) include several most important components required in data acquisition, transformation, and load operations. If the problem at hand demands a solution that cannot be solved using the built-in components alone, you can resort to the freely extensible Script Component, but when the circumstances also call for a more complex, and more robust solution, that will be deployed to more than one destination server, the more appropriate alternative is to design a Custom Component.In this session you will learn how this can be achieved, what advantages it provides, and how to perform even the most complex data transformations in a standardised and reliable environment.
Speaker:

Session Type:
Regular Session

Track:
Recommended for BI professionals

Level: Advanced

Session Code:

Date: April 18

Time: 10:00 AM - 11:00 AM

Room: Room 2

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.
Speaker:

Session Type:
Regular Session

Track:
Recommended for DBAs

Level: Intermedia

Session Code:

Date: April 18

Time: 11:15 AM - 12:15 PM

Room: Room 4

SQL Server 2014 comes with dozens of improvements in various areas. In this session we will discuss and see how the latest release can make the life of each and every developer easier and what are the top 5  T-SQL enhancements that we can use in our day-to-day work. 
Speaker:

Session Type:
Regular Session

Track:
Recommended for developers

Level: Intermedia

Session Code:

Date: April 18

Time: 10:00 AM - 11:00 AM

Room: Room 3

Sessions Found: 19
Back to Top