The Guru's Blog Author: Created: 12/13/2012 6:12 PM Jerry's thoughts, tips and ideas. PC Legacy Data: Recovering data from a STAC Stacker Volume By Jerry on 8/26/2014 7:55 PM In the 90's disk compression software was all the rage, starting with Stacker and then with DoubleSpace from Microsoft. The idea was to create a compressed file of an entire disk, and then load the compressed disk and present it as a normal uncompressed disk. For a long list of reasons no one does this anymore. However, what if you have an old disk, floppy, Zip Cartridge etc that has a Stacker volume on it. How do you get your old data? it's as easy as 1, 2, 7.... PermaLink Read More » Comments (29) Delphi/RAD Studio XE 5 OAuth1 Authentication issue with Twitter and Tumblr (Solution) By Jerry on 10/6/2013 5:11 PM Embarcadero's new RAD Studio XE5 introduces unified, single source cross platform Development for Win32, Win64, Mac OS X, iOS and Android. This is currently the best way to write cross platform applications over all these platforms. Certainly Mono, can work to hit most of them; but deployment of such apps along with their performance is extremely complicated. RAD Studio provides native level code on all of these platforms. At some point, I hope to post more on this in detail. In addition, they've implemented a new REST Client API supporting the REST Protocol and Open Authentication 1.0/1.1 and Open Authentication 2.0 this allows easy connection to most of the modern web API's. Unfortunately there is a bug in the OAuth1 client that causes OAuth1 authentication to fail in the western hemisphere for Twitter, Tumblr and other 1.1 API's I've tried. PermaLink Read More » Comments (69) The Secret to Extra Rapid Application Development By Jerry on 5/21/2013 9:17 PM Increase developer efficiency, shorten project times and create more stable applications by using third party controls. PermaLink Read More » Comments (5) Excel Functions inside SQL Server Stored Procedures By Jerry on 1/20/2013 4:44 PM SQL Server is a great product that many clients begin using when they want to automate a lot of work previously done in Excel and Access. People are amazed at the ease and speed at which SQL handles incredible volumes of data that would bring Excel to its knees. Unfortunately, there are a lot of Excel functions for which there are no equivalent functions in Transact-SQL, and which are very hard to write in t-SQL. The answer, of course, is write them in SQL CLR, a .Net assembly callable from SQL Server as an extended stored procedure. But who has time to write Accrual and BondInt functions, or string functions? The people at WestClinTech do. PermaLink Read More » Comments (11) MSMQ: The Indispensable Windows Subsystem Most Developers Have Never Heard Of By Jerry on 1/14/2013 10:44 PM MSMQ, Microsoft Message Queuing has been around since the days of NT 4.0 and Windows 95, way back to 1997. Initially it was an add on product to windows, but starting with Windows 2000 it was included in the server versions of Windows and with Windows XP it was included in the desktop operating system. It’s a Windows Feature that you can install/enable via the Windows Components part of Add/Remove Programs (or Add Features in W2K8). Yet surprisingly few application developers know about it or how to use it to improve application performance. Tonight we start with an introduction, later posts will talk about improving desktop application performance (everyone who blogs about MSMQ talks about server uses of MSMQ) PermaLink Read More » Comments (15) Top Ten: SQL Server Optimizations Everyone Should Do. By Jerry on 1/11/2013 5:30 PM While the "art" of being a DBA is something that's often very application specific there are some universal optimizations that can be done to almost any SQL Server. While tailored to MS SQL Server, these optimizations are generally valid for most RDBMS. PermaLink Read More » Comments (47) ARECA RAID Rescue By Jerry on 12/13/2012 7:20 PM The Areca RAID controllers are great SATA RAID controllers that I have great success with. Unfortunately, recovering a damaged array can be a bit, shall we say, unorthodox. PermaLink Read More » Comments (53) Write to the Eventlog in Delphi By Jerry on 12/13/2012 7:17 PM Simple routine to write to the event log in any version of Delphi (need to see about working on my code formatting in the blog though) PermaLink Read More » Comments (16) Increase the Number of Simultaneous Downloads in Internet Explorer By Jerry on 12/13/2012 7:12 PM How to increase the maximum number of simultaneous downloads from a given site in Internet Explorer PermaLink Read More » Comments (4) Enable Office Scripting on TS/RDS By Jerry on 12/13/2012 7:10 PM How to enable MS Office scripting in a Terminal Server/Remote Desktop Services environment. PermaLink Read More » Comments (2)
Tags Delphi (3)CLR (2)WestClinTech (2).Net (1)7-Zip (1)ARECA (1)Authentication (1)DevExpress (1)Eventlog (1)Excel (1)Hard Disk (1)IE (1)Iomega (1)legacy data (1)MS Office (1)MSMQ (1)OAuth1 (1)Open Authentication (1)RAD Studio XE 5 (1)RAID (1)RDS (1)RESTClient (1)SQL (1)STAC (1)STAC Electronics (1)Stacker (1)StacVol.dsk (1)Telerik (1)Terminal Services (1)Time Zone (1)Tumblr (1)Twitter (1)Visual Studio (1)Zip Drive (1)