ArnoldC

Here comes a new something, like a programming language but really funny: ArnoldC!

LOL

Here's my sample. Calculate BMI is boring but Arnie turns anything cheerful! :) You can try it here.

IT'S SHOWTIME
  TALK TO THE HAND "Arnold's BMI Calculator"
  
  HEY CHRISTMAS TREE weight
  YOU SET US UP 80
  
  HEY CHRISTMAS TREE height
  YOU SET US UP 175
  
  TALK TO THE HAND "Your weight is (kg):"
  TALK TO THE HAND weight
  TALK TO THE HAND "Your height is (cm):"
  TALK TO THE HAND height
  
  HEY CHRISTMAS TREE tons
  YOU SET US UP 0
  
  GET TO THE CHOPPER tons
   HERE IS MY INVITATION weight
    YOU'RE FIRED 10000
  ENOUGH TALK
  
  HEY CHRISTMAS TREE squareheight
  YOU SET US UP 0
  
  GET TO THE CHOPPER squareheight
   HERE IS MY INVITATION height
   YOU'RE FIRED height
  ENOUGH TALK
  
  HEY CHRISTMAS TREE calc
  YOU SET US UP 0

  GET TO THE CHOPPER calc
   HERE IS MY INVITATION tons
   HE HAD TO SPLIT squareheight
  ENOUGH TALK
  
  TALK TO THE HAND "Your BMI is about:"
  TALK TO THE HAND calc
YOU HAVE BEEN TERMINATED

SQL Saturday BUDAPEST

Úgy néz ki, hogy a promócióval már elkéstem...

We've reached the waitlist limit of #SQLSatBudapest! We still encourage you to register, just to have a chance to attend if someone cancels!
— Zoltán Horváth (@zoltanhorvath) February 4, 2014

... de emlékeztetőül azért leírom,

SQL Saturday Budapesten, a Lurdy Házban, 2014. március 1-én!

Link:

SQL Saturday Budapest

First steps in the Not Only SQL world

The first Cassandra db was be installed on my PC. The OpsCenter was launched and the first (test) node was created. But OpsCenter didn't work bacause agents failed to ssh to the node.

I got three suggested change in different settings to fix this. I did all of them and the issue was be fixed. My Cassandra runs on Windows 7(x64).

Add this line(s) (or update them) to the file below:

1. addres.yaml
  use_ssl: 0
2. local.conf
  conf_location = C:\Program Files\DataStax Community\apache-cassandra\conf\cassandra.yaml (check the path!)
3. opscenterd.conf
  [agents]
   ssh_port = 2222

All the files can be found under the folder 'Program Files\DataStax Community'.

Launch PS from Windows Explorer

It's just peanuts but very useful.

• If you type powershell in the addressbar of Windows Explorer (ALT + D), you will get a PS console with prompt of current directory.
• If you type it ii . (Invoke-Item .) in a PS console, it will navigate you in the Windows Explorer to the current directory.

I stole these tricks from a stackoverflow topic.

PowerShell és SQL Server prezentáció

Tegnap megtartottam életem első prezentációját a PowerShell és az SQL kapcsolatáról. És túléltem :) A helyszínt a LogMeIn biztosította, a rendezvényt pedig az SQLPASS local chapter HUG-MSSQL (Horvát Zoli) szervezte. Így az első előadásom egyben az első SQLPASS előadásom is!

PS and SQL

Az előadás diáit innen tudjátok letölteni.

Egy remek passz

A HUG-MSSQL a PASS tagja lett!

Egy éve írtam egy posztot anno a Horváth Zoli által szervezett SQL meetupokról, hát mit mondjak, szépen kinőtte magát a csoport. Hurrá és grat! :)

Az első PASS-os előadás május 29-én lesz, el ne felejtsétek! :)

Msg 11305

Execute a query on SQL Server 2008 such as this:

1. SELECT COUNT (ItemID) OVER (ORDER BY OrderID) FROM OrderDetails;

You get the following error message:

Msg 11305, Level 15, State 10, Line 1
The Parallel Data Warehouse (PDW) features are not enabled.

Really? Thank you for telling me but what can I do now?

OK, the reason of failure is simple. ORDER BY in OVER clause on an aggregate function works only in version 2012. But this message doesn't help much in debugging.