Category: General

  • FileStream FAQ

    I have consolidated some frequently asked questions for FileTable. I’ll try to cover as much as I can so that all your questions related to Filetable can be clarified. All these answers are based on SQL Server 2012 version these may change in future version and editions which I’ll be updating with the latest release.

  • Working with Filetables

    I have created an article sometime back about filetables but I have covered how to work with it. It’s now time for writing this article. In my earlier article you came to know what’s filetable and how it’s useful. Let’s now jump in to create and work with filetables. You need to satisfy all the…

  • SQL Server 2012 Certification

    SQL Server 2012 has been released with so many new features. Microsoft has changed SSMS 2012 core to integrate with Visual studio 2010 shell. This revamp is not only for features they also changed certification path for SQL Server 2012. Below are the new certification titles that comes with SQL Server 2012

  • Synonyms – SQL Server

    I was working in a project where we are using database mirroring as high availability solution. In the same instance we have multiple databases in which only critical databases are configured for database mirroring. As you know database mirroring scope is limited to database only which means dependent database are not failed over (which is…

  • Installing SQL Server 2012

    This might be a simple article for the intermediate folks, however I would like to show you the screen’s in SQL Server 2012 installation. As far as I know the setup is similar to the one which we did for SQL Server 2008 R2, there are some additions to the installation part. Before jumping into…