InfoQ Homepage SQL Server Content on InfoQ
-
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.
-
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.
-
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.
-
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.
-
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.
-
What’s Next for SQL Server?
As we reported last year, SQL Server 2008 R2 will support 256 logical processors. Other features include better multi-server management tools and geospatial visualization in Reporting Services 3. A preview of the new version is available to MSDN and TechNet subscribers. The general public will have access later this month.
-
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.
-
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.
-
Review: The Art of High Performance SQL Code
It is one thing to look at the execution plan for SQL Server queries, it is quite another to know what they mean. Grant Fritchey’s book, The Art of High Performance SQL Code: Part 1 Dissecting SQL Server Execution Plans, helps you get to that point.
-
Relational Cloud On the Horizon
Microsoft has announced that SDS will deliver full relational database capabilities as a service. The core foundational components of SDS have not changed and it is still the same proven architecture of the current CTP. However, the ACE (Authority, Container, Entity) data model is being retired.
-
Static Code Analysis for T-SQL
Static code analysis, long neglected on the Windows platform, has been becoming more and more import in the last few years. This hasn't gone unnoticed by database developers, who thanks to Ubitsoft can now analyze T-SQL just like .NET developers analyze managed code.
-
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.
-
Performance Problems Mar SQL Server 2008 Full Text Search
SQL Server Full Ttext Search is a rather specialized discipline among database administrators. For roughly a decade it has been something separate from the rest of SQL Server, and in most cases unnecessary. But for those who do use it, it tends to be core to how data is indexed and retrieved. For those using it and upgrading to SQL Server 2008, trouble is brewing.