I've never had to work full time in a QA group, but I have had to perform software testing of an application and it wasn't fun. Even as I worked through the various features, looking for edge cases, common mistakes, etc., I realized that running tests was something that really required more discipline and process than I was giving it at the time. Too often I 'd realize that my regressions weren't 100% duplicates of previous executions because I'd allowed too much "human effort" into my process.
These days most testing of software is automated. I know QA groups still exist, and they need to handle some of the manual checks that are very hard to automate. However more and more testing is being pushed back onto developers to handle, with frameworks like NUnit and JUnit. In the database world, we haven't done a great job of including testing into the code we write, but there's a great testing framework we can use.
TSQLT is a framework written by Sebastian Meine and Dennis Lloyd and it's free. It's been developed to help you write tests that can exercise your T-SQL code to determine if it's doing what you expect. I've used it a little, and while I see the potential, I also realize that this will take some practice to learn how to more easily write tests that can cover the various potential places where bugs can be introduced.
However, if you use version control, and you should, then you can easily spread the load of writing tests to all of your developers. Since the tests are stored procedures, they can be included in your VCS project and shared by all your developers. With a little effort from each member of your team, you might be surprised at the code coverage you can achieve with this framework.
Testing is important, as we see over and over again as software is released and doesn't work as expected. I think much of that is our fault, as software developers, for not improving our testing skills and discipline.
Join Red Gate for a free seminar on November 15 (the day before SQL Saturday Oregon). Steve Jones and Grant Fritchey, SQL Server MVPs, will present best practices for SQL Server version control, continuous integration and deployment, in addition to showing Red Gate tools in action. More »
This tip will guide you through a simple example to illustrate how you can use the SQL Server Distributed Replay feature to replay a simple SQL Server trace file that contained two sessions executing statements concurrently. More »
Microsoft keeps sneaking little things under the door for Windows Azure SQL Database. This time it’s a couple of new... More »
Question of the Day
Today's Question (by Mike Hays):
In SQL Server 2008 and beyond, automatic page repair is supported by database mirroring and by AlwaysOn Availability Groups. Which three page types can the page repair process not automatically repair?
Think you know the answer? Click here, and find out if you are right.
We keep track of your score to give you bragging rights against your peers.
This question is worth
1 point in this category: High Availability (HA).
We'd love to give you credit for your own question and answer.
To submit a QOD, simply log in to the
SQL Server 2012 Integration Services Design Patterns is a book of recipes for SQL Server Integration Services (SSIS). Design patterns in the book show how to solve common problems encountered when developing data integration solutions. Because you do not have to build the code from scratch each time, using design patterns improves your efficiency as an SSIS developer. In SSIS Design Patterns, we take you through several of these snippets in detail, providing the technical details of the resolution. Get your copy from Amazon today.
Yesterday's Question of the Day
(by Amit Raut):
What are the analytical functions available in SQL Server 2005? (Select 4)
ROW_NUMBER(), NTILE(), DENSE_RANK() and RANK() are the only analytical functions available in SQL 2005.
bulk export of xml column
- with reference to http://technet.microsoft.com/en-us/library/ms191184.aspx
res\db_features\bulk_import\examples_of_bulk>bcp practise..xTable out a-wn_x.out
-x -T -S user-PC\sqlexpress
Enter the file storage type of field xCol [nvarchar(max)]: varybin
BULK import of binary in xml column
- from http://technet.microsoft.com/en-us/library/ms191184.aspx
D. Specifying the field terminator explicitly using a format file
Sample Data File
FF FE 3C 00 3F 00 78 00-6D...
Behaviour of CONVERT with GETDATE() !!!
- [size="1"]select dateformat from sys.syslanguages where name = @@LANGUAGE
Above are the stats at the time of creating this post.
Split function in sql
- Hi ,
I need the store procedure which i need to get the comma seperator values result in different columns and...
SQL Report Builder
Not sure where to put this...
Im working in SQL Report Builder (sorry dont know which version) and am having trouble...
XML Export File
- Hi Friends,
The below i have mentioned the sample data and Table structure
[code="sql"]CREATE TABLE [dbo].[Xml_Export](
[City] [nvarchar](200) NULL,
[Company] [nvarchar](300) NOT NULL,
- Hii Guys
what are Isolation Levels ? how to apply various isolation levels and please give me a detailed information in understanding...
- Hi all,
I've had a trawl through the forum but can't find anything that will help although I'm sure this isn't...
Updating ID field
I have a table:
CREATE TABLE [dbo].[FIM_GLOBAL_ID](
[GlobalID] AS ('RH'+right(''+CONVERT([varchar],[ID]),(10))),
[ID] [int] IDENTITY(100100,1) NOT NULL,
[FirstName] [varchar](50) NULL,
[LastName] [nvarchar](50) NULL,
[PreferredName] [varchar](50) NULL,
[DisplayName] [varchar](50) NULL,
This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.