10 things you must do to make your desktop database apps better (www.vistadb.net)

submitted by vistadb(845) 12 hours, 58 minutes ago

Each of these items could be a blog post unto themselves, but I am going to try really hard to not be too verbose and just cover the core of the concept and why you need to do it. Everyone knows that any app driven by data is much more than just the app. In most cases the app without a database doesn’t even function, or fails to function properly. If a database is an integral part of your application, then shouldn’t you be doing all you can to ensure it stays healthy and prepare for the worst case events of corruption or dead drives? read more...

add a comment | category: Database | Views: 6

tags: Database another

Eagerly loading entity associations efficiently with nhibernate (ayende.com)

submitted by .NetKicks(1295) 2 days, 11 hours ago

Ayende explains the .Future(). read more...

add a comment | category: Database | Views: 9

tags: Database another

MongoDB in C# – Extensions to support Json-mapping or Proxy generation (daniel.wertheim.se)

submitted by sedanwer(30) 2 days, 16 hours ago

Simple example with external lib with extensions to the MongoDB Document to allow JSON-strings and serialization between plain c# objects and the Document class. Hence you get automappings. Also contains a simplified proxybuilder that you can use to create a proxy implementation that lets you convert between your c#-entities and the Document class. read more...

add a comment | category: Database | Views: 7

tags: Database another

Entity Framework Context Lifetime Best Practices (blogs.microsoft.co.il)

submitted by gilf(1458) 2 days, 23 hours ago

In this post I’m going to write about one of the major decisions that you need to take when you use ORM tools like Entity Framework. This decision is the context lifetime. read more...

add a comment | category: ADO.NET | Views: 7

tags: ADO.NET Database another

Query Optimization - Interesting Observation of Compute Scalar before (dotnetkicks.com)

published 1 day, 22 hours ago, submitted by pinaldave(6378) 3 days, 18 hours ago

SQL SERVER – Stream Aggregate Showplan Operator – Reason of Compute Scalar before Stream Aggregate February 5, 2010 by pinaldave | Edit I keep a check on the questions received from my readers; when any question crosses my threshold, I surely try to blog about it online. Stream Aggregate is a quite commonly encountered showplan operator. I have often found it in very simple COUNT(*) operation’s execution plan. If you like to read an official note on the subject, you can read the same on Book Online over here. The Stream Aggregate operator groups rows by one or more columns and then calculates one or more aggregate expressions returned by the query. Click more for further story. read more...

add a comment | category: Database | Views: 226

tags: SQLAuthority SQLServer SQL Database pinaldave another

DBA Survivor: Name That Caption (sqlserverpedia.com)

submitted by Marlonr(660) 4 days, 11 hours ago

So, the original SQL Batman, Tom LaRock ( Blog | Twitter) , has an upcoming book called “DBA Survivor: How To Become A Rockstar DBA“. Also, I’ve been aware of Tom’s “Name That Caption Contest” over at his book’s website but I never thought of joining the contest until I read Jorge Segarra’s entry. Basically, the contest is simple – you just give a caption to the header image of the book’s website. read more...

add a comment | category: Database | Views: 0

tags: Database another

Getting started with MongoDB – Using Json.Net and Castle Dynamic proxy (daniel.wertheim.se)

submitted by sedanwer(30) 4 days, 16 hours ago

This post is divided in three blocks: - Getting MongoDB to run on your machine - Consume it manually via the MongoDB – Console - Consume it from C# code. read more...

add a comment | category: Database | Views: 14

tags: MongoDB Database another

Using Unit of Work Pattern with Entity Framework (blogs.microsoft.co.il)

submitted by gilf(1458) 4 days, 17 hours ago

In a previous post I explained how to create a simple repository on top of Entity Framework. In this post I’ll explain the Unit of Work pattern and how we can use it with our data access layer. read more...

add a comment | category: ADO.NET | Views: 5

tags: ADO.NET Database another

SharePoint Custom Columns That May Come Handy To You! (www.sharepointboost.com)

submitted by TechShouter(25) 5 days, 3 hours ago

SharePoint tools related Custom Columns are playing useful roles in SharePoint. In this page there are several tools that may be come handy some day. read more...

add a comment | category: ADO.NET | Views: 1

tags: ADO.NET Database another

In MS SQL Server getting Deadlock details using Traces (sqlreality.com)

submitted by subhashpunia(30) 5 days, 18 hours ago

To get complete deadlock details the easiest and lighted-waighted method is using Traces#. For this purpose SQL Server have Trace # 1204, 1205. The information can be logged in Error log file using trace #3605. read more...

add a comment | category: Database | Views: 8

tags: Database another

Index improve performance by reducing blocking (sqlreality.com)

submitted by subhashpunia(30) 5 days, 18 hours ago

Reduced number of comparison is not the only reason for performance improvement because of indexes. Indexes also reduce the blocking and that reduces that waiting time. read more...

add a comment | category: Database | Views: 5

tags: Database another

Life time or age of a Share Exclusive and Update lock in SQL Server (sqlreality.com)

submitted by subhashpunia(30) 5 days, 18 hours ago

Age of shared lock is decided by the isolation level of session. Age of exclusive locks and update locks is always the length of outermost user defined transaction. There is no impact of isolation levels on the life time of these locks. read more...

add a comment | category: Database | Views: 1

tags: Database another

Nice wrapper around ADO.Net to call sprocs. (dayly-programming.blogspot.com)

submitted by valera.kolupaev(10) 5 days, 22 hours ago

Nice wrapper around ADO.Net to call stored procedures. The key benefit is descriptive consumer code. Wrapper supports error handling and output parameters. read more...

add a comment | category: ADO.NET | Views: 3

tags: ADO.NET Database another

Configuring nHibernate with Oracle and ODP.Net (www.mattlong.com.au)

submitted by mattdlong(35) 6 days, 9 hours ago

I’ve been doing a bit of proof of concept work recently with some ORMs and the Oracle databases of my employer. For various reasons we wanted to get away from our traditional persistence mechanism, stored procedures, the enterprise library’s data access block and ODP.net. read more...

add a comment | category: Database | Views: 4

tags: Database another

Episode 43: Talking OData and SQL Modeling Services with Douglas Purdy (deepfriedbytes.com)

published 12 hours, 55 minutes ago, submitted by cwoodruff(610) 7 days, 8 hours ago

In this episode, Keith and Woody sit down at PDC 2009 with Microsoft’s Douglas Purdy to discuss all things data. Do you remember Oslo from the previous PDC event? Well Oslo has been rebranded to SQL Server Modeling Services to help developers store and manage models for the enterprise. Modeling Services enables you to more productive when building and managing data-driven applications. The guys also get the low down from Douglas on a new web protocol for querying and updating data called OData. read more...

add a comment | category: Database | Views: 18

tags: OData Database another

Avoid singleton pattern using StructureMap with db4o (blog.elliottohara.com)

submitted by gerpx(404) 8 days, 14 hours ago

In this blog post Elliott O'Hara shows us how to avoid contamining your db4o server code with the singleton pattern thanks to StructureMap (a Dependency Injection / Inversion of Control tool for .NET) (sample source code included) read more...

add a comment | category: Database | Views: 7

tags: Database another