InfoQ Homepage SQL Server Content on InfoQ
-
SQL Server Denali: Microsoft Wants Your Feedback on Upgrade Paths and Supported Operating Systems
Microsoft posted the proposed list of SQL Server Code Name Denali upgrade paths and operating systems, and is soliciting feedback on their selections. Windows XP and 2003 are excluded, and versions of SQL Server may require service pack updates before a new Denali installation.
-
Visual Studio Database Development with SQL Server "Juneau"
SQL Server Development Tools (SSDT), codenamed "Juneau", provide a new Visual Studio-based development environment for SQL Server. Some of its features are already available in Visual Studio 2010 Ultimate, but SSDT includes some key new additions such as the close integration of Database and Application Projects.
-
Balanced Data Distributor: Improve SSIS Performance with Parallelism
The Balanced Data Distributor is a multithreaded data flow transform tool for SQL Server Integration Services 2008. It's intended to improve performance in multi-core and multi-processor server environments by distributing data to multiple outputs.
-
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.
-
Column-based Storage in SQL Server 2011
Imagine ad hock data mining queries against a single table with 1 TB of data and 1.44 billion rows coming back in roughly a second. This is the scenario Microsoft intends to support using 32-core machines and their new column-based storage engine.
-
Partitioning and Sharding Options for SQL Server and SQL Azure
Horizontal partitioning and sharding are important tools for developers working with extremely large datasets. We take a brief look at what’s available in SQL Server and what’s coming down the road.
-
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.
-
Microsoft Answers “Top 10 Questions on Data”
Microsoft has answered what they call “Top Ten Questions on Data”, explaining what has happened or it is going to happen to Oslo, ADO.NET Data Services, WCF, LINQ to SQL, T-SQL and other technologies.
-
SQL Server Express Shipping with Limited .NET 4.0 Support
A new build of Service Pack 1 for SQL Server 2008 Express has enabled some support for .NET 4.0. But with a large list of limitations one has to wonder what’s the point.
-
Visual Studio/SQL Server Reporting Services Continue to be Incompatible
Despite years of complaining from developers and the mockery of vendors such as IBM, Microsoft is continuing its policy of shipping components of Visual Studio that are incompatible with the current version SQL Server Reporting Services.
-
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.
-
Quickly Migrate from SQL Server to SQL Azure
In order to make migrating from SQL Server to SQL Azure easier, Microsoft is releasing a migration tool on CodePlex. The SQL Azure Migration Wizard will detect, and if possible, correct incompatibilities between SQL Server 2005/2008 and SQL Azure. In addition to generating scripts for deploying the migrated schema on SQL Azure, this tool will also allow you to migrate table data using BCP.
-
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.
-
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.
-
Is the NoSQL Meeting Announcing the End of the RDBMS Era?
The NoSQL meeting tried to raise the awareness towards the opportunity of using non-relational databases which promise to be cheaper, simpler to administer and maintain, and offering superior scalability. Michael Stonebraker, co-creator of Ingres and Postgres, thinks that the end of RDBMS era is close, while others think that we are not there yet.