20 posts

Introduction to Spatial data types in SQL Server

In this article I would introduce you to the new data types added in SQL Server 2008 called as spatial data types and the different terminologies and the structures used in them. Prior to SQL Server 2008 spatial data used be stored in a conventional manner by basically creating  two different […]

Cell Level Encryption in SQL Server

Cell level encryption provides encryption at a much granular level i.e. at the cell level or the column level. Cell level encryption has been available since SQL Server 2005 and supported in 2008 as well as 2012. In this article I am going to focus on the cell level or the column level encryption which can be used to encrypt columns storing credit card numbers or SSN .

SQL Server 2012 Analytical Functions, Part 2 of 2

This article is the second and the final article in the series on the new analytical functions introduced in SQL Server 2012. The new analytical functions are a great addition to SQL Server 2012. But I personally feel that SQL Server still has a bit to catch up with the capabilities of other RDBMS products like Oracle or DB2 or Sybase when it comes to analytical functions.

Top 10 Android Productivity Apps

One of the biggest areas of the Android app market experiencing high demand is productivity apps. Business people, in particular, are looking for ways to improve their productivity and if there are apps designed to work towards that, so much the better. But what are the best Android productivity apps on the market today? The best thing about any one of these apps is that they are also free for download.

SQL Server 2012 Analytical Functions, Part 1 of 2

This article is Part 1 of the series which describes the new analytical functions introduced with SQL Server 2012. This article focuses only on the newly added analytical functions introduced in SQL Server 2012.

How to write an Accelerator for Internet Explorer

I've always used IE accelerators for easy access. Translate and Bing search are some of the most commonly used accelerators for Internet Explorer when it comes to text selection. It saves the amount of time it takes to either open a new tab or use the current tab in addition to actually typing your search text. While I enjoy some of the default accelerators that come with IE, I wanted to quickly write one of my own to search for things instantly on Google's Play Store. Today let's look at how we can achieve that with a bit of XML code.

Ghost Records in SQL Server

Though the concept of Ghost records and many others like this may not be so useful practically in your day to day DBA activities but it gives you an insight on how SQL Server manages the objects in itself and I would say that each DBA should be aware of them.

SEQUENCE Objects in SQL Server 2012

In this article we would look into an another cool new feature of SQL Server 2012 called “SEQUENCES”. If you are familiar with Oracle you might know that this feature has been available since Oracle 8i but is new to the SQL Server world.

Column Store Indexes in SQL Server 2012

SQL Server 2012 introduces a new type of index called as “Column Store Index” .These indexes are a bit different from the traditional indexes which we have in SQL Server to date. Column store indexes are best recommended for data warehouse queries which speeds up the execution of queries. They are usually not recommended in OLTP environments.

Can actually beat our beloved Gmail?

Just like is for “Google account”, now we got for a “Microsoft account". The question is what is this unheard “Microsoft account”? It is simply the new name for what used to be called a "Windows Live ID." A combination of an email address and a password that will allow you to sign in to services like Hotmail, Xbox LIVE, Windows Phone, or SkyDrive is what Microsoft account is all about. In case you already have an email address and password from which you use these or other services, this means you already have a Microsoft account (and don’t know) —but you can also sign up for a new one if you like. In due course, all Microsoft services will be given new names.

Partially Contained Databases in SQL Server 2012

The biggest problem with SQL Server for a very long time has been that databases on an instance are always tightly coupled to it. So once you move your database to a different SQL server instance the database will always face compatibility issues though the target and source server instances were of the same version and Service packs.

Native Screenshot Function Coming to Windows Phone 8

Windows Phone users have long desired for native screenshot functionality. That ladies and gentlemen is coming true with Windows Phone 8. A purportedly leaked SDK puts to rest rumors of the start key + camera button combo in the SDK emulator. You can emulate the screenshot capture using the F7+F2 (start/camera) keys on the emulator (and fingers crossed this feature will not be deprecated in the final release by the boys at Redmond).