The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 4,225 other subscribers

Archive for January 14th, 2014

Reminder: find out which Windows 7 drivers work for ScanSnap S510 from Fujitsu

Posted by jpluimers on 2014/01/14

One of the few Windows XP machines left is main usage is for the Fujitsu ScanSnap S510 scanner that I have been using for years: it is small, does duplex scanning, emits searchable PDFs through an embedded Adobe Acrobat and Abby ScanSnap Edition OCR license. The Scan button on the scanner “just works” and allows for a “Scan Now, organize later” workflow.

Just Works: if a user is logged in on the Windows machine, which usually is the case.

Next to that, it is used for internet browsing and remote desktop access to VMs in the various clouds: it is more than adequate for that with dual Dell UltraSharp U2407WFP monitors at 1920×1200. The extra 120 pixels over “modern” 1080p do make a difference you know.

I never bothered to upgrade the machine, as it works so nicely and I have had bad experience replacing systems that include embedded licenses: it usually doesn’t work.

Of course I could buy a new ScanSnap iX500, but I don’t want to increase the electronic waste unless I’ve researched if it is possible to get the ScanSnap S510 working on Windows 7 or 8.x, or even on one of my Macs.

So here are some links for further research on a light-weight solution: Read the rest of this entry »

Posted in Apple, Fujitsu ScanSnap, Hardware, ix500, Mac, Mac OS X / OS X / MacOS, MacBook, MacBook Retina, MacBook-Air, MacBook-Pro, OS X 10.8 Mountain Lion, OS X 10.9 Mavericks, Power User, Scanners, Windows, Windows 7, Windows 8 | 1 Comment »

SQL Server: strange way of getting query statistics.

Posted by jpluimers on 2014/01/14

Last year, I had a very odd project at a client.

Their monitoring software was quite odd, and there was no time to create/test/implement a module for it doing SQL query performance measurement any better.

The odd software had two ways of looking at queries:

  • in a succeed/fail fashion
  • in a count(*) fashion

Don’t ask why it was that way, the monitor was hysterically grown.

So below is a small query script that does what the odd monitoring software can do: provide a select with rows indicating the query response time.

What is does is insert into the #sma temporary table a number of records depending on the query duration.
The partition here is 1 record per 125 milliseconds, aiming for four partitions (green, yellow, orange, red) in half a second.

Note the maximum accuracy is about 3.3 milliseconds.

The script is based on these SQL server features:

I might add a try/catch to fake a finally in case the #sma insert fails. Read the rest of this entry »

Posted in Database Development, Development, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 | Leave a Comment »

%d bloggers like this: