Monthly Archives: December 2011

bad programmers

this idiot is claiming I’m a bad programmer.. just because I don’t do pointers, and I couldn’t care less about the difference between objects and classes. http://badprogrammer.infogami.com/ Occam’s razor It is possible to describe the other planets in the solar … Continue reading

Posted in SQL Server, Visual Basic | Tagged | Comments Off on bad programmers

table valued parameters

I’ve been dying to give this a try.. my new job I will definitely be doing this. ——————————————————————————– Processing of delimited strings. This is awesome and I could have used this feature…well, always. Currently, we pass in delimited strings in … Continue reading

Posted in SQL Server | Tagged | Comments Off on table valued parameters

great new functions in SQL 2012

As we all know, Microsoft officially released SQL Server 2012 RC0. You can register and download the binaries from http://www.microsoft.com/sql. As with every new release, Microsoft added more features and enhancements, improvements not only to the SQL Server database engine … Continue reading

Posted in SQL Server | Tagged | Comments Off on great new functions in SQL 2012

How to Ace a Google Interview – WSJ.com

I think that riddles and puzzles in interview are dumb. http://online.wsj.com/article/SB10001424052970204552304577112522982505222.html?mod=googlenews_wsj

Posted in SQL Server | Tagged | Comments Off on How to Ace a Google Interview – WSJ.com

SQL Server – A Case for Include Indexs « Life is Sometimes a Crap Storm

http://crapstorm.net/2011/12/21/sql-server-a-case-for-include-indexs/

Posted in SQL Server | Tagged | Comments Off on SQL Server – A Case for Include Indexs « Life is Sometimes a Crap Storm

WEBlog — Wouter's Eclectic Blog

I think that mysql is ok… But I really prefer ms sql http://grep.be/blog/en/computer/cluebat/mysql_toy_argument

Posted in SQL Server | Tagged | Comments Off on WEBlog — Wouter's Eclectic Blog

Firefox's codebase is now so big it fails to build on 32-bit OSes, Mozilla backing out new features as a short-term fix. : programming

Jeez FireFox cannot compile on 32 bit OS. Scope creep is real peoples! http://www.reddit.com/r/programming/comments/ncij5

Posted in SQL Server | Tagged | Comments Off on Firefox's codebase is now so big it fails to build on 32-bit OSes, Mozilla backing out new features as a short-term fix. : programming

C# _CAN_ be used in SSIS 2008

Everywhere I go, people use C# for everything.. drives me crazy. VB.net is the ONLY language that is fully supported throughout all aspects of SQL Server.. but I guess that C# is now allowed in SSIS! http://www.simple-talk.com/sql/ssis/sql-server-2008-ssis-cribsheet/ In SSIS 2005, you … Continue reading

Posted in SQL Server, Visual Basic | Tagged | Comments Off on C# _CAN_ be used in SSIS 2008

Excel Javascript – why can't Microsoft treat Access Web JUST LIKE Excel?

I think that MS Access is more important to more poeple..  than Microsoft Excel. Why is it that Microsoft is coming out with all this great functionality for Excel Web Access.. but they never mention anything about Access Web Access? … Continue reading

Posted in SQL Server | Tagged | Comments Off on Excel Javascript – why can't Microsoft treat Access Web JUST LIKE Excel?

Access Data Projects – how to test all views

I think that I’ve written this code probably 20 times over the years. Basically, a lot of people used stored procedures for everything.. and I think that it’s more appropriate to use VIEWS for everything, and stored procedures for just … Continue reading

Posted in SQL Server | Tagged | Comments Off on Access Data Projects – how to test all views