Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: April 2012

SQL Server – Four-part object names

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

0 comments, 1,269 reads

Posted in SQL and Me on 30 April 2012

Run SSMS as different Windows user

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

1 comments, 603 reads

Posted in SQL and Me on 23 April 2012

Microsoft Certified Solutions Associate – SQL Server 2008 Core / Windows Server® 2008

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

1 comments, 941 reads

Posted in SQL and Me on 18 April 2012