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