InfoQ Homepage SQL Server Content on InfoQ
-
Launch Date set for Visual Studio 2008, SQL Server 2008 and Windows Server 2008
Yesterday Kevin Turner announced the release date of the next versions of Visual Studio, SQL Server Windows Server at the Worldwide Partner Conference in Denver, CO.
-
SQL Server Best Practices Analyzer No Longer Tied to Service Packs
According to Paul Mestemaker, the SQL Server Best Practices Analyzer is no longer being tied to SQL Server Service Pack releases. This announcement is being made in conjunction with the first production release of the tool.
-
Sparse Columns Added to SQL Server 2008
SQL Server 2008 has lifted the limit of 1024 columns per table with a new option called "sparse columns". While this seems like its excessive, some developers have been running up against this limit.
-
VS Express Editions Orcas CTP Available
Along with the full version of Visual Studio Orcas in beta, the free versions that make up the Visual Studio Express line are now available.
-
Deny Execute on Assembly Doesn't
According to Microsoft's SQL Programmability & API Development Team Blog, the Execute permission for CLR assemblies actually has no effect. To reduce confusion over this, the ability to grant execute permissions to assemblies has be removed from SQL Server 2005 SP 2.
-
SQL Server 2005 SP 2 Upgrade Warning
According to the SQL Server Manageability Team, there is a bug in the maintenance plan engine that may cause it to delete historical information too soon.
-
SQL Server 2005 Best Practices Analyzer Preview
A CTP of the SQL Server 2005 Best Practices Analyzer is now available. This tool can be thought of as FXCop for SQL Server.
-
SQL Server Now Supports Vista
With the release of Service Pack 2, SQL Server 2005 finally has full support on Vista. This includes SQL Server Express, which had serious difficulties running on the new operating system. Several new features are also included in this release.
-
SQL Server Compact Edition Released
SQL Server Compact Edition has been released. As we reported in September, this product is being positioned as a replaced for the venerable Jet engine traditional used by Visual Basic programmers for lightweight databases.
-
SQL Server Always-On Solution Review Program
When building a mission critical database, a lot of attention needs to be paid to the hardware. Simply getting the fastest drives isn't enough if those drives cannot be hot swapped or corrupt data whenever the power fails. Fortunately Microsoft has created a program for choosing the correct storage mechanism.
-
Using Regular Expressions in SQL Server Integration Services
Jamie Thomson demonstrates how to use .NET scripts in a SQL Server Integration Services (SSIS) pipeline to add Regular Expression support.
-
Visual Studio for Database Professionals Released
Microsoft has developed what they call "tools for building SQL databases in a managed project environment with support for versioning, deployment, unit testing, refactoring, and off-line SQL development." These tools, released under the name Visual Studio for Database Professionals, claim to offer a way to develop databases in the same off-line fashion as traditional applications.
-
SQL Server Best Practices Website
Mark Souza of Microsoft has announced a new web site for database administrators and developers called SQL Server - Best Practices. This site offers a wide range of material from top 10 lists suitable for novices to the in-depth technical white papers needed by seasoned professionals.
-
Tips on query normalization with SQL Server 2005
SQL Server application developers to want to normalize the query text returned in a Profiler trace. This allows the performance of a query to be more easily tracked and measured. Ken Henderson shares his insightful thoughts through a blog post on query normalization.
-
SQL Server Hosting Toolkit CTP 1 Released
Microsoft has released the first CTP of its SQL Server Hosting Toolkit. This toolkit is designed to provide support for companies using a hosted SQL Server.