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

How to configure your own DMV monitors dashboards…? (3/4)

By the last blogs we explained how to configure DMV monitors for making your dashboards for expensive queries statistics and for Connection statistics and outage cases , we are going today to discuss today a new dashboard related to waits /Overload statistics:

Waits /Overload  statistics

As done previously within the previous

Online Event – DBCC Commands: The Quick and the Dangerous

Presenter: Erin Stellato

Abstract:

There are many DBCC statements at the disposal of Database Administrators and Developers. Some are used for the greater good; others can wreak havoc in your system. The majority of these commands are informational, but if you’re not careful you can introduce chaos or at worst, lose data you may never find again. In this session we will explore DBCC commands that are useful for the DBA and developer, and cover when to use them and how. Expect demonstrations that provide a practical application of these commands – both documented and not – that database professionals can utilize quickly and easily.

Bio:

Erin Stellato is a Senior Database Engineer at Hyland Software, Inc. in Westlake, OH. She has over 11 years of technology experience, and has worked with SQL Server for the last eight years. Erin works with customers to provide support for problems that involve the database and system performance. She is an active member of the SQL Server community and blogs about her experiences. Her areas of interest include Internals, Maintenance strategies, Performance Tuning and High Availability.

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=s6798gl02wk3xg74 no later than 5:00 PM EDT on May 8th.

Live Meeting Link:

https://www.livemeeting.com/cc/8000181573/join?id=J93PGC&role=attend