Monthly archives: October, 2010

Kerberos Double Hop and Delegation between different Active Directory Accounts [SQL Server]

In the past, when I had bare knowledge of Active Directory, I dealt with double hop queries using SQL Server Authentication. What is the problem with SQL Authentication? Maintenance. The DBA team can literally spend hours maintaining usernames/passwords, linked servers, and of course giving appropriate grants/roles to a new user added to several database instances. …

SQL Server: Truncating Dates

TRUNC is a function I used a lot when I worked with Oracle and helped me slicing my data in several different ways, and keeping the columns in date format. That function is not available in SQL Server unless you work it around by using CONVERT or DATEPART. But both change the content to VARCHAR. …

Figuring out Android internals

My first task was to change the ringtone to music I used to have in my Windows phone. A simple search let me to a guide with this information: Music/ – Media scanner classifies all media found here as user music. Podcasts/ – Media scanner classifies all media found here as a podcast. Ringtones/ – …

From Palm to Windows Phone to Android

I have been a hardcore Windows Phone user (formerly Windows Mobile, and CE) for several years, mainly because it was very easy to  synchronize directly with Outlook and Microsoft Exchange. The GUI has been pretty nice since the first releases and resembled Windows in a way. Windows Phone let me transition from a Windows CE PDA (Toshiba E335) …