SSIS Expression for YYYYMMDD (ISO date)

Somthing small but really useful
This creates from a DATETIMESTAMP a STRING with following structure YYYYMMDD

(DT_WSTR,4)YEAR(GETDATE()) + RIGHT(“0” + (DT_WSTR,2)MONTH(GETDATE()),2) + RIGHT(“0” + (DT_WSTR,2)DAY(GETDATE()),2)

SSAS Cube in the Cloud

These days we hear so much about putting all our services in the cloud
For my main job i’m working on an reporting application, that is web-based but our analysis reports are with Excel with an SSAS Cube

So we were thinking to offer our product as a service to clients instead as an…

SSIS Annotation New Line

Ever had the problem you want to add annotation to your SSIS package and you hit your ENTER and you don’t get a new line?

Try: CTRL + ENTER

LEFT or LEFT OUTER JOIN?

When we are new in SQL, there is gonna be a time that we are wondering if its a:

LEFT or LEFT OUTER JOIN

RIGHT or RIGHT OUTER JOIN

FULL or FULL OUTER JOIN

WordPress change table prefix

For a friend I had to move a Wordpress Install to a new location, and I had to change the table prefix.

And I thought I just had to change the config file but nope, there was so much more that I didnt know.
Found this website and it really helped me…

Query all databases on server

[code lang=”sql”]
DECLARE @DbName VARCHAR(100)
 — Sql Query that you want to execute
DECLARE @Sql VARCHAR(MAX) = ‘SELECT * FROM t_alm_lot’