(Pinal Dave) It is quite common that when a new feature gets introduced, there is a lot of talk about them. Sometimes even the old capabilities are lesser known because they can be used interchangeably in conversations.

(James Serra) Polyglot Persistence is a fancy term to mean that when storing data, it is best to use multiple data storage technologies, chosen based upon the way data is being used by individual applications or components of a single application.

(Ed Elliott) Whether we use a tool to generate upgrade scripts or we write manual test scripts for database changes there are a few things that we should bear in mind to ensure we do not break existing databases.

(Thomas LaRock) Did you know table and index statistics are the most important piece of metadata for your database?

(Jeffrey Yao) I have many SQL Server transactional replication sessions to monitor, for some implementations, we have one strict requirement, i.e. the latency should be less than 90 seconds, otherwise, there may be timeout errors inside front-end application. Is there a good way to monitor the healt

(Ed Elliott) Whether we use a tool to generate upgrade scripts or we write manual test scripts for database changes there are a few things that we should bear in mind to ensure we do not break existing databases.

(Thomas LaRock) Did you know table and index statistics are the most important piece of metadata for your database?

(Jeffrey Yao) I have many SQL Server transactional replication sessions to monitor, for some implementations, we have one strict requirement, i.e. the latency should be less than 90 seconds, otherwise, there may be timeout errors inside front-end application. Is there a good way to monitor the healt

(Paul White) The fastest way to compute a median uses the SQL Server 2012 OFFSET extension to the ORDER BY clause. Running a close second, the next fastest solution uses a (possibly nested) dynamic cursor that works on all versions.

(Richard Carr) When working with large data sets it is common to retrieve a limited number of rows at a time and allow the user to page through the results. With SQL Server 2012, the paging can be controlled by the database engine, using new options of the ORDER BY clause.