What’s New in SQL Server 2008

-

SQL Server 2008 delivers on the following four key areas of the Microsoft data platform vision:

Mission-critical platform – SQL Server 2008 enables organizations to run their most complex applications on a secure, reliable, and scalable platform while enabling IT to reduce the complexity of managing their data management infrastructure. SQL Server 2008 provides a secure and trusted platform by securing valuable information in existing applications and enhancing the availability of the data. SQL Server 2008 introduces an innovative policy-based management framework that enables policies to be defined for explicit and automated administration of server entities across one or multiple servers. In addition, SQL Server 2008 delivers predictable query performance with an optimized platform.

Dynamic development – SQL Server 2008 along with the .NET Framework reduces the complexity of developing new applications. The ADO.NET Entity Framework enables developers to be more productive by working with logical data entities that align with business requirements instead of programming directly with tables and columns. The new Language Integrated Query (LINQ) extensions in the .NET Framework revolutionizes how developers query data by extending Visual C#® and Visual Basic® .NET to support an SQL-like query syntax natively. And support for occasionally connected systems lets developers build applications that enables users to take data with them on devices and later synchronize their data with central servers.

Beyond relational data – SQL Server 2008 enables developers to consume and manage any type of data from traditional data types to advanced new geospatial data. Developers can build next-generation database applications that feature new location awareness support and that enable document management capabilities.

Pervasive business insight – SQL Server 2008 provides a scalable infrastructure that can manage reports and analysis of any size and complexity while making it easier for users to access information through deeper integration with Microsoft Office. This enables IT to drive business intelligence throughout the organization. SQL Server 2008 makes great strides in data warehousing, enabling users to consolidate data marts in an enterprise data warehouse.

Comments

Post a Comment

Popular posts from this blog

ASP.NET Compillation Error BC31007 - Solution

-
TToday while I am working on the ASP.NET application, I suddenly encountered with below error while trying to debug the application. I tried couple of actions: .    ·           Clean and rebuild solution ·          IDE restart ·          Temporary asp.net files cleanup ·          System restart ·          Modified Identity in App pool Finally it got resolved by modifying the Identity to “Local System” in Application Pool Server Error in '/My App’ Application. Compilation Error Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. Compiler Error Message: BC31007 : Unable to open module file 'C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Temporary ASP.NET Files\crs\b1234521\35244951\App_global.asax.v8-jml4w.0.vb': System Error &Hc0000005& (Visual Basic internal compiler error) Source Error:
Read more

Test & Debug WCF service using WCFTestClient.exe

-
Image
VS.NET 2010 provides WCFTestClient.exe for us to test and debug the WCF service.  Please follow me to test and debug the service. Generally, first debug and then test the service, but here first I will tell you how to test it and then how to debug it J Test the WCF service using WCFTestClient. 1.        Open “Visual Studio Command Prompt (2010)” 2.        Go to “c:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\” 3.        Run WcfTestClient.exe 4.        It will open WCF Test Client, now add WCF Service (URL) 5.        Select the service method, from left panel 6.        Provide request data (i.e. values to parameters) on right panel and click on Invoke button. It gives you the response. Debug the WCF service, follow the commands. 1.        Go to WCF service project properties 2.        Go to Web menu on left menu 3.        Select WcfTestClient.exe from “c:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\” for “Start external progr
Read more

Microsoft Surface in brief

-
After years of covert development, Microsoft says it will release a computer that uses the tabletop as its high-resolution display, recognizes objects placed on the surface and skips the traditional keyboard and mouse in favor of fingers on the screen. What it is : A computer in the form of a table, using the hard acrylic tabletop as a high-resolution screen. First product from Microsoft's previously secret Surface Computing team, which has 120 employees. How it works : The surface itself isn't touch-sensitive, but a series of cameras inside the table can see when someone places or drags a finger, hand or any other object on or across the tabletop screen. Internal projector lights screen from beneath. Interface : People can use their hands to touch and move virtual objects on the screen, just as they would with a mouse on a traditional PC. The system also can recognize objects placed on the surface, based on their shape or on special codes affixed to them.Size: 22 inches high,
Read more