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

Saturday, August 16, 2008

My highlights from the book sale


The Really Good, Really Big, Really Cheap Book Sale in Greenville, SC is a fund raiser for the Greenville Literacy Association. I have looked forward to it every year I have been in Greenville. Here is just some of what I brought home today. The rest of my family made out great as well.

The first one is my biggest prize. Not only will it be a great course, but I only paid $5 for it. All the rest I paid $1 each for.

Einstein's Relativity and the Quantum Revolution: Modern Physics for Non-Scientists, 2nd Edition
4 DVD Set $254.95
http://snurl.com/3gv85-87021 [www_teach12_com]

Great Masters: Brahms—His Life and Music
8 Audio CDs 24.95
http://snurl.com/3guza-87021 [www_teach12_com]

Great Masters: Liszt—His Life and Music
8 Audio CDs 24.95
http://snurl.com/3gv0t-87021 [www_teach12_com]

Explaining Social Deviance
10 Lectures $39.95
http://snurl.com/3gvcw-87021 [www_teach12_com]

ATLAS SHRUGGED Abridged
http://snurl.com/3gvgl-87021 [www_amazon_com]

The Da Vinci Code Unabridged
http://snurl.com/3gvhc-87021 [www_amazon_com]

CHAOS Making a New Science
http://snurl.com/3gvhu-87021 [www_amazon_com]

Genetics For Dummies
http://snurl.com/3gvjb-87021 [www_amazon_com]

Monday, August 11, 2008

SC SQL Saturday Call for Speakers!

Event: SC SQL Saturday
Date: Saturday October 11, 2008

Location: ECPI
Greenville Campus
1001 Keys Drive #100
Greenville, SC 29615
http://www.ecpi.edu/campus/greenville_sc/index.cfm

SC SQL Saturday 2008 is looking for speakers!

Call for speakers is open! Please submit any SQL Server content you'd like to present. With SQL Server 2008 RTM we’d love to see some presentations on it, but we also do not want to leave out SQL 2005. Presentations focused on developers using SQL Server are also welcome.

Please submit you presentation at http://snurl.com/3gc2l-87021 .

Thank you,

The SQL Saturday #9 Team

Tuesday, July 01, 2008

SSIS Tools, Tips and Tricks

I posted my notes for the presentation I gave at the June 2008 SSIG meeting and Atlanta Code Camp 08 to www.ssig.org.

I also have them in a Word doc at http://cid-89384f23767a9a97.skydrive.live.com/browse.aspx/Public?uc=1

Friday, May 30, 2008

Microsoft Community Launch Greenville, SC

Here are links from my presentation on new features in SQL Server 2008 Business Intelligence.

Data Profiling

For this demo the following blog posts were combined.

  1. http://blogs.conchango.com/jamiethomson/archive/2008/03/02/ssis-data-profiling-task-part-1-introduction.aspx

  2. http://agilebi.com/cs/blogs/jwelch/archive/2008/03/11/using-the-data-profiling-task-to-profile-all-the-tables-in-a-database.aspx

From John Welch's post the tables are limited to the following from Jamie's post.

  • SSIS: Data Profiling Task: Part 2 - Column Length Distribution
    SSIS: Data Profiling Task: Part 8 - Candidate Key
    [HumanResources].[Department].[GroupName]
  • SSIS: Data Profiling Task: Part 3 - Column Null Ratio
    [Person].[Contact].[MiddleName]
  • SSIS: Data Profiling Task: Part 4 - Column Pattern
    [Production].[Product].[ProductNumber]
  • SSIS: Data Profiling Task: Part 5 - Column Statistics
    [Sales].[SalesOrderDetail].[UnitPriceDiscount]

Katmai: SSIS: Lookup component gets a makeover
http://blogs.conchango.com/jamiethomson/archive/2007/11/16/Katmai_3A00_-SSIS_3A00_-Lookup-component-gets-a-makeover.aspx

Star Schema Performance
http://technet.microsoft.com/en-us/magazine/cc434693.aspx

Reporting Services
Teo Lachev’s blog: http://prologika.com/CS/blogs/blog/archive/2007/08/29/under-the-hood.aspx

Enterprise Scale Reporting webcast: https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=6082

SQL 2008 BOL
http://msdn.microsoft.com/en-us/library/bb630410(SQL.100).aspx

Analysis Services

What's New (Analysis Services - Data Mining):
http://msdn2.microsoft.com/en-us/library/bb510513(SQL.100).aspx

Introducing the SQL Server 2005 Data Mining Add-ins for Office 2007
http://www.sqlserverdatamining.com/ssdm/Home/DataMiningAddinsLaunch/tabid/69/Default.aspx
Advanced Manageability for Analysis Services 2008 webcast: http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032352698&Culture=en-US

Advanced Manageability for Analysis Services 2008 webcast: http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032352698&Culture=en-US

Teo Lachev’s blog: http://prologika.com/CS/blogs/blog/archive/2007/08/29/under-the-hood.aspx

Enterprise Scale Reporting webcast: https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=6082

Reporting Services Tablix
http://prologika.com/CS/blogs/blog/archive/2007/08/12/tablix-the-crown-jewel.aspx

Wednesday, February 13, 2008

Design and build sites for Office SharePoint Server 2007

SharePoint Server 2007 is a big thing to get your arms around let alone your brain to fully understand it. Thankfully Microsoft understands this and is continuing to improve its documentation and guidance for implementing a variety of solutions with it.

The TechNet section for Office SharePoint Server 2007 is continually being updated with richer and richer content. Currently my favorite section is the Design and build sites for Office SharePoint Server 2007. With out understanding the concepts here and following the recommended approach to your desired solution mistakes are bond to happen. Even small mistakes in design early on can have costly consequences in the future