Category: Articles
-
What’s new in DTA – SQL Server 2012
DTA stands for Database Tuning Advisor which has introduced from SQL Server 2005. This utility helps the end user to tune their query and give them suggestions for better performance. It takes T-SQL query or profiler trace as workload, based on this it will analyze and give you the recommendation. Now in SQL Server 2012…
-
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…