Browsed by
Category: Uncategorized

What I like about PowerShell

What I like about PowerShell

Comments 0 Comment

Introduction First of all, I do not consider myself a professional let alone an expert on PowerShell. However, I think the learning curve of PowerShell is very appealing especially if you have got some background in programming. The first programming language I learned was Java…way back in 2005 at University. Well, frankly speaking my first programming language was Basic on a Commodore C128 computer…but that time as a teen I didn’t really get a deep understanding and ended up retyping…

Read More Read More

Creating a report with a custom shapefile in Cubeware Cockpit

Creating a report with a custom shapefile in Cubeware Cockpit

Comments 0 Comment

Earlier I described how to create the custom shapefile. Now I show you how to create some sample data for the report. Now let’s create a report based on that shapefile. You can grab my shapefile here if you didn’t create your own. First of all we need some sample data. Take the following script to create a database with the relevant data. The script should be compatible with at least SQL Server 2008 (nothing special there). If you are…

Read More Read More

Dirty DBA Tricks: Convince SQL Server Cluster < 2012 to use local SSD for tempdb

Dirty DBA Tricks: Convince SQL Server Cluster < 2012 to use local SSD for tempdb

Comments 0 Comment

As the title suggests this blog post is about a neat trick, which a decent DBA typically wouldn’t consider if he/she had other options. It worked for me and it was a well thought option to go for. I am not very proud of this trick (therefore “dirty”) however it saved my day and perhaps it’s a valid option for you to go as well. Remember that you use SQL server in a non-supported way doing this and don’t blame…

Read More Read More

A new SQL and BI blog!

A new SQL and BI blog!

Comments 0 Comment

Here I am…finally starting my own blog. I have been thinking about blogging for quite some time now and it is good to start it now. I am a german database and BI professional. However this blog will be in English for the following reasons: 1. I hope to attract a bigger audience by writing in English. 2. It’s a good practice for me to improve my writing skills.  For english natives: Please be kind if my English might sound…

Read More Read More