Calendar

December 2019
SunMonTueWedThuFriSat
24
25
26
27
28
29
30
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
1
2
3
4

Previous Meetings

Himalayan SQL Server User Group is a team of Professionals in Microsoft SQL Servers working together with an objective to become a solution provider in SQL Server through forums and SQL Chapter members. Our goal is to  produce more skilled and trained manpower in SQL Server, produce and promote MVP, launch social campaigns to create awareness of Microsoft related product and provide solution for software related problems to each individuals and corporate according to their needs.
We are a non-profit trading group working to help the community through the expertise of its members.
 
Using SQL Server 2012s Always
Excel 2013 PowerPivot in Action 
What's New in Analysis Services 2012
 

Date: 11/24/2012 2:16:18 AM


Himalayan SQL Server User Group is a team of Professionals in Microsoft SQL Servers working together with an objective to become a solution provider in SQL Server through forums and SQL Chapter members. Our goal is to  produce more skilled and trained manpower in SQL Server, produce and promote MVP, launch social campaigns to create awareness of Microsoft related product and provide solution for software related problems to each individuals and corporate according to their needs.

We are a non-profit trading group working to help the community through the expertise of its members.

About the presentation:

Monitoring SQL Server Database Mirroring with Email Alerts (continued)
OVER clause and Running and Sliding Aggregates on SQL Server 2012. (Live Session)
SQL Server 2012 Database Internals
Introduction to Virtualization and SAN Basics for DBAs

Date: 7/28/2012 2:00:00 PM


 

About Himalayan SQL Server User Group
 
Himalayan SQL Server User Group is a team of Professionals in Microsoft SQL Servers working together with an objective to become a solution provider in SQL Server through forums and SQL Chapter members. Our goal is to produce more skilled and trained manpower in SQL Server, produce and promote MVP, launch social campaigns to create awareness of Microsoft related product and provide solution for software related problems to each individuals and corporate according to their needs.
We are a non-profit trading group working to help the community through the expertise of its members.

About the presentation

Preparation for SQL Server Disaster
Why do we BI?

Date: 6/30/2012 3:00:00 PM


Presenter: Greg Linwood

Greg Linwood is the Managing Director of MyDBA.com - an Australian SQL Server specialist optimization, support & consulting business. Greg has a wide range of developer & DBA experience with SQL Server since 1993 and was the first Australian to receive Microsoft's SQL Server "Most Valuable Professional" award in 2003. Greg was one of the founders of the Australian SQL Server User Group in 2003.

Presentation Abstract:

The Art of SQL Server Performance Tuning

========================================
SQL Server database optimization remains an interesting mix of art & science, requiring practitioners to interpret some things which can be measured easily (eg. CPU utilization) and others that can't (eg. page splits, changing query plans). Understanding how to "read between the lines" and differentiate between "cause" and "effect" are essential skills in optimizing SQL Server database systems and in this presentation, Greg Linwood will cover the essentials for beginners and also some advanced concepts for seasoned pro's.

Understanding SQL Server Query Execution Plans

==============================================
Central to the performance of any SQL Server system is how queries are being processed by the database engine. Execution plans describe what steps SQL Server is taking to process a query so being able to understand this information is crucial to controlling SQL Server performance. Whilst this topic is sometimes considered to be the domain of experts, a few simple techniques can significantly improve your ability to understand what is going on "in there", putting you in a position to control the performance of your SQL Server system. In this session we will cover the fundamentals of how to obtain& read execution plans, including how to work out whether SQL Server is utilising good indexes and choosing efficient join techniques to process queries efficiently.

Unlocking blocking and deadlocking problems

===========================================
Diagnosing SQL Server blocking and deadlocking is tricky business if you're not sure how to approach diagnosis or design effective solutions to these problems.

In this session, SQL Server MVP Greg Linwood discusses how you can efficiently diagnose blocking & deadlocking problems, whether your SQL Server platform is 2000, 2005 or 2008 (each has improvements in diagnostic capabilities & tools). Greg will also discuss how to design effective solutions once you've identified the source of your blocking or deadlocking problems.

Content for this session spans introductory through to advanced topics, including SQL Server Locking internals, DMVs, SQL Trace, DBCC commands and also SQL 2008's Extended Events (XEvents) which provide deeper information on blocking than was previously available in earlier versions of SQL Server. This session is also based on real world case studies& attendees are invited to bring questions along on the night.

If you have a SQL Server system that suffers from blocking problems & you're not sure what to do next, this is a great opportunity to come along, learn & ask questions from a highly experienced SQL Server Database Administrator!

SQL Server Memory Management & Tuning

=====================================
Memory (RAM) is the most important hardware resource SQL Server uses to achieve high levels of performance. Database systems that lack sufficient memory or are not configured to use available memory properly always perform poorly compared against systems with well configured & adequately sized memory. In this session, we look at how SQL Server uses memory and what you can do to improve the performance of your SQL Server system by sizing & configuring memory properly. Techniques discussed are applicable to SQL Server 2000, 2005 & 2008 and include:

v How to identify whether your system has sufficient memory

v How to configure your server to use all available memory

v How to monitor your system, tracking memory usage over time

Smashing performance bottlenecks with Solid State Disks

=======================================================
Solid State Disks (SSDs) have recently emerged as a mainstream storage alternative to traditional Hard Disk Drives (HDDs) and vendors are now producing SSDs for servers that provide huge improvements in I/O performance whilst also reducing heat & energy consumption.

In this session, Greg Linwood describes how this technology works and what types of SQL Server workloads can leverage the maximum potential from SSDs, based on experiences with several real world business critical SQL Server systems that have been successfully implemented on SSDs.

 Presenter: Greg Linwood Presenter

Greg Linwood is the Managing Director of MyDBA.com - an Australian SQL Server specialist optimization, support & consulting business. Greg has a wide range of developer & DBA experience with SQL Server since 1993 and was the first Australian to receive Microsoft's SQL Server "Most Valuable Professional" award in 2003. Greg was one of the founders of the Australian SQL Server User Group in 2003.

Date: 12/17/2011 9:00:10 AM


Himalayan SQL Server User Group (HSUG) is a team of Professionals in Microsoft SQL Servers working together with an objective to become a solution provider in SQL Server through forums and SQL Chapter members. Our goal is to produce more skilled and trained manpower in SQL Server, produce and promote MVP, launch social campaigns to create awareness of Microsoft related product and provide solution for software related problems to each individuals and corporate according to their needs. We are a non-profit trading group working to help the community through the expertise of its members

Himalayan SQL Server User Group Monthly Meeting Sessions November 26th, 2011

1st Session: Himalayan SQL Server User Group
Start Time: 3:00 PM

Recap: Himalayan SQL Server User Group

presented by Shree Prasad Khanal

2nd Session: Microsoft SQL Server Database Administrator
Start Time: 3:30 PM

Using SQL Server 2008 /R2 Database Mirroring to Become a Super Hero

Presented by Nutan Raj Marasaini

3rd Session: Microsoft SQL Server Business Intelligence

Start Time: 4:30 PM

Dimensional Modeling and SQL Server Analysis Services

presented by Shrwan Krishna Shrestha

Date: 11/26/2011 3:00:00 PM


Displaying results 21-25 (of 36)
 |<  <  1 - 2 - 3 - 4 - 5 - 6 - 7 - 8  >  >| 
 
Copyright 2010 - 2017 www.sqlpassnepal.org