Saturday, January 24, 2009

SSIS Screen Scraper

I wanted to save one of my co-workers a bunch of monkey work, so I wrote this screen scraper to get the html he needed.

Please use this sample at your own risk.  It worked on my box and that is all I know.   I stole, err, borrowed heavily from others.  The three main victims are:





To run the sample you will need 2 tables created in a SQL database.  I used SQL 2008 and my database name is SandBox.

The scripts to create the tables are in the SQL folder along with one to insert data into the SourceURLs table.

The SSIS package and SQL can be downloaded from my SkyDrive.

Have fun.

Tuesday, January 20, 2009

Policy-Based Management in SQL Server 2008

Here are some links I used to prepare for my presentation on Policy-Based Management in SQL Server 2008.  SQL Books Online is also a great source of information.


SQL Server 2008 Policy Based Management Interview

http://edge.technet.com/Media/SQL-Server-2008-Policy-Based-Management-Interview/

 

Using Policy-Based Management in SQL Server 2008

http://www.mssqltips.com/tip.asp?tip=1492

 

Use Policy Based Management Features of SQL Server 2008 to Manage SQL Servers

 http://technet.microsoft.com/en-us/sqlserver/dd391551.aspx

 

SQL Server Policy-Based Management

This blog is dedicated to Policy-Based Management introduced in SQL Server 2008

http://blogs.msdn.com/sqlpbm/default.aspx

 

 ExecuteWQL() in Policy Based Management

http://statisticsio.com/Home/tabid/36/articleType/ArticleView/articleId/283/ExecuteWQL-in-Policy-Based-Management.aspx

 

Microsoft SQL Server 2008 Feature Pack, October 2008

http://www.microsoft.com/downloads/details.aspx?FamilyId=228DE03F-3B5A-428A-923F-58A033D316E1&displaylang=en