Browsed by
Category: Uncategorized

Creating a report with a custom shapefile in Cubeware Cockpit

Creating a report with a custom shapefile in Cubeware Cockpit

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

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!

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