Database Tuning at Emergency Reporting
This week I started working at Emergency Reporting doing database performance tuning and scalability work. Currently this is a half time gig focused on SQL Server database performance. Fun stuff.
SQL Server 2008 compatibility levels
SQL Server can run in a number of different compatibility levels, but how do you change it and how do you set it. These compatibility levels reflect the version of SQL server. 60 = SQL Server 6.0 65 = SQL Server 6.5 70 = SQL Server 7.0 80 = SQL Server 2000 90 = SQL Server 2005 100 = SQL …
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 am very impressed, and I have realize that there are some very interesting features beyond just blocking bad sites. DNS …
OpenDNS Review – What a Great Site, what a great service Read more »
Going Freelance
Leaving the corporate world and going freelance.
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 Variables The latest versions of MySql supports bind variables, and Oracle has supported bind variables for a very long time. …
New Blog
This week I moved my blog away from the Simple PHP Blog that was a free open source product. It appeared to have too many security holes.
SQL Server 2005 Compatibility Level
SQL Server can run in a number of different compatibility levels, but how do you change it and how do you set it. These compatibility levels reflect the version of SQL server. 60 = SQL Server 6.0 65 = SQL Server 6.5 70 = SQL Server 7.0 80 = SQL Server 2000 90 = SQL Server 2005 Here is a …
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 won’t hurt us. Our team today consisted of Steve, Marcia, Alex (8 years old), and Uncle Glenn (2nd time Geocaching). …
SQL server for Microsoft Great Plains
Installing, configuring and administering SQL Server for Microsoft Great Plains. What a bunch of crazy table names.