Database Trends and Applications

SQL SERVER AND MICROSOFT TECHNOLOGIES REACH ACROSS THE ENTERPRISE
This survey of Professional Association for SQL Server (PASS) members was completed in October, 2006. (18 pages including 20 charts and graphs. Sponsored by GoldenGate Software.)

The data management community long waited for SQL Server 2005. But how quickly was Microsoft’s new database management system implemented in the year following its general availability? This study examines the SQL Server 2005 adoption rate and explores the other technologies data managers in SQL Server shops adopting to support their and implications for enterprise-scale and business intelligence applications. Among the key findings:

SQL Server 2000 is still the dominant database platform, but after one year, seven out of 10 respondents also have SQL Server 2005 running on the premises. Overall, 95 percent of respondents either already run SQL Server 2005 or plan to upgrade to the database platform within the next two years.
Microsoft development tools are the tools of choice – 81 preecent report using Microsoft Visual Studio.NET on a daily basis to build or integrate applications with their SQL Server databases. In addition, 81 percent write their stored procedures in T-SQL.
Windows Server 2003 is and will remain the leading deployment platform for SQL Server databases. Ninety-four percent of respondents report running their database systems on Windows 2003, a number that will remain constant for the next two years.

A total of 267 people participated in the survey. A total of 44 percent of respondents are database administrators, while 21 percent are developers or analysts. Another 18 percent come from various
management-level positions. A third of respondents come from organizations with more than 5,000 employees. In addition, the survey reflected SQL Server’s strength in the financial services, technology, and government markets.