InfoQ Homepage SQL Server Content on InfoQ
-
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.
-
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.
-
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.
-
Amazon's EC2 Switches from Beta to Production
Amazon's EC2 services are no longer offered as beta, but they have been switched into production, Amazon offering a Service Level Agreement (SLA). Windows on EC2 is still available as beta.
-
SSIS for Oracle and Teradata
In conjunction with Attunity, Microsoft has released SSIS Connectors for Oracle and Teradata.
-
SQL Server 2008 Report Builder 2.0 RC1 Ready for Download
Microsoft has released SQL Server 2008 Report Builder 2.0 RC1. The Report Builder has full support for SQL Server 2008 Reporting Services including: various report layouts, data visualizations and formatted text.
-
SQL Server 2008 Express Series Is Available
Microsoft has made available three versions of SQL Server 2008 Express. Express editions are free versions of SQL Server intended for learning or building small server applications, or for ISV redistribution. The Tools edition contains the Management Studio, while the Advanced Services edition has full-text search and Reporting Services.
-
Table-Valued Parameters in SQL Server
Table-valued parameters are a new feature introduced in SQL Server 2008. They provide a built-in way to send multiple rows of data from a client application to SQL Server in a single parameterized SQL statement.
-
Sparse Columns, Filtered Indexes, and Column Sets
Sparse Columns, Filtered Indexes, and Column Sets are new features for SQL Server 2008. While they allow you to break the 1024 limit on columns and save significant disk space, if not used correctly they can be a disaster.