Sacramento SQL Server User Group

Sacramento SQL Server User Group 2012 Meeting Archive

December, 2012

Minimize

Wednesday, December 5th at 6:00PM

William Brown of Microsoft - Microsoft Data Mining functionality from the developer to the end user

Learn all about Microsoft Data Mining functionality from the developer to the end user. In the past, data mining belonged to the deep technical specialist, but the current Microsoft stack allows anyone to create very powerful data mining models. Data mining allows users to find insights that are difficult or impossible to discover with traditional analysis.In this presentation we will learn about the new SQL2012 AlwaysOn and its features. We will see the Pros and Cons of the current High Availability/Disaster Recovery Solutions and how the features of SQL 2012 AlwaysOn addresses these issues. 

Attendance: 16

November, 2012

Minimize

No meeting due to PASS Summit

October, 2012

Minimize

Wednesday, October 3rd at 6:00PM

Dilip Nayak: SQL Server 2012 AlwaysOn

In this presentation we will learn about the new SQL2012 AlwaysOn and its features. We will see the Pros and Cons of the current High Availability/Disaster Recovery Solutions and how the features of SQL 2012 AlwaysOn addresses these issues. 

Learn more about: 

1. configuring an availability group, availability group listener and Read-only Routing. 

2. configure automatic/manual failover with synchronous/asynchronous modes. 

3. Reading data from Active Secondary and its other usefulness. 

Dilip Nayak currently works as a DBA at CUDirect Corporation. His expertise is SQL performance tuning, high availability and database administration. He has over 17 years of IT experience starting as a VB/.NET developer and working with SQL for the past 8 years. 

E-mail: d_nayak@hotmail.com 

Attendance: 12

September, 2012

Minimize

Wednesday, September 5th at 6:00PM

Eric Bragas Sr. - SQL Server Management Studio Template Files

SQL Server Management Studio Template Files - Something Every User Can Benefit From 

In this presentation Eric will show that SSMS templates are: 
* useful - all Management Studio users can benefit from using templates (developers, DBAs, programmers, and "everybody else," such as power users); 
* simple - SSMS templates are easy to create, find, and use; 
* powerful - a template created in just the right way can be very effective, timesaving, and convenient. 

General advantages: 
* templates have great staying power--once you create a "killer" template, you're inclined to use it (and improve it) whenever you see the chance; 
* templates often force the creator to think in set-based rules because have to to deal with a situation in concept, not a specific instance of that situation; (for example, not knowing if a query will return one row or many rows for each and every customer address) 
* successful templates tend to take on a "black box" sort of feel ("[I wrote it, ] it works, it's durable, I don't worry about the intricacies of it anymore") 
* they're great for generating "non-report" reports--those seldom-requested reports that don't quite justify the time of creating an actual report, the ones the requestor is content to accept in Excel or even text format. 

Examples: 
* Built-in templates
* convenient for seeing proper T-SQL syntax; 
* How have I used templates? 
* CAST and CONVERT examples 
* Commonly-needed functions, like "first day of last month," "strip the time from the date," "previous Monday's date," etc. 
* Job and Step monitoring 
* Include examples for each of the groups listed: developers, DBAs, programmers, and "everybody else" 

Summary 
* There are no rules! You can make a template any way that suits you. 
* If you ever have to run a query more than once, a template could probably save you time. 
* You'll get better with templates with practice. Use pre-existing built-in templates as guides. 
* Build your templates for YOU. Make them super-ultra-useful to YOU. Others will see the value in the templates built for specific uses.  

Eric Bragas, Sr. is currently contracting as a Senior Business Intelligence Developer at California State Lottery working on a major BI project. He has worked with all versions of SQL Server since version 7 starting in 1997 (but not SQL Server 2012). Previous positions include Data Warehouse Architect, DBA, Database Developer, Applications Developer.

Sponsor: Robert Half Technology

Attendance: 15

August, 2012

Minimize

Wednesday, August 1st at 6:00PM

Group Therapy/SQL Discussion

The Group Therapy/SQL Discussion 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.

Attendance: 14

June, 2012

Minimize

Wednesday, June 6th at 6:00PM

Phil Robinson - Delivering Reports - Report Manager, SharePoint and Beyond

SQL Server Reporting Services provides a great web platform for creating, managing and delivering many types of reports. We will review delivering reports with Report Manager and SharePoint integrated mode and then explore using SSRS as the engine for report presentation within web and windows applications. We will also look at using reports as an alternative to the ASP.NET data grid in a real world application. 

Phil Robinson is an independent consultant focused on developing Business Intelligence solutions using SQL Server tools. He is founder of the San Diego SQL Business Intelligence Group and co-founder of SQL Saturday - San Diego. He currently serves as a PASS Regional Mentor for the Southwest Region. 

Sponsor: Robert Half Technology

Attendance: 22

May, 2012

Minimize

Wednesday, May 2nd at 6:00PM

William Brown of Microsoft - Power View, a feature of SQL Server 2012 Reporting Services Add-in for Microsoft SharePoint Server 2010 Enterprise Edition

Power View, a feature of SQL Server 2012 Reporting Services Add-in for Microsoft SharePoint Server 2010 Enterprise Edition, is an interactive data exploration, visualization, and presentation experience. It provides intuitive ad-hoc reporting for business users such as data analysts, business decision makers, and information workers. They can easily create and interact with views of data from data models based on PowerPivot workbooks published in a PowerPivot Gallery, or tabular models deployed to SQL Server 2012 Analysis Services (SSAS) instances. Power View is a browser-based Silverlight application launched from SharePoint Server 2010 that enables users to present and share insights with others in their organization through interactive presentations.

In this session, William Brown, will demonstrate new how to create a PowerPivot and tabular mode SSAS database that is optimized for Power View. He will cover new PowerPivot features, review the new tabular model of Analysis Services and new Power View add-in to SharePoint. 

Sponsor: Robert Half Technology

Attendance: 20

April, 2012

Minimize

Wednesday, April 4th at 6:00PM

Dan Hess of CSU, Sacramento - Database mirroring with Transparent Data Encryption

Do you want to provide high availability for an application and pass an audit at the same time? Dan will go over the implementation of database mirroring in conjunction with Transparent Data Encryption. We'll discuss security, backups and some monitoring techniques. We'll also see how to undo the whole process. 

Dan Hess is a SQL Server/Oracle DBA for California State University, Sacramento as well as a board member for the Sacramento SQL Server users group. 

URL: http://www.expressnetsolutions.com/sqldch 
Twitter: @SQLDCH 

We will raffle off: (1) Book- To Be Determined; and (1) O'Reilly e-book (of your choice). 

Sponsor: Robert Half Technology

Attendance: 15

March, 2012

Minimize

Wednesday, March 7th at 6:00PM

Angel Abundez of Designmind - Reporting Services with Sharepoint and Mobile devices

Angel Abundez is bringing a little bit of Mountain View back to Sacramento. This weekend Angel presented this keynote at SQL Saturday 109 and received excellent reviews with people saying “Excellent”, “Great Presentation” and “He brought up concepts I had never thought of before” 

Today's executives and information workers want to use mobile devices to get at their business information, make critical decisions, and thrive. Let's help them get there with SQL Server Reporting Services and SharePoint. Tablets are common place now, and smart phones have been in place for years, but have we devoted enough attention to make effective use of the new form factors? Let's discuss how our design approach changes when we want to launch mission-critical dashboards and reports on smaller screen sizes using touch-screen technology. We'll look at iPad and Windows Phone, SSRS and SharePoint, BI Developer and Business User, with emphasis on data visualization best practices. 

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. 

Blog: www.angelsbiblog.com 
Twitter: @AngelStreamline 

We will raffle off: (1) Book- Provided by Wiley (The Microsoft Data Warehouse Toolkit- Second Edition With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset; and (1) O'Reilly e-book (of your choice). 

Pragmatic Works is giving everyone a 3-month license of BIxPress for everyone who does not opt-out and provides the following: Company, Email, and Phone Number 

Attendance: 16

February, 2012

Minimize

Wednesday, February 1st at 6:00PM

The Group Therapy/SQL Discussion 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. 

Attendance: 14

January, 2012

Minimize

Wednesday, January 4th at 6:00PM 

Dr. Meiliu Lu of CSU, Sacramento - Dimensional modeling techniques for the data warehouse.

Meiliu Lu received her Ph.D. degree in Computer Science from the University of Illinois. She is a Professor of the Computer Science Department at California State University, Sacramento. Her current research interests include: data warehousing, data mining, machine learning, bioinformatics, and interactive media for user-paced learning.  She has authored or coauthored publications in journals, conference proceedings, and book chapters, in these and other areas. She is a member of ACM since the 1980’s.

Robert Half Technology will be hosting the event: 

Attendance: 14

Our Sponsors

PASSChapterLogo100.jpg

 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids