Online Event – Memory Management in SQL Server 2012

Date: October 9, 2012

Noon Mountain time – http://www.timeanddate.com/worldclock/fixedtime.html?msg=PASS+DBA+Virtual+Chapter+Live+Meeting&iso=20121010T12&p1=75&ah=1

Presenter: Neil Hambly

Abstract:

SQL Server 2012 brings a wide range of changes from its previous versions – one key change is the way SQL Server memory is managed. With releases prior to SQL Server 2012, there were 2 memory managers, these have been merged into 1 with the latest version,
and that’s just the start of the changes for SQL Server memory. This session will dive into questions related to memory in SQL Server 2012.

Session Takeaways:
• Explore SQL Server 2012’s new memory architecture and learn how to diagnose memory performance issues
• Gain insight on memory pressure issues
• Discover settings to adjust the memory configuration levels and their impact

Bio:

Neil Hambly is a SQL veteran of more than 13 years, with expertise in SQL Server from Version 6.5 to the latest 2012 editions. He’s held database roles at major organizations, including the BBC, ABN AMRO, Accenture, as well as at a number of smaller companies. He’s currently serving as a Database Architect at MDSL, with prior roles as both a DBA and developer.

An active speaker and leader of the London Area SQL Server User Group (UK), Neil can frequently be seen at UK and international events. You can also find him sharing online via his blog, Twitter, and LinkedIn. When not presenting or organizing UG events, Neil is hitting the books and keyboard as he studies for the SQL Server 2008 MCM certification.

Door prize: There will be a raffle for a $50 Amazon gift certificate.  You do not need to register for the meeting, but if you want to enter the raffle, you must register at https://www.livemeeting.com/lrs/8000181573/Registration.aspx?pageName=2vk5v398vnbv91sp no later than 5:00 PM EDT on October 9th.

Live Meeting Link: https://www.livemeeting.com/cc/8000181573/join?id=627TDQ&role=attend

Note: the meeting will be recorded and available on the meeting archives page at dba.sqlpass.org about a week after the event.

SQL Server Path Offline Event (4th of October)

We’ve been cooking this for a while, and here it is. Our event will be held in Riyadh as a first step (Jeddah and Khobar, you’re next). We’ll be having four sessions stating with Hossam discussing the hows and whats of becoming a Database professional for students. The second session will also be a very interesting one for students and professionals, where Nabeel will introduce the audience to SSIS, its uses, and features. These two sessions will be giving in Arabic to ease the communications with the audience.

The third session with Kamal will be about Data Modeling, and I don’t think I need to add anything to how important this session is for everyone. Our last session will be an advanced one, where Shehap will discuss techniques to tune your T-SQL scripts in SQL Server.

If yo want to know more, click HERE

See you all soon.

Online Event – SQL Server Database Design Tips for Optimum Performance

Date: Wednesday, August 29th 2012

Time: 2:00 p.m. ET | 7:00 p.m. UTC/GMT | 10:00 p.m. KSA

Duration: 1 hour.

Session: SQL Server Database Design: Size DOES Matter

Speaker: Thomas LaRock

Abstract:
Great database performance starts with great database design. During the design process it is important to select your SQL Server datatypes wisely. Failure to do so will result in wasted disk space, additional I/O overhead, and decreased performance. There is also the risk that your design will not scale as well as it should. Unless you have unlimited hardware purchasing power, size matters.

Please join Sr. DBA Thomas LaRock (@SQLRockstar) for this live event to learn how smart, effective database design will ensure your databases perform at their peak efficiency. You will learn how to choose the best performing datatypes, how to measure their effectiveness, and how to correct bad datatypes decisions (decision that were not, of course, made by you.)

Bio:
Thomas LaRock is a seasoned IT professional with over a decade of technical and management experience. Currently serving as a Senior DBA for Confio Software, Thomas holds a MS degree in Mathematics from WSU. Thomas currently serves on the Board of Directors for the Professional Association for SQL Server (PASS), and is also a SQL Server MVP. Thomas can also be found blogging at http://thomaslarock.com and is the author of DBA Survivor: Become a Rock Star DBA (http://dbasurvivor.com).

Registration: Register Now

Enjoy SQL Server!

~ Hossam

Natural vs. Surrogate Keys, which school you follow? and why?

When you are designing a database you need to decide how you will handle the primary keys.

Some people use natural keys for that, while other prefer using surrogate keys. Apparently, there are three schools in handling that: natural key, surrogate key, and using both natural and surrogate keys.

Share with us, which school you follow? and why?

For more details about the pros and cons of each, you may read these two articles:

  • SQL Server: Natural Key Verses Surrogate Key
  • Natural vs. Surrogate Keys in SQL Server : Getting the Proper Perspective

Let us have an interesting discussion about this subject.

Enjoy SQL Server!

~ Hossam

Online Event – Don’t Panic, Keep Calm and Organize Your DR Plan

Presenter: AJ Mendo

Abstract:

Chances are sooner or later you will experience a disaster of some sort. Having the knowledge and skills needed to recovery after a disaster is one of the most important skills a DBA needs to have. Practicing those skills will make you more confident and help you handle yourself during the recovery process instilling calm in others.

In this session AJ will discuss what it means to have a recovery plan. He will talk about Service Level Agreements and what you need to know about them. He will talk through several scenarios and demonstrate how to recover from each one. AJ will provide the scripts so you can practice on your own and give you the confidence to Keep Calm And Organize Your DR Plan.

Bio:

AJ has over a decade of experience working with database management systems and has supported a variety of applications. He is a frequent presenter at user groups, SQL Saturdays and online and is on the board of POSSE and the media manager for CACTUSS. He gives his time freely for SQL Events and loves being a part of the SQL Community.

Door prize: There will be a raffle for a $50 Amazon gift certificate.  You do not need to register for the meeting, but if you want to enter the raffle, you must register at https://www.livemeeting.com/lrs/8000181573/Registration.aspx?pageName=4zxpn664m95z034q no later than 5:00 PM EDT on June 12th.

Live Meeting Link: https://www.livemeeting.com/cc/8000181573/join?id=FZT8Q4&role=attend