Did you know that the upcoming version release of SQL Server 2008 has some new datatypes that are going to be available? One of the areas with a number of changes are the datatypes available for storing data related to dates and times in a database.

As I began thinking on some of the impact the following application of this functionality came to mind. Imagine creating a database of your favorite movies and favorite clips within those movies. The new TimeOnly datatype in SQL would allow you to pinpoint and store the specific start and end times within the movie …read more

Last night I had the privilege of being a guest speaker at a local university. I spoke about blogging and using Word 2007 to publish your posts. Not my preference as a blog tool, but if you’re just getting started, have Word already, it’s available to you.

Since I couldn’t make it to the early class where they were covering Word 2007, I spoke on the night they covered Access 2007. I ended up hanging around through the entire class to get a little introduction and overview of the power of Microsoft Access 2007.
I’ve been working with SQL databases and a …read more

I’m in SQL just about every day of the week. Supporting multiple clients with multiple SQL servers in operation, we’re regularly working on databases. Part of that process is to backup and restore databases on our local machines for development.

One of the annoying items about SQL for me is that it wants to bury your database files deep within the Windows program folder for your SQL install. I really don’t want to dig down 7 levels of folder structure to get to my files. I can see how that might be handy and serve as a layer of protection, but …read more

I’m getting my first experience working with the newest version of Microsoft’s SQL Server. We recently installed SQL Server 2008 at a client and we are setting up a web application on their servers now.

In  my experience with SQL when I needed to edit data in a table I would right-click on the table name and select "Open Table" to display all the data in that table. I realize this probably isn’t the preferred or perhaps even "correct" method to use, but for me it worked, was quick and allowed me to immediately edit data in the table.
With SQL Server …read more