SQL Server, Denali | Anuj Varma

SqlGeometry Data Type–Treating it alongside other SqlParameters | Posted on October 26, 2011 by Anuj Varma

SqlGeometry is a spatial data type introduced in SQL Server 2008 (R2). It can be found in the Microsoft.SqlServer.Types namespace. This is a special data type and not one of the standard SqlDbTypes (enum) datatypes. So – if you have … Continue reading →

Moving from Oracle to SQL Server – Data Types To Worry About | Posted on October 18, 2011 by Anuj Varma

As you start planning the migration of the schema objects, one immediate concern will be the data type mismatches between SQLServer and Oracle. Here are some helpful links in determining the correct translation of data types (I had to dig … Continue reading →

Detaching, Dropping SQL Server Databases–Some gotchas | Posted on September 22, 2011 by Anuj Varma

There’s a couple of different ways to drop/detach databases from sql server (assuming the obvious Right Click, Delete option in Management Studio did not work for you)
Method 1 – Make it Offline First
One of the surest ways to drop/detach a … Continue reading →

sa user unable to attach detach databases | Posted on September 22, 2011 by Anuj Varma

PROBLEM
With a new SQLServer install, if you selected Mixed Mode authentication, chances are you want to be able to use your sa user to connect to the database. You will be able to connect just fine, but will soon discover … Continue reading →