Posts Tagged ‘database’

Given the amount of time it seems I spend working on data access related code I’d be very interested in what solutions the community is coming up with as an alternative.

Enthusiasts Convene To Say No To SQL, Hash Out New DB Breed

via Slashdot Technology Story | Enthusiasts Convene To Say No To SQL, Hash Out New DB Breed.


Read Full Post »

Just finished another excellent podcast from .NET Rocks which this time discussed the new features of the Entity Framework which is currently out in beta. While I haven’t had a chance to give it a try myself I’m very interested in what Daniel Simmons described. Having written off the EF as “not ready yet” and expecting the new release to still not meet my needs, I was very pleasantly surprised to hear that new features will make it into the final release that weren’t “supposed” to as of a few months back. I definitely need to reevaluate because based on what I heard in the interview the EF may be just a good a fit for me as nHibernate. I definitely recommend anyone interest in ORM check out the interview. (And go write some code)

Daniel Simmons is back this time to talk about the new features of ADO.NET Entity Framework version 4.

Daniel SimmonsDaniel Simmons is dev manager for the Entity Framework and LINQ to SQL team where his mission is to build a team and a product that will fundamentally change the way we build data-centric software. He has been at Microsoft for 10 years working on a variety of products. Before coming to Microsoft he worked as a consultant, founded an ISP and engaged in various other software pursuits.

.NET Rocks!.

Read Full Post »

While listening to another .NET Rocks podcast this morning I caught mention of Sequential GUID’s, a feature introduced in Sql Server 2005. Given the use of GUID’s as primary keys I thought this a useful piece of information.

What are the performance improvement of Sequential Guid over standard Guid? – Stack Overflow.

Read Full Post »

NHibernate keeps looking more and more like the enterprise .NET solution to choose…

But support in NHibernate for Sybase is not great. The basics work but some of the more advanced features are not implemented at all or are done poorly. Fortunately we have an excellent relationship with our vendor and have had for many years. Earlier this week they contacted me and mentioned that they will be undertaking an effort to improve their support for NHibernate and were looking for some beta testers.

via Sybase working to improve NHibernate support | Elegant Code.

Read Full Post »

A reference to the master.dbschema (or similar, see below!) is necessary for database projects in Visual Studio that reference system objects. Here’s how to add those objects without slowing everything down.

In the March edition of MSDN we provided an overview of Server Projects and how to reference the master.dbschema file to resolve references to system objects. If you have a project that references the master.dbschema file, you may have noticed it takes a while to establish this reference. You may have also noticed the project may not load or deploy as quickly as it did before referencing the master.dbschema file. This is because when referencing the master.dbschema file you are adding all the system objects found in a typical SQL Server instance to your database model in Visual Studio. The number of system objects defined in the master.dbschema file greatly outnumbers the user created objects for many database projects. If you have multiple projects referencing the master.dbschema file this can be compounded as each projects reference to the master.dbschema has its own copy of the database model in memory.

via VSTS: DB Best Practices : Right sizing the master.dbschema file for better design time performance.

Read Full Post »

I spent an embarrassingly long period of time trouble-shooting my Sql Server install only to find the problem was the Windows Firewall.

Firewall systems help prevent unauthorized access to computer resources. If a firewall is turned on but not correctly configured, attempts to connect to SQL Server might be blocked.

To access an instance of the SQL Server through a firewall, you must configure the firewall on the computer that is running SQL Server to allow access. The firewall is a component of Microsoft Windows. You can also install a firewall from another company. This topic discusses how to configure the Windows firewall, but the basic principles apply to other firewall programs.

via Configuring the Windows Firewall to Allow SQL Server Access.

Read Full Post »

Despite my continued doubts about stored procedures and practical limits on their best practices usage, there’s no reason to forget all the other lessons I’ve learned about software just because I’m using them. Enter DbUnit, a database testing framework.

DbUnit is a JUnit extension (also usable with Ant) targeted at database-driven projects that, among other things, puts your database into a known state between test runs. This is an excellent way to avoid the myriad of problems that can occur when one test case corrupts the database and causes subsequent tests to fail or exacerbate the damage.

DbUnit has the ability to export and import your database data to and from XML datasets. Since version 2.0, DbUnit can also work with very large datasets when used in streaming mode. DbUnit can also help you to verify that your database data match an expected set of values.

via DbUnit – About DbUnit.

Read Full Post »