Home > SQL Server User Group > New Sydney SQL Server User Group

New Sydney SQL Server User Group

New Lunchtime-Based Sydney SQL Server User Group

A new lunchtime SQL Server User Group Meeting will start in the Sydney CBD in February. This new user group, co-ordinated by Victor Isakov (MCT, MCITP, MCM, SQL Ranger), will focus on best practices, optimisation, design and implementation – areas specifically geared towards the corporate sector.

The meetings will be of high quality that you would typically see at conferences such as Microsoft Tech Ed, SQL PASS or SQL Connections. A number of industry experts and Microsoft personnel have committed to presenting at this new user group in 2009. The structure and the content of the meetings will provide ‘free’ professional skills development and the opportunity to network with your peers.

These new lunchtime SQL Server User Group monthly meetings will run on the 1st Wednesday of every month, from 12:30 to 14:30, at Westpac Place. The nearest train station is Wynyard. There are parking facilities at Wynyard Place on Kent Street.

 
The meetings of this new user group will rotate through 3 core themes:

 

  • Database Administrator (DBA) Focuses on the responsibilities of the Database Administrator, covering areas such as disaster recovery, management, performance tuning, security and operational excellence.
  • Database Developer (DBD) Focuses on the responsibilities of the Database Developer, covering areas such as query writing, query tuning, indexing strategies, locking architecture and database design.
  • Database Architect (ARC) Focuses on the responsibilities of the Database Architect, covering areas such as high-availability, storage, consolidation / virtualization and scalability.

The details for the new SQL Server User Group are as follows:

 

Time

12:30 to 14:30

Agenda

12:30 – 13:00: Registration / Networking

13:00 – 13:15: News / Case Studies

13:15 – 14:30: Presentation

Location

Westpac Place

275 Kent St, Sydney, NSW 2000‎

Dates

4th Feb, 4th Mar, 1st Apr, 6th May, 3rd Jun, 1st Jul, 5th Aug, 2nd Sep, 7th Oct, 4th Nov, 2nd Dec

Contact

victor @ sqlserversolutions.com.au

 

It would be ideal to pre-register for the SQL Server User Group Meetings to help facilitate entry into Westpac Place. 

 

However, you are most welcome to come on the day without pre-registering, and are encouraged to "bring a friend", but it will take longer to gain entry.

 

To pre-register please email victor @ sqlserversolutions.com.au.

 

In financially challenging times these meetings provide a day-time opportunity to participate in free SQL Server skills development and professional networking. Please let your managers and colleagues know about this great opportunity by sending this link or email to them.

 

Besides getting free skills development and professional networking opportunities, all attendees will have the opportunity to win a valuable door prize.

 

The first three meetings for 2009 are as follows:

 


 

Topic: DBA: Best Practices for All DBAs to Follow

Date: 4th February

Description: As the popularity of SQL Server continues to grow, so is the demand for new SQL Server DBAs. Unfortunately, you can’t “go to school” to learn how to become a DBA. Most DBAs learn from books, seminars, short classes, and trial and error. This session is designed to encourage a cross-pollination of ideas and best practices between DBAs from different organizations. It includes best practices from the trenches which can only be obtained through experience.

 


 

Topic: DBD: A Comprehensive Guide to Indexing in SQL Server

Date: 4th March

Description: With the release of SQL Server 2008 the database developer has more choices in their arsenal for optimally indexing database solutions. In this session we will explore the different indexing technologies that are available in SQL Server 2005 and SQL Server 2008, such as included, composite and filtered indexes. We will discuss the primary design considerations and tradeoffs made when implementing an indexing strategy and present more "exotic" scenarios such as how to implement custom hash indexes, how to combine filtered indexes with sparse columns, partitioned indexes and how to implement partitioned views with different underlying table indexes.

 


 

Topic: ARCH: Reducing Your Storage Cost in SQL Server 2008

Date: 1st April

Description: Are increasing storage costs hurting your bottom line as data sizes keep growing throughout your organization? In this session, we explore how SQL Server can help you lower your storage costs. We start with Microsoft SQL Server 2005 partitioning to transparently migrate older data to lower-cost storage tiers over time. We then discuss new storage cost-saving functionality in Microsoft SQL Server 2008 such as data compression, backup compression, and sparse columns, filtered indexes, file stream which can get you to 50% or more reduction in storage requirements for typical applications. Throughout the session, we share experiences, insights, and best practices from SQL Server customers and Microsoft-internal deployments. Learn how to make good use of these technologies in combination.

About these ads
Categories: SQL Server User Group
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: