Determining Size of all Tables in a Database

Just a quick SQL script to get the rowcount and size data of every table in the current database:

CREATE TABLE #sizeof (
 name varchar (70),
 [rows] int,
 reserved varchar(20),
 data varchar(20),
 index_size varchar(20),
 unused varchar(20),
)

DELCARE @name varchar(70)
DECLARE cur CURSOR FOR select name from ...
more ...

RssCache - An RSS Cache / Aggregator

Note: I'm no longer using this site, and might take it down. Let me know if you want the code.

Recently I've decided that I want to use ╬╝Torrent's Feed ability to auto download BitTorrent torrents, after I gave up on Miro (I moved my video library ...

more ...

Making sure your Audit Collection Server is collecting

A few days ago I wanted to make sure that my ACS (Audit Collection Server) is collecting events from all of my DCs.
For those unfamiliar with ACS, it's an additional component to SCOM (System Center Configuration Manager) that allows you to collect events from the security log of ...

more ...

Dumping your MySQL db using PHP

Hi.
One of my clients asked me to be able to take manual backups of his DB, and because he wasn't so technologically-inclined, using the hosting company's interface wasn't an option. So I created a small PHP page that uses mysqldump to dump the site's db ...

more ...


Querying SQL Servers

Before I had a chance to study Microsoft's SQL Server Management Studio (SSMS)'s Powershell SnapIn, I needed to grab some data from an SQL DB. I ended up creating 3 nifty functions for that very thing, and I still use them today, because I find SQL's SnapIn ...

more ...