“NOT LIKE” in Qlikview

“NOT LIKE” in Qlikview

Tried using ‘Not Like’ or ‘<>’ in your Qlikview loaders. Don’t bother as it doesn’t work! Wild match is the only replacement for like in Qlikview and is actually more advantageous as it allows multiple wild ‘likes’ in the same statement as below.

   

UPSERT using MERGE

UPSERT using MERGE

Do you find UPSERT in MYSQL useful? Would you like to do this in SQL Server (MS-SQL)? Well, sorry it doesn’t exist per se… 🙁 However, what SQL Server does have is the MERGE command introduced in 2008. Normally when you want to INSERT a row to a table if it does not exist or UPDATE if it does, you would first check if the row exists using the standard SELECT-UPDATE-INSERT approach, but this is time consuming and takes two…

Read More Read More

Leopard Rebirth

Leopard Rebirth

Thanks to ‘SourceSunTom’ over at http://leopardrebirth.net/, PowerPC enthusiasts now have a package available that skins a Leopard (10.5) mac to appear running MacOS Sierra. There is a thread going on over at MacRumors discussing this and you can download the latest package (1.2) here or the LeopardRebirth homepage. System Requirents Mac OS X 10.5 Leopard PowerPC G4 or G5 Processor 512MB of RAM 100MB of Free Hard Drive space Downloads Leopard Rebirth 1.2 (46.5mb)

Managing Scheduled Reports

Managing Scheduled Reports

SQL Reporting Services has come a long way since 2000, but there are still plenty of ways it can be improved to benefit the end user the DBA.  Manually initiating a subscription is a tedious task in SQL Server Reporting Services. Each subscription in Reporting Services is setup as a SQL Server Agent job, but the job names are not intuitive, rather named as a Unique Identifier as shown below. In my current employment, the reporting server has over 400…

Read More Read More

SSIS Packages with Unspecified Error

SSIS Packages with Unspecified Error

Have you ever been haunted by a failing SSIS package with an ‘Unspecified Error’, leaving no information to trace? I have, and I suspect so has everyone who ever deals with SQL Server. The reason for this is fairly simple to understand, it would just be helpful is Microsoft made their errors easier to understand. SQL Server was consuming almost all the memory and taking higher priority over SSIS.  As a general rule of thumb, I tend to limit SQL Server…

Read More Read More

Apple Without Steve Jobs Again

Apple Without Steve Jobs Again

A very interesting piece from Low End Mac. Love him or hate him, Steve Jobs will always be Apple. A visionary? A marketing genius? A control freak? What will happen to Apple in the future without him? Whether you read the countless books or watch the numerous films on the early days of Apple, they all point to Steve Wozniak being the technical brains, while Steve Jobs having the vision, drive, and marketing prowess to push ideas and find people to…

Read More Read More

How to detach a table box

How to detach a table box

Detaching an object means that it becomes static and no longer responds to selection changes. So you are detaching from the selection state, not from other objects.If you need to ignore specific selections, you can use set analysis in your expression to “detach” the expression from those selections. A table box does not have a detach setting. The only way to ‘detach’ it is to use an alternate state. You could use a straight table box option with all the…

Read More Read More

CronniX

CronniX

CronniX is an Aqua front-end to the powerful Unix tool “cron”. Cron is a Unix system service that allows scheduled execution of scripts, programs, applications – in short anything that can be started from the command line. This includes OSX applications and AppleScripts. The Lirko.Online server used to run on OS X 10.11 (El Capitan) and for a while it was good, but over time I experienced more issues and performance hits. This coupled along with the buggy OS X…

Read More Read More

Leopard Assist

Leopard Assist

When Leopard (OS X 10.5) was released back in 2007 it requited at least a G4 867mhz processor which at that time left a lot of people out of the experience. However, we now know that although it will not install directly it can be ran on any Mac with G4 processor and AGP graphics. This is where LeopardAssist….er….assists! :p Perhaps LeopardAssist looks a little basic on the surface. A few clicks of the mouse is all LeopardAssist needs to…

Read More Read More

Determine Table Sizes

Determine Table Sizes

A useful query to determine the space used by all tables on your database.