SQLSaturday #184 - North Haven 2013 3/2/2013 12:00:00 AM (GMT-05:00) Eastern Time (US and Canada) SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat184 Quinnipiac University 370 Bassett Road North Haven CT 06473-4201 http://www.sqlsaturday.com/images/sqlsaturday_gb_icon.png http://www.sqlsaturday.com/images/sqlsaturday_gb_image.png Conference Information general True 1 default Maps maps False 2 default Schedule of Events schedule True 3 default Sponsors List sponsorslist True 4 default Twitter twitter True 5 default Todo List todo False 6 default My Schedule myschedule True 7 default Feedback feedback False 8 default Key Events keyevents False 9 default Share share True 10 default 2902 Tallan, Inc. Gold Sponsor http://www.tallan.com http://www.sqlsaturday.com/files/18d57800-15a5-4992-9dee-e55e32d58207.jpg 60 170 2918 TEKsystems Gold Sponsor http://www.teksystems.com http://www.sqlsaturday.com/files/f542cd7b-0bc3-4951-84a9-5f3cdd63b8d0.PNG 60 170 2919 Bridgewater Associates Gold Sponsor http://www.bwater.com/home/careers/technology-hires.aspx http://www.bwater.com/images/bridgewater_logo.png 60 170 2936 Theia Solutions Gold Sponsor http://theiasolutionsllc.com/ http://www.sqlsaturday.com/files/dfad715f-e3a1-4ef3-955f-6a2a6091931a.jpg 60 170 2843 Confio Software Silver Sponsor http://www.confio.com http://www.confio.com/images/assets/confio_logo.jpg 60 170 2952 Connolly, LLC Silver Sponsor http://www.connolly.com http://www.sqlsaturday.com/files/ef0e7ecd-8cd0-4e4d-ad4f-3b483251f1d9.gif 60 170 2953 BlumShapiro Silver Sponsor http://www.blumshapiro.com http://www.sqlsaturday.com/files/0a0a7e50-5531-4e06-9fbd-ca3c1e0f27fa.png 60 170 3002 Randstad Technologies Silver Sponsor http://www.randstadtechnologies.com http://www.sqlsaturday.com/files/db247f4b-dc8a-4696-aab0-64c07104758b.jpg 60 170 3083 Spire, LLC Silver Sponsor http://www.spirenow.com http://www.spirenow.com//images/print_header.gif 60 170 2965 COZYROC Bronze Sponsor http://www.cozyroc.com/ http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 3059 xSQL Bronze Sponsor http://www.xsql.com http://www.xsql.com/images/xSQLSoftware.png 60 170 3098 Pearl Knowledge Solutions Inc. Bronze Sponsor http://www.pearlknows.com/ http://pearlknows.com/wp-content/pk_images/pearl_logo.jpg 60 170 11779 SQL Saturday 184 Data Base Administration 210 3/2/2013 8:30:00 AM 3/2/2013 9:00:00 AM 11779 SQL Saturday 184 Development 215 3/2/2013 8:30:00 AM 3/2/2013 9:00:00 AM 11779 SQL Saturday 184 BI 220 3/2/2013 8:30:00 AM 3/2/2013 9:00:00 AM 11779 SQL Saturday 184 SQL 2012 230 3/2/2013 8:30:00 AM 3/2/2013 9:00:00 AM 11779 SQL Saturday 184 Professional Development 235 3/2/2013 8:30:00 AM 3/2/2013 9:00:00 AM 11780 SQLSaturday 184 Professional Development 235 3/2/2013 11:45:00 AM 3/2/2013 1:10:00 PM 11780 SQLSaturday 184 SQL 2012 230 3/2/2013 11:45:00 AM 3/2/2013 1:10:00 PM 11780 SQLSaturday 184 BI 220 3/2/2013 11:45:00 AM 3/2/2013 1:10:00 PM 11780 SQLSaturday 184 Development 215 3/2/2013 11:45:00 AM 3/2/2013 1:10:00 PM 11780 SQLSaturday 184 Data Base Administration 210 3/2/2013 11:45:00 AM 3/2/2013 1:10:00 PM 11781 SQLSaturday 184 Data Base Administration 210 3/2/2013 8:00:00 AM 3/2/2013 8:30:00 AM 11781 SQLSaturday 184 Development 215 3/2/2013 8:00:00 AM 3/2/2013 8:30:00 AM 11781 SQLSaturday 184 BI 220 3/2/2013 8:00:00 AM 3/2/2013 8:30:00 AM 11781 SQLSaturday 184 SQL 2012 230 3/2/2013 8:00:00 AM 3/2/2013 8:30:00 AM 11781 SQLSaturday 184 Professional Development 235 3/2/2013 8:00:00 AM 3/2/2013 8:30:00 AM 11782 SQLSaturday 184 Professional Development 235 3/2/2013 5:20:00 PM 3/2/2013 5:40:00 PM 11782 SQLSaturday 184 SQL 2012 230 3/2/2013 5:20:00 PM 3/2/2013 5:40:00 PM 11782 SQLSaturday 184 BI 220 3/2/2013 5:20:00 PM 3/2/2013 5:40:00 PM 11782 SQLSaturday 184 Development 215 3/2/2013 5:20:00 PM 3/2/2013 5:40:00 PM 11782 SQLSaturday 184 Data Base Administration 210 3/2/2013 5:20:00 PM 3/2/2013 5:40:00 PM 11783 Mike Hillwig SQL 2012 230 See those things around your ankles? You hope they're your socks because no DBA wants to be caught with their pants down. Whether you're an accidental DBA, a DBA who has just inherited a bunch of servers, or someone who works in a shop that won't buy monitoring tools, this session will help you get basic monitoring in place to make sure you know what's going on in your environment. You'll learn how to implement simple scripts that perk their ears up and start barking like a dog after a stranger walks in the house. They are the canary in your coal mine. You'll know when backups fail, when they run longer than usual, when data files are getting full, when transaction logs have excessive VLFs, and more. 3/2/2013 1:10:00 PM 3/2/2013 2:20:00 PM 11784 Mike Hillwig Professional Development 235 Mike Hillwig is known as the Cranky DBA. You probably have pain points in your environment that make you cranky, too. Mike has lots of horror stories to tell about bad SQL Server implementations and practices. More importantly, he has developed a list of 12 key tips for managing your SQL Server environment. By following these tips, you’ll make your DBAs, developers, and system administrators a little less cranky. 3/2/2013 4:05:00 PM 3/2/2013 5:15:00 PM 11785 SB Chatterjee Development 215 PowerShell is a command-line scripting language primarily designed for system administration development. Unlike VBScript or DOS batch files, PowerShell is built upon the .NET Platform which makes it customizable and extensible. This introductory session will show the PowerShell language constructs scripts and how it can be used for SQL Server administration (using SMO WMI providers) and development (ADO.Net OLEDB providers). 3/2/2013 10:35:00 AM 3/2/2013 11:45:00 AM 11787 Matt Velic Professional Development 235 “No one knows what I do.” That’s a chief complaint of data professionals everywhere, and it’s a dangerous position to be in as well. Reviews may not be favorable, promotions more uncommon, and training dollars more rare. But by practicing written and verbal communication, new opportunities may present themselves. This session is for data professionals that are looking for fun activities to grow their written and verbal communication skills. 3/2/2013 9:15:00 AM 3/2/2013 10:25:00 AM 11801 Paresh Motiwala Professional Development 235 As IT personnel, we tend to get boxed-in, stranded on our own little island. We fail to make people aware of our activities, both within our own organization and in our wider professional circles. Just like a shipwrecked captain waiting for the rescue boat on a desert island, if you fail to communicate, your career will be stuck with no possibility of progression. This presentation will show you how to leverage networking and self-marketing techniques that will allow you to set sail off the island and into new opportunities. 3/2/2013 1:10:00 PM 3/2/2013 2:20:00 PM 11803 Paresh Motiwala Professional Development 235 As DBAs we are often straddled with writing a best practices document. In this session, I will start with a bare bones template and then we can collectively come up with a Best Practices Document by the end of the session. I challenge you that this document can come in handy, no matter where you go.If time permits, we can also discuss how to implement this in organizations with varying degrees of acceptance. 3/2/2013 10:35:00 AM 3/2/2013 11:45:00 AM 11840 Steve Simon Development 215 SQL Server 2012: Efficient and effective database design is so important that leaving it solely to the DBAs is simply not a solution. We as developers will more than likely have to create applications to access the data stores and as such must ensure that all application related considerations are taken into account within the database design.In this session, (aimed at software developers) we shall be touching upon several concepts of special importance to the developer. These include database development 'patterns and anti-patterns', final proofing of design and creating versatile deployment scripts that can and will be utilized in future endeavors. 3/2/2013 2:30:00 PM 3/2/2013 3:40:00 PM 11850 Steve Simon Development 215 This presentation is meant to introduce the power of SQL Server to the 'total novice'. Often folks arrive at SQL Saturdays hoping to attend a session aimed at the novice. Well this is your chance!!. This hands on presentation assumes that you know NOTHING about SQL Server and that you must come up to speed in a minimal amount of time. We shall learn about the varied components of the product and end up creating a few simple queries, giving you enough knowledge to go back to your workplace and to perform like a star. 3/2/2013 1:10:00 PM 3/2/2013 2:20:00 PM 11854 Martin Schoombee BI 220 Snapshot fact tables are a common approach when a point-in-time reference is required. In some cases though, even snapshots are not an option due to the amount of data it will generate. In this session we will walk through a practical example of when and how to implement temporal fact tables, and how these can be a viable alternative to snapshots in certain situations. 3/2/2013 9:15:00 AM 3/2/2013 10:25:00 AM 11865 Sunil Kadimdiwan BI 220 In this session I will focus on how you can use the new features of Office 2013 such as Power View in Excel. How do you connect to multiple data models? How can you layout your data on a Map? How can you drill down to the details? And much more. 3/2/2013 1:10:00 PM 3/2/2013 2:20:00 PM 11881 Jack Corbett SQL 2012 230 XEvents were introduced with SQL Server 2008 and enhanced in SQL Server 2012 and with the announcement that SQL Trace/Profiler is being deprecated now is the time to begin learningXEvents. We will look at why you should start working with Extended Events, when you should start, and how to start. What you will learn: 1. How to investigate XEvents objects using the DMV's 2. How to create an XEvents Session 3. How to transition an existing Trace to an XEvents Session. What you should know coming in: 1. Basic use of SSMS 2. Familiarity with Trace/Profiler 3/2/2013 10:35:00 AM 3/2/2013 11:45:00 AM 11940 John Miner SQL 2012 230 Many corporations are composed of small divisions located in countries throughout the world. While you might be the lead DBA for your corporation, there are several other employees who have the keys to the kingdom. This presentation will review techniques on how to prevent and/or audit data and schema changes. 1 – Granting correct user access is vital 2 – DML triggers to keep a DATA audit trail. 3 – DDL triggers to keep a SCHEMA audit trail. 4 – Preventing unwanted DATA modifications 5 – Preventing table TRUNCATIONS 6 – Preventing unwanted SCHEMA changes 7 – New Feature (2008) – change data capture 3/2/2013 9:15:00 AM 3/2/2013 10:25:00 AM 11957 Todd Chittenden BI 220 Microsoft Excel is the most popular data analysis tool in use. But most users tend to extract data for their analysis and end up with large volume spreadsheets that only they can understand and use. Data Analysts outside the official IT Department need a tool that will allow them to build and browse data models without extensive time lag to stand up traditional SSAS cubes. Learn how to build SSAS Tabular Models in Excel and Visual Studio. Skirt around Tabular's Parent/Child limitation using DAX Expressions. Use Excel 2013 and SharePoint to build PowerView reports to visualize data trends. Browse a Tabular Model with the DAX Query language. 3/2/2013 10:35:00 AM 3/2/2013 11:45:00 AM 11982 Aaron Bertrand Development 215 The session will cover a collection of minor bad habits that can occasionally lead to major problems. 3/2/2013 9:15:00 AM 3/2/2013 10:25:00 AM 12028 Robert Pearl Data Base Administration 210 Much Ado about Indexes - Tips, Tricks and Tuning.. In my session, I will offer some practical tips and tricks on a wide-array of Index Analysis methods that will allow you to find out everything about a client's indexes and were afraid to ask! What better way to optimize the performance of the database than talk about their indexes. What do you need to know in order to make these suggestions, and implement them. This session will cover the basics on indexes, and then demonstrate ways to improve DB performance. Missing Indexes, Duplicate Indexes, Fragmented Indexes, Covering Indexes, Clustered Nonclustered indexes, and the queries that love them. I will also demo how to correlate the worst performing queries with missing indexes 3/2/2013 2:30:00 PM 3/2/2013 3:40:00 PM 12258 Kathy Gibbs Data Base Administration 210 SQL Server on VMware??? Many of our customers are either virtualizing databases or planning to do so soon. I hear from many groups that attempted running their database on VMware but went back to physical hardware because of performance issues. There are many reasons this may have happened, but quite often the decision to go back to physical was not based on hard facts. This presentation will explore the fundamentals of monitoring databases running in a VMware environment. If you are using classic O/S monitoring tools, you may be getting misleading data. Understand what metrics are important and how to get to that data. 3/2/2013 9:15:00 AM 3/2/2013 10:25:00 AM 12326 David Eichner BI 220 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. See how SQL Report Builder makes creating executive dashboards easy! 3/2/2013 2:30:00 PM 3/2/2013 3:40:00 PM 12384 Grant Fritchey Data Base Administration 210 Just because you're using an Azure SQL database does not mean you can avoid tuning queries. Microsoft has throttling in place that could seriously impact your systems if your queries are using up lots of resources. This session will introduce you to the tools you have available to identify poor performing queries, such as dynamic management objects and others. You'll learn how to understand why a query is running slow using the Azure Portal execution plans. This understanding will enable you to fix your poorly performing queries. All in the cloud. 3/2/2013 1:10:00 PM 3/2/2013 2:20:00 PM 12385 Grant Fritchey Data Base Administration 210 You've fallen into a job that requires you to manage a SQL Server Database Management System. Now you have to keep these databases on their feet. You've heard of this concept called a backup, and it sounds great, but you sure don't know what it is. This session is for you. We're going to go over backups, right from the beginning, so that when you come out of this session you can go back to your systems and set up backups, log backups, differentials, and anything else you might need. Further, you'll know how to recover your database in the event of an actual failure. The fundamentals you need to get a good backup in place and then be able to restore it will be covered in this session. 3/2/2013 4:05:00 PM 3/2/2013 5:15:00 PM 12434 Thomas LaRock Data Base Administration 210 Great database performance starts with great database design. During the database design process it is important to select your datatypes wisely. The wrong choices will often lead to wasted space, increased response times, and less stability. Additionally you run the risk of having your design not scale as well as it should. Leave this session armed with the knowledge you need to help your databases perform at their peak efficiency. 3/2/2013 10:35:00 AM 3/2/2013 11:45:00 AM 12661 Matt Velic Development 215 If you don't have the chance to work on different kinds of projects, it may be tough to grow all the necessary skills to further your career. By building a virtual lab at home, you can take control of the situation. This session will focus on setting up a basic network environment using VirtualBox, free (downloadable) software, and your home computer. It's aimed towards individuals that aren't afraid to modify server settings or use the command line. This session is focused mainly on virtualization and networking topics, and not so much on SQL Server. However, you'll be in the position to tackle larger projects, such as SQL Server clustering or Availability Groups, once complete. 3/2/2013 4:05:00 PM 3/2/2013 5:15:00 PM 12665 Thomas Grohser SQL 2012 230 How SQL Server performs I/O How is SQL Server really accessing the data and log files on the disk? What's done asynchronous and what's synchronous and what impact does that have on our queries and DML statements. Which impact have features like database mirroring and replication, what's different when SQL Server is starting up.   Which I/O Subsystems (including SSD) are best for which type of data and what's the impact if you choose a different one. Which files can be placed on the same volume and which should not. 3/2/2013 2:30:00 PM 3/2/2013 3:40:00 PM 12666 Thomas Grohser SQL 2012 230 Most DBA's rarely establish Service Level Agreements (SLA) with the Management and if they do they sometimes just come up with some random numbers for availability. Then when at some point something goes really wrong everybody wonders why it takes so long to bring everything back online.   This Session will teach you how to ask the right questions, analyze your databases and servers and generate from the gathered data a realistic SLA. 3/2/2013 4:05:00 PM 3/2/2013 5:15:00 PM 12671 Daniel Bowlin BI 220 This session will walk through the various elements that are important to professional and consistent looking reporting. After a review of the report elements we will develop a template using all those elements and then show how to use that template in all your future reports. 3/2/2013 4:05:00 PM 3/2/2013 5:15:00 PM 12676 Melissa Demsak Professional Development 235 In recent years Data Careers have expanded beyond the conventional role of a DBA. This is due to the ever expanding amount of data, a larger variety of tools and the need for business to use data to drive their own performance goals. This session will provide an overview of Data Careers, a discussion of personal traits and life stages that may align with different Data Careers. The new Career areas such as Data Science, Analytics and Data Journalism will be reviewed. In addition, the attendees will be provided with a template that will enable them to make more strategic career-related decisions. 3/2/2013 2:30:00 PM 3/2/2013 3:40:00 PM 12940 Professional Development 235 3/2/2013 3:40:00 PM 3/2/2013 4:05:00 PM 12940 BI 220 3/2/2013 3:40:00 PM 3/2/2013 4:05:00 PM 12940 SQL 2012 230 3/2/2013 3:40:00 PM 3/2/2013 4:05:00 PM 12940 Development 215 3/2/2013 3:40:00 PM 3/2/2013 4:05:00 PM 12940 Data Base Administration 210 3/2/2013 3:40:00 PM 3/2/2013 4:05:00 PM