When you try to restore a database there are some very tricky stuff you need to know.
Year: 2008
T-SQL Settings Explained
A list of widely used SQL settings Explained ANSI NULLS QUOTED_IDENTIFIER ARITHMABORT ANSI_DEFAULTS ANSI_WARNINGS DATEFIRST DATEFORMAT NOCOUNT NOEXEC IDENTITY_INSERT IMPLICITY_TRANSACTIONS…
ADD IDENTITY TO COLUMN
TraceMonkey and Javascript Engines Compared
One of the most impressive features in Google’s open source Chrome web browser is V8, a high-performance JavaScript virtual machine…
Sql Server 2008 – New Features
If you work with SQL Server on a regular basis, either writing custom queries, designing databases, or optimizing queries, this…
Powerfull Paging with Stored Procedure
Lets consider a simple table called employee( emp_id, name, salary). Now, suppose that we need to create a gridview with…
SQL SERVER – Reset sa Password
1.Open the SQL Server express management studio 2.Connect to SQL Server using windows authentication 3.Right click the server name and…
Photoshop add transparency technique
Let’s say you have an image with no transparency. This is a technique i found to make photos transparent to…
Meta Tags Explained
Recommended META-Tags Meta Content Language (non-US English ONLY) Meta Content Type Meta Description Meta Language (non-US English ONLY) Optional META-Tags…
Vista User Switching Options
Here is a list of tips to change the style you logon to your OS.