Monthly Archives: September 2012

Web Sites with Embedded Command Lines: You got your Command Line in my Internet – Scott Hanselman

http://www.hanselman.com/blog/WebSitesWithEmbeddedCommandLinesYouGotYourCommandLineInMyInternet.aspx

Posted in SQL Server | Tagged | Comments Off on Web Sites with Embedded Command Lines: You got your Command Line in my Internet – Scott Hanselman

sharepoint people – is it ok to create indexes in SharePoint catalog?

I don’t understand why Microsoft ships products that aren’t indexed properly. Using this query, it is easy to see that this simple SharePoint server – that is SLOW AS MOLASSES ON NICE HARDWARE by the way – select * From … Continue reading

Posted in SQL Server | Tagged | Comments Off on sharepoint people – is it ok to create indexes in SharePoint catalog?

Why do people hate SUBQUERIES?

I don’t get it.. I’ve got a couple of co-workers that are just TERRIFIED whenever they see a subquery.  WHY? I’ve always loved subqueries- I think that it makes more sense to have a single distinct SQL Statement that we … Continue reading

Posted in SQL Server | Tagged | Comments Off on Why do people hate SUBQUERIES?

SQLDOM for parsing HTML

  This is the coolest thing I’ve found in SQL Server in the past 10 years. SQLDOM project SQLDOM is an easy and robust way to parse HTML directly into SQL tables, manipulate DOM nodes in a JQuery-like manner, and to … Continue reading

Posted in SQL Server | Tagged | Comments Off on SQLDOM for parsing HTML

Sane people avoid Oracle.

I’ve always hated Oracle products. They just SUCK from a usability perspective – no, I do NOT want to run everything inside of a webpage!?!?! I do NOT want Java errors when I launch my DB Development studio!!!! Well– it … Continue reading

Posted in SQL Server | Tagged | Comments Off on Sane people avoid Oracle.

Job – SQL Server BI / Data Warehouse Developer – Hedge Fund – London

http://careers.hereisthecity.com/job/sql-server-bi–data-warehouse-developer—hedge-fund—london-373041/

Posted in SQL Server | Tagged | Comments Off on Job – SQL Server BI / Data Warehouse Developer – Hedge Fund – London