SQL Azure Reporting

Oct 23, 20110 likes249 views

Luka Lovosevic

SQL Azure Reporting session on Advanced Technology Day 7, Zagreb, Croatia

LECTURE

SQL Azure Reporting
Luka Lovo?evi?, Microsoft

Sadr?aj
? Uvod
? SQL Azure Reporting
? Razvoj izvje?taja
? Demo
? Novosti
? Zaklju?ak
? Korisno

Uvod
? SQL Azure
– Dio Windows Azure platforme
– SQL Server u oblaku
– Microsoft se brine o:
? Skalabilnosti
? Sigurnosti
? Dostupnosti
? Smanjenje tro?kova – pay as you go

Uvod (ii)
? SQL Server Reporting Services
– On-premise izvje?tajni sustav
– Enterprise-ready
– Podr?ka za razne izvore podataka
– Razni formati za eksport
– Pull / push
– Skalabilnost
– Mogu?nost pro?irenja (.NET)

SQL Azure Reporting
? Spoj SQL Azure + Reporting Services
? Izvje?tajni sustav u oblaku
– Skalabilno
– Sigurno
– Uvijek dostupno
– Isti alati i znanja
? Dio Microsoft BI Cloud roadmapa

SQL Azure Reporting (ii)
? Finalni public CTP
– Slu?beni Microsoft support
– Dostupno u svim data centrima
– Pobolj?ane performanse
– Sami mo?emo stvoriti SQL Azure Reporting server
? Potreban SQL Azure account
? Dostupno kroz Azure Management Portal
? Model naplate jo? nije definiran
– Bandwidth

SQL Azure Reporting (iii)
? Arhitektura
Load Balancer

Gateway nodes

– Multi-tenant
? RS gateway RS nodes

– Data tier
? SQL Azure database.windows.net

– Monitoring Catalog TempDB Data Source

– Sigurnost …

Razvoj izvje?taja
? Preduvjeti
– SQL Azure account i baza podataka
– SQL Azure Reporting usluga aktivirana
? Klasi?an life cycle
1. Dohvati podatke
2. Nacrtaj izvje?taj
3. Deploy
4. Security
5. Pregled preko browsera ili aplikacije
6. Export u neki od formata

Razvoj izvje?taja (ii)
? Razvoj
– Business Intelligence Development Studio
– Report Builder
? Izvor podataka - SQL Azure baza
? Management
– Windows Azure Management Portal
– Browser
? Sigurnost - SQL Azure autentikacija

Razvoj izvje?taja (iii)
? Ograni?enja vezana uz SQL Azure
? Nema full-text search, CLR integracija, …
? Windows auth jo? nije podr?an
? Jo? ne podr?ava
– Scheduling
– Pretplate
? Paziti na upite koji se dugo izvr?avaju

Demo
1. Registracija na Windows Azure
Management Portal
2. Stvaranje SQL Azure baze
3. Aktivacija SQL Azure Reportinga
4. Punjenje baze sadr?ajem
5. Izrada izvje?taja
6. Deploy
7. Pregled kroz browser i aplikaciju

Novosti
? PASS summit 2011
? SQL Azure Reporting public CTP
? SQL Azure novosti
– Q4 2011 Service Release
– Business edition – sa 50 na 150 GB
– Federations – sharding
– Pobolj?ani SQL Azure Management Portal
? Pregled query planova, statistika, itd.
? Metro UI

Novosti (iii)
? SQL Azure Data Sync CTP
– Povezivanje on-premise i cloud okolina
– Pobolj?ani Management Portal
? Grafi?ki pregled i pra?enje topologije za sync, itd.
– Definiranje sync grupa
– Dostupno direktno unutar SQL Azurea

? Apache Hadoop – big data
– Windows Azure CTP do kraja godine

Zaklju?ak
? Managed izvje?tajni sustav u oblaku
? Vi?e ne moramo brinuti o
skalabilnosti, sigurnosti, patchiranju, itd.
? Public CTP
? Ne znaju se jo? detalji o modelu naplate
? Ne moramo u?iti ni?ta novo, poznata
okolina i alati

Korisno
? SQL Azure Reporting FAQ
www.microsoft.com/windowsazure/faq/#reporting
? MSDN
msdn.microsoft.com/en-
us/library/windowsazure/gg430129.aspx
? SQL Azure Labs
www.microsoft.com/en-us/sqlazurelabs/default.aspx

– twitter.com/lukalovosevic
– hr.linkedin.com/in/lukalovosevic

El documento habla sobre diferentes temas relacionados con la expresión escrita y oral. Explica que al escribir es importante considerar el tema y darle un título breve pero que deje intriga. También habla sobre cómo resumir textos captando las ideas centrales, y sobre cómo redactar ensayos interpretando un tema de manera breve. Además, menciona normas para la presentación de textos y sobre la ortografía. Por último, aborda el miedo escénico al hablar en público y el uso de ayudas audiovisuales para transmit

Playmaker PeptalkCarsten Borch

Bilancio alfa spaFranz Romanof

Affine transformations 2PowerSaw

Ciberassetjament en adolescents (v.bona)aumapito

Skills rimpa 2011Anastasia Govan Kuusk

Maria noelpetynoel

La comunicación es el proceso que permite la relación entre las personas a través de elementos verbales como el lenguaje y no verbales como gestos y danza. Para que haya comunicación debe haber entendimiento. Según Jacobson, las funciones de la comunicación son informar, influir sobre el receptor, expresar la subjetividad del emisor y mantener la comunicación. El lenguaje puede variar de acuerdo a factores dialecticos, sociolectos, cronolectos e idiolectos.

Treinamento compacto 2013 20 min vers?o 2.1Mauro Friedrich

Leonardo da vincijgn1996

Dao tao do son 10. 2011hamanhcuong

Logística.. copiaedilma67331117

Mugatzaileaprofe42

??????? ??????? ??? ??? ??????????.amrtec2010

Biji kopi-1Bhadra Mano

Teks tersebut membandingkan proses memasak tiga bahan (wortel, telur, biji kopi) yang direbus dalam air mendidih selama 15 menit. Wortel menjadi lunak, telur menjadi keras, sedangkan biji kopi tidak berubah melainkan mengubah warna dan aroma air menjadi khas kopi. Perbandingan ini digunakan untuk mengajak pembaca agar dalam menghadapi kesulitan hidup, jangan menyerah seperti wortel atau membeku seperti tel

Novi vekfilipovicsabina

Wps italiano 03 10GpsLazio

Presentación final del CursoLuis Andrés Gonzalez

La investigadora Karen McComb observó que su gata usaba un ronroneo en lugar de un maullido para despertarla y pedir comida. Esto la llevó a investigar por qué algunos gatos usan ronroneos en lugar de maullidos para pedir comida, realizando experimentos con grabaciones de sonidos de gatos para analizar las diferencias en las frecuencias y duraciones de los ronroneos de solicitud frente a los de no solicitud. Sus hallazgos sugieren que los gatos usan ronroneos más placenteros para solicitar comida a los human

Formato condicional power metalMalloha

El documento presenta una explicación breve del formato condicional en Excel, el cual permite resaltar celdas con valores específicos usando colores, barras de datos e íconos. Se describen opciones como resaltar celdas mayores o menores a un número, iguales a un valor, con fechas determinadas o con valores entre rangos. También se explican reglas para resaltar los 10 valores más altos o bajos y el uso de escalas de color y barras para representar valores. Finalmente, se menciona la administración de múltiples formatos con

Curs - Domiciliul fiscalOlivia Anamaria

Allahu akbar!!!azylamp

Seguranca informacaosped sc-02-02-2012Ivanildo Marcelino

Auto route.jjauto-route

Boot Verbs Keynotepr437140mhs

健康知多少Chaur-ming Jeng

Sistemas operativos jpmtatii2011

Flacco E- learning-e_la_mediazione_formativaSicolo Francesco

MSNetwork 4 - Enterprise funkcionalnosti u malim tvrtkama sa Office 365Tomislav Lulic

Microsoft WinDays16 Technology Dynamics AX 7 Cloud ERP.PPTXIvan Kaselj

More Related Content

Viewers also liked (20)

Maria noelpetynoel

Treinamento compacto 2013 20 min vers?o 2.1Mauro Friedrich

Leonardo da vincijgn1996

Dao tao do son 10. 2011hamanhcuong

Logística.. copiaedilma67331117

Mugatzaileaprofe42

??????? ??????? ??? ??? ??????????.amrtec2010

Biji kopi-1Bhadra Mano

Novi vekfilipovicsabina

Wps italiano 03 10GpsLazio

Presentación final del CursoLuis Andrés Gonzalez

Formato condicional power metalMalloha

Curs - Domiciliul fiscalOlivia Anamaria

Allahu akbar!!!azylamp

Seguranca informacaosped sc-02-02-2012Ivanildo Marcelino

Auto route.jjauto-route

Boot Verbs Keynotepr437140mhs

健康知多少Chaur-ming Jeng

Sistemas operativos jpmtatii2011

Flacco E- learning-e_la_mediazione_formativaSicolo Francesco

Maria noelpetynoel

Treinamento compacto 2013 20 min vers?o 2.1Mauro Friedrich

Leonardo da vincijgn1996

Dao tao do son 10. 2011hamanhcuong

Logística.. copiaedilma67331117

Mugatzaileaprofe42

??????? ??????? ??? ??? ??????????.amrtec2010

Biji kopi-1Bhadra Mano

Novi vekfilipovicsabina

Wps italiano 03 10GpsLazio

Presentación final del CursoLuis Andrés Gonzalez

Formato condicional power metalMalloha

Curs - Domiciliul fiscalOlivia Anamaria

Allahu akbar!!!azylamp

Seguranca informacaosped sc-02-02-2012Ivanildo Marcelino

Auto route.jjauto-route

Boot Verbs Keynotepr437140mhs

健康知多少Chaur-ming Jeng

Sistemas operativos jpmtatii2011

Flacco E- learning-e_la_mediazione_formativaSicolo Francesco

Similar to SQL Azure Reporting (20)

MSNetwork 4 - Enterprise funkcionalnosti u malim tvrtkama sa Office 365Tomislav Lulic

Microsoft WinDays16 Technology Dynamics AX 7 Cloud ERP.PPTXIvan Kaselj

Kako izvuci (naj)vise iz vaseg share pointa 2013Matija Blagus

Upravljanje pristupom uz Azure AD B2C_IvanMarkovicIvan Markovi?

Za?to nam treba PaaS u Srcu?Denis Kranj?ec

U Srcu razvijamo, odr?avamo i dajemo podr?ku za veliki broj sustava, gdje se svaki sastoji od niza servisa i aplikacija, broj aktivnih korisnika ide i preko 150.000 (uglavnom iz akademske zajednice), a ti sustavi rade na raznim platformama (Java, .Net, PHP, ...). Potrebe i ?elje korisnika za doradama, nadogradnjama i pro?irenjima sustava konstantno rastu kako rastu i sami sustavi. Kako bi i dalje uspje?no pratili potrebe korisnika smatramo da nam treba Platform as a service (PaaS) kao temelj za daljnji razvoj i odr?avanje na?ih sustava. U prezentaciji je prezentirano u kojim segmentima rada nam PaaS mo?e pomo?i.

Osb studija slucaja sgsb-a.ppt [compatibility mOracle Hrvatska

Project Server and SharePoint Server - better togetherAdis Jugo

JavaCro'15 - Enterprise service bus - Juraj ?uti?HUJAK - Hrvatska udruga Java korisnika / Croatian Java User Association

?to je novo u Officeu 2016 za korisnikeTomislav Lulic

Oracle information age co croz-neos v2.2.Oracle Hrvatska

Microsoft sql server 2003sofijaseminarski

Javantura Zagreb 2014 - Alfresco-Neo4j integracija - Damir MuratHUJAK - Hrvatska udruga Java korisnika / Croatian Java User Association

Konferencija Javantura Zagreb 2014 by HUJAK Alfresco – Neo4j integracija – nova vrsta CMS aplikacija by Damir Murat Graph baze imaju mnoge primjene, a jedna od njih je oboga?ivanje i novi na?in pretra?ivanja i kori?tenja postoje?ih podataka. Ako prate?i tu ideju pove?emo CMS sustav Alfresco (www.alfresco.com) i graph bazu podataka Neo4j (www.neo4j.org), otvara se mogu?nost kreiranja nove vrste CMS aplikacija. Dodamo li u mje?avinu jo? i tehnologije kao ?to su Ext JS, D3.js i Grails, rezultat mo?e biti vrlo atraktivan za krajnjeg korisnika.

Kako pretvoriti server_sobu_u_cloudDubravko Marak

Kako pojednostaviti administriranje manjih okru?enja?Tomislav Lulic

Kvalitetno rje?enje za male tvrtke (do 25 korisnika) u kombinaciji sa uslugama u oblaku. Ga?enjem linije proizvoda pod nazivom Small Business Server, Microsoft poku?ava promijeniti svijest manjih IT okru?enja, koja bi se bazirala na hibridnom sustavu on-premise i cloud rje?enja. Prva verzija Essential servera do?ekana je na ?no?“, zbog popularnosti SBS-a i mogu?nosti koje je pru?ala. Da li je to stvarno tako i ?to je to u drugom izdanju Essential-a pobolj?ano i novo? Kako zavoljeti ovaj proizvod, uz upoznavanje njegovih prednosti i mogu?nosti. Osvrt na integraciju sa Office 365, User expirience, olak?ani backup sustav, korisni?ke kvote, health monitoring, VPN Connector.

Office 365 u malim tvrtkama s poslovne straneTomislav Lulic

Kako pretvoriti server_sobu_u_cloudDubravko Marak

White paper - Migracija IT rjes?enja u Cloud Hrvatskog TelekomaHrvatski Telekom

Why Firebird - Fact for decision makers, in BosnianMind The Firebird

Db security vaba information age 2010 v6.ppt [compatibility mOracle Hrvatska

Db security vaba information age 2010 v5.ppt [compatibility mOracle Hrvatska

MSNetwork 4 - Enterprise funkcionalnosti u malim tvrtkama sa Office 365Tomislav Lulic

Microsoft WinDays16 Technology Dynamics AX 7 Cloud ERP.PPTXIvan Kaselj

Kako izvuci (naj)vise iz vaseg share pointa 2013Matija Blagus

Upravljanje pristupom uz Azure AD B2C_IvanMarkovicIvan Markovi?

Za?to nam treba PaaS u Srcu?Denis Kranj?ec

Osb studija slucaja sgsb-a.ppt [compatibility mOracle Hrvatska

Project Server and SharePoint Server - better togetherAdis Jugo

JavaCro'15 - Enterprise service bus - Juraj ?uti?HUJAK - Hrvatska udruga Java korisnika / Croatian Java User Association

?to je novo u Officeu 2016 za korisnikeTomislav Lulic

Oracle information age co croz-neos v2.2.Oracle Hrvatska

Microsoft sql server 2003sofijaseminarski

Javantura Zagreb 2014 - Alfresco-Neo4j integracija - Damir MuratHUJAK - Hrvatska udruga Java korisnika / Croatian Java User Association

Kako pretvoriti server_sobu_u_cloudDubravko Marak

Kako pojednostaviti administriranje manjih okru?enja?Tomislav Lulic

Office 365 u malim tvrtkama s poslovne straneTomislav Lulic

Kako pretvoriti server_sobu_u_cloudDubravko Marak

White paper - Migracija IT rjes?enja u Cloud Hrvatskog TelekomaHrvatski Telekom

Why Firebird - Fact for decision makers, in BosnianMind The Firebird

Db security vaba information age 2010 v6.ppt [compatibility mOracle Hrvatska

Db security vaba information age 2010 v5.ppt [compatibility mOracle Hrvatska

More from Luka Lovosevic (10)

(WD16) Machine Learning u praksiLuka Lovosevic

Machine learning and the lambda architecture are discussed for practical applications like smart grids. The Cortana Analytics Quick Start templates provide ready-to-use templates for common use cases including demand forecasting for smart grids. Hands-on demos are shown using Azure services like Event Hub, Stream Analytics, and Machine Learning to power the lambda architecture and intelligent systems.

(WD15) Brzo odlucivanje uz pomoc Microsoft cloud platformeLuka Lovosevic

(ATD10) Postar zvoni dvaput - dostava podataka u AzureuLuka Lovosevic

(Windays 14) Big data u praksi - Kako postati predsjednik uz pomo? big data t...Luka Lovosevic

(Windays 13) Microsoft Big Data PlatformLuka Lovosevic

Microsoft Open Government Data InitiativeLuka Lovosevic

(ATD 9) Microsoft Big Data PlatformLuka Lovosevic

ALM u Microosft Hrvatska - SIBSLuka Lovosevic

This document summarizes a presentation about Application Lifecycle Management (ALM) in Microsoft Croatia - SIBS. It discusses SIBS, an interbank reporting system that processes 80 reports and 60 GB of data monthly. It also discusses moving to a new architecture, ALM, TFS, and continuous integration to support new regulations and bank requirements with tight deadlines. The presentation covers ALM, including continuous application lifecycle management from governance to development to operations. It demonstrates branching, releasing, building, and testing strategies used with ALM tools like TFS to manage versions from development to production.

MILE - Mobile and Interactive Learning EnvironmentLuka Lovosevic

mojmag.comLuka Lovosevic

mojmag.com is a proposed central online platform for browsing, finding, and accessing magazines. It would provide both a basic free hosting service for magazines as well as a professional paid service with additional features like readership analytics. The project faces threats such as no existing competitors, the difficult process of partnering with publishers, financial challenges, and ensuring the site always stays up to date. Future plans include adding classified listings and enabling online magazine subscriptions. The founders held a Q&A about the proposal.

(WD16) Machine Learning u praksiLuka Lovosevic

(WD15) Brzo odlucivanje uz pomoc Microsoft cloud platformeLuka Lovosevic

(ATD10) Postar zvoni dvaput - dostava podataka u AzureuLuka Lovosevic

(Windays 14) Big data u praksi - Kako postati predsjednik uz pomo? big data t...Luka Lovosevic

(Windays 13) Microsoft Big Data PlatformLuka Lovosevic

Microsoft Open Government Data InitiativeLuka Lovosevic

(ATD 9) Microsoft Big Data PlatformLuka Lovosevic

ALM u Microosft Hrvatska - SIBSLuka Lovosevic

MILE - Mobile and Interactive Learning EnvironmentLuka Lovosevic

mojmag.comLuka Lovosevic

SQL Azure Reporting

2. MOLIMO VAS STI?AJTE SVOJ MOBITEL

3. LECTURE SQL Azure Reporting Luka Lovo?evi?, Microsoft

4. Sadr?aj ? Uvod ? SQL Azure Reporting ? Razvoj izvje?taja ? Demo ? Novosti ? Zaklju?ak ? Korisno

5. Uvod ? SQL Azure – Dio Windows Azure platforme – SQL Server u oblaku – Microsoft se brine o: ? Skalabilnosti ? Sigurnosti ? Dostupnosti ? Smanjenje tro?kova – pay as you go

6. Uvod (ii) ? SQL Server Reporting Services – On-premise izvje?tajni sustav – Enterprise-ready – Podr?ka za razne izvore podataka – Razni formati za eksport – Pull / push – Skalabilnost – Mogu?nost pro?irenja (.NET)

7. SQL Azure Reporting ? Spoj SQL Azure + Reporting Services ? Izvje?tajni sustav u oblaku – Skalabilno – Sigurno – Uvijek dostupno – Isti alati i znanja ? Dio Microsoft BI Cloud roadmapa

8. SQL Azure Reporting (ii) ? Finalni public CTP – Slu?beni Microsoft support – Dostupno u svim data centrima – Pobolj?ane performanse – Sami mo?emo stvoriti SQL Azure Reporting server ? Potreban SQL Azure account ? Dostupno kroz Azure Management Portal ? Model naplate jo? nije definiran – Bandwidth

9. SQL Azure Reporting (iii) ? Arhitektura Load Balancer Gateway nodes – Multi-tenant ? RS gateway RS nodes – Data tier ? SQL Azure database.windows.net – Monitoring Catalog TempDB Data Source – Sigurnost …

10. Razvoj izvje?taja ? Preduvjeti – SQL Azure account i baza podataka – SQL Azure Reporting usluga aktivirana ? Klasi?an life cycle 1. Dohvati podatke 2. Nacrtaj izvje?taj 3. Deploy 4. Security 5. Pregled preko browsera ili aplikacije 6. Export u neki od formata

11. Razvoj izvje?taja (ii) ? Razvoj – Business Intelligence Development Studio – Report Builder ? Izvor podataka - SQL Azure baza ? Management – Windows Azure Management Portal – Browser ? Sigurnost - SQL Azure autentikacija

12. Razvoj izvje?taja (iii) ? Ograni?enja vezana uz SQL Azure ? Nema full-text search, CLR integracija, … ? Windows auth jo? nije podr?an ? Jo? ne podr?ava – Scheduling – Pretplate ? Paziti na upite koji se dugo izvr?avaju

13. Demo 1. Registracija na Windows Azure Management Portal 2. Stvaranje SQL Azure baze 3. Aktivacija SQL Azure Reportinga 4. Punjenje baze sadr?ajem 5. Izrada izvje?taja 6. Deploy 7. Pregled kroz browser i aplikaciju

14. Novosti ? PASS summit 2011 ? SQL Azure Reporting public CTP ? SQL Azure novosti – Q4 2011 Service Release – Business edition – sa 50 na 150 GB – Federations – sharding – Pobolj?ani SQL Azure Management Portal ? Pregled query planova, statistika, itd. ? Metro UI

15. Novosti (ii)

16. Novosti (iii) ? SQL Azure Data Sync CTP – Povezivanje on-premise i cloud okolina – Pobolj?ani Management Portal ? Grafi?ki pregled i pra?enje topologije za sync, itd. – Definiranje sync grupa – Dostupno direktno unutar SQL Azurea ? Apache Hadoop – big data – Windows Azure CTP do kraja godine

17. Zaklju?ak ? Managed izvje?tajni sustav u oblaku ? Vi?e ne moramo brinuti o skalabilnosti, sigurnosti, patchiranju, itd. ? Public CTP ? Ne znaju se jo? detalji o modelu naplate ? Ne moramo u?iti ni?ta novo, poznata okolina i alati

18. Korisno ? SQL Azure Reporting FAQ www.microsoft.com/windowsazure/faq/#reporting ? MSDN msdn.microsoft.com/en- us/library/windowsazure/gg430129.aspx ? SQL Azure Labs www.microsoft.com/en-us/sqlazurelabs/default.aspx – twitter.com/lukalovosevic – hr.linkedin.com/in/lukalovosevic

19. PITANJA

20. HVALA!

Editor's Notes

#6: - Relacijska baza podataka
#7: SQL Server, Analysis Services, Oracle, Teradata, XML, SQL Azure, itd.Sigurnost (role-based)Izvr?avanje: on-demand, cache (multi-user), schedulirano, snapshotsWeb servis koji exposea van funkcionalnostiRazni alati za authoring (BIDS, Report Builder)Pull – klasika (web forme, win forme, BIDS, Sharepoint, itd.)Push – delivery na mail, itd.
#11: SQL Server, Analysis services, Sharepoint, Oracle, OLE DB, ODBC, XML, SAP, Hyperion, …Business Intelligence Development Studio, Report Builder

狠狠撸

SQL Azure Reporting

Recommended

More Related Content

Viewers also liked (20)

Similar to SQL Azure Reporting (20)

More from Luka Lovosevic (10)

SQL Azure Reporting

Editor's Notes