SLODUG
Spletno mesto uporabniške skupine slovenskih razvijalcev programskih rešitev
Zadnje letošnje srečanje SLODUG v sredo, 8.12.

Pozdravljeni,

Veseli dogodek bo v sredo, 8.12. na ustaljeni lokaciji.

Vsebina srečanja je sledeča:

17:00-17:15 Zbiranje

17.15-18:15 A Handful of Practical Advanced BI Problems (Dejan Sarka, SQL Server MVP)

In the presentation, we are going to show solutions for couple of problems you might run into with zour data warehousing and ETL application(s). These problems include:
- Dynamic dynami pivot. We all know that the PIVOT operator in T-SQL is not dynamic. Of course, we can make it dynamic through dynamic SQL. However, what if a single "dynamic" is not enough? What if instead of consuming the results in client application you need to insert the pivoted data into a destination table with ever-changing schema?
- Encrypted SSIS configurations. Whatever is inside a SSIS package, can be encrypted through regular SSIS options. However, you can store any package element outside a package, in a SSIS configuration, which can be, for example, an XML file or a SQL Server table. You might need to encrypt this information as well. How can you achieve this?
- Row-level security in a data warehouse. Row-level security is alsways a problem. In an OLTP applications, a typical solution involves views. However, what can you do in a data warehouse, with even more complex problem, when the schema changes? And how can you do row-level filtering in SSAS cube?

18.30-19:30 Koncepti v predpomnenju in MS AppFabric Distributed Cache (Matevž Gačnik, Gama System d.o.o.)

Predavanje je namenjeno razkritju konceptov in funkcionalnosti platforme za predpomnenje – Microsoft AppFabric Distributed Cache. Pogledali si bomo kako lahko AppFabric DC pomaga pri razvoju hitrih in skalabilnih spletnih aplikacij ter hkrati pomaga razbremeniti podatkovni nivo. Predlagali bomo nekaj možnih arhitektur, ki omogočajo izkorišanje sistema predpomnenja z več zornih kotov.

19:30 - * Debata, pizze in pivo.

Se vidimo na Šmartinski 140!


Posted 12-03-2010 10:23 by MihaM
Pripete označbe:
© 2004-2008 SLODUG
Powered by Community Server (Commercial Edition), by Telligent Systems