[No text]

I have 2 YouTube Video Log or VLOG.

One is work related and called the icsql channel. The clip below talks about SSIS script component changes:

My other VLOG is related to art and volunteer works I do around the community. I volunteer some of my free time to KFAI radio these days. Here is a radio interview I did with some notable friends like Matt Harding, Palbasha Siddiqui, and Garry Schyman:

 

My team and I have been working on building an enterprise tool to audit data in SQL Server. The 1st CTP permits you to remove redundant data. Other features will be available later. It is available for download at http://www.icdotnet.com.

Here is a screenshot: .

Sorry everyone...

 

The websites http://www.icdotnet.com and http://www.icsql.com is down today.

 

It will be up if all works out by tomorrow. 

As most of us know already, that powershell is the new shell around SQL 2008 to automate database related routines. It reminds me of the manpages in unix itlabs at the UofM. Anyways, I'll start posting few entries related to it. The example below, shows you how to manipulate .NET collection classes. 

PS SQLSERVER:\> $c = New-Object "System.Collections.ArrayList"
PS SQLSERVER:\> $c.Add("test")
0
PS SQLSERVER:\>
PS SQLSERVER:\> $c.Add("your")
1
PS SQLSERVER:\>
PS SQLSERVER:\> $c.Add("mind")
2
PS SQLSERVER:\>
PS SQLSERVER:\> $c
test
your
mind
PS SQLSERVER:\>
PS SQLSERVER:\> $c | Select-Object -first 2
test
your
PS SQLSERVER:\> $c | Select-Object -last 2
your
mind
PS SQLSERVER:\>

One of my SQL Server crashsed. I have a long night ahead... yikes. :(