Search 
Thursday, July 03, 2008..:: SQL Server » San Francisco SQL Server User Group::..Register  Login
 San Francisco SQL Server User Group Minimize

RSVP for the next meeting
Please RSVP by email before noon on the day of the meeting. Your response helps us determine refreshments required, and lets us save money by booking the conference room that best matches our head count. To RSVP or for more information or location details please email Mark Ginnebaugh
About the San Francisco SQL Server User Group
The San Francisco SQL Server User Group maintains a focus on database development and administration practices specifically centered around Microsoft SQL Server. Presentations include developer centric interactive sessions as well as demonstrations of related products that have been judged to have potential value or be of interest to the professional database community. The intent is also to provide a face to face forum for peer learning and networking within the context of SQL Server. Members include DBAs, application developers long experienced using SQL Server, FoxPro or Access as a backend data source for custom business systems, as well as developers migrating to the Microsoft .NET platform.

General Agenda:
06:30 to 07:00 - Introductions, food and refreshments, discussion, networking
07:00 to 08:30 - Presentation and Q&A (w/ break)
08:30 to 9:00 - Informal discussion and networking  
Directions To The Meetings
Meetings are held at the NEW Microsoft Office at 835 Market Street, Suite 700, San Francisco, CA 94103.  Click here for a map and more information. 

Mark Ginnebaugh - User Group Leader
Mark is President of DesignMind, a Bay Area developer of Websites and Database Applications.  Send User Group-related questions and suggestions to mark@designmind.com.  

 


Syndicate   Print   
 Meeting Information Minimize

June Meeting - Wednesday, June 11, 2008

At our June meeting, Ross Mistry will give us a jumpstart on how to harden a SQL Server 2008 implementation.

 SQL Server is regularly targeted by hackers as it is a repository of sensitive data for organizations.  If breached, hackers can gain access to confidential information, including credit card numbers, social security numbers, or marketing information.    This presentation will cover topics pertaining to best practices on how to secure and harden a SQL Server 2008 implementation when running on Windows Server 2008. 

Some of the following security and hardening topics will be covered; using database encryption, leveraging Policy-Based Management,  implementing enhanced auditing techniques, using SQL Server configuration tools to minimize attack surface, which authentication method should be utilized, enforcing strong passwords, using SQL Server security logs, creating policies and linking them in Active Directory, verifying security with Microsoft Security Baseline Analyzer and installing Windows and SQL Server Service Packs.  

 Speaker:  Ross Mistry is a partner and principal consultant at Convergent Computing located in the San Francisco bay area.   As a lead architect, Ross design and implements SQL Server, Active Directory and Exchange solution for fortune 500 organizations.  He is a co-author on SQL Server 2005 Management & Administration and Windows Server 2008 Unleashed.   Ross frequently speaks at international conferences around the world such as SQL Server PASS and Dev Connections.  Ross is currently working on his latest title, SQL Server 2008 Management & Administration  – Mastering the Database Engine, which is scheduled for release in fall of 2008.

Remember Our New Location:  835 Market Street, Suite 700.


 

April Meeting - Wednesday, April 9, 2008

At our April meeting, Denise McInerney of Intuit, will talk about Transaction Management.

Lost or corrupted data can have a direct impact on customers and the success of the business, therefore protecting data integrity is one of the primary responsibilities of a DBA.  Denise will discuss how to successfully protect your organization’s data by understanding and practicing effective transaction management.  She’ll discuss:

  • How transactions work in SQL Server
  • Options for transaction management
  • SQL Server isolation levels
  • Tips for effective DBA/Developer partnerships
Speaker:  Denise McInerney is a Sr. Database Developer/DBA at Intuit and has over ten years experience as a SQL Server DBA.  Denise’s focus is design and performance tuning OLTP databases that support web-based applications. She’s an MCDBA and an MCTS in SQL Server 2005 and is the Chairperson for PASS Women in Technology.
 

Additional Upcoming Meetings

July:  Hemant Gaidhani, of VMWare, will be speaking on "Virtualizing SQL Server."  7/9/08

August:  Kevin Tsai, of Microsoft, will talk about "SQL Server Clustering vs. Oracle RAC."  8/13/08

September:  Alex Viera, of Microsoft, will speak in the "SQL Server 2008 Resource Governor, Declarative Management Framework."  9/10/08

October:  Joel Belson, of Microsoft Consulting, will discuss "SQL Server Performance:  Disk I/O."  10/8/08

November:  Kevin Kline, of Quest Software, will be speaking.  His topic is still TBD.  11/12/08

 


Syndicate   Print   
 Links Minimize


Syndicate   Print   
 Documents Minimize

 TitleOwnerCategoryLast UpdatedSize (Kb) 
20040218 Keen Browne: Reporting ServicesMark GinnebaughPresentation slides6/11/2008510.46Download
20050309 Karl Kuhnhausen: Analysis ServicesMark Ginnebaugh 6/11/20084,063.74Download
20080409 Denise McInerney - Transactions in SQL ServerMark GinnebaughSQL6/11/200871.73Download
20080514 - Rene Woody's "Finding the Best Performing SQL"Mark GinnebaughSQL6/11/2008437.76Download
Data Security Within the EnterpriseAdministrator Account 5/9/2007529.41Download
Ross MistryAdministrator AccountRoss Mistry5/9/20075,673.99Download
Ross Mistry Hardening SQL ServerJohn Hanson 6/18/2008779.11Download
SQL Reporting Services vs. Crystal Reports Feature ComparisonAdministrator AccountComparative Analysis5/9/2007580.41Download
SQL Server High AvailabilityJohn Hanson 6/18/20082,027.52Download
SQL Server High Availability - Paul BertucciAdministrator Account 5/9/20071,280.06Download

Syndicate   Print   
 Sponsors Minimize


 Print   
Copyright 2006-2008 by BAADD   Terms Of Use  Privacy Statement