A recent Microsoft report indicates its upcoming SQL Server 2008 R2 Parallel Data Warehouse edition features a number of noteworthy security advantages over its predecessors.
According to Microsoft Certified Professionals Magazine, SQL Server primarily uses Information Security Consolidated Events to monitor and retain data on virtual servers. These protocols maintain a consistent level of security, ensuring businesses can control and secure information.
Microsoft's report said the company tested the Parallel Data Warehouse edition of SQL Server on 250,000 devices in 100 countries to trial its abilities in forensic data security and analysis. The primary focus of the testing was to achieve rates upwards of 60 terrabytes for Information Security Consolidated Events. SQL Server Parallel Data Warehouse Edition managed to meet this goal while producing a number of noteworthy improvements.
Overall, the Technology Adoption Program found SQL Server 2008 R2 Parallel Data Warehouse Edition is capable of retaining data for 90 days, as opposed to its predecessor's 60 day limit. It also improved on earlier versions' maximum load handling of 1 terrabyte, reaching 4 terrabyte levels daily. The report said one query, which took an hour to complete on earlier systems, needed just four minutes with the new platform.