Mindscape Blog » Blog Archive » 5 reasons not to use a micro ORM(www.mindscapehq.com)

submitted by Noldorin(829) 5 months, 15 days ago

An interesting counter-argument against the recent trends towards lightweight micro-ORM frameworks in the .NET database world. read more...

1 comment |category: Database |Views: 19

tags: Database another

New and Updated Resources Available for Telerik OpenAccess ORM(blogs.telerik.com)

submitted by vaskess(120) 5 months, 18 days ago

As we are constantly trying to make the Telerik OpenAccess ORM learning resources and documentation better and easier to use, we have made some changes that you might find very useful. Getting Started Videos ... read more...

add a comment |category: Database |Views: 12

tags: Database another

SQL Server Download Links All Editions [Very Useful](www.sqlservercurry.com)

submitted by mopen(3596) 5 months, 24 days ago

With SQL Server 2012 RC0 recently announced and a plethora of previous editions already available, it can get tedious to keep track of all these downloads. In this post, I will attempt to share the download links of all SQL Server versions - SQL Server 2012, SQL Server 2008 & R2 and SQL Server 2005. read more...

add a comment |category: Database |Views: 27

tags: Database another

I Just Don't Like Object Mappers(openmymind.net)

submitted by Noldorin(829) 6 months, 4 days ago

Karl Seguin also discusses the use of Object Relational Mappers, and Data Mappers and how he has a growing dislike of them. read more...

2 comments |category: Database |Views: 90

tags: Database another

Polyglot Persistence: Using multiple database technologies in one app(martinfowler.com)

submitted by dpeterson(4397) 6 months, 8 days ago

Martin Fowler discusses how the concept of polyglot programming, using many languages for a single enterprise application, is bleeding into the realm of data persistence. He gives an example of how various pieces of an application may store data differently, and advises that you should no longer assume your persistence layer is relational, or that all of your data will be held within the same store. read more...

1 comment |category: Database |Views: 19

tags: Database another

Linq query or plain SQL? On using tools for what they are made for.(notherdev.blogspot.com)

submitted by notherdev(238) 6 months, 8 days ago

There are some scenarios where using NHibernate.Linq makes no sense. NHibernate's provider is just a tool, with its design, its features and its limitations. It's important to be aware what each tool is the best at and not to look for universal tool. read more...

1 comment |category: Database |Views: 27

tags: Database another

The Entity Framework (v1 and v4) Deal Breaker: TPT Inheritance(samscode.com)

submitted by Noldorin(829) 6 months, 22 days ago

Samuel Meacham highlights a crucial performance issue when dealing with many inheritance models in the Entity Framework 4. Microsoft has to this day not dealt with the issue, and in something of a scandal, has deleted the bug report on Connect that Sam filed. Sam offers a good reason to stay clear of the Entity Framework for the time being and perhaps a long time to come too. read more...

2 comments |category: Database |Views: 36

tags: Database another

Microsoft Data Explorer Walkthrough(blogs.msdn.com)

submitted by dpeterson(4397) 7 months, 7 days ago

Micosoft's Data Explorer team walks us through their new cloud service which allows you to discover, enrich, and publish your data in new and interesting ways. read more...

1 comment |category: Database |Views: 31

tags: Database another

Massive (The Micro-ORM), winforms and VB.Net(blogs.lessthandot.com)

submitted by Noldorin(829) 7 months, 8 days ago

Christiaan Baes takes an introductory look at the use of the Massive Micro ORM from Rob, walking through a getting started from installation to retrieving data. (Courtesy of The Morning Brew.) read more...

6 comments |category: Database |Views: 46

tags: Database another

Running totals in SQL(dotnetinternal.blogspot.com)

submitted by naveedbutt(20) 7 months, 20 days ago

How to calculate running totals using SQL Server in the same select query.... read more...

1 comment |category: Database |Views: 32

tags: Database another

NHibernate for Entity Framework Devs - Writing and Mapping Classes(weblogs.asp.net)

submitted by dpeterson(4397) 7 months, 22 days ago

In part 1 of this series, we are shown how to map our domain model in NHibernate, leveraging some of our prior Entity Framework knowledge. This series is not a debate between the two ORMs, nor is it a comparison series. This series is aimed at developers who wish to learn NHibernate, whether they come from Entity Framework or not. read more...

add a comment |category: Database |Views: 23

tags: Database another

SQL Server Denali – FORMAT() string function(beyondrelational.com)

submitted by jacobsebastian(3639) 8 months, 13 days ago

SQL Server Denali brings us new string function, FORMAT function. It will make formatting of date/time and number values easier. Syntax: FORMAT (value, format [,culture]) Formatting Date/Time Let’s see how it works: DECLARE @a datetime = getdate... read more...

add a comment |category: Database |Views: 9

tags: Database another

Performance Best practice - Transaction log must on a different drive.(beyondrelational.com)

submitted by jacobsebastian(3639) 8 months, 14 days ago

It is a well-known recommendation and best practice that the transaction log of any database must be on a drive different than the data files are on. This is especially useful to improve transaction log file performance, which manifests itself as a high... read more...

3 comments |category: Database |Views: 31

tags: Database another

T-SQL Enhancements: FIRST_VALUE() and LAST_VALUE()(beyondrelational.com)

submitted by jacobsebastian(3639) 8 months, 17 days ago

A couple a weeks ago I blogged about a few of the enhancements in the OVER clause, and now I will show you guys a couple of new windowing functions, that goes along with the OVER clause. read more...

add a comment |category: Database |Views: 8

tags: Database another

SQL Server – "Denali" – PERCENT_RANK() Analytic Function(beyondrelational.com)

submitted by jacobsebastian(3639) 8 months, 25 days ago

PERCENT_RANK() returns the position of a row within the result set. In contrast to RANK() function, PERCENT_RANK() ranks rows between 0 and 1, both inclusive. Computation formula used by PERCENT_RANK(): (RANK() – 1) / (Number of Rows – 1)... read more...

add a comment |category: Database |Views: 3

tags: Database another

Every .NET Developer Should Know Their Database Well Enough(www.sqlservercurry.com)

submitted by SuprotimAgarwal(715) 8 months, 25 days ago

I am a strong believer that a Developer should understand the databases and network he/she is interacting with. As a .NET Developer, having TSQL and SQL Server Administration knowledge to some degree of depth, really helps to design and develop your applications as well as communicate with the DBAs and admins you work with. read more...

7 comments |category: Database |Views: 216

tags: Database another