Processing 6 billion records in 4 seconds on a home PC with crappy pentium processor.

Processing 6 billion records in 4 seconds on a home PC. Lately I see a lot of hype around Hadoop. However if you look close at the performance of Hadoop clusters it is not all that stellar. Actually it is more like a terrible waste of computing cycles. Let’s see if we can find a greener, […]

See your ASP.NET app's server interaction thanks to Glimpse

Glimpse lets you see what’s happening on the server for your ASP.NET application, all within the browser and with no changes to the application. What is going on? We’ve all been in this situation: The code looks right and the page is displaying correctly, but execution isn’t matching expectations. You dig into the code and […]

Importing SharePoint data from Access Data Projects looks much faster than using SSIS.

Just had to share.. I’m currently importing a list of about 4000 items from SharePoint into SQL Server. I’m experimeting with moving OFF of  ADP to do this.. but the performance side just kills me. I just swear that using Access to import from Sharepoint is about TWICE as fast as SSIS.  I’m currently using […]

nonclustered Covering index will usually provide the optimum performance of a query

Designers of database systems will often assume that the use of a clustered index is always the best approach. However the nonclustered Covering index will usually provide the optimum performance of a query. https://www.simple-talk.com/sql/learn-sql-server/using-covering-indexes-to-improve-query-performance/

Querying agent job status, executing and waiting for job completion from within T-SQL

In this article I would like to describe how easily you can query an Agent Job status from within T-SQL command and also how it is possible to execute an agent job and wait for it’s completion. It can happen, that you do not have access to the Job Activity Monitor and would like to […]

my favorite Windows API calls in VB

When a VBA solution falls short of your needs, there’s probably a Windows API function that can handle the job. Susan Harkins lists 10 handy APIs and explains how you can put them to work. Office developers rely heavily on VBA. But even though it’s versatile and robust, it doesn’t do everything. Sometimes, a VBA […]

great list of windows shortcut keys

great article I found regarding Windows Shortcut keys. This articles claims that this is specific to HP computers, I think that most of these are applicable to most Windows PCs. HP PCs – Using Keyboard Shortcuts and Special Keys This document pertains to HP products with a Microsoft Windows operating system. Enhance your efficiency in […]