January 2009 Entries
Recap In Episode 1 I addressed database instances but I'd like to correct a technicality. I compared SQL Server instances with Oracle Database instances. While this is pretty much correct, I'd like to add that technically this isn't correct. At least not according to Oracle's documentation. If you look on your installation disk for the docs directory I recommend reading the 2 Day DBA document. So far I'm finding it very valuable. Here's a quote from the Chapter 2 overview: After you create a database, either during installation or as a ...
I have been using SQL Server for about 8 years now. When compared to my peers (read: coworkers) I would classify myself as a SQL Server guru. When compared to many I meet on sites like SQLServerCentral.com where there seem to be those I would classify as SQL Server gods I feel small. When working for MaxPreps.com I was forced to sink or swim and had to learn in depth details about things like replication, mirroring, partitioning and the intricacy of the proceedure cache, execution plans and the query optimizer. So I have had the opportunity to really learn a...
First of all I have to say I'm excited. Today Scott Guthrie announced the Release Candidate (RC) for ASP.NET MVC is now available. And just yesterday my client signed off on the use of ASP.NET MVC for the project I'm currently ramping up. As I'm reading through the Release Notes and Scott's post, the first thing I wanted to setup was compile checking of my views. The recommendation is to only use this project setting when releasing your build to staging or production because of the time required. I gave it a shot with a brand-new MVC application and the difference...
This month I started with a new client. I'm excited because we'll be rewriting a legacy app using Entity Framework against an Oracle backend, and possibly ASP.NET MVC. The team is full of good, experinced developers, any of which could lead their own team. But as with all new technologies we're experiencing pains with early adoption. One of design goals is to be testible. We're not quite talking TDD here. None of us have been on a TDD project here so we're more just talking about trying to move in a direction we think will be beneficial. Additionally, the project specifications require us...
Sql Server best practices recommend using a local, low-permissions account as the service account. But if your machine isn't a member of a domain then you don't get a security tab in the folder properties window. There's many reasons to want to control permissions when you're not on a domain, but how can you do it?I had to do this today and I realized this wasn't something that was obvious to everyone, so I thought I'd make a quick post about it.UPDATE - 1/28/2009I have found there is a much better (read: safer) way to accomplish what is described below....