Friday, October 31, 2008
PASS Community Summit 2008

PASS Community Summit 2008 Bulletin
     

Looking for ROI Justification to Attend PASS Summit 2008?

Look no further. This is the one SQL Server event you simply can't afford to miss. We've assembled a list of ideas that you can customize in order to justify the cost to your manager.

REGISTER NOW

With three days of proven best practices, how-tos, and practical training to make you and your teams successful with SQL Server you simply need to attend. Our action-packed agenda includes:

Face-to-face interaction with over 300 Microsoft SQL Server development team members

Best Practices for using SQL Server directly from the Microsoft Customer Advisory Team

Over 150 technical sessions, including 14 pre-conference sessions and 29 hands-on-labs

And so much more.

Join your SQL Server colleagues and register now.

PASS Summit 2008
Nov 18-21, Seattle WA
$1,595 until November 18

Extended Hotel Discounts
Have a better Summit experience and stay at the center of activity. Contact the hotels below to access the best rates in Seattle.

Red Lion Hotel
$179/night
Call 206-971-8091
Email Red Lion hotel
(mention PASS Summit)

Renaissance Seattle
$185/night
Call 206-583-0300
Reserve online
(use code SQLSQLA)

The Westin Seattle
$195/night
Call 206-728-1000 x5533
Email Westin hotel
(mention PASS Summit)

 

dell
Microsoft VMWare

   


Contact Us | Privacy Policy | Terms of Use

Copyright © 2008 PASS
Professional Association of SQL Server
Suite 2100- 203 North LaSalle Street Chicago IL 60601
604.899.6009 www.sqlpass.org

All Rights Reserved

 

 

Events | News | PASS
10/31/2008 2:25:50 PM UTC  #    Disclaimer  |  Comments [0]  | 
 Thursday, October 30, 2008
Microsoft’s Theory of I.T. Evolution

http://www.microsoft.com/middleeast/gulf/ITEvolution/images/logo.png

Technology is moving into the next era. Are you ready to take the leap with us?

At IT Evolution 08, join us as we unveil the latest technologies that could help change the very DNA of your IT department.

Get a front row seat as we unveil technologies like Hyper-V, App-V and Virtual Machine Manager that will help you ride the hottest trend in IT today - Virtualization. Learn how the new SQL Server 2008 will help you manage any data, any place, any time. See how Visual Studio 2008 provides the most productive developer experience and learn how you can deliver the next generation of rich interactive applications with Silverlight.

 

http://www.microsoft.com/middleeast/gulf/ITEvolution/Images/Register.gif

 

City

Date

Abu Dhabi

Tue Nov 4th

Bahrain

Sun Nov 9th

Oman

Sat Nov 15th

Qatar

Wed Nov 19th

Dubai

Sun Nov 23rd

Kuwait

Wed Nov 26th

 

http://www.microsoft.com/middleeast/gulf/ITEvolution/Images/Robot.png

http://www.microsoft.com/middleeast/gulf/ITEvolution/Images/IT.png

http://www.microsoft.com/middleeast/gulf/ITEvolution/Images/Microsoft.png

http://www.microsoft.com/middleeast/gulf/ITEvolution/Images/bg_bottom.png

http://www.microsoft.com/middleeast/gulf/ITEvolution/Images/ITELogos.JPG

Events | News
10/30/2008 1:08:00 PM UTC  #    Disclaimer  |  Comments [0]  | 
 Sunday, October 26, 2008
TechEd 2008 Barcelona, Spain - Here I come

Once again I've been elected as ATE SQL Server "Ask The Expert" for TechEd Europe 2008 Barcelona. I was excited throughout the year that whether I would be able to be there or not and finally I my wish comes true. Now I am getting prepared to answer all the questions hopefully and to attend the KeyNote from Jason Zander which is the most exciting part.

Last year there was great number of audience around 4000+, this time I don't know what would be the strength.

Thanks to God giving me another chance to be with the Product team and to visit the place.

Stay tuned for the latest updates.

Bandagi!

News | TechEd
10/26/2008 1:07:50 PM UTC  #    Disclaimer  |  Comments [0]  | 
 Saturday, October 25, 2008
Primary vs. Unique Key

Often question comes to mind "What's the difference between Primary and Unique Key"

Primary Key:

  • Enforce uniqueness
  • Never allow NULL value
  • By Default create Clustered Index on column

Unique Key:

  • Enforce uniqueness
  • Allow Null value
  • By Default create Non Clustered Index on column

 

Bandagi!

Interviews | QnA | Quick Tips
10/25/2008 10:26:53 AM UTC  #    Disclaimer  |  Comments [0]  | 
 Friday, October 24, 2008
Deadlock vs. Livelock

So far you have heard about Deadlock where this Livelock comes in?

Deadlock, if a process acquires a lock on a piece of data and another process is also looking for the same piece of data but due to first process waiting indefinitly then it would become a Deadlock, unless one of the user processes is terminated. SQL Server detects Deadlock and terminates one user's process.

Livelock, if a process's exclusive lock request is repeatedly denied due to series of overlapping shared locks then it would become a Livelock, SQL Server detects the Livelock and after 3 denials terminates the Livelock. Another example of Livelock; when a read transaction hold a lock on a table and forcing a write transaction to wait indefinitly.

 

Bandagi!

Interviews | QnA | Quick Tips
10/24/2008 11:17:01 AM UTC  #    Disclaimer  |  Comments [1]  | 
 Thursday, October 23, 2008
How to secure your SQL Server

This is a basic checklist and if you follow then you can secure your SQL Server instance.

  • Disable all guest accounts
  • Apply strong passwords to SA account
  • Rename builtin administrative account
  • Prefer Windows Authentication
  • Install Secure Socket Layer or SSL
  • Install a Network Firewall
  • Isolate SQL Server from your Web Server
  • Restrict physical access to SQL Server
  • Secure SQL Server data files with NTFS Permissons

 

Bandagi!

Interviews | QnA | Quick Tips
10/23/2008 11:26:37 AM UTC  #    Disclaimer  |  Comments [0]  |