a: from command prompt run:

rundll32.exe keymgr.dll, KRShowKeyMgr

date input format YYYYMMDDHHMMSSNN

date ouput format YYYY-MM-DD HH:MM:SS

update tablename
set editDate = substring(editdate,1,4) + '-' + substring(editdate,5,2) + '-' + substring(editdate,7,2) + ' ' + substring(editdate,9,2) + ':' + substring(editdate,11,2) + ':' + substring(editdate,13,2)


The emulator is on the iPad and was provided with a 2005 remake of the bards tale. Other than the title the games are not related.

You roam the city Skara Brea fighting evil creates. If you are lucky enough you will find a Cellar that leads you to the Sewers.

In the sewer you will learn to fight and advance your characters until they are ready to face the catacombs.

Ready for Adventure? Love classic games? Go get the game at the app store or click here: click here

I decided to provide this just in case someone else was looking for similar code.


Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim mym As New MainMenu
Dim myi As MenuItem = mym.MenuItems.Add("File")
myi.MenuItems.Add("Item1")
myi.MenuItems.Add("Item2")
Dim myi3 As MenuItem = myi.MenuItems.Add("Item3", New System.EventHandler(AddressOf menuClick))
Me.Menu = mym
End Sub
Sub menuClick(ByVal sender As Object, ByVal e As EventArgs)
'you can use a case statement here to decide how to handle the menu item.
'in my case I will use an INI file to pull in more data based on the menu item.
MsgBox(sender.text)

Free online courses can be found at

Silversword is by far the best iPad game I have played so far. Most games on the iPad
Are written for mobile devices with simplicity in mind with little thought to content. This game has a classic feel with a great modern interface. I hope to see more games of this style produced by the author.

This game was done in the style of bards tale i-iii but has its own unique feel. The game like any good rpg has a main plot and many smaller sub quests that are optional.

This game, unlike many iPad games, does not pressure you to purchase anything. You can purchase gold and a extra guide but this is not required to complete the game or have fun…

Enabling Network Level Authentication on Windows XP Service Pack 3 for access to Server 2008 via Remote Desktop
Solution When connecting to a Windows 2008 Server using remote desktop from a Windows XP client running service pack 2 or earlier, you get the following error message:

The remote computer requires Network Level Authentication, which your computer does not support.

To enable NLA in XP machines; first install XP SP3, then edit the registry settings on the XP client machine to allow NLA

• Configure Network Level Authentication

1. Click Start, click Run, type regedit, and then press ENTER.
2. In the navigation pane, locate and then click the following registry subkey: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa
3. In the details pane, right-click Security Packages, and then click Modify.
4. In the Value data box, type tspkg. Leave any data that is specific to other SSPs, and then click OK.
5. In the navigation pane, locate and then click the following registry subkey: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders
6. In the details pane, right-click SecurityProviders, and then click Modify.
7. In the Value data box, type credssp.dll. Leave any data that is specific to other SSPs, and then click OK.
8. Exit Registry Editor.
9. Restart the computer.

some things about winter have a bit of magic to them. Ice Shoves are one of those things.

As a kid they where a place to test your balance, strength and persistence to climb to the top. They also made magical noise as the water moves the chunks of ice.

Apparently unknown to my childhood adventures they also did much damage to property.

Here are some photos I found on the web.

http://www.uwgb.edu/dutchs/GeologyWisconsin/weather/ICESHOVE.HTM

If I make it back to the lake I grew up on I plan to take some photos if the timing is good.

my database has one record in one table that has account number of ’123′

This code return two records, 1,0 in my case

declare @Account varchar(20);
set @Account = '123'

select count(*) as mycount From tableone where accountNumber = @Account 
union  
select count(*) as mycount From tabletwo  where Accountnumber = @Account

The secret is to select from the union and using the union as the “FROM” part of your query.

This is the T-SQL to get it done with SQL-2005
In this instance I get one row with the sum or total of the two count requests. That value is 1.

declare @Account varchar(20);
set @Account = '123'

select sum(mycount) from 
(
select count(*) as mycount From tableone where accountNumber = @Account 
union  
select count(*) as mycount From tabletwo  where Accountnumber = @Account
) as myUnion

VB.NET Code:

Dim sql As String 

sql = "select sum(mycount) from ( select count(*) as mycount From table1 where accountNumber = @Account union select count(*) as mycount From tabletwo  where Accountnumber = @Account) as myUnion"

            Dim recCount As Integer = 0 
            sqlcn.Open()
            sqlCmd.Connection = sqlcn
            sqlCmd.CommandText = sql
            sqlCmd.Parameters.AddWithValue("@Account", myAccount)
            sqlReader = sqlCmd.ExecuteReader()

            sqlReader.Read()
            recCount = sqlReader.GetValue(0)

...