How can connection strings be used to change the behaviour of an application? In this post, we explore the use of the system function APP_NAME(), which returns the application name for the current session if set by the application....

I am working a Data Quality Services Demo where i had to figure out how to write a domain rule to validate a email address. for this task, i re-learned how to write a regular expression; here's my basic version: [A-Za-z0-9._-]+@[A-Za-z0-9.-]+.[A-Za-z...

I am working a Data Quality Services Demo where i had to figure out how to write a domain rule to validate a email address. for this task, i re-learned how to write a regular expression; here's my basic version: [A-Za-z0-9._-]+@[A-Za-z0-9.-]+.[A-Za-z...

What permissions does one need to capture SQL traces using SQL Server Profiler? Is it essential that the user must be a member of the sysadmin fixed server role? This post shows the minimal permissions required for a user to capture SQL traces using the...

...

Congratulation to all winners....

While Rebuilding is index table is in S Lock and Sch-M Lock Pages of the table are in X Lock mode But why we can not access table if table is in S Lock mode , index is created drop and created for rebuild purpose so All pages are created Again and...

1.Tempdb does not Follow all ACID rules. Answer of Bonus Question 1.Tempdb Does not follow property Durability. 2.Tempdb is created whenever sql server is restarted so all changes in tempdb are gone.what if system is crash and starts again we w...

I was Mckinsey's Big Data report 2011 when I learned that " during a single cross-country flight, a Boeing 737 generates 240 terabytes of data " ...

I was Mckinsey's Big Data report 2011 when I learned that " during a single cross-country flight, a Boeing 737 generates 240 terabytes of data " ...