SPARSE Column

Happy New Year My dear Friends It’s  been a long this feature has been released however I just got an opportunity to check it out. This feature is released in SQL Server 2008 version. Sparse columns are normal columns which will store NULL values in a optimized storage which means no storage space is taken… Continue reading SPARSE Column

Deploying Data Tier Application (DAC) Package

Last week I wrote an article for Creating DAC packages. Today I’m going to cover how to deploy a DAC package. It’s very easy  for the DBA’s to deploy the DAC in few clicks that means in few clicks database implementation will get completed, it’s as simple as like that. I’m going to use the… Continue reading Deploying Data Tier Application (DAC) Package

Creating a Data Tier Application (DAC) Package

In previously article I’ve covered what is DAC package and how it helps during deployment. In this article I’m going we are going to see how can we create a new data tier application (DAC) package for deployment. All SQL Server related objects can be included in this package for deployment, this includes both database… Continue reading Creating a Data Tier Application (DAC) Package

How to change Server Collation in SQL Server 2008

In this article we are going to discuss about changing SQL Server 2008 collation at serverlevel. While installing SQL Server 2008 we may miss to choose the right collation and we need to rectify this by changing the collation at serverlevel. You can change the collation of sql server without uninstalling. Lets discuss the necessary… Continue reading How to change Server Collation in SQL Server 2008