SQLSaturday #108 - Redmond 2012
Event Date: 02/25/2012 00:00:00
Event Location:
- The MIXER building
- 15255 NE 40th Street
- Redmond, Washington
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: SQL Server Reporting Services - Beyond the Basics
Abstract: You’re already familiar with your data sources and datasets, and already comfortable with your basic tables and matrices. Now you want to add a bit more “zing” to your reports. In this presentation we will look different ways of using and extending Reporting Services.
In this session we will work with expressions to add dynamic components to SSRS, create drilldowns and drillthroughs, use custom code to modularize our logic, connect to non-SQL Server data sources, and utilize your geospatial data by plotting them onto SSRS maps. We’ll include a few more cool stuff you might not have known about SSRS!
This presentation will be demo-filled. You’ll be sure to go home with ready-to-use tricks up your sleeve.
Speaker(s):
- Donabel Santos
Track and Room: Montlake - N/A
Title: PowerShell for Data Professionals
Abstract: You’ve heard it said, “If you have to do it twice, automate it.” Cut the learning curve and get a real handle on this powerful automation tool. This session walks you through a dozen scripts to simplify and easily automate time-consuming and tedious elements of your day to day job. This isn’t stuff you’ll use SOMEDAY, these are scripts you can use when you get home tonight. Harness the power of Power Shell to easily find Servers short on space. Script out tables and constraints across all of your databases at once. Backup databases and restore them to a different environment. These tricks and many others will allow PowerShell to simplify your job like no other tool.
Speaker(s):
- Aaron Nelson
Track and Room: Pioneer Square - N/A
Title: Database lifecycle with Visual Studio 2010 and TFS
Abstract: Are you tired of manually integrating scripts before every release, inadequate history of changes to database objects or lack of consistent and automated unit testing for SQL Server objects? We will learn how we can use Visual Studio 2010 Database Project and Team Foundation Server for managing lifecycle of our database projects. Session will cover basic rules for managing tables, views and stored procedures in Visual Studio project, using Team Foundation Server source control and creating unit tests. We will also use TFS build agent to automate creation of the differential SQL scripts, deploying it to test/development environment and execution of defined unit tests. Finally we will create deliverables for release.
Speaker(s):
- Piotr Palka
Track and Room: Capitol Hill - N/A
Title: Unleashing Common Table Expressions in SQL Server
Abstract: Have you ever wanted to create a recursive query, but didn’t see how to do it. With the Common Table Expressions class you will learn everything needed to start using CTE’s for recursive queries, as a temporary views, and to use the result set multiple times in the same query. Learn how simplify query syntax using CTE’s. One of the most overlooked features of SQL Server is the CTE which no only simplifies the query, but gives you the ability to do things that would otherwise be impossible (or at least very challenging) with SQL Server. This presentation is targeted for database programmers and administrators who are familiar with TRANSACT SQL, Subqueries, and advanced join techniques.
Speaker(s):
- Steve Stedman
Track and Room: Capitol Hill - N/A
Title: Database Development: Keep It Agile, Not Fragile
Abstract: Does your company use agile development? It can deliver more value to customers with lower project risk. However, it can also make the system design change rapidly, and require frequent software rollouts. This session will focus on best practices for DBAs and developers to make design, testing and deployments easier. Keep your systems agile, not fragile!
Speaker(s):
- Dev Nambi
Track and Room: Capitol Hill - N/A
Title: PowerShell 101
Abstract: If you haven’t dug in to PowerShell at this point, you’re missing out on some amazing, powerful, practical stuff that could save you time every day. PowerShell does have a learning curve at the outset, especially for those not already familiar with OO concepts or programming in a language like C#, so this introductory session will go through the very basics of PowerShell syntax. If that collection of pipes and hyphens and curly braces seems to be written in some incomprehensible foreign language, this session is for you. At the end of the session you should have a grasp of how and why a PowerShell script does what it does, and the confidence to dig in deeper and begin using POSH scripts in your own work.
Speaker(s):
- Merrill Aldrich
Track and Room: Pioneer Square - N/A
Title: Data Warehousing Update
Abstract: Data warehousing is changing. New products, new features - how do you make sense of it all. This session takes a look data warehousing on SQL Server, looking at Classic Data warehousing, Fast Track, PDW and the new features Denali introduces, specifically Columnar storage and Data Quality Services. How do you use them in your situation, why and what is the impact.
Speaker(s):
- Douglas Barrett
Track and Room: Montlake - N/A
Title: Basic Performance Tips and Gotchas
Abstract: Forget Profiler for a second, I have seen one poorly placed index bring an enterprise database to its knees. We will cover the basic tips of performance which always work and the ones which always fail. What can you do – and what should you do –when it comes to the most common types of indexes so you always make the right move. We will use lessons from SQL Architecture Joes 2 Pros Vol3.
Speaker(s):
- Rick Morelan
Track and Room: Capitol Hill - N/A
Title: Top 10 Admin Mistakes on SQL Server
Abstract: Microsoft SQL Server is easier to administrate than any other relational database on the market. But “easier than everyone else” doesn’t mean it’s easy. And it doesn’t mean that database administration on SQL Server is problem free. And since SQL Server is constantly growing from small, home-grown applications, many IT professionals end up encountering issues that others had tackled and solved years ago. Why not learn from those who first blazed the trails of database administration, so that we don’t make the same mistakes over and over again. In fact, wouldn’t you like to learn about those mistakes before they ever happen?
Speaker(s):
- Kevin Kline
Track and Room: Pioneer Square - N/A
Title: The Elephant in the Room (Hadoop for DBAs)
Abstract: The rapidly evolving worlds of cloud and big data are producing a wide variety of new computing and storage platforms beyond the relational paradigm. This includes Not-Only SQL (noSQL) data stores, such as MongoDB and Cassandra, to distributed data management and computation ecosystems such as Hadoop.
This session will explore the key technology gaps and drivers behind this shift, and examine the pros and cons of various tools and approaches.
This will encompass hands-on demonstrations, real world applications and how best to leverage these new platforms in conjunction with SQL Server.
Speaker(s):
- Mark Simms
Track and Room: Capitol Hill - N/A
Title: SRS Report Builder for Business Intelligence
Abstract: Learn how easy it is to utilize the free download from Microsoft that allows users to create maps, charts, dashboard objects and reports against any kind of data easily without having to use Visual Studio.
Speaker(s):
- David Eichner
Track and Room: Montlake - N/A
Title: Merge Replication for High Availability
Abstract: Load balancing web servers between database servers enables high availability when using merge replication. When one data center has a power failure, the HVAC is down or other disaster, the web hosting and databases at the other data center can take over new connections along with the existing connections and continue with the entire load. Upgrades and equipment maintenance are more convenient when another data center can easily take over. There are limitations and specific procedures for setup and maintenance. Discover the benefits and caveats of merge replication.
Speaker(s):
- Diane Robey
Track and Room: Queen Anne - N/A
Title: Advanced indexing
Abstract: So you know all about heaps, clustered indexes, and nonclustered indexes, but are still not satisfied? Then this is just the session for you!I will explore advanced features such as included columns, indexed views, and filtered indexes. You will find out how they are stored on disk, and how SQL Server uses them to satisfy queries, But I will also show the dangers of using too many indexes, and the tools SQL Server itself hands you to help identify just the right subset of indexes.
Speaker(s):
- Hugo Kornelis
Track and Room: Queen Anne - N/A
Title: Fundamentals of SAN, NAS and IP Storage
Abstract: SAN’s and NAS’s have their own challenges but also open up a whole new set of tools for disaster recovery and high availability. We will touch on the basics that can be applied to most SAN’s and talk about strategies for setting up your storage. We will also cover what makes up a Storage Area Network and what seperates Network Attached Storage from SAN’s and how iSCSI fits into this picture.
Speaker(s):
- Wesley Brown
Track and Room: Queen Anne - N/A
Title: Replication Magic: Initializing From Backups
Abstract: If you work with very large databases (VLDBs) that must be replicated, you should be using initialization from backup. There are a some misconceptions the have caused DBAs to assume that they could not use initialization from backup. In this session I will explore those misconceptions and prove that they are incorrect.
Demos will include initializing a subscriber from a transaction log backup and performing a partial restore of a database and initializing the subscriber from the partial backup.
Speaker(s):
- Robert Davis
Track and Room: Pioneer Square - N/A
Title: Parallel Task Scheduling with T-SQL
Abstract: It’s not so difficult to write a stored procedure to execute number of tasks (SQL statements) sequentially and/or conditionally. However, things will become complex when you decide to run the code blocks within the procedure from different sessions concurrently with desired ordering and definable degrees of parallelism. In this session, we will discuss different ways to implement thread schedulers, semaphores, synchronizations, and process ordering as well as process monitoring and manipulation by using pure T-SQL.
Speaker(s):
- John Huang
Track and Room: Queen Anne - N/A
Title: Dashboard Design: Making Reports Pop
Abstract: Create a highly-visual reporting experience in SharePoint with SQL Server Reporting Services integrated with SharePoint 2010. See how to use BI report design elements like sparklines, KPI indicators, gauges and maps to make important business information jump off the screen and get users’ attention. Create highly-interactive reports with dynamic drill-down, drill-through and super reports that morph as users interact with the data. Build an interactive dashboard using PerformancePoint/Insights and Reporting Services together.
Speaker(s):
- Paul Turley
Track and Room: Montlake - N/A
Title: Enterprise Data Mining with SQL Server
Abstract: This presentation describes SQL Server Data Mining (SSDM) for SQL Server Professionals. Starting with SQL Server Management Studio (SSMS), the demo includes the interfaces important for professional development, including Business Intelligence Development Studio (BIDS), highlighting Integration Services, and PowerShell. The interactive demos are based on Microsoft’s Contoso Retail sample data. Finally we will evaluate where Microsoft data mining can help you in a practical business environment, which may include Oracle and SAS.
Speaker(s):
- Mark Tabladillo
Track and Room: Pioneer Square - N/A
Title: 5 SSIS Tricks to Take You from Beginner to Awesome
Abstract: You know how to create a connection manager, and you can extract data to a flat file. So how do you get past basic package creation? This presentation will cover 5 high-level techniques you can use to become the “go-to” person for SSIS in your organization. This session will be packed with demos of packages you can use to achieve SSIS Awesomeness!
Speaker(s):
- Wil Sisney
Track and Room: Montlake - N/A
Title: Troubleshooting SQL Server with SysInternals Tools
Abstract: In this demo-packed session we will explore the use of SysInternals tools like Process Monitor, Process Explorer, and many others to troubleshoot various problem scenarios with SQL Server. This session is not for the faint of heart and is tailored toward those adventurous DBAs who often like to step out of their comfort zone. A fair knowledge of Windows OS internals is recommended.
Speaker(s):
- Argenis Fernandez
Track and Room: Queen Anne - N/A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Mark Simms
Twitter: - @mabsimms
Contact: http://appfabriccat.com
Mark is a Principal Program Manager on the SQLCAT (SQL Server Customer Advisory Team), working on large-scale cloud applications. Usually found nerding out on challenging customer problems, he is currently focused on telemetry driven applications and guidance to navigation the distributed system landscape.
Robert Davis
Twitter: - @SQLSoldier
LinkedIn: Robert Davis
Contact: http://www.sqlsoldier.com
Robert is a SQL Server Certified Master, MVP, and has spent 17+ years honing his skills in security, performance tuning, SQL development, high availability, and disaster recovery. He served as PM for the SQL Server Certified Master Program at Microsoft Learning, and in various roles at Microsoft specializing in SQL Server administration, development, and architecture. He currently works as a Database Engineer at BlueMountain Capital Management where he spends a vast majority of his time tuning massively parallel queries. Robert feeds his passion for security by acting as co-leader of the PASS Security Virtual Chapter.
Kevin Kline
Contact: http://KevinEKline.com
Kevin Kline is the Director of Engineering Services at SQL Sentry. A Microsoft SQL Server MVP, Kevin is a founding board member of PASS, editor-in-chief of SQLServerPedia.com and the author of popular IT books like “SQL in a Nutshell” (O’Reilly Associates). His twitter handle is @kekline and he blogs at http://KevinEKline.com. Kevin is a top-rated speaker at industry trade shows and has been active in the IT industry for over 20 years.
Dev Nambi
Contact: http://devnambi.com
I am a SQL Server Developer/Architect and involuntary DBA at Microsoft and have worked with SQL Server for 7+ years. I specialize in performance tuning, agile development, VLDBs, and relational data warehousing. I blog at www.devnambi.com and on Twitter at @devnambi .
Aaron Nelson
Twitter: - SQLvariant
LinkedIn: Aaron Nelson
Contact: http://sqlvariant.com/
Aaron Nelson is an author, public speaker, blogger, and leader in the community. He has over 15 years of experience in architecture, Business Intelligence, development, and performance tuning of SQL Server. Aaron has received many certifications and is a six time winner of the Microsoft MVP Award.
Aaron leads the PowerShell Virtual Group of PASS (SQLPS.io), is a board member of PowerShell.org, and is a volunteer at his PASS Local Group, AtlantaMDF.
Mark Tabladillo
Contact: http://www.marktab.net
Mark Tabladillo (MVP, SAS Expert) has been an information technology professional since 1998, and has a primary career consulting with companies across the United States and around the world. Mark’s business mission is to empower and inspire executives, architects and developers with insights from data mining, predictive analytics and business intelligence to make actionable decisions. Mark shares his thoughts on his professional blog at http://marktab.net
Piotr Palka
Twitter: - @PiotrPalka
Piotr Palka has been working with high volume data processing systems since 1999. Piotr implemented and maintained multiple systems for telecommunication companies, including call records processing, billing and customer relationship management and operation support systems. Now he is lead data warehouse developer for Washington State Department of Corrections. He regularly delivers technical presentations at Olympia, WA, PASS chapter.
Wesley Brown
Twitter: - @sqlserverio
LinkedIn: Wesley Brown
Contact: http://www.sqlserverio.com
Wesley Brown is a former SQL Server MVP and PASS Chapter Leader who loves to teach others about SQL Server.He maintains his technical blog at http://www.sqlserverio.com. Wes specializes in high availability, disaster recovery, and large-scale database performance tuning.
Wil Sisney
Twitter: - @HanSQL
Contact: http://www.wilsisney.com
Wil Sisney is a senior database administrator for a large health insurance company, managing business-critical databases. Wil is a Microsoft Certified Professional, holding MCITP certifications in Administration and Development in SQL Server 2008. When Wil isn’t speaking about SQL Server, he’s saving the world from zombies with his website www.zombieprep.net. Find Wil online at: http://www.wilsisney.com
Steve Stedman
Twitter: - @sqlemt
LinkedIn: Steve Stedman
Contact: http://SteveStedman.com
Steve Stedman is the Leader of a PASS Local Group in Bellingham WA USA. Steve runs his own SQL consulting firm Stedman Solutions, LLC. He has 29 years of programming and SQL experience. He has written the book on SQL Common Table Expressions. He teaches, speaks at conferences, writes, and has taught SQL server classes at Western Washington University. Steve has previously spoken at PASS Summit, TechEd, DevTeach Vancouver, many SQLSaturdays, and more.
Donabel Santos
Contact: http://www.sqlmusings.com
Donabel Santos (MCITP, MCT) is a SQL Server MVP and is the senior SQL Server Consultant/Trainer at QueryWorks Solutions in Vancouver, BC. She has worked with SQL Server since version 2000 in numerous development, tuning, reporting, and integration projects with ERPs, CRMs, SharePoint, and other custom applications. She is the author of SQL Server 2012 with PowerShell V3 Cookbook from Packt Publishing.
John Huang
Twitter: - @sqlnotes
LinkedIn: John Huang
Contact: http://www.sqlnotes.info
John Huang, SQL MCM and MVP, has been working with SQL Server since 1994. He is an independent SQL Server consultant in Vancouver specialized in complex data processing, data warehouse, and performance tuning.
Douglas Barrett
Twitter: - @dougy_jb
LinkedIn: Douglas Barrett
Contact: https://www.wherescape.com/blog/
Douglas has worked in the field of Business Intelligence for 20 years - concentrating primarily on data. Data Warehouse design, data processing, tuning, data quality - leading projects for Banks, Airlines, Retailers, Brewers (dim_beer anyone?), Universities etc. When not building data warehouses Douglas loves hiking in the Northwest.
It becomes abundantly clear after project 1 that agility - prototyping, iterations and collaboration with SMEs / BAs is the only way to de-risk a data project. Douglas works for WhereScape - a software company that builds agile tools for developing / managing data warehouses / vaults / hubs. The design will change - when it meets the data, when it meets the users - it is expected, lets make it easier.
Argenis Fernandez
Twitter: - DBArgenis
LinkedIn: Argenis Fernandez
Contact: http://blog.purestorage.com/author/argenisfernandez/
Argenis is a Principal Architect at Pure Storage. He works with customers around the world to make sure they don’t have to worry much about their infrastructure for Data. He is a former Data Platform MVP, former VMware vExpert, Microsoft Certified Master, and more recently worked in the Microsoft Azure Data/SQL Server engineering team as a Principal PM in the Tiger team.
Hugo Kornelis
Contact: http://sqlblog.com/blogs/hugo_kornelis/default.aspx
Hugo is co-founder and RD lead of perFact BV, a Dutch company that improves analysis methods and develops computer-aided tools to generate completely functional applications from the analysis deliverable. The platform for this development is SQL Server. In his spare time, Hugo likes to share and enhance his knowledge of SQL Server by frequenting newsgroups and forums, reading and writing books and blogs, and attending and speaking at conferences. Hugo is also a SQL Server MVP since 2006.
Diane Robey
Diane Robey is a Database Administrator for Economic Research Institute in Redmond, WA and has been in IT since 1984. She became familiar with the SQL language using Informix, and then Oracle as a Certified Oracle DBA. Diane has developed data models and databases for several web sites and now specializes in SQL Server, primarily as a DBA.
As Vice President of the Pacific Northwest SQL Server User Group (PNWSQL), Diane enthusiastically promotes SQL Server and encourages DBAs and developers to embrace SQL Server. She has presented at PNWSQL and SQLSaturday #68 in Olympia, Washington.
Paul Turley
Twitter: - paul_turley
LinkedIn: Paul Turley
Contact: http://www.sqlserverbiblog.com
Paul is a Principal Consultant for Pragmatic Works, a Mentor and Microsoft Data Platform MVP. He consults, writes, speaks, teaches blogs about business intelligence and reporting solutions. He works with companies around the world to model data, visualize and deliver critical information to make informed business decisions; using the Microsoft data platform and business analytics tools. He is a Director of the Oregon Data Community PASS chapter user group, the author and lead author of Professional SQL Server 2016 Reporting Services and 14 other titles from Wrox Microsoft Press. He holds several certifications including MCSE for the Data Platform and BI.
Merrill Aldrich
Twitter: - @onupdatecascade
LinkedIn: Merrill Aldrich
Contact: http://sqlblog.com/blogs/merrill_aldrich/
Merrill is a consultant with the national Digital and Technology Consultancy RBA. In past lives he was a SQL Server DBA for Financial Services and Real Estate Management organizations, a designer of buildings, an expert in three dimensional computer graphics and building information modeling, a speaker, teacher, and visiting lecturer.
David Eichner
Twitter: - @ICANSoftware
LinkedIn: David Eichner
David Eichner is a licensed CPA and is also CEO of ICAN Software Corporation, a Microsoft Dynamics amp; Acumatica ERP partner firm that sell and implements ERP and CRM software, develops software solutions and provides technology consulting. He is the host of a radio show called Business In The Cloud that airs weekly on KLAY 1180AM. He is skilled in building integrated cloud app solutions. His career spans more than 20 years in various technical/managerial positions within industries as diverse as military service, engineering/construction, municipal government, consulting and certified public accounting. Additionally, he holds various national certificates in technology (MCDBA, MCSE, CNE, CITP, Dynamics CRM and ERP, Acumatica CRM and ERP)
Rick Morelan
Rick has worked more than 12 years at Microsoft and has attained over 30 Microsoft technical including certifications in applications, networking, databases and .NET development (MCDBA, MCTS, MCITP, MCAD, MOE, MCSE, MCSE+I). He has also provided training for NW University, Volt Technical Education, The DigiGirlz, and Microsoft. Rick is the Author of the 5 volume SQL Joes 2 Pros book series.
Sponsors
The following is a list of sponsors that helped fund the event: