Raspored
| 08:00 – 09:00 | Dolazak i registracija sudionika | |||
| 09:00 – 10:00 | A1 | Keynote | ||
|
|
|
TRACK 1
|
|
TRACK 2
|
|
10:10 – 11:00
|
A2
|
B2
|
||
|
11:10 – 12:00
|
A3
|
B3
|
||
|
12:10 – 13:00
|
A4
|
B4
|
||
|
13:00 – 14:30
|
Ručak
|
|||
|
14:30 – 15:20
|
A5
|
B5
|
||
|
15:30 – 16:20
|
A6
|
B6
|
||
|
16:20 – 16:50
|
Pauza, kava
|
|||
|
16:50 – 17:40
|
A7
|
B7
|
||
|
17:50 – 18:40
|
A8
|
B8
|
||
| 18:40 – 19:00 | A9 | Zatvaranje konferencije | ||
Query Tuning Tips for SQL Server 2008 and Denali
Writing T-SQL code that works correctly is not a trivial task. Writing T-SQL code that works correctly and efficiently is even less trivial of a task. This session will walk you through several query tuning tips that will help you write more efficient code.
The session will cover tips related to SQL Server 2008 as well as tips related to new features in the next planned major release—SQL Server 11, code-named Denali. You will learn about the performance penalties associated with the use of user defined functions and how to address those; use of computed columns for improved performance; efficient filtering with SQL Server Denali’s OFFSET/FETCH option, as well as use of the new SEQUENCE object to generate keys.
Download the session materials
T-SQL – Bug or Feature?
Some behaviors in T-SQL are clear bugs and some are clear features. But being a relational language with many unique aspects compared to procedural languages, sometimes you may find yourself wondering whether a certain behavior is in fact a bug or a feature. This session covers various cases that aren’t clear cut and through those cases try to shed some light to help better understand some important principals of this unique language.
Download the session materials
Data Quality in Denali
Data quality is these days one of the main focuses of many companies. Microsoft is also aware of this problem, and invests continuously in this area. In next version of SQL Server, code name Denali, we will get Data Quality Services (DQS). However, even before Denali, there are many tools and possibilities for data quality checks available. In this presentation, we are going to introduce and compare different data quality tools in SQL Server, including DQS, Integration Services Data Profiling task, Transact-SQL queries, and Analysis Services Data Mining models. We will show how we can use these tools efficiently to improve the quality of our data.
Download the session materials
Engineering BI Solutions
Are you starting to create a BI solution….but where do you begin with? How to setup everything correctly so that you'll be able to handle new features required by the customers easily and without too much effort? Which standard do you put in place so that everyone who will join the project will be immediately operative? How do you define your BI architecture so that it can be sound and flexible and the same time? All this questions come out every time someone has to start a BI project. That's because in this field there's a lot of architectural knowledge but almost nothing in terms of engineering discipline. In this session I'll present a set of rules and best practices, developed in more than six years of work, that helps to make the creation of a BI solution an engineered process. Naming convention, design decisions, database unit testing, layering and everything needed to make sure that we can have some standards that protects the project from careless errors, inexperience, heterogeneous solution ideas and everything can bring the project down. The proposed approach will also make sure that the solution will be "Adaptive" enough to embrace changes that happens during such long-running projects, taking also into consideration maintainability and helping to automate repetitive tasks.
Download the session materials
Performance tuning from the field
In this session we will look at some common practices I have seen in the field that cause performance problems. We will diagnose the cause of the problem and the resolution to the problem.
This includes the use of subqueries, over clauses, different join styles, handling large data volumes, indexes not being used and bad plans.
After this session you will have some more knowledge of what to look at in your SQL that can cause you problems and how to correct your code to avoid them.
SQL Server backup and restore done right
Surprisingly small number of people do any kind of backup. Even smaller number get it right. In this session we'll explain various backup types and strategies, and when to choose what over something else and why. Come, we'll have fun.
Download the session materials
AlwaysOn: Quest for The Holy Grail
SQL Server 2005 je predstavio Database Mirroring kao novi alat za povećavanje dostupnosti database sustava. Jednostavno konfiguriranje uz kvalitetne mogućnosti učinile su ovu tehnologiju izuzetno privlačnom i korištenom u praksi.
Sa SQL Serverom 2008 unešena su dodatna poboljšanja sistema, poput kompresiranja data streama i na taj način povećavanje efikasnosti komunikacije između servera. Dodatno je omogućen automatski data page repair sa mirror baze što je dodatno povećalo stabilnost sustava.
Mirroring međutim ima svoje mane, od kojih je bitno istaknuti da je tzv. 'Mirror' baza offline odnosno nedostupna za čitanje i obradu, moguće je povezati samo dva servera (i witness), te je failover omogućen isključivo na nivou baze.
HADRON AlwaysOn tehnologija koja dolazi sa Denali edicijom riješava trenutne nedostatke i omogućava stvarno postavljanje HA (high availability – visoka dostupnost) i DR (disaster recovery) sustava. Predavanje se bavi specifičnostima i detaljima postavljanja tehnologije HADRON i scenarijima implementacije.
Download the session materials
Living with SQL Server Full-text Search
If you're already using SQL Server Full-text Search (FTS) in your applications, or are just starting to consider it for a future implementation, there are a couple of things you should know about it, that some day just might save your life. Or at least make it a little less stressful. Join me in learning how to plan, deploy and maintain your full-text application.
Download the session materials
Building Large Scale Data Warehouses on SQL Server
Is SQL Server designed for large scale Data Warehousing? What should architect consider building very large projects on SQL Server? The session is covering improvements made in the last versions of the SQL Server (SQL 2008 and SQL 2008 R2) to support large scale Data Warehousing, as well as re-introducing balanced Data Warehouse architecture Fast Track. The Session is going to highlight some experience collected by the SQL CAT team in building big Data Warehouses projects, such as the most biggest data generators – Telecom companies.
Download the session materials
CSI SQL Server
Accelerating development of information technologies also causes the growth of computer crime which has the main goal to profit illegally, industrial espionage, forgery and falsification of data. Therefore, a demand for data security is needed more than ever. This presentation describes a methodts which ensures effective detection of authorized and unauthorized modification of database scheme and data itself.
Download the session materials
SQL Server memory usage
Cilj predavanja je prikazati utjecaj memorije na rad SQL Servera, te pokazati kako pravilno podesiti i monitorirati dostupnu memorije u svrhu što boljih performansi sustava.
Glavni dijelovi predavanja su:
- Postavke memorije na SQL Serveru
- Monitoring memorije pomoću performance countera
- Monitoring memorije pomoću DMV-a
- Analiza utjecaja memorije na izvršavanja upita
- Kako radi NUMA
- Troubleshooting problema sa memorijom (Memory dump)
- Demo: Paralelno izvršavanje upita (raspodjela memorije po jezgrama)
Download the session materials
The many adventures of the utility dimension
Utility dimension is a designing concept which can be used for implementing flexible calculations, data transformation, selections, iteration, advanced navigation, dimension compression and many other cool things you can do with your multidimensional cubes. The session gives a summary of utility dimension usage scenarios covered with many examples.
Download the session materials
SQL Statistics benefits, problems and solutions
Microsoft® SQL Server collects statistics about individual columns (single-column statistics) or sets of columns (multi-column statistics). Statistics are used by the query optimizer to estimate the selectivity of expressions, and thus the size of intermediate and final query results. Good statistics allow the optimizer to accurately assess the cost of different query plans, and choose a high-quality plan.
SQL Server has a number of features for maintaining statistics. The most important one is the ability to automatically create and update statistics. For the majority of databases and applications, developers and administrators can rely on the automatic creation and update of statistics to provide comprehensive and accurate statistics about their data.
What you can do if you need more control over statistics creation and update to get good query plans and manage the overhead of gathering statistics? You can use manual statistics creation and update capabilities. This will be the main goal of this presentation, explained in details by using many demos for all of the features including some problems and solutions and few tricks to achieve best performance.
Download the session materials
Mobile BI: New Trends and Opportunities
Arian Stipić & Tomislav Bronzin
Along with advances of technology, it is already both possible and inevitable to apply various BI solutions on mobile devices in almost any complex business solution today. This is an updated and completely revisited discussion on the latest developments in the Mobile BI one year later after the original pioneering presentation has been delivered. It gives a review of the existing market offer with special attention to the important conceptual and technical limitations. Presentation will give several recommendations about how to achieve the best effects with the introduction of BI solutions on mobile devices with special emphasize on the latest, not yet commercially available, Microsoft BI platform. Finally, presentation will (as tradition requires) present a couple of forecasts about the possible trends in the near future.
Download the session materials
