Creating Date and Time dimensions for your data warehouse

Good morning fellow coders!

I won't write long, but I figured that it was worth mentioning that I found quite a nice article that will help you easily and quickly create Data and Time dimensions for your SQL data warehouse (or any other warehouse for that matter, but you would obviously have to modify the scripts slightly).

Enjoy the following link to its fullest:

http://www.sqlservercentral.com/articles/Data+Warehouse/106149/

Happy warehousing!

SQL Server 2008 R2 "Out of Memory" exception

Dear Readers

I have been away from this blog for much too long, but I'm back and getting back into posting about some of my favorite technologies. I ran into an interesting problem today. It's definitely common, but it was the first time for me. I was running a stored procedure on SQL Server 2008 R2 and got an "Out of Memory" exception.

I googled around and came across a fix which is quite easy. Well, let me not call it a fix since obviously it might not work for everyone; however it is currently working for me (running as I'm typing) so I thought I'd share.

Apparently, what happens is that you receive a .NET Exception. This happens when the result set that your query returns (in my case, I am using a "SELECT" statement to extract values into a cursor) is very large and you exceed the limits of a 32-bit virtual address space (2GB). The workaround is to run the stored procedure using the "sqlcmd" utility (as obviously CLI tools require way less resources).

Simply type 'sqlcmd' -S <servername> into your command prompt and press enter. Then type 'Use <database>' name to change to the relevant database. Press Enter' Type 'exec dbo.<sp_name>' to execute the stored procedure. Quite simple. Please let me know if this doesn't work for you. It would be interesting to try to solve more complicated problems.

Happy coding!

Hermann

Microsoft Surface RT

Hi guys,

This is my review of the new Microsoft Surface RT. I got my tablet one day ago so in the future I might post a more informed review.

Let's discuss the hardware first. The tablet has a very solid construction. It is pretty obvious that quite a lot of thought and money have gone into this design, which is something that is not very surprising giving Microsoft's need to get into the mobile market. The tablet offers all the functionality that people have come to expect from tablets, except for a GPS. Microsoft stated (regarding the lack of 3G support for the tablet) that consumer research showed that tablets the size if the Surface don't leave areas where Wi-Fi is available very often. It seems fair to assume that this might be at least a partial reason not to include a GPS either.

In addition the surface has a USB port, Micros SD card slot, and an HDMI video out slot. Clearly Microsoft is trying to penetrate the business world with its first offering. The tablet is a little more professional-looking in my opinion and thus not as sexy as an iPad. However, once again I think this simply demonstrates where Microsoft if focusing some of its efforts as well.

The software has impressed me although I will admit that the Windows store is not yet up to par with either Google Play or the Apple Store. As far as the OS goes, Microsoft has done very well as far as I can tell and there is a lot of potential there. I would suggest to wait a little bit if you want to buy a Surface, since the price might drop a little bit and the Windows Store is just going to get bigger. I will mention that it was nice when I received an email last night with a PowerPoint attachment, which I could open directly on the tablet without even skipping a beat.

Right now the Surface is a very solid offering, but if you wait a little bit, it will only get better. Like I said, there are still some things that Microsoft can (and I think will) improve. In addition, as I run into more of the tablet's particulars, I will keep mentioning them.

For those of you who already bought one, enjoy.

Hermann

Update:

I have been very impressed by the content that is available in the media store for the Xbox. I am not sure how it stacks up against the offering from Amazon, but it definitely beats Google's heftily.

Android connection problems to Google servers

Hi guys,

One of my friends ran across an issue with her new Samsung Galaxy S and I wanted to jot it down, since it seems like she is not the only person to have come across this issue. The fix in her case was quite simple.

A quick description of the issue:

When you try to sync your Google account with your phone, after inputting your username and password, the following message appears:

Your phone has to connect with Google servers to set up your account. This may take up to five minutes.

The after a while it shows the following message:

Can't establish a reliable data connection to the server.

And the fix in this case:

Go to Menu -> Settings -> Accounts & Sync -> Background Settings (Tick this)

And then Settings -> Accounts & Sync -> Add Account -> Google -> (create your account or log in)

Hope this helps some of you.

Enjoy your Android devices :)

Hermann

Report Viewer webpart location

Hi guys,

This is just a short post that I am actually posting for myself in order to remember the location of the installed Sharepoint RS webparts. I hope someone else can find this useful as well since I had quite a hard time finding an answer to this (maybe I didn't use the right search strings on Google :) )

The default location for these are:

C:\Program Files\Microsoft SQL Server\100\Tools\Reporting Services\SharePoint\RSWebParts.cab


Thanks,


Hermann

MySQL reconfigure root password

Hi guys,

I ran into an interesting situation today and thought that I'd just mention a real quick painless solution. To make a long story short I did a MySQL dump on my windows machine in order to restore the DB on my Linux box. In the process, you also have to copy the mysql database since the grant tables are stored in that database. Somewhere along in the process though I messed something up and lost my root user account. I then got an access denied for any attempt to log in as root and I couldn't change the password for root either since the user didn't even exist in the mysql.user table.

One would be able to manually insert a user into the table; however I don't recommend that approach. It is just not a clean way of dealing with your most important account as far as MySQL goes.

I am not exactly sure what the problem was yet, but a quick painless solution is to reconfigure the MySQL server:

sudo dpkg-reconfigure mysql-server-5.1

Replace the version number with your version, which you could check by running mysql --version.

Hope this helps someone out!

Happy coding :)

Hermann

SharePoint remote management through Windows Powershell

Hi guys,

Just a quick note on managing SharePoint remotely through the use of Windows Powershell. I just wanted to blog this for my own use, but thought that someone else might find it handy. The following blog is a very nice description of how to setup and use remote management through Windows Powershell.

http://blogs.msdn.com/b/opal/archive/2010/03/07/sharepoint-2010-with-windows-powershell-remoting-step-by-step.aspx

Thanks,

Hermann