Interests: SQL Server!

SQL Server – Login Failed, cannot open user default database

by VishalGajjar

SQL and Me

Each login in SQL Server has a default database associated with it. When you login to SQL Server context is...

2013-01-07

1,809 reads

SQL Server – Skipping Function Execution when parameters are NULL

by VishalGajjar

SQL and Me

You can avoid executing a function when NULL values are passed as parameters. To achieve this you need to create...

2012-12-28 (first published: 2012-12-19)

4,126 reads

Discuss

SQL Server – DDL vs. DML Triggers

by VishalGajjar

SQL and Me

Although, DML and DDL triggers are used for different purposes, there are some similarities and differences between these.

Similarities between DDL...

2012-05-28

1,639 reads

SQL Server – Check SQL Agent Job History using T-SQL

by VishalGajjar

SQL and Me

To check SQL Server Agent Job History you can use the Log File Viewer from SQL Server Management Studio.
To Open...

2012-05-14

2,844 reads

SQL Server – Purging Database Mail History

by VishalGajjar

SQL and Me

SQL Server stores all mails and attachments in msdb database. To avoid unnecessary growth of msdb database you should remove...

2012-05-10

1,249 reads

SQL Server – Four-part object names

by VishalGajjar

SQL and Me

Generally it is considered good practice using two-part names for objects. It make the code more readable and avoids confusion...

2012-04-30

3,145 reads

Run SSMS as different Windows user

by VishalGajjar

SQL and Me

When connecting to a server from SSMS using Windows Authentication, you are limited to using only user which you used...

2012-04-23

2,430 reads

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

by VishalGajjar

SQL and Me

Yesterday, I received two mails from the Microsoft Certification Program Team about two new certification earned:
1. Microsoft Certified Solutions Associate...

2012-04-18

1,720 reads