Three things that SQL Server DBA needs to know

TechTarget Reporter was fortunate enough to interview SQL Server consultant and popular blogger, Denny Cherry, in June. He talked about three things that SQL Server DBA needs to know, and describes the trends in SQL Server development.

1, SQL Server 2012 has been released. Cherry said: "I met a lot of people asking me what time SQL Server 2012 was released." It has actually been released. "Why is there such confusion?" Microsoft recently released a number of new products, including Window Server 2012 and Digital Studio 2012, which are still in beta, and led to the mistaken SQL Server 2012 is also in beta version. However, the fact that the SQL Sever 2012 official version of the database was released as early as March.

2, the availability of new features. The AlwaysOn availability form will help you achieve high availability and apply landscape scaling, and you will be able to run SQL Server together across different hosts.

3, PC form function support. "This is a great convenience for SQL developers," Cherry said. "These features are useful for doing data aggregation, and it allows you to examine data more easily."

We also let Denny Cherry share what he sees as the hottest trends in SQL Server. Here are three directions he's expected to develop.

1, data analysis and Business Intelligence (BI) into the company. "Bi is very popular at the technical convention," Cherry said. In any case, the focus on BI will not disappear quickly. "People are learning data analysis and BI quickly," he added. ”

2, high availability features. In Cherry's view, the need for such functions will only continue to grow. "Companies are no longer able to accept various types of long downtime, and their applications require 7*24 to run." ”

3, data growth. All companies are generating more and more data, and they need to be kept longer. As a result, cherry that the tools to manage "big data" will become increasingly popular.