SQL Server 2008 Content on InfoQ
News about SQL Server 2008
- Topics
- SQL Server 2008,
- SQL Server 2005,
- SQL Server 2012,
- SQL Server,
- Unit Testing,
- Relational Databases,
- Microsoft,
- Database,
- Companies,
- Testing,
- TDD,
- T-SQL,
- tSQLt
tSQLt is a free, open-source framework for unit testing in SQL Server. By writing tSQLt test cases, developers can create fake tables and views based on production data, then compare expected versus actual results. Tests can be created directly in SQL Server Management Studio.
- Topics
- ADO.NET Entity Framework,
- SQL Server 2008,
- SQL Server 2011,
- SQL Server,
- ADO.NET,
- SQL Server 2012,
- Relational Databases,
- .NET,
- Data Access,
- Microsoft,
- Companies,
- Programming,
- Database,
- Entity Framework
The Code First approach means that the object model is created in code, and then the database structure is generated from that model. Code First Migrations allows developers to make changes to the database via code, many of which can be done automatically.
- Topics
- SQL Server Denali,
- .NET Framework 4.0,
- SQL Server 2012,
- SQL Server 2008,
- .NET Framework 3.5,
- MySQL,
- .NET Framework,
- SQL Server,
- Data Access,
- Performance Tuning,
- Relational Databases,
- .NET,
- Microsoft,
- Oracle,
- Database,
- Programming,
- Performance & Scalability,
- ORM,
- Companies
Solutions Design has released ORM Profiler, a tool meant to help improve data access layer performance. It tracks and logs ADO.NET calls so that developers can analyze their data access and discover potential problems.
- Topics
- SQL Server 2008,
- SQL Server,
- .NET,
- Relational Databases,
- Microsoft,
- Programming,
- Database,
- Companies,
- LINQ
One of the new additions in the Entity Framework June CTP is official support for Spatial data types, which allow developers to represent data using a system of coordinates, such as shapes, lines, or points on a map.
- Topics
- SQL Server 2005,
- SQL Server 2008,
- SQL Server,
- .NET,
- Microsoft,
- Relational Databases,
- Programming,
- Performance & Scalability,
- Database,
- SQL Server 2000,
- SQL Server 2008 R2,
- Companies
In "Slow in the Application, Fast in SSMS?", SQL Server MVP, Erland Sommarskog, explores the various things that affect Query Plan, compilation of Dynamic SQL and other things that ultimately affect your SQL Server Database Performance. He covers various concepts and scenarios like parameter sniffing, query plan caching, Blocking, saved settings, issues with linked servers and more.
- Topics
- SQL Server 2008,
- SQL Server,
- .NET,
- Microsoft,
- Relational Databases,
- Programming,
- System Management,
- Database,
- Windows Server 2008,
- System Center Advisor,
- Companies
Microsoft System Center Advisor is a new cloud-based service that analyzes installations of Windows Server 2008 and SQL Server 2008 (and later versions). It tracks configuration changes and upgrades, and reports on potential issues due to missing security patches, incompatibilities, or deviations from best practices.
- Topics
- SQL Server 2008,
- SQL Server,
- SQL,
- .NET,
- Data Access,
- Microsoft,
- Relational Databases,
- Programming,
- SQL Server 2008 R2,
- Database,
- Companies
Microsoft has announced the availability for download of SQL Server 2008 R2 SP1 CTP, including all cumulative updates, and SQL Server 2008 R2 SP1 Feature Pack CTP1, containing a number of stand alone tools adding more value to SQL Server 2008.
- Topics
- SQL Server 2008,
- SQL Azure,
- SQL Server 2005,
- MySQL,
- Azure,
- SQL Server,
- .NET,
- Data Access,
- Relational Databases,
- PaaS,
- Microsoft,
- Oracle,
- Programming,
- Cloud Computing,
- SQL Server 2008 R2,
- Companies,
- Database
Microsoft has released the SQL Server Migration Assistant (SSMA) for MySQL 1.0, and has refreshed SSMA for Oracle v4.2, SSMA for Sybase v4.2, and SSMA for Access v4.2. These toolkits helps customers migrating their MySQL/Oracle/Sybase/Access databases to SQL Server and some even to SQL Azure.
- Topics
- SQL Azure,
- SQL Server 2005,
- SQL Server 2008,
- SQL Server,
- MySQL,
- Azure,
- PaaS,
- Microsoft,
- .NET,
- Database Design,
- Relational Databases,
- Architecture,
- Database,
- Companies,
- Programming,
- Cloud Computing
Microsoft has released its first community tech preview for a MySQL to SQL Server migration tool. This tool supports SQL Server 2005, 2008, and Azure.
- Topics
- SQL Azure,
- SQL Server 2005,
- SQL Server 2008,
- Azure,
- SQL,
- SQL Server,
- PaaS,
- .NET,
- Data Access,
- Relational Databases,
- Microsoft,
- Programming,
- Database,
- Cloud Computing,
- Companies
The SQL Azure Migration Wizard (SQLAzureMW) is a CodePlex project and wizard that can be used to migrate SQL 2005 and SQL 2008 databases to SQL Azure.