Sacramento SQL Server User Group 2011 Meeting Archive

December, 2011

Minimize

Wednesday, December 7th at 6:00PM 

We are proud to announce that Joel Champagne, President, CodeX Enterprises LLC, will be speaking for our group! 

Joel has been involved in the San Francisco Bay Area SQL community in various roles: consultant, developer, and speaker. He’s a .NET architect with a strong emphasis on SQL Server / SSRS / SSAS and data architecture. In 2011, he’s presented in San Francisco, San Diego and LA, talking on SQL stress testing and SQL source control. Expect to see him doing some more evangelism and dog-and-pony in the summer and fall. Joel runs a company with the two-pronged focus of consulting and building developer productivity tools. You can follow him at @sqlheroguy. 

Keynote: Visualizing SQL Server Profile data 

The traditional way to look at SQL Server Profile data is in a basic grid - borrrring! In this talk we'll take a look at a tool that Joel has developed which allows you to visualize execution flow graphically in two different ways: one showing the concurrency of execution, the other showing the nesting of calls and their relative performance. Actually seeing a picture of what's going on in your database helps quickly pinpoint what might be otherwise obscure problems. From here we'll get into some of the kinds of reporting that are possible when we actually aggregate this information, both by touching on MDW (Management Data Warehouse) and SQL-Hero's reporting features. We'll also take a look at programming API's (.NET and SQL based) that are available to extract trace data from trace files, letting you build your own applications that read raw trace data. 

Twitter: @sqlheroguy 

We will raffle off: (1) APress Book: SQL Server 2008 Query Performance Tuning Distilled or SQL Server Transact-SQL Recipies; and (1) O'Reilly e-book (of your choice). 

Attendance: 14 members

November, 2011

Minimize

Wednesday, November 2nd at 6:00PM 

We are proud to announce that Jorge Segarra (Microsoft SQL Server MVP) will be speaking for our group! Jorge is a DBA-turned-BI Consultant for Pragmatic Works consulting and a SQL Server MVP. In addition to being a member of the Jacksonville SQL Server User Group he is a Regional Mentor for PASS. He has also co-authored the book from Apress “SQL 2008 Pro Policy-Based Management“. Redgate Exceptional DBA of the Year 2010 Finalist. He also founded SQL University which can be found in his blog. 

Keynote: Making SSIS Dynamic with Expressions and Configs 

Scenario: I am using SQL Server Integration Services (SSIS) in Business Intelligence Development Studio (BIDS). I have to read from a source database and put it into a destination flat file but at the same time the source database should be configurable. That means in the OLEDB Connection manager connection string should change dynamically. This connection string should be taking from a configuration/xml/flat file. 

How do I do this? Come on November 2nd and find out what Jorge Segarra has to say about this! 

Blog: http://www.sqlchicken.com/ 

Twitter: @SQLChicken 

We will raffle off: (1) Book: Apress- SQL 2008 Pro Policy-Based Management (We can probably get Jorge Segarra to sign this book for you as well); and (1) O'Reilly e-book (of your choice).

Attendance: 15

October, 2011

Minimize

Tuesday, October 5th @ 6:00PM

Mitchell Bottel - Easily Manage your Servers with CMS and PMB
We are proud to announce that Mitch Bottel will be speaking for our group! Mitch has received excellent reviews from his prior speaking engagement which included around 1000 registrants!

In this session, you will learn how to setup and implement Central Management Server (CMS) to run queries against multiple SQL servers in your environment. We will also cover Policy Based Management (PBM) and how to use out of the box best practices and create custom policies to maintain your environment. We will then look at using both CMS and PBM in conjunction with each other to monitor your environment.

Short Bio: Mitchell Bottel is a senior database administrator and owner of Innovative IT Consulting. He has 11 years of IT experience, focusing on SQL Server for the last seven 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.

Blog: http://mitchespitch.com/
Twitter: @SacSQLDude

We will raffle off: (1) Book: Microsoft SQL Server 2008 Administrator's Pocket Consultant- Updated for R2, and (1) O'Reilly e-book (of your choice).

Robert Half Technology will be hosting the event:
2180 Harvard St, Suite 250
Sacramento, CA 95815

Attendance: 13 members

September, 2011

Minimize

Wednesday, September 7th, 2011 @ 6:00 PM

The group therapy meeting is designed to provide a forum that allows attendees to discuss their real world SQL Server related questions, issues and concerns which will be addressed as a group. The discussions will be mediated; bring your questions and we will share experience to get them answered.

One lucky person will walk away with 1 month of free online training!

Food and Beverages will be provided, Robert Half Technology will be sponsoring this event.

Please RSVP by adding a comment to the discussion on LinkedIn.

Attendance: 9

August, 2011

Minimize

Tuesday, August 16th, 2011 @ 6:00 PM

Peter Myers from SolidQ (formerly Solid Quality Mentors) will be visiting Sacramento the week of August 15th and will be presenting for our group!

Jorge Segarra AKA SQLChicken, who was just awarded MVP status, will also be at our meeting and deliver a brief social media/community talk.

Peter Myers will present a keynote on "Developing an Analysis Services Tabular Project BI Semantic Model". He will be presenting the know-how required to develop and deploy a tabular BI Semantic Model – a new data modeling approach made available to developers in the upcoming release of SQL Server Analysis Services.

Bio: Peter Myers has 13 years' solid experience working in OLTP database design and development, DBA support and Data Warehousing/Business Intelligence with SQL Server.
Specializing in Microsoft Business Intelligence, Peter provides mentoring, technical training and course content authoring for SQL Server and Office. Specifically he works with Integration Services, Analysis Services (cubes and data mining), Reporting Services, Excel, PowerPivot and PerformancePoint Services.
He has a broad business background supported by a bachelor degree in applied economics, and he extends this with current MCITP and MCT certifications. He has been an MVP since 2006 (or 2007).
Peter is an established presenter and enjoys sharing his enthusiasm for Microsoft technologies by presenting at user group meetings, technical events and conferences.

Keynote:
SQL Server PowerPivot, first released with SQL Server 2008 R2, empowers business users to create their own tabular data models in Excel 2010. In this presentation you will learn how the features of PowerPivot have been enhanced to support the creation of more sophisticated data models, and that these and additional features are available to the developer to create and secure larger scale solutions.
The presentation will also introduce theory and considerations to help you determine whether PowerPivot or the Tabular Project BI Semantic Model is the appropriate data modeling choice. Additionally, theory and considerations to describe when a Multidimensional BI Semantic Model (previously named the Unified Dimensional Model, and which is still fully supported in the upcoming release) continues to be the appropriate data modeling approach will also be covered.
This presentation is targeted at IT professionals with an interest in data analysis and equally for non-IT professionals interested to understand and evaluate the new data modeling capabilities delivered in the upcoming release of SQL Server Analysis Services. Those with a background in PowerPivot and/or developing Analysis Unified Dimensional Models will benefit from a comprehensive overview of the new data modeling capabilities, theory and discussion to understand when each modeling choice is appropriate.

Note: All theory and demonstrations will be based on the latest publicly available version of SQL Server Code Name “Denali” which is considered to be feature complete.
We will raffle off: (1) Book: Microsoft SQL Server 2008 Administrator's Pocket Consultant- Updated for R2, and (1) O'Reilly e-book (of your choice).

Food and Beverages will be provided. Robert Half Technology will be sponsoring this event.

Attendance: 14



Wednesday, August 3th, 2011 @ 6:00 PM

Kevin Kline- SQL MVP/Author
Unfortunately Jason Hall is being pulled away to Chicago and weill be unable to present. Instead, Kevin Kline will present the keynote on "Managing SQL in a Virtualized Environment". He will discuss the present day challenges of managing SQL VMs and how to overcome these challenges. Kevin's kenote will be done via LiveMeeting and Kyle Patterson from Quest Software will be in attendance.

Kevin Kline is the Technical Strategy Manager for SQL Server Solutions at Quest Software. A Microsoft SQL Server MVP since 2004, Kevin is a founding board member and past president of the Professional Association for SQL Server (PASS). He has written or co-written several books including "SQL in a Nutshell (O'Reilly & Associates)," "SQL Server MVP Deep Dives (Manning)," "Pro SQL Server 2008 Database Design and Optimization (APress)," and "Database Benchmarking: Practical Methods for Oracle & SQL Server (Rampant)." Kevin is a columnist for SQL Server Magazine and Database Trends & Applications Magazine. Kevin is a popular blogger and top-rated speaker at conferences worldwide such as Microsoft TechEd, PASS Summit, Microsoft IT Forum, DevTeach, and SQL Connections, and has been active in IT for over 20 years.
http://sqlblog.com/blogs/kevin_kline/
Twitter @KEKline

We will raffle off: (1) Book: Microsoft SQL Server 2008 Administrator's Pocket Consultant- Updated for R2, and (1) O'Reilly e-book (of your choice).
Kyle Patterson (Quest) will also bring some nice giveaways: T-Shirts and other stuff.

Food and Beverages will be provided. Robert Half Technology will be sponsoring this event.

Attendance: 17

July, 2011

Minimize

Wednesday, July 6th, 2011 @ 6:00 PM

The group therapy meeting is designed to provide a forum that allows attendees to discuss their real world SQL Server related questions, issues and concerns which will be addressed as a group. The discussions will be mediated; bring your questions and we will share experience to get them answered.

One lucky person will walk away with 1 month of free online training. We will also be giving away a (Sigg style) water bottle.

Food and Beverages will be provided. Robert Half Technology will be sponsoring this event.

Attendance: 12

June, 2011

Minimize

Wednesday, June 1st, 2011 @ 6:00 PM

William Brown from Microsoft
Many people requested to have William Brown return after his last keynote going over SSAS. We are happy to announce that William Brown from Microsoft will be returning to hold a keynote for our next meeting.

This session will provide an in-depth review of MDX. It will cover a brief overview of why and how we use MDX. We will walk through the steps to create MDX statements, and discuss the various uses of MDX.

We will raffle off: (1) mouse and (1) book, specifics will be included in the meeting reminder.

Food and Beverages will be provided. Robert Half Technology will be sponsoring this event.

Attendance: 18

May, 2011

Minimize

Wednesday May 4th, 2011 @ 6:00 PM

The group therapy meeting is designed to provide a forum that allows attendees to discuss their real world SQL Server related questions, issues and concerns which will be addressed as a group. The discussions will be mediated; bring your questions and we will share experience to get them answered.

One lucky person will walk away with 1 month of free online training!

Food and Beverages will be provided. Robert Half Technology will be sponsoring this event.

Discussion topics:
E-commerce websites and website framework
Stored procedures - reporting, editing, variable limitations
LINQ
SSIS and ETL techniques
SQL Server Denali

Attendance: 14

April, 2011

Minimize

Wednesday, April 6th @ 6:00 PM (Free Keynote, Food, and *SQL Prompt License)

How do you find information that has typos in it? Fuzzy-string processing! And if your information is in a database, the best place to do that processing is in the database.

Keynote Speaker: Tom Keller- A local database consultant with over 15 years of SQL Server experience covering a broad range of subject matter.

Tom Keller will present a keynote on an optimized T-SQL Implementation of the Damerau–Levenshtein algorithm (“fuzzy" string searching). He will go over details on how the algorithm works at an analytical and detailed level. We will actually, visibly, see results at each consecutive step while the algorithm is in action. He set up a website to display this at http://fuzzy-string.com/

*We will raffle off a license of Red Gate's SQL Prompt Pro ($295 value) - provided by Red Gate.
Red Gate will also be running free webinar "Business Intelligence Development using SQL Developer Tools" on 19th April (8:00-9:00am)- Register at http://www.red-gate.com/products/sql-development/sql-source-control/webinars

Robert Half Technology will be hosting the event:
Wednesday, April 6th @ 6:00PM
2180 Harvard St, Suite 250
Sacramento, CA 95815

Attendance: 15

March, 2011

Minimize

Wednesday, March 2nd, 2011 @ 6:00 PM

The group therapy meeting is designed to provide a forum that allows attendees to discuss their real world SQL Server related questions, issues and concerns which will be addressed as a group. The discussions will be mediated; bring your questions and we’ll share experience to get them answered.

Food and Beverages will be provided. Robert Half Technology will be sponsoring this event.

Please RSVP by adding a comment to the discussion on LinkedIn.

Attendance: 8

February, 2011

Minimize

Wednesday, February 2nd, 2011 @ 6:00 PM

William Brown of Microsoft will present on SQL Server Analysis Services. He will cover a brief overview of why multidimensional databases exist, their use cases and terminology. We will then walk through the steps to create an Analysis Services database, adding business logic, and deployment to the server.

Attendance: 20

January, 2011

Minimize

Wednesday, January 5, 2011 @ 6:00 PM

The group therapy meeting is designed to provide a forum that allows attendees to discuss their real world SQL Server related questions, issues and concerns which will be addressed as a group. The discussions will be mediated; bring your questions and we’ll share experience to get them answered.

Food and Beverages will be provided. Robert Half Technology will be sponsoring this event.

Discussion topics:
Better alternatives to moving data over a linked server; replication was offered as one solution
Environment refreshes with only a subset of data
Common Table Expressions and recursion
Oracle data queries and aggregation of data from Oracle into SQL Server
Sizes of dimensions
Performance baselines and trending
Value of a SQL Server certification
SQL Server compatibility with UTF 8

Attendance: 10