මයික්‍රෝසොෆ්ට් SQL Server ගැන පරිගණක මෘදුකාංග ක්ෂේත්‍රයේ සිටිනා කවුරුත් දන්නා දත්ත සමුදාය කළමණාකරණ පද්දතියක්. මා හට එහි ලගදී නිකුත් කිරීමට නියමිත වෙළුමේ ඇති තාක්ෂණික පසුබිම පිළිබද විස්තරයක් මයික්‍රෝසොෆ්ට් වෙබ් අඩවියෙන් හමුවුනා. කරුණු ටික තියෙන්නෙ නම් ඉංග්‍රීසියෙන්. පරිවර්ථනය කිරීම ටිකක් අපහසුයි. ඒ නිසා ඉංග්‍රීසියෙන්ම කියවලා බලන්න.

Each and Everyone knows in software field about MS SQL Server. It’s most familiar with Microsoft developers. I found article from Microsoft web site about SQL Server 2008 Technologies. SQL Server delivers a wealth of features grouped by core technologies that enable you to easily consume and understand the breadth of capabilities available for your business.

Analysis Services

SQL Server 2008 helps enable organizations to build comprehensive, enterprise-scale analytic solutions that deliver actionable insights through familiar tools.

Data Mining – Predictive Analytics

SQL Server 2008 empowers informed decisions with predictive analysis through intuitive data mining, seamlessly integrated within the Microsoft Business Intelligence platform and extensible into business applications.

High Availability – Always On

Microsoft SQL Server 2008 Always on Technologies provides a full range of options to minimize downtime and maintain appropriate levels of application availability.

Integration Services

SQL Server 2008 provides a scalable enterprise data integration platform with exceptional ETL and integration capabilities, enabling organizations to more easily manage data from a wide array of data sources.

Manageability

SQL Server 2008 provides a policy-based system for managing one or more instances of SQL Server along with tools for performance monitoring, troubleshooting, and tuning that enable administrators to more efficiently manage their databases and SQL Server instances.

Performance and Scale

SQL Server 2008 provides a comprehensive data platform that can grow with your business. SQL Server 2008 is packed with technologies to scale-up individual servers, and scale-out very large databases, and tools to optimize performance.

Reporting Services

SQL Server 2008 Reporting Services provides a complete server-based platform designed to support a wide variety of reporting needs including managed, enterprise, ad- hoc, embedded, and Web-based reporting, and enable organizations to deliver relevant information where needed across the entire enterprise.

Security

SQL Server 2008 offers security feature enhancements that help provide effective management of security feature configuration, strong authentication and access control, powerful encryption and key management capabilities, and enhanced auditing.

Spatial Data

SQL Server 2008 delivers comprehensive spatial support that enables organizations to seamlessly consume, use, and extend location-based data through spatial-enabled applications which ultimately helps end users make better decisions.

Data Platform Technologies

ADO.NET Data Services

Microsoft ADO.NET Data Services provides a first-class infrastructure for the next wave of dynamic Internet applications by enabling Web applications to expose data as REST based data services that can be consumed by client applications in corporate networks and across the Internet.

ADO.NET Entity Framework

The Microsoft ADO.NET Entity Framework is an evolutionary step in data development. It simplifies data access code in applications by enabling developers to create a customizable conceptual model for data from any source, and easily map it to business requirements.

LINQ

LINQ is an exciting evolution in data programming that enables developers to build queries over data directly from within any .NETbased programming language. LINQ to Entities, LINQ to DataSet, LINQ to SQL, and LINQ to XML are key implementations of this powerful technology.

Native Data Access

Enhanced SQL Server 2008 Native Client provides a high-performance, versatile, data access library that enables developers to take advantage of the new capabilities of SQL Server 2008.

Sync Framework

The Microsoft Sync Framework is a comprehensive synchronization platform that enables collaboration and offline scenarios for applications, services and devices. Developers can build sync ecosystems that virtually integrate any application, any type of data, using most protocols over virtually any network.

SQL Server 2008 Online Resources

SQL Server 2008 Web site

www.microsoft.com/sql/2008
Resources about SQL Server 2008 features, pricing and editions.

SQL Server 2008 TechCenter

http://technet.microsoft.com/sqlserver

Resources for IT Professionals who deploy, manage, and administer SQL Server.

SQL Server 2008 Developer Center

http://msdn2.microsoft.com/sqlserver

Resources for developers who develop applications and software that work with SQL Server.