This month we have Data warehousing with SQL Server Analysis Services from Terry McCann.
In this 2 hour session (with a pizza break in the middle – [Jonathan]) we will look at a primer to data warehouses and then follow this up a look at the 2 flavours of SSAS. Firstly we will tackle SSAS multidimensional looking at what it is and how it works, then we will look at SSAS tabular and talk about how tabular works.
You might be thinking why on earth is there 2 versions of SSAS!?! We will talk about that too and briefly touch on the languages that each model uses. At the end of this session, you might not be an SSAS maestro, but you will know the details of each product and I will demo building an SSAS cube in each product. This session is not just for you BI guys, this session is for DBAs too – You need to know what these developers are building in your estate.
I asked a question on Twitter recently and got a helpful response and two requests to share the solution. So, here is the solution!
My particular problem didnt get resolved, I think there are issues concerning the way my other blog is hosted/managed but that isnt the point. I tried connecting Open Live Writer (OLW) to my user group blog and had no issues at all so here is the step by step on how to get it done. If you havent heard of OLW then take a look at their website and on Scott Hanselman’s blog for a potted history of this great app.
Things you will need:
- Your WordPress blog login name.
- Your WordPress blog login password.
- Your blog url.
I keep the first two of these in a password manager so that was easy and the URL was pretty simple to locate too.
If you havent already installed OLW then you wont have it linked to a blog, this means that on startup the app will present you with a dialog to get connected. If you have OLW already installed then you can start the same dialog by going to the Blog Accounts button on the Home ribbon and clicking the downward facing arrow head
from here you can select ‘Add blog account’ (or ‘Manage blog accounts’ and then click the Add button on the dialog there) and this will place you right in the same place.
You need to select a blog provider from the list.
I havent tried other providers so cant vouch for the process there but with WordPress the next screen requests the information we gathered together earlier on.
Fill in the details as requested.
Click Next and magic should start to happen. (* this is precisely where the magic doesnt happen for me with the issue that prompted my question)
After a moment or two, depending on your internet connection speed you will get a final dialog that asks you for the friendly name for your blog account.
Click Finish and you are all set to start using OLW as your blogging tool.