InfoQ Homepage SQL Server Content on InfoQ
-
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.