BT

Facilitating the Spread of Knowledge and Innovation in Professional Software Development

Write for InfoQ
News Articles Presentations Podcasts Guides

Topics

Choose your language

InfoQ Dev Summit Boston

Discover transformative insights to level up your software development decisions. Register now with early bird tickets.
InfoQ Dev Summit Munich

Get practical advice from senior developers to navigate your current dev challenges. Register now with early bird tickets.
QCon San Francisco

Level up your software skills by uncovering the emerging trends you should focus on. Register now.
The Software Architects' Newsletter

Your monthly guide to all the topics, technologies and techniques that every professional needs to know about. Subscribe for free.

InfoQ Homepage SQL Server 2008 Content on InfoQ

News

RSS Feed
Newer Older

  • SQL Server Unit Testing with 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.

    Jenni Konrad
    on Feb 10, 2012

  • Code First Migrations Updates Data Structure From Code

    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.

    Jenni Konrad
    on Dec 02, 2011

  • ORM Profiler Analyzes Data Access Performance

    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.

    Jenni Konrad
    on Oct 14, 2011

  • Spatial Data Introduced to Entity Framework

    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.

    Jenni Konrad
    on Oct 06, 2011

  • MVP Erland Explores SQL Server Performance Concepts

    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.

    Roopesh Shenoy
    on Jul 13, 2011

  • Cloud-Based Server Management and Troubleshooting with System Center Advisor

    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.

    Jenni Konrad
    on Jun 30, 2011

  • SQL Server 2008 SP1 and Feature Pack CTP Bring New Features and Tools

    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.

    Abel Avram
    on Apr 28, 2011

  • Migrating from MySQL/Access to SQL Server/Azure with SSMA

    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.

    Abel Avram
    on Aug 17, 2010

  • Microsoft is Making a Play for MySQL Users

    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.

    Jonathan Allen
    on Jan 19, 2010

  • SQLAzureMW Migrates SQL Databases to SQL Azure

    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.

    Abel Avram
    on Sep 03, 2009

  • MapPoint Add-In For SQL Server Released

    Microsoft released a free MapPoint 2009 Add-In for SQL Server 2008 spatial data. The add-in can be used with MapPoint to build map graphics against queries on SQL Server 2008 spatial geography columns.

    Al Tenhundfeld
    on Aug 22, 2009

  • SQL Enlight T-SQL Analyzer

    SQL Enlight is a tool designed to expedite and facilitate T-SQL development through code analysis and templating. SQL Enlight integrates into MS Visual Studio and SQL Management Studio.

    Al Tenhundfeld
    on Apr 29, 2009

  • SQL Server 2008 Major Updates

    Microsoft has released significant updates for SQL Server 2008, including 2008 Service Pack 1, Express Edition Service Pack 1, large Feature Pack, Upgrade Advisor, SRS Report Builder 2.0, SharePoint integration, and data mining Office add-ins.

    Al Tenhundfeld
    on Apr 20, 2009

  • MIX 09: Nigel Ellis on Azure SQL Data Services

    Nigel Ellis, Architect at Microsoft, presented today a detailed overview of the new relational model of Azure SQL Data Service, which was announced a couple of weeks ago on the team's blog. Nigel also demonstrated how SDS could be used by WordPress (a PHP application) via an ODBC driver.

    Jean-Jacques Dubray
    on Mar 20, 2009

  • 256 Core SQL Server

    With Windows Server 2008 R2 and SQL Server Kilimanjaro, it is expected that SQL Server will be able to support at least 256 logical processors.

    Jonathan Allen
    on Nov 12, 2008
Newer News
Older News
BT