Agenda

• 6:05 - 6:50 - Using Resource Governor to Manage workload and resources with Dinesh Asanka (MVP)
• 6:50 - 7:05 - Refreshments & Networking
• 7:05 - 7:50 - Eliminating roundtrips: MERGE and the TABLE data type with Dinesh Priyankara (MVP)

Session #1

Using Resource Governor to Manage workload and resources

by Dinesh Asanka (MVP)

Resource Governor is a new technology in SQL Server 2008 that enables you to manage SQL Server workload and resources by specifying limits on resource consumption by incoming requests.

Dinesh blogs at: http://dbfriend.blogspot.com/

Session #2

From Here to There and Everywhere: An Open Discussion
by Dinesh Priyankara (MVP)

Is your client application still making multiple calls to SQL Server for updating a single dataset? If so, each time the client application makes a call, it affects the network layer unnecessarily. In this session we will see how we can minimize this, passing the dataset with a single call and updating the table with a single statement.

Dinesh blogs at: http://dinesql.blogspot.com/

Where:

Microsoft Sri Lanka
11th Floor
DHPL Building
No. 42
Nawam Mawatha
Colombo 2
SRI LANKA

When:

January 18th (WEDNESDAY), 2012
6:00 PM Onwards

Who:

Everyone are welcome. Entrance: FREE

Map:

CLICK HERE FOR MAP

Agenda

• 6:05 - 6:35 - There's More to T-SQL than Stored Procedures with Dinesh Asanka (MVP)
• 6:40 - 7:10 - BI Goodies up Microsoft's Sleeve with Dinesh Priyankara (MVP)
• 7:10 - 7:25 - Refreshments & Networking
• 7:25 - 8:00 - Looking after VLDBs with Prithiviraj Kulasingham (MVP)

Session #1

There's More to T-SQL than Stored Procedures by Dinesh Asanka (MVP)

Many prefer to using stored procedures (SPs) when modeling businss logic in T-SQL. A lot of them forget the features in SQL Server that sometimes allow better coding standards and efficiency. This session focuses on one of those: Functions. Join this session to learn how functions can be used effectively.

Dinesh blogs at: http://dbfriend.blogspot.com/

Session #2

BI Goodies up Microsoft's Sleeve by Dinesh Priyankara (MVP)

Microsoft continue their experiments with BI offerings. These offerings may or may not be added to the SQL Server suite. But it is well worth taking a look at what Microsoft have up their sleeve. Dinesh will give you a quick view and try to foresee what Microsoft's future plans could look like.

Dinesh blogs at: http://dinesql.blogspot.com/

Session #3

Looking after VLDBs by Preethi Kulasingham (MVP)

Most people do not see Very Large Databases (VLDBs) in real life. Some of us do. Maintaining them, design considerations and best practices tend to be different from small scale databases. Join veteran DBA Preethi, as he shows you how it's done with VLDBs.

Preethi blogs at: http://preethiviraj.blogspot.com/

Where:

Microsoft Sri Lanka
11th Floor
DHPL Building
No. 42
Nawam Mawatha
Colombo 2
SRI LANKA

When:

October 19th (WEDNESDAY), 2011
6:00 PM Onwards

Who:

Everyone are welcome. Entrance: FREE

Map:

CLICK HERE FOR MAP

Agenda

• 6:05 - 6:50 - On the Reporting Cat-Walk with Dnesh Priyankara (MVP)
• 6:50 - 7:05 - Refreshments & Networking
• 7:05 - 7:50 - From Here to There and Everywhere with Dinesh Priyankara (MVP), Dinesh Asanka (MVP) and Prithiviraj Kulasingham (MVP)

Session #1

On the Reporting Cat-walk: Report Models
by Dinesh Priyankara (MVP)

Authoring ad-hoc reports and facilitating for it are quite complex tasks. IT teams have to work hard addressing all the requirements and facilities, while information workers need an easy to use mode of report authoring.

Microsoft provides the solution: SQL Server Report Model. It eliminates the complexity involved and the burden on the IT team. Join Dinesh as he shows you how to make use of the Report Model to publish meta data and to author reports in an easy to use way.

Dinesh blogs at: http://dinesql.blogspot.com/

Session #2

From Here to There and Everywhere: An Open Discussion
headed by Dinesh Priyankara(MVP), Dinesh Asanka (MVP) and Prithiviraj Kulasingham (MVP)

Everyday, you are faced with the challenges of importing and exporting data to and from SQL Server. Sources and destinations include Excel files, CSVs, XMLs, Access, Oracle and what not. Bring along your data import & export problems and join this open discussion.

They blog at: http://dinesql.blogspot.com/,
http://dbfriend.blogspot.com/ and
http://preethiviraj.blogspot.com/

Where:

Microsoft Sri Lanka
11th Floor
DHPL Building
No. 42
Nawam Mawatha
Colombo 2
SRI LANKA

When:

September 29th (THURSDAY), 2011
6:00 PM Onwards

Who:

Everyone are welcome. Entrance: FREE

Map:

CLICK HERE FOR MAP

Agenda

• 6:05 - 7:05 - Modifying Schemas on Large Production Tables with Susantha Bathige
• 7:05 - 7:15 - Refreshments & Networking
• 7:15 - 8:15 - SQL Server Codenamed "Denali" - CTP3 with Dinesh Asanka (MVP)

Please note that Preethiviraj Kulasingham MVP will do the last session (On SQL Server codenamed "Denali") due to sudden unavailability of Dinesh Asanka.

(Please leave a buffer of 15 - 30 minutes in case we get carried away with our discussions) 

Time and Place

• Location: Microsoft Sri Lanka, 11th Floor, No. 42, Nawam Mawatha, Colombo 2, Sri Lanka. (Click for map)

• Date & Time: July 20, 2011 (WEDNESDAY) 6:00 pm onwards

• Attendance: FREE. Anyone can attend. No registrations required.

Agenda

• 6:05 - 7:05 - What is All This Noise About Non-relational Databases? with Susantha Bathige
• 7:05 - 7:15 - Refreshments & Networking
• 7:15 - 8:15 - Common Table Expressions (CTEs) in SQL Server with DInesh Asanka (MVP)

(Please leave a buffer of 15 - 30 minutes in case we get carried away with our discussions) 

Time and Place

• Location: Microsoft Sri Lanka, 11th Floor, No. 42, Nawam Mawatha, Colombo 2, Sri Lanka. (Click for map)

• Date & Time: June 16, 2011 (THURSDAY) 6:00 pm onwards

• Attendance: FREE. Anyone can attend. No registrations required.

Agenda

• 6:05 - 7:05 - I Need To Wait Till This Day To Talk About "Wait Stats" with Preethiviraj Kulasingham (MVP)
• 7:05 - 7:15 - Refreshments & Networking
• 7:15 - 8:15 - A Discussion of NULLs

(Please leave a buffer of 15 - 30 minutes in case we get carried away with our discussions)

Extended Agenda

• I Need To Wait Till This Day To Talk About "Wait Stats"with Preethiviraj Kulasingham

It is important to understand what waits are and how they affect overall performance. This session will focus on Dynamic management views for waits, and how to gather important information from them to track down application and server performance issues. Join this session to learn about Wait Stats.

Target Audience: BIntermediate/Advanceds - Developers.

About Preethi: Preethi is a veteran SQL Server personality with over 15 years' experience. He works as a Senior Lead DBA at eCollege and is an MCITP. Preethi specializes in core DBA work.  His areas of passion are: Performance Optimization & Tuning, High Availability and Automation. Get to know him through his blog: http://preethiviraj.blogspot.com.

• A Discussion of NULLs

A discussion of NULLs? Really? What's so special about NULLs? It stores nothing. What else is there to know about it, right? Well, wrong. Attend this session to learn about the mysterious NULL...

Target Audience: Beginners - Developers

About: This session will be a interactive discussion led by the UG leaders.

Time and Place

• Location: Microsoft Sri Lanka, 11th Floor, No. 42, Nawam Mawatha, Colombo 2, Sri Lanka. (Click for map)

• Date & Time: May 26, 2011 (THURSDAY) 6:00 pm onwards

• Attendance: FREE. Anyone can attend. No registrations required.

Agenda

• 18:10 - 19:00 - Identifying Data Corruption by Jude Pieries
• 19:00 - 19:10 - Refreshments and Networking
• 19:10 - 20:00 - BI without BI with Silverlight PivotViewer by Gogula G. Aryalingam (MVP)

Location

• Microsoft Sri Lanka

Content

• Photo Gallery: Click here
• Session Content Downloads: Click here

No Goodies This Time Round Either :(

The March 2011 edition of the SS SLUG was held on March 16, 2011 at Microsoft Sri Lanka, where the attendees discussed various topics on SQL Se

Agenda

• 6:15 - 7:45 - SQL Conversation 3 with SQL Server community leaders and the attendees
  
• Refreshments (in between)
  

Location

• Microsoft Sri Lanka

Content

• Photo Gallery: Click here
• Session Content Downloads: Click here

No Goodies This Time Round Either :(