Keep it Simple and Smart
How do I export my LinkedIn connections? You can easily export your Linked connections or contacts into CSV (Comma Separated Values) files. You can later import this CSV into any other email program. Click Connections at the top of your contact Menu The connections screen open, at the button of
» Read moreA self-join is joining a table to itself. This is done by using table name aliases to give each instance of the table a separate name. Self Join is very useful when you want to compare values in a column to other values in the same column. Self join and
» Read moreSQL Server database administrators frequently need in especially development and test environments to find and kill all the blocked process. Following scripts are useful in that scenario. Script – 1 — Find All the Blocked Processes SELECT spid, status, loginame=SUBSTRING(loginame,1,12), hostname=SUBSTRING(hostname,1, 12), blk = CONVERT(char(3), blocked), dbname=SUBSTRING(DB_NAME(dbid),1, 10), cmd, waittype
» Read moreThere are two new Logical functions are introduced in Denali. Let‘s have a look IFF CHOOSE IFF It Returns one of two values, depending on whether the Boolean expression evaluates to true or false. IIF is a shorthand way for writing a CASE statement. It evaluates the Boolean expression passed
» Read moreRanking functions return a ranking value for each row in a partition. Depending on the function that is used, some rows might receive the same value as other rows. Ranking functions are nondeterministic. There are four functions RANK DENSE_RANK ROW_NUMBER NTILE RANK Â Returns the rank of each row within
» Read moreThe LINQ language extensions allow you to query data in a consistent manner. However, LINQ also includes additions to the .NET Framework itself for working with specific types of data such as relational databases, XML, and objects.These additions allow you to connect to this data, query against it, and insert, update,
» Read moreLINQ stands on Language Integrated Query. LINQ changes the way you access and query data. Before LINQ was created, most queries were expressed as text that was executed against a database. This SQL text was often specific to the underlying technology of the database being queried. LINQ elevates the process
» Read moreOne of most useful feature of Facebook that allow you to download your complete profiles as a backup. This Backup includes all your messages, Wall Posts, photos, status updates and profile information. All you need to do is follow the guide below to get your complete Facebook profile backup (
» Read moreThis book has been authored by Rick A. Morelan. If you are a SQL Developer, you must read the series of this book. Highlights of the Book The Contents of the 2th Volume of the SQL Queries Joes 2 Pros Data information and Tables Query Options Null, Expressions, and Identity
» Read moreMy one friend calls me and asks where I find the Object detail in SQL Server 2008. This is very simple but may be some people are in the same situation and finding the Object Explorer Details in SQL Server 2008. That‘s why here sharing Object Explorer Details and SQL
» Read moreVarinder Sandhu is using WP-Gravatar