DH Unlimited
Portfolio Blog Login
X

About
DH Unlimited is comprised solely of me, Dave. I've been doing freelance web development since 2010, mainly for the purpose of expanding my technical skill set.


Site Updated
01/06/2016

Empty The Sybase Transaction Log

Monday, April 22, 2013 2:25 pm

dump tran


your_database_name


with truncate_only



Tag(s): Sybase 

Furlough

Tuesday, April 16, 2013 4:11 pm

I would rather plan my vacation than being forced to take one because a contract is not in place. But such is life. I shall enjoy the sunshine and smile.



Tag(s): Work 

iTunes Problem

Sunday, April 7, 2013 6:27 pm

One issue I’ve had is downloading a purchase made on another device and then playing on my iPod. For some reason something is not quite right and iTunes “thinks” I’m not eligible to listen to whatever it is I bought.


My Solution:


Delete all traces of the file on both my iPod and my computer. Sign Out of iTunes. Change my password. Sign back in iTunes. Download the file again.



Tag(s): Apple  Music 

High Flight

Friday, March 22, 2013 12:38 pm

By Pilot Officer John Gillespie Magee 


 Oh! I have slipped the surly bonds of Earth
 And danced the skies on laughter-silvered wings;
 Sunward I’ve climbed, and joined the tumbling mirth
 of sun-split clouds, — and done a hundred things
 You have not dreamed of — wheeled and soared and swung
 High in the sunlit silence. Hov’ring there,
 I’ve chased the shouting wind along, and flung
 My eager craft through footless halls of air….

 Up, up the long, delirious, burning blue
 I’ve topped the wind-swept heights with easy grace.
 Where never lark, or even eagle flew —
 And, while with silent, lifting mind I’ve trod
 The high untrespassed sanctity of space,
 - Put out my hand, and touched the face of God.



Tag(s): Poetry 

SQL Server and Sybase Versions

Thursday, March 21, 2013 11:08 am

It’s fairly easy to find out which version of SQL Server / Sybase you’re using.  Both Microsoft SQL Server and Sybase implement T-SQL so the command below will work for either RDBMS. Just open a query window and type in:  


SELECT @@VERSION

 But if you don’t have access to query a database that resides on a SQL Server instance you can always go to the registry and find out by going to the following key:   


HKEY_LOCAL_MACHINE


  —> SOFTWARE


    —> Microsoft


      —> Microsoft SQL Server


        —> “Your SQL Server Instance”


          —> Setup



Tag(s): Sybase  SQL Server 
Back to the Top