Swiss-knife features in SQL Server to help you
Over the times managing RDBMS platform has evolved into a phase that all of the essential functionality that a Database Administrator needs to administer a multivendor or single-vendor database environment wrapped in an intuitive graphical interface. May be it is a smaller system or mission-critical system to maintain, there are various factors involved to manage in order to provide high availability or least downtime.
Micrsoft invested heavily such offers within SQL Server for OLAP by adding cube queries and multidimensional expressions (MDX) in addition to TSQL, CLR too. Similarly IBM, Oracle, Sybase and others embraced object-relational technology.
So as to find these hidden features in SQL Server refer to this Top10Gems whitepaper.