SQL Server 2008 R 2 SQLBI MTC Moscow
SQL Server 2008 R 2 – новые возможности Иван Косяков Архитектор (SQL-BI), MTC Moscow Лидер Russian Business Intelligence User Group (PASS Chapter)
Проекты: приложения баз данных и уровня данных Проект баз данных (Mission or business critical) Проект приложения уровня данных (Departmental apps in V 1) Visual Studio Build . dacpac . sql Generate scripts . dbschema Deploy SQL Server 2005, 2008 R 2 SQL Server 2008 R 2
Ресурсы § Managing the SQL Server Utility http: //msdn. microsoft. com/enus/library/ee 210557(SQL. 105). aspx § Data-tier Application Tutorials http: //msdn. microsoft. com/enus/library/ee 210554(SQL. 105). aspx § Видео на Tech. Days. ru: Даниил Хабаров. SQL Server 2008 R 2: Multi-Server Administration и Data-Tier Application http: //www. techdays. ru/videos/2497. html
Демонстрация. Пример приложения Stream. Insight Иван Косяков Архитектор (SQL-BI), MTC Moscow Лидер Russian Business Intelligence UG (PASS Chapter)
Ресурсы § Stream. Insight Website § http: //www. microsoft. com/sqlserver/2008/en/us/R 2 -complexevent. aspx § Stream. Insight Books Online § http: //msdn. microsoft. com/en-us/library/ee 362541(SQL. 105). aspx § Stream. Insight Forums § http: //social. msdn. microsoft. com/Forums/en. US/streaminsight/threads § Stream. Insight Whitepaper § http: //download. microsoft. com/download/F/D/5/FD 5 E 855 C-D 89545 A 8 -9 F 3 E-110 AFADBE 51 A/Microsoft%20 CEP%20 Overview. docx § Видео на Tech. Days. ru: Михаил Сидоров. Технология Stream. Insight – обзор возможностей § http: //www. techdays. ru/videos/2484. html
Business Intelligence § § § Что есть в SQL Server 2008 Reporting Services MDS Excel и Power. Pivot Share. Point
Новое в Reporting Services
Демонстрация Визуализация данных (в Report. Builder 3. 0) Иван Косяков Архитектор (SQL-BI), MTC Moscow Лидер Russian Business Intelligence UG (PASS Chapter)
Ресурсы § SQL Server 2008 R 2 Books Online: What's New (Reporting Services) § § Report Builder 3. 0 – Shared Data Sets, by Yaniv Mor § § http: //prologika. com/CS/blogs/blog/archive/2009/11/16/shareddatasets. aspx SQL Spatial Tools § § http: //blogs. microsoft. co. il/blogs/yanivmor/archive/2009/12/16/reportbuilder-3 -0 -shared-data-sets. aspx Shared Datasets, by Teo Lachev § § http: //msdn. microsoft. com/en-us/library/ms 170438(SQL. 105). aspx http: //sqlspatialtools. codeplex. com/ Robert Bruckner’s Advanced Reporting Services blog § http: //blogs. msdn. com/robertbruckner/archive/2009/01/19/betterreport-viewing-in-visual-studio-2010. aspx
Ресурсы (продолжение) § Brian Hartman's Report Viewer blog: Java. Script API § § Microsoft Chart Controls for Microsoft. NET Framework 3. 5 § § http: //code. msdn. microsoft. com/mschart Alex Gorev’s Weblog – Data Visualization § § http: //www. microsoft. com/downloads/details. aspx? familyid=1 D 69 CE 13 -E 1 E 54315 -825 C-F 14 D 33 A 303 E 9&displaylang=en Chart Controls Samples § § http: //www. microsoft. com/downloads/details. aspx? Family. Id=130 F 7986 -BF 494 FE 5 -9 CA 8 -910 AE 6 EA 442 C&displaylang=en Microsoft Chart Controls Add-on for Microsoft Visual Studio 2008 § § http: //blogs. msdn. com/brianhartman/archive/2009/11/09/javascript-api. aspx http: //blogs. msdn. com/alexgor Видео на Tech. Days. ru: Евгений Никоноров. Новое в Reporting Services 2008 R 2 CTP 3 § http: //www. techdays. ru/videos/2228. html
Master Data Services
Ресурсы § Официальные ресурсы § Microsoft. com: http: //www. microsoft. com/sqlserver/2008/en/us/MDS. aspx § MSDN Library: http: //msdn. microsoft. com/enus/library/ee 633763(SQL. 105). aspx § Блоги § Kirk Haselden’s Kirkapedia (блог руководителя разработки MDS): http: //sqlblog. com/blogs/knightreign § Master Data Services Team: http: //sqlblog. com/blogs/mds_team § Блог Ивана Косякова: http: //microsoftbi. ru/2010/01/27/mds-3/ § Видео на Tech. Days. ru: Иван Косяков. Введение в Master Data Services http: //www. techdays. ru/videos/2184. html
Классы для веб-сервисов Microsoft. Master. Data. Services - методы IService § § § Annotations. Delete/Update Business. Rules. Clone/Create/Delete/Get/Palette. Set/Publish/Update Entity. Members. Copy/Create/Delete/Get/Merge/Update Export. View. Create/Delete/List. Get/Update Hierarchy. Members. Get Metadata. Clone/Create/Delete/Get/Update Model. Members. Bulk. Delete/Bulk. Merge/Bulk. Update/Get Security. Privileges. Clone/Create/Delete/Get Staging. Clear/Get/Process Validation. Get/Process Version. Copy …
Ресурсы § Официальные ресурсы § Microsoft. com: http: //www. microsoft. com/sqlserver/2008/en/us/MDS. aspx § MSDN Library: http: //msdn. microsoft. com/enus/library/ee 633763(SQL. 105). aspx § Блоги § Kirk Haselden’s Kirkapedia (блог руководителя разработки MDS): http: //sqlblog. com/blogs/knightreign § Master Data Services Team: http: //sqlblog. com/blogs/mds_team § Блог Ивана Косякова: http: //microsoftbi. ru/2010/01/27/mds-3/ § Видео на Tech. Days. ru: Иван Косяков. Введение в Master Data Services http: //www. techdays. ru/videos/2184. html
Новое в Excel и Power. Pivot
Демонстрация Power. Pivot для Excel Иван Косяков Архитектор (SQL-BI), MTC Moscow Лидер Russian Business Intelligence UG (PASS Chapter)
Варианты использования Power. Pivot для Excel Power. Pivot для Share. Point
Ресурсы Блог продуктовой команды Excel § § http: //blogs. msdn. com/excel Сайт Microsoft Power. Pivot § § http: //www. powerpivot. com Информационный центр Power. Pivot и DAX § § § Блог продуктовой команды Power. Pivot § § http: //blogs. msdn. com/powerpivot Описание языка Data Analysis Expression (DAX) § § http: //www. powerpivot-info. com http: //technet. microsoft. com/en-us/library/ee 634556(SQL. 105). aspx Видео на Tech. Days. ru: Александр Усольцев. Использование языка Data Analysis Expressions в Power. Pivot § http: //www. techdays. ru/videos/2467. html
Новое в Share. Point 2010
Ресурсы по SQL Server 2008 R 2 § SQL Server 2008 R 2 Training Kit § http: //www. microsoft. com/downloads § SQL Server 2008 R 2 Training Course on Channel 9 § http: //channel 9. msdn. com/learn § SQL Server on microsoft. com § http: //www. microsoft. com/sql § SQL Server Developer Center on MSDN § http: //msdn. microsoft. com/sql § SQL Server Tech Center on Tech. Net § http: //technet. microsoft. com/sql § Russian SQL Server User Group (INETA) § http: //sql. ineta. ru § Russian Business Intelligence User Group (INETA, PASS) § http: //rubi. ineta. ru § Блог Ивана Косякова о Microsoft BI § http: //microsoftbi. ru
Спасибо за внимание! Иван Косяков Архитектор (SQL-BI), MTC Moscow Лидер Russian Business Intelligence User Group (PASS Chapter) i-ivanko@microsoft. com
- Slides: 54