SQLSaturday #176 - Pordenone, Italy 201211/17/2012 12:00:00 AM(GMT+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, ViennaSQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat176Consorzio Universitario di PordenoneVia PraseccoPordenone , Italy331702742SolidQ Italyhttp://www.solidq.comhttp://www.sqlsaturday.com/files/338fa3c5-d141-4485-a023-0ffac9e8b007.png601702744Servizi CGNhttp://www.cgn.it/http://www.sqlsaturday.com/files/62289f86-2ff6-43a9-8809-efe85b5dff17.png601702804Trilancehttp://www.trilance.com/http://www.sqlsaturday.com/files/c2021607-f64c-4c54-8cd2-1591a3d5fd28.png601702805Real Comm srlhttp://www.realcomm.it/http://www.sqlsaturday.com/files/f738c84d-094f-40f6-9fdd-e2ecf425bab9.png601702806Think ithttp://www.thinkit.it/http://www.sqlsaturday.com/files/2fc0f42b-eea9-4a6a-9121-b94e834f7f1d.png6017028071nn0vahttp://www.innovazionefvg.net/http://www.sqlsaturday.com/files/a1ffc970-f9bb-4281-97c0-61833400e6a9.png601702809sqlbihttp://www.sqlbi.com/http://www.sqlsaturday.com/files/aa6b224c-fa13-4ab4-ae7a-902293de6a0f.png601702810Consorzio Universitario di Pordenonehttp://www.unipordenone.it/http://www.sqlsaturday.com/files/3c22a83e-8796-41ca-9f91-5fba4b893709.png601702814Beantechhttp://www.beantech.it/http://www.sqlsaturday.com/files/0f4d8963-72d9-4396-8280-ab35c47e418e.png6017011481David Peter HansenDavid Peter Hansen is a Principal Consultant, Practice Manager at Platon, a Scandinavian Information Management consultancy. He has worked with database development and administration for 11 years, and has worked with the Microsoft Business Intelligence platform since SQL Server 2000. He works mostly on projects in the financial sector, and specializes in developer coaching as well as scalable architecture and performance tuning on large scale data warehouses and BI solutions.@dphansenhttp://www.linkedin.com/in/davidpeterhansenhttp://dave.dkhttps://api.twitter.com/1/users/profile_image?screen_name=@dphansen484811696Davide MauriDavide Mauri is a SolidQ Mentor and member of the Board of Directors of SolidQ Italia. A Microsoft SQL Server MVP, MCP, MCAD, and MCDBA, he is a well-known speaker at international SQL Server conferences. Davide enjoys working with T-SQL and relational modeling and studying the theory behind it. Well-grounded in Reporting Services, .NET, and object-oriented principles, he has deep understanding of Integration Services and Analysis Services, giving him broad area of expertise around the Microsofthttp://www.davidemauri.it484811536Dejan SarkaDejan Sarka, MCT and SQL Server MVP, focuses on development of database business intelligence applications. Besides projects, he spends about half of the time on training and mentoring. He is the founder of the Slovenian SQL Server and .NET Users Group. Dejan Sarka is the main author or coauthor of eleven books about databases and SQL Server. Dejan Sarka also developed two courses and many seminars for Microsoft and SolidQ.@DejanSarkahttp://www.linkedin.com/profile/guided?goback=%2Efps_PBCK_*1_Dejan_Sarka_*1_*1_*1_*1_*2_*1_Y_*1_*1_*1_false_1_R_*1_*51_*1_*51_true_*2_*2_*2_*2_*2_*2_*2_*2_*2_*2_*2_*2_*2_*2_*2_*2_*2_*2_*2_*2_*2%2Enpv_http://blogs.solidq.com/dsarka/Home.aspxhttps://api.twitter.com/1/users/profile_image?screen_name=@DejanSarka484811519Emanuele ZanchettinAppassionato di numeri, nel 1998 inizia l'avventura con i DB relazionali, il DB2. Dopo aver fatto esperianza con Access e Oracle, nel 2007 si immerge quasi completamente nella tecnologia SQLServer. Partendo dalla versione 2000, si passa alla 2005, alla 2008 e alla 2008R2 per poi arrivare ad oggi alla 2012 e SQLAzure. Nel comtempo acquisisce competenze anche su MySQL. Formazione continua e ricerca accurata, consentono di avere un'occhio critico sui vantaggi e limiti delle diverse tecnologie.@_thinkIT_http://www.linkedin.com/pub/emanuele-zanchettin/18/921/34http://www.thinkit.it/https://api.twitter.com/1/users/profile_image?screen_name=@_thinkIT_484811548Francesco De ChiricoFrancesco De Chirico is a SolidQ Mentor and a member of the Board of Directors of Solid Quality Italia. Francesco is specialized in modeling and developing complex Business Intelligence solutions with the whole Microsoft BI stack. He has been working with Analysis Services since 2001 and has a strong knowledge of the MDX language. He is a Microsoft Certified Trainer with MCTS and MCITP certifications for Business Intelligence. In March 2012 he achieved the SSAS Maestro certification.@_fmilano_http://it.linkedin.com/in/fmilanohttp://community.ugiss.org/blogs/fmilano/default.aspxhttps://api.twitter.com/1/users/profile_image?screen_name=@_fmilano_484811544Gianluca HotzGianluca Hotz is a consultant, trainer and speaker at SolidQ specialized in architecture, database design, high availability, capacity planning, performance tuning, system integration and migrations for Microsoft SQL Server. He has been working as a consultant in the IT field since 1993 and with SQL Server since 1996. He is among the original founders of ugiss.org, where he is serving as vice-president since 2001, for his contribution to the community he has been a SQL Server MVP since 1998.@glhotzhttp://it.linkedin.com/in/ghotzhttp://spaghettidba.comhttps://api.twitter.com/1/users/profile_image?screen_name=@glhotz484811591Ian MeadeIan Meade has been working with SQL Server since 2001 and with a database / application developer for even longer. Lots of experience designing and implementing db solutions as well as fixing sick solutions. Holder of MCM SQL Server 2008, MCSD.NET and other certifications.http://www.linkedin.com/profile/view?id=202850271trk=tab_pro484811706Marco ParenzanDa sempre sviluppatore, programmatore .NET dalla sua introduzione e utente di SQL Server. Speaker per le community di 1nn0va e di xe.net. Docente in diversi corsi aziendali, in enti di formazione del territorio friulano e, fino a poco tempo fa, presso l'Università degli Studi di Trieste. Ama i linguaggi di programmazione, anche quelli dichiarativi e funzionali, e, se avanza tempo, prova a sviluppare videogiochi.@marco_parenzanhttp://it.linkedin.com/in/marcoparenzanhttp://codeisvalue.wordpress.comhttps://api.twitter.com/1/users/profile_image?screen_name=@marco_parenzan484811576Matija LahMatija Lah has more than a decade of experience working with Microsoft SQL Server, mostly architecting data-centric solutions in the legal domain. His contributions to the SQL Server community have led to the Microsoft Most Valuable Professional award in 2007 (Windows Server System SQL Server). In 2008 Matija joined SolidQ as a Mentor, located in Central and Eastern Europe. He spends most of his time on projects involving advanced information management, and natural language processing.@MatijaLahhttp://www.linkedin.com/in/matijalahhttp://milambda.blogspot.com/https://api.twitter.com/1/users/profile_image?screen_name=@MatijaLah484811584Sergio GovoniSergio Govoni è laureato in Scienze e Tecnologie Informatiche. Da oltre 12 anni lavora presso una software house che produce un noto sistema ERP, distribuito a livello nazionale ed internazionale, multi azienda client/server su piattaforma Win32.
Nello staff di UGISS (http://www.ugiss.org/) si dedica alla formazione e alla divulgazione in ambito SQL Server e tecnologie a esso collegate. Ha contribuito alla scrittura del libro SQL Server MVP Deep Dives Volume 2 (http://www.manning.com/delaney/@segovonihttp://www.linkedin.com/in/sgovonihttp://www.ugiss.org/sgovonihttps://api.twitter.com/1/users/profile_image?screen_name=@segovoni484811695SQLSaturday 176STAFF@mauridbhttp://www.linkedin.com/in/davidemaurihttps://api.twitter.com/1/users/profile_image?screen_name=@mauridb48481143811438SQLSaturday 176S1Coffee BreakCoffee Break11/17/2012 4:45:00 PM11/17/2012 5:15:00 PM1143811438SQLSaturday 176S6Coffee BreakCoffee Break11/17/2012 4:45:00 PM11/17/2012 5:15:00 PM1143811438SQLSaturday 176S8Coffee BreakCoffee Break11/17/2012 4:45:00 PM11/17/2012 5:15:00 PM1143911439SQLSaturday 176S1Lunch BreakLunch Break11/17/2012 12:45:00 PM11/17/2012 2:00:00 PM1143911439SQLSaturday 176S6Lunch BreakLunch Break11/17/2012 12:45:00 PM11/17/2012 2:00:00 PM1143911439SQLSaturday 176S8Lunch BreakLunch Break11/17/2012 12:45:00 PM11/17/2012 2:00:00 PM1144011440SQLSaturday 176S1RegistrationRegistration11/17/2012 9:00:00 AM11/17/2012 9:30:00 AM1144011440SQLSaturday 176S6RegistrationRegistration11/17/2012 9:00:00 AM11/17/2012 9:30:00 AM1144011440SQLSaturday 176S8RegistrationRegistration11/17/2012 9:00:00 AM11/17/2012 9:30:00 AM1148111481David Peter HansenS6Layered Partitioning - (re)load your data fastLoading data into your Data Warehouse is not always a trivial task. Especially if the source systems can re-deliver data and you want to replace an old subset of your data. The quick answer you always hear is “just use partitioning”, but nobody really tells you how you should design or implement it.
This session will show one way to load and access your data really fast, by using layered partitioning. We will walk through partitioned tables and partitioned views, before moving on to the concept of layered partitioning. We will also take a look at the management and performance benefits (and challenges) partitioning gives us.11/17/2012 5:15:00 PM11/17/2012 6:30:00 PM1151911519Emanuele ZanchettinS1SQL Server 2012 come motore di ricerca semanticoCon l'aumentare del numero di documenti creati, ricevuti e archiviati informaticamente, aumenta di conseguenza la difficoltà e i tempi per reperire tali documenti in base al loro contenuto e significato. Grazie a SQL Server 2012, alle sue nuove funzionalità Filestream e caretteristiche del motore FullText, è possibile andare oltre alla 'classica' gestione di parole e frasi chiave collegate al singolo documento. Grazie alla ricerca semantica si è in grado di ricercare i documenti secondo il loro significato, trovare documenti correlati e reperire documenti simili, in modo semplice ed efficace. 11/17/2012 5:15:00 PM11/17/2012 6:30:00 PM1153611536Dejan SarkaS1High Performance Statistical QueriesSQL Server 2012 database Engine has so many business intelligence improvements that it might become your primary analytical database system. However, in order to get the maximum out of these features, you need to learn how to properly use them. This in-depth session shows some extremely efficient statistical queries that use the new Window functions and are optimized through proper indexing, including columnstore indices. We will also explain the formulas and usage of those statistical procedures. This session is useful not only for BI developers; database and other developers can successfully learn how to write efficient queries as well.11/17/2012 3:30:00 PM11/17/2012 4:45:00 PM1153711537Dejan SarkaS8Market Basket AnalysisCross-selling is one of the best ways how to increase your sales. In order to know what products to offer together, you need to do a market basket analysis. Many solutions still use all kinds of distinct count queries, including T-SQL queries from SQL Server data, MDX queries from Analysis Services Dimensional models, or DAX queries from PowerPivot and Analysis Services Tabular data. However, once you know how to perform market basket analysis with data mining, you will forget on all other techniques. DMX queries will blow away other language queries. In this session, you are going to learn which data mining algorithms you should use for market basket analysis, how they work, and how you can efficiently use them in production.11/17/2012 5:15:00 PM11/17/2012 6:30:00 PM1154411544Gianluca SartoriS6ORMs: the good, the bad and the uglyORM technologies can assist the developers’ work with a simplified data access layer and nobody questions their usefulness any more: ORMs are here to stay. On the other hand, DBAs often get frustrated when ORMs are used to access data, because many tools in their belt turn out being ineffective.
Developers and DBAs are focused on different goals and finding a balance between ease of development and performance can be an overwhelming challenge, or even turn into a continuous and unproductive blamestorm.
In this session we will walk through some common performance issues in ORM technologies and we will try to address them, hoping to bridge the notorious gap between developers and DBAs.
11/17/2012 2:00:00 PM11/17/2012 3:15:00 PM1154811548Francesco MilanoS1NOLOCK is gonna save your lives (or maybe not)Nessuno può negare che ignorare i blocchi in lettura dei dati porti, solitamente, a performance migliori. Un po' come se tutti i semafori nelle strade avessero sempre luce verde: le code calerebbero drasticamente. Nel caso dei semafori, però, i rischi di una scelta del genere sono facilmente intuibili.
NOLOCK e READ UNCOMMITED sono molto diffusi in viste e SP ma raramente vengono usati con cognizione di causa e con piena consapevolezza dei pericoli a cui ci si espone. La comprensione dei meccanismi di lock e dei livelli di isolamento è fondamentale per compiere scelte oculate nella scrittura del codice e nel pianificare le strategie di accesso ai dati. In questa sessione si cercherà di fornire uno sguardo di insieme su tali meccanismi.11/17/2012 11:30:00 AM11/17/2012 12:45:00 PM1156311563Gianluca HotzS6SQL Server 2012 AlwaysOnBusiness continuity is becoming more and more a central topic for many companies. AlwaysOn is the new solution for high availability and disaster recovery introduced with SQL Server 2012. With the help of live demos, in this session we will cover in details this new technology that extends on the familiar concepts of database mirroring and failover clustering. We will also introduce some other engine enhancements that will help raising the overall service availability.11/17/2012 3:30:00 PM11/17/2012 4:45:00 PM1157611576Matija LahS6FILETABLEs: What They Are and How to Use ThemHave you ever had the need to access documents in your database as if they were files in the file system? SQL Server 2012 introduces a brand new method for managing large data objects (BLOBs) in a database. FILETABLEs provide access to data using Transact-SQL - just like any other table inside the database, while at the same time also provide access to the data using the operating system File I/O API - i.e. just like any other folder in the file system. In this session you will learn how to upgrade your document management solutions by migrating your large data to FILETABLEs. The session covers two most typical migration scenarios: migrating from a distributed data store, where files are stored outside the database, and from a homogeneous d11/17/2012 11:30:00 AM11/17/2012 12:45:00 PM1158411584Sergio GovoniS1Rewrite your Queries with SQL Server 2012Confrontato con altri linguaggi di programmazione, T-SQL non è un linguaggio difficile da imparare, e al netto di eventuali errori sintattici può essere molto tollerante.
Nel comparto IT è utilizzato da molte persone, che però, tendono ad imparare soltanto gli statement fondamentali del linguaggio ovvero: SELECT, INSERT, UPDATE e DELETE. Solo chi investe più tempo scopre la natura dichiarativa di questo linguaggio e può ottenere il massimo delle prestazioni e della potenza dalle proprie queries.
In questa sessione vedremo come migliorare la scrittura del codice T-SQL sfruttando gli statement Set-Based presenti da tempo in SQL Server, nonché quelli implementati con SQL Server 2012 con particolare riferimento alle 'Window Functions'.11/17/2012 10:00:00 AM11/17/2012 11:15:00 AM1159111591Ian MeadeS1Dynamic code for efficient searching Illustrate how multipurpose queries can lead to issues with scalability and performance. Show a few alternatives that will work for smaller and simpler queries while highlighting their limitations for more complex queries. Then work through building a dynamic search query to resolve the identified performance issues.
Touching on:
• Testing.
• Tuning each part of the query in isolation.
• Plan cache re-use
• Security – SQL injection attacks and authorisation / code signing.
• Possibly, mentioning greater re-use and extendibility.
11/17/2012 2:00:00 PM11/17/2012 3:15:00 PM1169511695SQLSaturday 176S1KeynoteKeynote11/17/2012 9:30:00 AM11/17/2012 10:00:00 AM1169511695SQLSaturday 176S6KeynoteKeynote11/17/2012 9:30:00 AM11/17/2012 10:00:00 AM1169511695SQLSaturday 176S8KeynoteKeynote11/17/2012 9:30:00 AM11/17/2012 10:00:00 AM1169611696Davide MauriS8Data Warehousing Basics In questa sessione verrà introdotto il Data Warehouse, punto cardine di ogni soluzione di Business Intelligence.
Dopo aver definito il ruolo del DWH e le sue motivazioni di base, durante la sessione saranno mostrate le tecniche di modellazione, i principi guida da seguire, al terminologia ed i design pattern più noti e comuni.11/17/2012 10:00:00 AM11/17/2012 11:15:00 AM1170611706Marco ParenzanS6SQL Server Data ToolsNella creazione di applicazioni, non abbiamo mai avuto a disposizione un ambiente integrato, dedicato allo sviluppatore per la progettazione e il deployment di un Database, per la scrittura di codice SQL. Oggi questa lacuna è stata colmata dall'introduzione degli SQL Server Data Tools: grazie ad un apposito template per Visual Studio 2010 e 2012, è possibile gestire un progetto SQL, come un progetto di una applicazione desktop o di una applicazione web. Vediamo insieme cosa possiamo fare con questi strumenti.11/17/2012 10:00:00 AM11/17/2012 11:15:00 AM1179411794Marco RussoS8Tabular DAXBISM is the acronym for Business Intelligence Semantic Model and in SQL Server Analysis Service 2012 you have two options for creating a data model in this environment: Multidimensional and Tabular.
In this introduction to the Tabular models in Analysis Services you will understand the capabilities of this type of data modeling for Data Analysis and you will learn the basics of DAX, the language used to define the measures for Tabular models.11/17/2012 2:00:00 PM11/17/2012 3:15:00 PM1179511795Marco PozzanS8Using Integration Services to load the DWHCome popolare un DWH con sql server integration services 2012(SSIS) .11/17/2012 11:30:00 AM11/17/2012 12:45:00 PM1179911799Francesco De ChiricoS8OLAP MDX in actionIn questa sessione introduttiva vedremo all’opera il motore OLAP di Microsoft (Analysis Services) sia nella fase di creazione di un cubo OLAP che in quella di interrogazione dello stesso attraverso il linguaggio MDX.
Dopo una breve introduzione teorica sulla tecnologia OLAP, vedremo come creare un semplice progetto formato da un cubo e da un paio di dimensioni partendo da zero.
A seguire, iniziando da query molto semplici sulla base dati appena creata, illustreremo alcuni dei concetti base del linguaggio MDX, con l’obiettivo di arrivare a scrivere query più complesse per soddisfare alcune delle più comuni richieste di analisi quali Previous Period Growth e Percentage Share.
11/17/2012 3:30:00 PM11/17/2012 4:45:00 PM