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!