This complete package takes care of modeling data and managing the resulting designs -- provided you're using entity-relationship modeling to design your databases.
Red Gate SQL Source Control is a useful tool for SQL Server developers using TFS or Subversion, but falls short in managing database design changes.
Mike worked as a SQL developer for a non-profit, debt management company that handled student loans.
- By Kathleen Richards
- 11/01/2010
In a Redmond Review column last year ("What's Old Is New Again," April 2009), I discussed a move by Microsoft to reform its then-named SQL Data Services (SDS).
- By Andrew J. Brust
- 10/01/2010
LiveLINQ speeds up LINQ queries against in-memory collections by an order of magnitude -- but before you buy it, make sure you have the problems it solves.
Lennie Lobel, CTO of Sleek Technologies and a consultant at twentysix New York, is an expert on Entity Framework and Microsoft .NET Framework data-access technologies.
- By Readers of Visual Studio Magazine
- 10/01/2010
Microsoft today released Service Pack 2 for SQL Server 2008.
It's no surprise that 'Oslo', also known as SQL Server Modeling, has not survived the on-going battle of competing data platform strategies at Microsoft.
- By Kathleen Richards
- 09/22/2010
The industrial-strength Microsoft ORM is finally ready for prime time. Are you?
- By Kathleen Richards
- 09/01/2010
Microsoft extends its enterprise-capable database platform with powerful new management and scalability features -- and there's plenty in the latest rev for developers.
A new component in SQL Server 2008 R2 gives users the autonomy to set up business intelligence functionality in Excel without taking control of the process away from IT.
- By Andrew J. Brust
- 09/01/2010
Microsoft issued even more details about Windows security concerns, even after releasing its August security update on Tuesday.
- By Jabulani Leffall
- 08/11/2010
New versions add caching, support for LightSwitch development.
- By Michael Desmond
- 08/05/2010
On VB author Joe Kunk shows how you can quickly discover the orientation of an unknown database using dynamic queries.
If you're willing to make the mental shift to storing objects instead of data, db4Objects may be the right solution for a distributable local database.