Keep it Simple and Smart
You can configure the SQL Server replication agents such as, the Snapshot Agent, Log Reader Agent, Queue Reader Agent, Distribution Agent, and Merge Agent to capture more information about error messages and procedure calls to a text file. For example, you can capture the additional information about error messages and
» Read moreContains one row for each system error or warning that can be returned by Microsoft SQL Server. SQL Server displays the error description on the user’s screen. You can get the List of all the Error codes or messages as USE master GO SELECT * FROM sysmessages You will get
» Read moreHow 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 moreVarinder Sandhu is using WP-Gravatar