SQLSaturday #197 - Omaha 20134/6/2013 12:00:00 AM(GMT-06:00) Central Time (US and Canada)SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat197Mammel Hall, University of Nebraska-Omaha6708 Pine StreetOmahaNE681062906House of Brick Technologieshttp://www.houseofbrick.comhttp://davidklee.net/hob_sqlsat_logo.png601702931Confio Softwarehttp://www.confio.comhttp://www.confio.com/images/assets/confio_logo.jpg601702943Tegile Systemshttp://www.tegile.comhttp://www.sqlsaturday.com/files/4bea2224-5b2e-4510-83a8-7f11e6685b15.jpg601702960Deliveron Consulting Serviceshttp://www.deliveron.comhttp://www.davidklee.net/wp-content/uploads/2013/01/deliveron.png601703007Farm Credit Services of Americahttps://www.fcsamerica.com/http://www.fcsamerica.com/images/logo.png601703025Dell Software Grouphttp://www.quest.com/http://i.imgur.com/BAdC3.png601703067Blue Cross Blue Shield of Nebraskahttps://www.nebraskablue.com/http://www.sqlsaturday.com/files/6939f80b-8f7f-49ba-ac9c-556f8b95b2ef.png601703178GNet Grouphttps://www.gnetgroup.comhttp://www.gnetgroup.com/_styles/images/bg-logo.png601703201Modishttp://www.modis.com/http://www.sqlsaturday.com/files/352cccb7-1d87-4f8c-84e8-7ab68c5b71e3.png601703205Violin Memoryhttp://www.violin-memory.com/http://www.sqlsaturday.com/files/c7cff1d7-3156-4eac-8939-2ba76a756afc.jpg601703221Sogeti USAhttp://www.us.sogeti.com/http://www.us.sogeti.com/web-images/SogetiLogo.jpg601703179Aspect Software http://www.aspect.com/Pages/default.aspxhttp://www.aspect.com/images/logo.jpg601703093Home Instead, Inc.http://www.homeinstead.comhttp://www.homeinstead.com//Style%20Library/Images/Corporate/Corporate-bw.gif601703030Pluralsighthttp://pluralsight.comhttp://s.pluralsight.com/mn/img/logo/pluralsight-fullcolor-250x55-v1.png601703013SQLskills.comhttp://www.sqlskills.com/http://www.sqlskills.com/images/sqlskillslogo_color.jpg601702866PASS Headquartershttp://www.sqlpass.orghttp://www.sqlsaturday.com/images/PASS_logo.jpg601702896Datavailhttp://www.datavail.com/http://www.sqlsaturday.com/files/8b0cd3a8-d1f9-44a3-bbbc-84af0649037f.JPG601702969COZYROChttp://www.cozyroc.com/http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png601703086Sql Power Tools, Inc.http://www.sqlpower.comhttp://www.sqlpower.com/img/spt_logo_sql_saturday.png601703282idea5, Inc.http://idea5inc.com/index.htmlhttp://idea5inc.com/images/idea5_logo.png601703199CRihttp://www.clientresourcesinc.com/http://www.clientresourcesinc.com/wp-content/uploads/2013/03/CRI_logo_WEB137x60.gif601703193QCIhttps://www.qci.comhttp://www.sqlsaturday.com/files/acaeeb2b-e83d-4dd1-9630-9fee77792607.png401003054Data On Wheels - Steve Hugheshttp://www.dataonwheels.comhttp://dataonwheels.files.wordpress.com/2013/02/data-on-wheels-1.png401003078Wroxhttp://www.wrox.comhttp://www.sqlsaturday.com/files/01de18c8-27fe-4cbb-a060-cad5836816b9.gif4010013156Bill FellowsBill has been a professional developer for the past 13 years and has had the pleasure and pain of working with a variety of RDBMS. He's been involved with SQL Server since 2000 and has lost far too many hairs to DTS and SSIS, He was the organizer of SQL Saturday 53 and 101. When not milking yaks or fighting crime, Bill finds himself employed as the lead database developer for an undisclosed entity in the Kansas City, Missouri area.@Bill_Pearsonbillinkchttps://api.twitter.com/1/users/profile_image?screen_name=@Bill_Pearson484812692Brandie TarvinBrandie Tarvin (MCITPDBA, MCTS, MCDBA) is a senior Database Administrator SQL Developer for Allstate Dealer Services in Jacksonville. She has published several articles on SQLServerCentral.com and presented at several SQL Saturday events. Her experience includes working in the Records Management industry as well as being the business coordinator for disaster recovery planning at two of her previous employers. In her spare time, she edits and writes fiction and RPGs.@WannaBeWriter06http://www.linkedin.com/in/brandietarvinhttp://www.brandietarvin.com/database-administration/dba-blog/https://api.twitter.com/1/users/profile_image?screen_name=@WannaBeWriter06484812728David KleeDavid Klee (@kleegeek) is a SQL Server performance and virtualization expert. With over fifteen years of IT experience, David spends his days virtualizing mission critical SQL Servers as a Solutions Architect for House of Brick Technologies. His areas of expertise are virtualization and performance, datacenter architecture, software engineering, security, and business process analysis.@kleegeekhttp://www.linkedin.com/in/davidakleehttp://davidklee.nethttps://api.twitter.com/1/users/profile_image?screen_name=@kleegeek484813556Dean Nicholson I have been in IT for 16 years, over 12 as a DBA. I have worked on Oracle, Sybase and Sql Server 6.5 thru SQL 2012 in both administration and development. I am active in the local PASS user group.484812721Glenn BerryGlenn Berry is a Principal Consultant with SQLskills. He has worked as a SQL Server professional for many years in a variety of roles, most recently as Database Architect for Avalara in Parker, CO. Glenn has been a SQL Server MVP since 2007, and he has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests. @GlennAlanBerryhttp://www.linkedin.com/pub/glenn-berry/10/a61/6b8http://sqlserverperformance.wordpress.comhttps://api.twitter.com/1/users/profile_image?screen_name=@GlennAlanBerry484814052Jason HornerJason Horner has been working with SQL Server for over 10 years. He is currently focused on a large scale Spatial Data Warehouse project. He holds MCITP Certifications in both Database Administration and Database Development.@jasonhornerhttp://www.linkedin.com/in/jasonhornerhttp://www.jasonhorner.comhttps://api.twitter.com/1/users/profile_image?screen_name=@jasonhorner484812696Jeff HicksJeff Renz has been working in the IT industry for 14 years, the last 10 of which has been focused on designing and implementing data collection and reporting solutions. He is currently working as a senior consultant for Statera on the Business Intelligence Solutions team.@jeff_renzhttp://www.linkedin.com/in/jefferyhickshttp://jdhitsolutions.com/bloghttps://api.twitter.com/1/users/profile_image?screen_name=@jeff_renz484812342Joseph SackJoe Sack is a Principal Consultant with SQLskills. Prior to joining SQLskills he worked at Microsoft as a Premier Field Engineer supporting large enterprise customer environments. He achieved “MCM:SQL Server 2005” and “MCM:SQL Server 2008” certification and from 2009 to 2011 he was the acting Program Manager for the SQL MCM program. His most recent book is 'SQL Server 2008 Transact-SQL Recipes' (APress).@josephsackhttp://www.linkedin.com/pub/joe-sack/1/81b/276https://api.twitter.com/1/users/profile_image?screen_name=@josephsack484812537Kathy GibbsKathy has over 19 years of IT work experience and over 13 years of DBA experience including architecting, design, development, implementation, monitoring, and disaster recovery of databases. Before starting with Confio, Kathy worked in the financial, retail, and telecom industries working with critical OLTP and OLAP databases. Kathy excels in being a liaison between technical and the end-users or management teams to provide solutions@DBkghttp://www.linkedin.com/pub/kathy-gibbs/a/6a8/680https://api.twitter.com/1/users/profile_image?screen_name=@DBkg484813212Kevin BolesKevin is a SQL Server expert, working exclusively with the product since version 6.5. With almost 20 years of database experience, he holds many SQL Server related certifications and is also an MCT and was a SQL Server MVP from 2007 to 2012. Kevin teaches occasionally and has been a very successful independent consultant for almost 15 years. His passion is the relational engine, especially scalability, performance analysis and tuning.@TheSQLGuruhttp://www.linkedin.com/in/thesqlguru https://api.twitter.com/1/users/profile_image?screen_name=@TheSQLGuru484813550Leslie WeedLeslie Weed is currently a Consultant with RevGen Partners in Denver, CO. She has been working with SQL Server for over 13 years in various industries including manufacturing, finance and retail. While starting out as a VB application developer, she quickly caught the SQL bug and hasn't been able to drop it yet. Leslie strongly believes the best SQL goes hand in hand with a good cup o’ joe.
@weederbughttp://www.linkedin.com/in/leslieweedsql https://api.twitter.com/1/users/profile_image?screen_name=@weederbug484812151Matthew BrimerMatthew Brimer has 7 years experience with SQL Server, 3 of
which was spent as a Database Security expert for a Department of Defense
Agency. Matt also holds several Security and Microsoft Certifications, is
the Vice President of OKCSQL and is the Event Chair for SQL Saturday
Oklahoma City.
@sneakanddestroyhttp://www.linkedin.com/pub/matthew-brimer/25/b1/881https://api.twitter.com/1/users/profile_image?screen_name=@sneakanddestroy484813078Meagan LongoriaMeagan Longoria is a BI consultant with Valorem Consulting in Kansas City, MO. She has over 5 years of experience with the SQL Server BI stack and enjoys sharing her knowledge and experiences at SQL Saturdays. @mmariehttp://www.linkedin.com/in/meaganlongoriahttps://api.twitter.com/1/users/profile_image?screen_name=@mmarie484812153Michael FalMike Fal is a musician turned SQL Server DBA, with 10+ years of experience as a database administrator. He has worked for several different industries, including healthcare, software development, marketing, and manufacturing and has experience supporting databases from 1 GB to 4 TB in size. Mike received his a Bachelor's Degree from the University of Colorado at Boulder in 1996 and has been caught playing trombone in public on more than one occasion. @Mike_Falhttp://www.linkedin.com/pub/michael-fal/13/b70/b97http://mikefal.nethttps://api.twitter.com/1/users/profile_image?screen_name=@Mike_Fal484813553Phil BrammerPhil Brammer, a sixth year Microsoft MVP in SQL Server and a Microsoft Certified Solutions Expert, has over 12 years’ data management experience in various technologies from reporting through ETL to database administration. He has worked with SSIS since 2007 and he continues to play an active role in the SSIS community via online resources as well as his technical blog site, SSISTalk.com. He has contributed to books, SQL Saturdays, SQL PASS Summits, and other online communities.@PhilBrammerhttp://www.ssistalk.comhttps://api.twitter.com/1/users/profile_image?screen_name=@PhilBrammer484813723Reeves SmithReeves Smith is a SQL Server consultant specializing in data warehouse projects. He has been working with SQL Server for over 17 years beginning with SQL Server 6.5. During that time he has had the opportunity to work on various development and data warehouse projects within industries like the DoD, telecommunication, entertainment, oil and gas, manufacturing, travel, and banking. He is a SQL Server MCM, MCSE, MCITP and MCDBA. @RPS3COhttp://www.linkedin.com/in/reevessmithiiihttps://api.twitter.com/1/users/profile_image?screen_name=@RPS3CO484813442Ronald YenkoRonald Yenko is a Database Engineer at Pitney Bowes Presort Services in Omaha, NE. For the past 20 years he has been involved with various Microsoft technologies including SQL Server (from 6.5 through 2012) in the ecommerce, retail, law enforcement, government and financial industries. In recent years, he has specialized in enterprise architecture, business continuity and performance tuning. He holds various Microsoft certifications including Microsoft Certified Trainer and MCITP/MCTS.484813476Scott ShawScott Shaw is the co-author of two books on T-SQL through Apress publishing. He is a frequent speaker at SQL community events and is the co-leader for the PASS Virtual Chapter on Virtualization. He currently lives in Saint Louis working for Oakwood Systems Group as a Principal Consultant for BI. @shawsqlhttp://www.linkedin.com/in/scottpshawwww.dbaexperience.comhttps://api.twitter.com/1/users/profile_image?screen_name=@shawsql484813562Shawn MeyersShawn is a Technical Consultant at House of Brick technologies. Started SQL server life as an accidental DBA with SQL server 6.5 loved turning data into information. 20+ years of IT experience from my own business to working for Fortune 100. Main focus has been performance tuning of SQL server and infrastructure, in the past year added Virtualization of SQL server skill sets. Hobbies, being a geek, camping, bad B movies, sometimes all at the same time.484812780Steve HughesSteve Hughes is a Principal Consultant at Magenic. His area of expertise is in data and business intelligence architecture on the Microsoft SQL Server platform. He was also the data architect for a SaaS company which delivered a transportation management solution for fleets across the United States. Steve has co-authored two books and delivered more than 30 presentations on SQL Server and data architecture over the past six years. @dataonwheelshttp://www.linkedin.com/in/way0utwesthttps://api.twitter.com/1/users/profile_image?screen_name=@dataonwheels484813175Sudhir GajreSudhir Gajre is a Principal Technologist with Microsoft. He has been with Microsoft for over 12 years, specializing in Relational Database Technologies, BI, and Data Warehousing. He has been in the Data Management and Analysis field for over 18 years.
His experience is predominantly in architecting, designing, and tuning VLDB databases and mission critical applications. Performance, Scalability and High Availability are his core areas of expertise.
@#SudhirGajrehttp://www.linkedin.com/pub/sudhir-gajre/30/732/5b5https://api.twitter.com/1/users/profile_image?screen_name=@#SudhirGajre484813567Tim PlasTim is a Principal Consultant at Virteva, in Mpls MN. His current focus areas are operational-DBA services, storage, virtualization, cloud computing. His experience in the last 25 years has been primarily with server / data-center infrastructure, including CTO / co-founder of a successful hosting company. Tim has held a variety of MS certifications since 1994.@tjplashttp://www.linkedin.com/in/tplashttp://www.virteva.com/bloghttps://api.twitter.com/1/users/profile_image?screen_name=@tjplas48481214812148SQLSaturday 197122Lunch Break4/6/2013 11:30:00 AM4/6/2013 12:45:00 PM1214812148SQLSaturday 197121Lunch Break4/6/2013 11:30:00 AM4/6/2013 12:45:00 PM1214812148SQLSaturday 197120Lunch Break4/6/2013 11:30:00 AM4/6/2013 12:45:00 PM1214812148SQLSaturday 197119Lunch Break4/6/2013 11:30:00 AM4/6/2013 12:45:00 PM1214812148SQLSaturday 197117Lunch Break4/6/2013 11:30:00 AM4/6/2013 12:45:00 PM1214812148SQLSaturday 197118Lunch Break4/6/2013 11:30:00 AM4/6/2013 12:45:00 PM1214912149SQLSaturday 197122Opening Remarks4/6/2013 8:00:00 AM4/6/2013 8:30:00 AM1214912149SQLSaturday 197121Opening Remarks4/6/2013 8:00:00 AM4/6/2013 8:30:00 AM1214912149SQLSaturday 197120Opening Remarks4/6/2013 8:00:00 AM4/6/2013 8:30:00 AM1214912149SQLSaturday 197119Opening Remarks4/6/2013 8:00:00 AM4/6/2013 8:30:00 AM1214912149SQLSaturday 197117Opening Remarks4/6/2013 8:00:00 AM4/6/2013 8:30:00 AM1214912149SQLSaturday 197118Opening Remarks4/6/2013 8:00:00 AM4/6/2013 8:30:00 AM1215012150SQLSaturday 197122Raffle4/6/2013 5:00:00 PM4/6/2013 5:30:00 PM1215012150SQLSaturday 197121Raffle4/6/2013 5:00:00 PM4/6/2013 5:30:00 PM1215012150SQLSaturday 197120Raffle4/6/2013 5:00:00 PM4/6/2013 5:30:00 PM1215012150SQLSaturday 197119Raffle4/6/2013 5:00:00 PM4/6/2013 5:30:00 PM1215012150SQLSaturday 197117Raffle4/6/2013 5:00:00 PM4/6/2013 5:30:00 PM1215012150SQLSaturday 197118Raffle4/6/2013 5:00:00 PM4/6/2013 5:30:00 PM1215112151Matthew Brimer118Database Security Shrinking Your Attack SurfaceDatabase Security is a very broad and scary topic, one which
many days could be dedicated to speaking on it. In this session Matt will
give a high level overview of what Database Security is, what tools
Microsoft gives you to accomplish it and some simple things that you can do
to shrink your attack surface.4/6/2013 8:30:00 AM4/6/2013 9:45:00 AM1215312153Michael Fal121Exposing the Core: SQL 2012 on Server CoreEverything that's old is new again, as Windows Server moves back to the terminal interface. With SQL 2012, we can now run our SQL Servers on Server Core, a version of the Windows OS that is smaller and more secure. This presentation will introduce you to Server Core, how to prepare it for a SQL installation(including using Powershell for management), and how to actually install SQL 2012 on to it.4/6/2013 3:45:00 PM4/6/2013 5:00:00 PM1234212342Joseph Sack120Troubleshooting Query Plan Quality IssuesWhen the query optimizer inaccurately estimates the number of rows for query execution plan iterators, performance can suffer due to the generation and use of a suboptimal plan. Fixing cardinality estimate issues will help the query optimizer generate a higher quality plan. This session will teach you how to identify cardinality estimate issues in your query execution plan and also cover various ways in which cardinality estimate issues can be addressed.4/6/2013 12:45:00 PM4/6/2013 2:00:00 PM1253712537Kathy Gibbs121Extend your Knowledge with Extended EventsWith 2012 Extended Events became much easier to use and is a great way to find out more of what is going on in the database. This
presentation will show how you can use Extended Events to find out about items like Deadlocks and Query Performance. We will create a
new Event and I will show you how you can use the data collected to report commonly monitored statistics.4/6/2013 2:15:00 PM4/6/2013 3:30:00 PM1269212692Brandie Tarvin119Designing a Data Recovery SolutionHaving scheduled database backups is one thing, but knowing what backup types are needed is a different horse of a different color. Building on the 'Backups 101' session, this discussion focuses on why we should build Recovery solutions instead of Backup solutions, and the most important things to remember when designing the solution.4/6/2013 10:00:00 AM4/6/2013 11:15:00 AM1269612696Jeff Renz117Tabular ModelsTabular modules allow developers to create models based upon different data sources; create hierarchies, perspectives, partitions and roles similar to traditional OLAP cubes. In this session will highlight the differences between traditional OLAP and tabular models and reasons for selecting one approach over another. I will demonstrate how to create a data model first in power pivot model and then import into an Analysis Services Tabular Project. Working with the imported data I will then create measures, KPIs, perspectives, and implement security. Finally I will deploy the model to an Analysis Server.4/6/2013 12:45:00 PM4/6/2013 2:00:00 PM1272112721Glenn Berry121Hardware 201: Selecting Database HardwareThe foundation of database performance is the underlying server hardware and storage subsystem. Even the best designed and optimized database application can be crippled by an inadequate hardware and storage infrastructure. Recent advances in new processors and chipsets, along with improvements in magnetic and SSD storage have dramatically changed the evaluation and selection process compared to the past. Many database professionals struggle to keep up with new technology and often simply let someone else make their hardware selection and sizing decisions. Don't let this happen to you! This session covers current and upcoming hardware from both Intel and AMD.4/6/2013 8:30:00 AM4/6/2013 9:45:00 AM1272312723Glenn Berry121Dr. DMV: How to Use Dynamic Management ViewsSQL Server 2005 introduced Dynamic Management Views (DMVs) that allow you to see exactly what is happening inside your SQL Server instances and databases with much more detail than ever before. SQL Server 2008 R2 adds even more capability in this area. You can discover your top wait types, most CPU intensive stored procedures, find missing indexes, and identify unused indexes, to name just a few examples. This session (which is applicable to SQL Server 2005 through 2012), presents and explains over fifty DMV queries that you can quickly and easily use to detect and diagnose performance issues in your environment.
4/6/2013 10:00:00 AM4/6/2013 11:15:00 AM1272812728David Klee118SQL Server vs. Oracle: The Throwdown!Come see David Klee (@kleegeek) and Joe Grant (@dba_jedi) in a 'discussion' with a competitive comparison between SQL Server and Oracle in a highly interactive dynamic session. Each database engine has its place in the IT world, and we will discuss which is the right tool for the job. The goal is to be objective and compare features, strengths and weaknesses, and editions. Check your opinions at the door and come join us for an educational session!4/6/2013 10:00:00 AM4/6/2013 11:15:00 AM1278012780Steve Jones120Searching Binary Data in SQL Server 2012More and more data collected in organizations is in an encoded format, essentially a binary classification of data. These can be images, audio files, video, or even common formats like Word and Excel files. This data contains lots of important data, but the formatting must be stripped out in order for users to effectively search this data. Filestream, Filetable, Full-Text Search, and Semantic Search are covered.4/6/2013 3:45:00 PM4/6/2013 5:00:00 PM1278212782Steve Jones121The Encryption PrimerLearn the options for encryption in SQL Server, covering hashing, symmetric keys, asymmetric keys, and encrypted communications.4/6/2013 12:45:00 PM4/6/2013 2:00:00 PM1307813078Meagan Longoria117Building Dashboards in PerformancePointPerformancePoint can be a useful tool for delivering a dashboard to users through SharePoint. The data visualizations for your dashboard can come from PerformancePoint, Excel Services, Reporting Services, or a web page. Understanding the features and limitations of these sources of data visualizations can help you create a dashboard that best meets your users’ needs. 4/6/2013 8:30:00 AM4/6/2013 9:45:00 AM1315613156Bill Fellows1202012 TSQL SweetsThe 2012 release of SQL Server promise a variety of delicious new language features to solve problems. After this session, you'll have a taste for all the sweets they've packed into the language including conversions, date time functions, windowing functions, analytic functions and sequences.4/6/2013 10:00:00 AM4/6/2013 11:15:00 AM1317513175Sudhir Gajre118SQL Server 2012 HA and DRThis is a deep dive session in the new HA/DR options for SQL Server 2012. Through interactive discussions and lively demos, get an in depth understanding of the AlwaysOn Failover Clustering and AlwaysOn Availability Groups. Experience how to set up active secondary’s and off load backups to the secondary servers. You will walk away with a thorough understanding of the pros and cons of each HA/DR option in SQL Server 2012 and can immediately apply it to practical use. 4/6/2013 3:45:00 PM4/6/2013 5:00:00 PM1317713177Sudhir Gajre119How to be DBA and retire richYes, how to be a DBA and retire rich. This is a session in the ‘off the beaten path’ or the ‘miscellaneous track’. You will learn nothing SQL Server technical in this session, but will learn about the Modern Portfolio Management theory in Finance. I will conduct a practical discussion on how to structure your 401(K) portfolio or your general investment portfolio for the most optimal asset allocation and maximum return while minimizing taxes and expenses. You can use the practical tips in this session to consider options to streamline your portfolio to maximize returns. This session may serve as a wakeup call to do something about your portfolio. When it comes to retirement, clearly, luck is not a strategy. 4/6/2013 12:45:00 PM4/6/2013 2:00:00 PM1321213212Kevin Boles120Windowing Functions: THE Reason to Upgrade to 2012For the first time since SQL 7 there is a compelling reason for EVERY SQL Server user to upgrade to the next version and this time around the reason is Windowing Functions. And these are NOT limited to Enterprise Edition, like so many other really useful and important features! The range of data processing needs that can be very efficiently and cleanly solved with these tools is stunning. In this demo-packed session we will cover as many features as we can pack into an hour's time, and you can take the demo code back home with you to review at your leisure!4/6/2013 8:30:00 AM4/6/2013 9:45:00 AM1344213442Ronald Yenko119Tips and Tricks for Auditing in SQL ServerSQL Server 2005 and later continued to introduce tools to help you audit what was occurring in your database, with 2012 introducing even more auditing tools. In this session, we'll go over the questions you need to ask your business to determine what level of auditing is appropriate. We'll go through how to set up many of the common audits to meet your business' requirements. Each technique has its features and each has associated costs - your goal is to find a balance.4/6/2013 8:30:00 AM4/6/2013 9:45:00 AM1347613476Scott Shaw117Dimensional Modelling for the DBAHave you ever wondered what's going on with that SQL Server Analysis server you support? Do you want to know what this
BI fuss is all about? I'll walk you through the basics of dimensional modelling to help you understand from a operational
DBA perspective what's going on and why a BI system needs to be treated differently. I'll take the mysticism out of the
differences between OLTP and OLAP and provide a method to the maddness. 4/6/2013 2:15:00 PM4/6/2013 3:30:00 PM1355013550Leslie Weed122Windows Azure SQL Reporting ServicesWhat you need to know about Reporting Services in the Cloud. We will cover benefits, limitations and scenarios that you may or may not have thought about for implementing this into your enviornment or for simply taking advantage of the free trial period.4/6/2013 12:45:00 PM4/6/2013 2:00:00 PM1355313553Phil Brammer122SSIS 2012: A Deep Dive into the SSIS CatalogNew in SQL Server 2012, the SSIS catalog provides a rich set of built-in tools for capturing/reporting package logging, statistics, and other interesting things all within a few keystrokes or mouse clicks. This session will focus on the internals of this new catalog and how to use it. You will learn how to extend and query the metadata captured by the package execution process and how to navigate your way around the built-in reports.4/6/2013 8:30:00 AM4/6/2013 9:45:00 AM1355613556Dean Nicholson 120Minimum Database IndexingDiscuss the basic indexing principles you should have learned in school if you had been paying attention. We will examine a couple of data and indexing patterns that will enable you to make an educated decision on your indexing strategy. We will also take a deep dive in how indexes begin and grow and how they are used4/6/2013 2:15:00 PM4/6/2013 3:30:00 PM1355913559Steve Hughes122Building BI Solutions with Excel 2013If you have not experienced building BI solutions with Excel 2010, be amazed at what you can do in Excel 2013. In this session we will use PowerPivot, Power View, Quick Explorer, and other great features in Excel to build an Excel 2013 BI solution. Microsoft has went 'all-in' with Excel as their primary BI client. If you want to get a first hand look at using it more fully, you will be amazed. I know I was.4/6/2013 3:45:00 PM4/6/2013 5:00:00 PM1356213562Shawn Meyers118Performance baseline your new SQL instance Using freely available tools to baseline your new SQL server instance. Using Crystal disk mark, SQLIO, Memtest86, and Dell DVDstore tools to measure, baseline and compare results of your new hardware. Crystal disk mark and SQLIO will test IO subsystems ; memtest86 will test your memory before you put it into production. Dell DVDstore will be used to create a database enabling you to put a synthetic load simulating numerous users to your SQL server instance, enabling the creation of solid baselines when putting the server under a heavy load. Using the benchmarks to determine capacity of the hardware and will it met the expected load.4/6/2013 12:45:00 PM4/6/2013 2:00:00 PM1356713567Tim Plas118Amazon RDS and SQL Azure - DB in the cloudAmazon’s AWS and Microsoft’s Azure both offer SQL Server instances as services (not necessarily as servers). What do they offer, why would one use them, how do they differ, what special considerations are there? What exactly does “Platform as a Service” (PaaS) mean with SQL?4/6/2013 2:15:00 PM4/6/2013 3:30:00 PM1372313723Reeves Smith117Master Data Services – 101Master Data Services (MDS) is a Master Data Management solution on the Microsoft Platform. This solution enables the management of non-transactional data (nouns) within the enterprise. Get a good business and technical understanding of how MDS can help your organization obtain better data governance. The demo will walk through the basics of getting started with Master Data Services 2012, including the Excel Add-in for Master Data Services. 4/6/2013 3:45:00 PM4/6/2013 5:00:00 PM1372513725Reeves Smith122DAX – Get ContextData Analysis Expressions (DAX) is the language of PowerPivot and the BISM Tabular Model. Understand the basics of the DAX language and get introduced to evaluation context.4/6/2013 10:00:00 AM4/6/2013 11:15:00 AM1405214052Jason Horner122Dimension Modeling Design Patterns: Beyond BasicsThis session will provide a deeper dive into the art of dimensional modeling. We will look at the different types of fact tables and dimension tables, how and when to use them. We will also some approaches to creating rich hierarchies that make reporting a snap. This session promises to be very interactive and engaging, bring your toughest Dimensional Modeling quandaries.4/6/2013 2:15:00 PM4/6/2013 3:30:00 PM1407514075Bill Pearson117Beyond Plateaux: Optimize SSAS via Best PracticesWhether we inherit our Analysis Services environments from predecessors or create them - learning as we go - ourselves, we often conclude that performance (processing and / or querying) and functionality can be enhanced. In this session, Microsoft BI Architect and SQL Server MVP Bill Pearson overviews ways to launch new capabilities and to propel performance beyond its current plateau, using design best practices to better meet consumer performance and functional needs.4/6/2013 10:00:00 AM4/6/2013 11:15:00 AM1409814098Jeff Hicks119Getting Started with PowerShell's Job InfrastructureA key feature of Windows PowerShell is the ability to execute long running tasks in the background while you continue to use the shell for other tasks. In this session you will learn about the PowerShell's job infrastructure including using scheduled background jobs, a new PowerShell 3.0 feature. We'll also explore some alternatives such as using runspaces.4/6/2013 2:15:00 PM4/6/2013 3:30:00 PM1453914539Jeff Hicks119Getting Started with PowerShell WorkflowOne of the killer features in PowerShell 3.0 is the ability to create workflows with Powershell script. You do not need a developer background or Visual Studio to create workflows. Now you can workflow scripts for long running and unattended tasks that can survive network interruptions or even reboots. In this session we'll look at workflow syntax, how to run and some best practices.4/6/2013 3:45:00 PM4/6/2013 5:00:00 PM