Android - how to move apps to SD storage from phone storage

I recently acquired my first Android phone, a Samsung Galaxy Ace. Due to my limited budget, it's an entry level phone, so it does not have a lot of built-in storage, so I soon started running out, and had to look for ways to move apps off the phone storage. Here's how: http://www.bongizmo.com/blog/moving-all-android-apps-to-sdcard-apps2sd-froyo/

Authorization Manager check failed - FIX - for real this time!

We finally managed to find a fix for the above PowerShell error that pops up from time to time: restart the Windows Management Instrumentation (WMI) service!

SQL in the Wild » Blog Archive » Are all updates split into delete-insert?

SQL in the Wild » Blog Archive » Are all updates split into delete-insert?

Interesting post that debunks the myth that ALL updates are split into delete-insert pair.

Changing your culture

I recently noticed that the same ASP.Net application behaves differently in terms of formatting between Windows Server 2003 and Windows Server 2008/Windows 7 for culture en-ZA.

Our application has functionality that exports a gridview to a CSV file, and this is where I picked up something is wrong, the digit separator showed as a  character, which is a unicode character which Excel does not handle well in CSV files.

On Windows Server 2003, the digit grouping symbol is a comma (,), whereas on Server 2008 and Windows 7 it is a unicode space. Apparently someone decided that change was necessary, I found a reference here: http://forums.asp.net/t/1424752.aspx/1

Closed a SQL query by accident? There is help

Have a look at this post: Oh ****! | Home Of The Scary DBA

And this one:

Recover Backed-up query files in SQL Server Management Studio

AuthorizationManager check failed - SOLUTION!

I found a solution to the above problem first mentioned here today by pure chance. Since PowerShell is part of SQL Server 2008 (I think!), I decided to restart SQL Server 2008 on my machine when the error surfaced yet again today, as I was not in the mood for a reboot (too many open files & sessions).

Guess what, the error disappeared! So there must be some tight integration between SQL Server and PowerShell for this to be the solution. 

Please see this post for a repeatable solution.

Giving IIS 7 AppPoolIdentity account access to SQL Server

IIS 7 has a nifty new feature whereby you can set the identity of the application pool to ApplicationPoolIdentity. It then creates a virtual user with the same name as the name of the application pool, i.e. if you named your application pool Bozo, it will create a virtual user called Bozo, to which you can assign rights.

To allow the virtual user access to SQL Server, do the following:

• In SQL Server Management Studio, open the Security folder, right-click the Logins folder, and click New Login...
• Enter IIS AppPool\{apppoolname}, replacing {apppoolname} with the name of your application pool - DO NOT USE THE SEARCH FUNCTIONALITY
• Assign the necessary database level privledges and click Ok

This has been tested on SQL Server 2005, I would imagine it works in SQL2008 too.

Source: http://efreedom.com/Question/1-1933134/Add-IIS-AppPool-Identities-SQL-Server-Logons