Generally it is considered good practice using two-part names for objects. It make the code more readable and avoids confusion if objects with similar names exists in different schemas. Some features requires that two-part naming must be used such as creating a view WITH SCHEMABINDING.

However, you can also… Read more

When connecting to a server from SSMS using Windows Authentication, you are limited to using only user which you used to log on to Windows. For example, if you login using User1 on Windows and launch SSMS, you can only use User1 to connect to a server from SSMS as… Read more

Yesterday, I received two mails from the Microsoft Certification Program Team about two new certification earned:

1. Microsoft Certified Solutions Associate – SQL Server 2008 Core

2. Microsoft Certified Solutions Associate – Windows Server® 2008

These also reflected on my transcript today. These two new certifications are awarded due… Read more