(Rohit Garg) Today, We will go through with the steps of renaming or changing SQL Server Standalone Named Instance.
Other News
Understanding Single, SingleOrDefault, First and FirstOrDefault
(Shailendra Chauhan) LINQ provides element operators which return a single element or a specific element from a collection. The elements operators are Single, SingleOrDefault, First, FirstOrDefault, Last, LastOrDefault.
Working with Serialized JSON Data in Windows Phone 8 Apps
(Vipul Patel) To store or transmit data, we need the data to be converted into a sequence of bytes. We can achieve this by serializing data.
WPF Base Classes – HeaderedItemsControl
(Richard Carr) The eighty-third part of the Windows Presentation Foundation Fundamentals tutorial looks at another base class of the menu controls. HeaderedItemsControl provides functionality for controls that hold multiple items and include a header.
Data Transmission for Dynamic Databases
(Tom Beebe and Lester Knutsen) On the heels of the release of IBM Informix Version 12.10xC3 database, references to JavaScript Object Notation (JSON) and NoSQL have been getting a lot of buzz. As a result, database administrators (DBAs) are asking the following questions: “Why do I even want to deal
To Sync or Not to Sync
(Peter Vogel) One reader’s comments in an article I wrote about Entity Framework’s async programming turned into an interesting discussion on the role of asynchronous programming in the modern world (interesting for me, at any rate).
Manage Your SQL Connections Wisely
In my experience it is better for developers who do not understand database connection pooling to not use it than to use it incorrectly. In many of the new frameworks this is handled for you, the creating and tearing down of connections, and the return of a closed connection object to the connection pool. In those instances when you roll […]
Use jQuery to Mimic nth-child Behavior in IE8
(Ryan) Nth-child pseudo-selectors are a cool way to supercharge your CSS. They do a great job of styling a group of elements that need slight changes based on their order. A popular example of this is a grid system, or any similar list of items.
Recover after DROP TABLE. Case 1
(Andriy Lysyuk) Human mistakes are inevitable. Wrong “DROP DATABASE” or “DROP TABLE” may destroy critical data on the MySQL server. Backups would help however they’re not always available. This situation is frightening but not hopeless. In many cases it is possible to recover almost all the data tha
Finding the Cause of a Deadlock or Timeout
(Troy Coleman) Pinpointing the cause of an application failure is one of the more challenging aspects of a developer’s job. Locking problems can be greatly reduced by designing applications that support checkpoint restart and provide the capability to tune commit frequency. Of course, applications f