SQL Server 2008 – Filtered Indexes
SQL Server 2008 introduces a new feature called Filtered Index. A filtered index is a way of adding a WHERE clause to the index definition to get faster access to a subset of the data. For instance if you have …
Category: Steve
SQL Server 2008 – Backup Compression
The biggest benefit that I see with the new backup compression in SQL Server 2008 is that it improves the speed of the restore. The thing that is far more important that a database backup is the actual restore process, …
SQL Server 2008 – Sparse Columns
In SQL Server, an empty or a null column still would take up space in the database, so even if you added a column that was set to null values, there would still be space taken up in the database. …
Giving up on Regular Broadcast TV
Since I am no longer paying for an broadcast television service (other than Netflix). Not satellite, no cable TV, and no broadcast TV. Now I am 100% internet TV, I guess I should say 100% legal internet TV.
OpenDNS Review – What a Great Site, what a great service
A week or so ago I heard someone on the radio talking about Open DNS as a way to help protect children from some of the nasty sites on the internet. After using it now for about a week, I …
OpenDNS Review – What a Great Site, what a great service Read more »
A Comparison of Oracle and MySQL
MySQL is to Oracle as Linux is to Windows. Limiting Result Sets Oracle supports ROWNUM to limit the result Sets SELECT * FROM tablename WHERE rowmun < 10 MySql uses the LIMIT clause. SELECT * FROM tablename LIMIT 10 Bind …
Kauai Tunnel Hike
Wow, what a day, this was a fabulous adventure. We rented a SUV and the guy at the rental shop told us that we were not allowed to take it off of the pavement. I guess what he doesn’t know …
Starting at Amazon.com
Just started working at Amazon.com. Now I need to take everything that I know about SQL server and apply it to Oracle.
Working With SQL Server Again
Working on the Cyberprise project at Wall Data where we are utilizing Microsoft SQL server to create a corporate intranet product which includes connectivity to AS/400’s and manframes.
WinTech released to Microsoft Support Services
We just got the first version of WinTech a SQL Server based support services tool completed, and the team Supporting the Windows 3.0 product started using it.