Exclusive Sneak Peek: Testing the Database
by Andy Leonard
With the introduction of Visual Studio 2005 Team System (VSTS), Microsoft for the first time offers software developers and test engineers a complete and integrated suite of tools for software testing. And the new Wrox book Professional Software...
Read More...
DTLoggedExec: Don’t Work with SSIS Without It!
Solid Quality™ mentor and Microsoft SQL Server MVP Davide Mauri recently released an enhanced version of DTLoggedExec, a free tool that logs detailed information about SQL Server 2005 Integration Services (SSIS) execution status and package...
Efficiently Querying and Calculating Using SQL Server Date/Time Columns
by Adam Machanic
The central goal of any database system is to allow the user to query the data to answer business questions, and the most important of these questions always involve dates. Querying date/time data in SQL Server has some interesting pitfalls...
A T-SQL Regular Expression Library for SQL Server 2005
by Steve Abraham
With the advent of CLR integration into SQL Server 2005, it has become incredibly easy to extend the power of the T-SQL programming language. Two of the areas that can be improved upon by way of CLR integration are string matching and...
Accessing the SQL Server Virtual Device Interface via .NET (C#)
The virtual device interface of SQL Server allows developers to define "virtual devices" for SQL Server to backup and restore databases and transaction logs. Having access to these virtual devices gives you access to the raw data that is passed into...
by Ken Spencer
These days, many shops are evaluating commercial automated build systems and investigating how to create the custom extensions that you often have to develop to fit these solutions to your needs. Automated build systems are key to...
Solid Quality Learning is being re-branded as Solid Quality Mentors
Listen to Douglas McDowell, Director of BI, interviewed by the B-Eye Network about who “Solid Quality Mentors” is and how it is different than our past name Solid Quality Learning. Download the podcast here.
by Itzik Ben-Gan
A common comment from students who’ve taken my course “Advanced Transact-SQL Querying, Programming and Tuning for SQL Server 2000 & 2005” is that they didn’t realize how much they didn’t know about T-SQL. Although I...
