Changing the DHCP range for Internet Connection Sharing in Windows 7

ICS, or Internet Connection Sharing, is a simple method to share the internet connection on your computer with other local computers. It's fairly simplistic in it's approach, and not a lot of configuration is available. Which is by design, it's not meant to be a robust routing solution. One drawback is that the DHCP range is not easily configurable (the range of IP addresses your computer gives out to the network). This is a problem if your existing home network uses the same IP range as the ICS range... or in my case, if your work VPN uses the same range as ICS. I connect my laptop to my Xbox 360 (cause I'm too cheap at present for their 70€ wireless adapter), but it means I can't work from my laptop after I set up ICS. Luckily, there are workarounds. In Windows 9x, Microsoft offered a simple registry hack to change the IP range, which did the trick wonderfully. In Windows XP, Vista and Windows 7, however, it's not so simple; you cannot actually change the DHCP range, but you can still make ICS bow to your demands. Once you've set up ICS, go to the adapter that ICS is available on, and you'll see a static IP has been set. You can change this IP to whatever you'd like, in any subnet you want. The caveat is that DHCP will no longer function, so in order for ICS clients to work, they'll need a static IP in the same subnet as you configured for the PC. Then just set the router and DNS addresses as your PCs address, and you should be in business. For me and my Xbox 360, this solution works just fine.

Thanks to Steve for pointing out this was possible, after numerous other searches said it was not possible.

Query a MSSQL database for table sizes

We use Microsoft SQL 2005 for our mission critical and web databases. In one instance, we're able to use SQL Express just fine, but lately I had been keeping an eye on a DB that was approaching the 4GB limit imposed on SQL Express. I had a Google for queries to list the table sizes (it's simple enough to find out the size of a single table in Management Studio, but querying is clearly simpler/faster). I found exactly what I was looking for, thanks to Scott Moss. Paste this below, replacing OnePoint with your DB name. Everything else is fine as is.

-- 12/16/2007 -- Any DB will show the table size in MegaBytes -- worked with a SQL Guru at M$ for a few hours last week, here are some fruits of mostly his labor Use OnePoint Go

select object_name(id) [Table Name], [Table Size] = convert (varchar, dpages * 8 / 1024) + 'MB'

from sysindexes where indid in (0,1) order by dpages desc

-- Have A great Week!

Thank you Scott Moss!