Interactive ASP.NET

Sometimes those transaction logs get a little large and unwieldy! For dev machines I almost never want the transaction log to ever be larger than 1GB. I often find some transaction logs of 10GB and larger and there is little in the way of GUI tools to help you free up that wasted space. Luckly there...

I know the title of this post is a little bit of a misnomer, business objects will never map 1 to 1 with relational database objects. However, when just starting out and when you get to control the schema of the database, it sure makes a good starting point and this trick makes it really easy and avoids...

Naming conventions are like arm pits. Everyone has them and they all stink! Well, at least that's the perspective of pretty much every developer an DBA alike. I will present my own personal philosophy for naming conventions on databases and hopefully spawn some discussion in the process. Basic Principles...

I posted a blog entry a while back about how to change the owner of a database. What that still does not solve is the problem you have when there is a database user in the database you restored and there is a database user already in your system, each with the same name. While it seems intuitive that...

If you do a lot of programming on a SQL 2005 database, chances are this has happened to you! You restore a database and try to diagram it (or make some other change) and get this error: TITLE: Microsoft SQL Server Management Studio Express ------------------------------ Database diagram support objects...