Month: October 2010

Miscellaneous
Rant

Most Developers Have No Business In The Database World

I have been around superb developers that understand the concept of approaching efficient code that needs to be ran on the database, and will seek help from database developers/DBAs to ensure that is the case. Unfortunately, most do not really understand the need and approach a solution to certain requirement with one thing in mind: […]

Read More
Database
SQL Server

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. […]

Read More
Database
SQL Server

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. […]

Read More
SmartPhones
Technology

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/ – […]

Read More
SmartPhones
Technology

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) […]

Read More