Sacramento SQL Server User Group 2013 Meeting Archive
Wednesday, December 4, 2013 at 6:00 PM
Group Therapy: We had a great interactive meeting during which group members shared their Thanksgiving experiences and discussed a variety of topics including database corruption, documenting database design, blocking, backups and more.
Location: This was our third meeting at the new location! Patrick Hays Learning Center, 2700 Gateway Oaks Drive, Suite 2600, Sacramento, CA 95833
Sponsor: Robert Half Technology
Wednesday, November 6, 2013 at 6:00 PM
Presentation: Chris Hitchcock, Monitoring, SQL Inventory, Automation, Reporting, and Administration All In One Tool
Monitoring, SQL Inventory, Automation, Reporting, and Administration All In One Tool. The tool is hosted in a SQL Server 2012 instance, and utilizes PowerShell Scripts, SQL Server Agent and SQL Server Reporting Services to provide monitoring, reporting, environment inventory and administration automation. Chris will go over the overall design, discuss the database and associated functionality stored procedures and views; demonstrate monitoring examples, automation examples, and reporting examples; will discuss reasons for developing the tool, and additional functionality that may be implemented.
About Chris Hitchcock:
Chris is a Lead SQL Server DBA at the California Public Employees Retirement System. He has 7 years experience with Microsoft SQL Server as a DBA and SQL Developer, with 11 years of overall experience in IT fields. His certifications include MCITP Database Administration 2008 and MCITP Database Developer 2008. His LinkedIn profile may be found at www.linkedin.com/pub/chris-hitchcock/35/146/373/ and you may find him on Twitter at https://twitter.com/sqlhitch or @sqlhitch.
Location: This was our second meeting at the new location! Patrick Hays Learning Center, 2700 Gateway Oaks Drive, Suite 2600, Sacramento, CA 95833
Sponsor: Robert Half Technology
Wednesday, October 2, 2013 at 6:00 PM
Presentation: Kalen Delaney, SQL Server Query Plan Options
Being able to determine how SQL Server is processing your critical queries is the most crucial step in determining what queries are tunable, and how you might begin your tuning efforts. We will cover the basics of displaying various kinds of query plans, both text based and graphical. We will also look at the XML query plan feature available through the SQL Server Management Studio and through the a SQL Trace, and discuss the various uses for plans in XML format
About Kalen Delaney:
Kalen Delaney has been working with SQL Server for over 25 years, and provides advanced SQL Server training to clients around the world. She has been a SQL Server MVP since 1993 and has been writing about SQL Server almost as long. Kalen has spoken at dozens of technical conferences, including every PASS conference in the US and multiple TechEd events in both the US and Europe. Kalen is the author or co-author of many books on SQL Server, the most recent being SQL Server 2012 Internals, from O'Reilly/Microsoft Press. She is one of the main editors for SQL Server Central's SQL Server Stairways series, http://www.sqlservercentral.com/stairway. Her most recent major editing project was as editor of SQL Server MVP Deep Dives, Volume 2, a collection of articles by SQL Server experts from around the world, with all the royalties going to charity.
Kalen's website with her current training schedule is at http://www.sqlserverinternals.com, she blogs at http://www.sqlblog.com and her Twitter feed is at https://twitter.com/sqlqueen.
Location: This was our first meeting at the new location! Patrick Hays Learning Center, 2700 Gateway Oaks Drive, Suite 2600, Sacramento, CA 95833
Sponsor: Robert Half Technology
Wednesday, September 4, 2013 at 6:00 PM
Presentation: Ami Levin, SQL Server Internals: Physical Join Operators SQL Server implements three different physical operators to perform joins. In this session you'll see how each of these operators work plus its advantages and challenges. You also get to see some informative demos.
The logic behind the optimizer's decisions
Which operator to use for various joins using (semi) real life examples
How to avoid common join-related pitfalls
Speaker Ami Levin is a Microsoft SQL Server MVP and a Mentor with SolidQ. For the past 14 years, he has been consulting, teaching, writing, and speaking about SQL Server worldwide.
Levin’s areas of expertise are data modeling, database design, T-SQL and performance tuning.
Before moving to California, he led the Israeli SQL Server user group (ISUG) and moderated the Hebrew MSDN SQL Server support forum. Ami is a regular speaker at Microsoft Tech-Ed Israel, Dev Academy, and other SQL Server conferences. He blogs at SQL Server Tuning Blog.
Wednesday, August 7, 2013 at 6:00 PM
Presentation: Jonathan Amen, Table Partitioning in the Wild
Jonathan Amen, a SQLSaturday #222 presenter, delivered his "Table Partitioning in the Wild" presentation. Jonathan discussed the why and how of table partitioning, talked about some theory, and built a simple partitioned table. He also shared his demo scripts.
Wednesday, July 10th at 6:00PM
Group Therapy: We had a great interactive meeting during which group members discussed a variety of topics, including SSRS report design and layout, workload prioritization strategies, replication oddities, useful online SQL Server information resources, SSRS export issues, multi-hop authentication, Windows Azure SQL Database and more.
SQL Saturday #222: Discussion of the upcoming event and organization of volunteers for various tasks.
Wednesday, June 5th at 6:00PM
Presentation: Robert L. Davis (Remotely, via WebEx), Performance Troubleshooting with DMVs
Abstract: There are many tools for a DBA to use for performance troubleshooting. One of the best tools are Dynamic Management Views and functions (collectively referred to as DMVs). DMVs offer insight into the inner workings of SQL Server and helps you identify symptoms and track down root cause. The trick is knowing which DMVs to use and how to interpret the data. This session will detail the DMVs that are most useful in troubleshooting performance problems and will show you how to use the information to reach resolution.
Bio: Robert L. Davis is a SQL Server 2008 Certified Master and an experienced Database Administrator, SQL Server evangelist, speaker, writer, and trainer. He has worked with SQL Server for more than 13 years, most recently as a Sr. Product Consultant and Chief SQL Server Evangelist for Idera Software. Prior to that he served as Program Manager for the SQL Server Certified Master Program at Microsoft Learning, and before that as a production DBA at Microsoft.
Robert is currently working as an independent consultant at SQL DBA Master and recently joined Coinstar, Inc. as a Principal DBA where he will help drive the SQL Server strategy across the many lines of business owned by Coinstar. He blogs at www.sqlsoldier.com and can be found on Twitter as @SQLSoldier.
Robert helped found the PASS Data Architecture Virtual Chapter, was the primary author of Pro SQL Server 2008 Mirroring, and was a Charter Member of the Idera ACEs program. He often speaks at SQL Server events and has written articles and product reviews for SQL Server Pro magazine.
Wednesday, May 1st at 6:00PM
Presentation: Mitch Bottel of Sutter Health Talking About Networking and Self-Promotion
Self-promotion is often times the best promotion you can get. In this session, we will talk about how to promote yourself, your brand and your career. We will discuss Social Medias, communities, volunteering and other ways to get your name out for people to see… What are the first steps? Come find out.
Mitchell Bottel is a Database Administrator with Sutter Health and owner of Innovative IT Consulting. He has 13 years of IT experience, focusing on SQL Server for the last 10 years with an emphasis on database administration and high availability solutions. He has authored blog posts on the SQLServerPerformance website and written White Papers on using Dynamic Management Views. Mitch blogs at http://mitchespitch.com/.
Wednesday, April 3rd at 6:00PM
Presentation: Dan Hess, Sutter Health DBA: SQL Server Encryption 3 Ways - At Rest, In Transit and Column Level
Confused about the various ways SQL Server handles encryption? Are you tasked with securing your environment or trying to pass an audit? There's a lot of information that can be difficult to wade through. In this session, I'll go over the three ways to encrypt SQL Server, showing practical examples of the various techniques.
Dan Hess is a DBA with Sutter Health in Sacramento. He's a Sacramento SQL Server board member since 2011 and has contributed to SQLServerCentral.com. You can read his blogs at http://www.expressnetsolutions.com.
Chapter elections were held.
Raffle: Two printed and one e-book were raffled off.
Wednesday, March 6th at 6:00PM
Presentation: Angel Abundez of DesignMind, 5 ways SSIS 2012 will save you time and money
Integration Services in SQL Server 2012 gives DBAs and BI developers new features that save time and money in terms of development and management. Whether you're automating IT tasks or running ETL processes, SSIS has something for everyone.
Come learn about
Improvements in the design interface
Easier Deployment with the SSIS Catalog
New Standard Reports for monitoring SSIS
New ways to control SSIS on the server.
If you're on SQL Server 2008, not to worry. I will show you an additional 3rd party tool that gives you a lot of this functionality. But nothing beats the ROI with SSIS 2012.
Angel Abundez is a Business intelligence consultant with DesignMind. He is passionate about Business Intelligence, Visualization, and improving business processes using SQL Server, SharePoint, and ASP.NET. Angel’s worked with SQL Server since 2007 and is excited about the new visualizations coming out with PowerPivot, Power View, and SharePoint. He is currently the Co-Lead of the Bay Area BI User Group and is an active speaker in the SQL Server community.
Wednesday, January 30th at 6:00PM
Presentation: Kalen Delaney, SQL Server MVP, What's Simple About SIMPLE Recovery?
Kalen is an internationally recognized author, lecturer and authority on SQL Server. You can find more about her at http://www.sqlserverinternals.com.
There is a common misconception that SIMPLE Recovery means no logging, and this is a very dangerous myth to propagate. SQL Server does log database changes in SIMPLE Recovery, but some (not all) operations are minimally logged. In this session, I'll discuss what exactly minimal logging means and what the benefits and dangers of the SIMPLE Recovery Model are.