SQLServerCentral - www.sqlservercentral.com

A community of more than 1,600,000 database professionals and growing

Featured Contents

Featured Script

The Voice of the DBA

Less QA?

Throughout most of my career, people have complained that software is never tested enough, not tested well, and certainly not enough time is allocated in project plans. I'd also argue that all too often we don't have people building software with experience in how to perform extensive testing. Most developers only have a rudimentary knowledge of software testing and that part of their skill set doesn't receive constant training. However I've found plenty of QA people that were in the same situation. Some educate themselves and learn how to test better, but many go through the motions. They don't take pride in their role as a software tester.

There have been lots of advances in automated testing and TDD methodologies over the years, which means that developers have been taking more of the responsibility, and effort, for testing code. It's hard to know if this has resulted in higher quality code, lower quality, or a mix. Overall I think that the latter is likely. Code quality is all over the board, probably based more on the skill and talent of the individual developer than on any process.

That's good for the companies that have hired strong developers, but not so great for our industry as a whole. We still produce lots of software that takes too long to develope, costs too much, and often has too many bugs. Overall we are sloppy and inconsistent in how we build software. Some of that is the nature of our business, one with such a low bar of entry that anyone can give software development a try.

I don't know how we improve the quality of software, though I do think continuing to educate and train people on what works well is a good start. However I also think that we still need QA groups. We need people that will use software in ways that automated tests won't. People that will press buttons, enter values, and push software in ways that developers would never consider using it. Most of all, we need QA and testing to be treated as a valuable part of our industry. We need QA people that view testing as a valid career path, not a stepping stone for junior developers that look to move on as soon as possible.

Steve Jones from SQLServerCentral.com

Join the debate, and respond to today's editorial on the forums


Video and Audio versions

Today's podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.

Follow Steve Jones on Twitter to find links and database related items and announcements.

Steve Jones

Windows Media Video ( 15.7MB) feed

MP4 iPod Video ( 20.2MB) feed

MP3 Audio ( 3.9MB) feed

Feeds are available at iTunes and Mevio

To submit an article, rant or editorial,
log in to the Contribution Center

ADVERTISEMENT
SQL DBA Bundle

‘10 Tips for Efficient Disaster Recovery’

Learn Steve Jones’ disaster recovery lessons, and be better prepared for future disasters, big or small. Read now.

sqlsearch

How do you search your database schema?

"I use SQL Search regularly and think it's great." Gregor Suttie, Senior Software Engineer, Pulsion Technology. Download Red Gate SQL Search while it's free.

sqlinthecity

SQL in the City – Free SQL Server Training the Red Gate way

Red Gate is hosting free seminars and events in the US this summer and fall. Learn about best practices for SQL Server database development and administration from top SQL Server MVPs. Find out more and register

Featured Contents

 

Biml Basics - Level 2

Andy Leonard from SQLServerCentral.com

The next step in the stairway to Biml teaches you how to build a basic SSIS package using the scripting language. More »


 

Biml Workshop presented by Varigence and Linchpin People

Press Release

Business Intelligence Markup Language (Biml) automates your BI patterns and eliminates the manual repetition that consumes most of your time. On October 15th come see why BI professionals around the world think Biml is the future of data integration and BI. More »


 

SQL Saturday #234 Baton Rouge, LA

Press Release from SQLServerCentral.com

SQL Saturday is coming to Baton Rouge for a free day of SQL Server training and Networking on August 3. There is also a pre-conference session presented by Bill Pearson on Practical Self-Service BI with PowerPivot for Excel on August 2nd. More »


 

From the SQLServerCentral Blogs - Generic Dynamic SQL Stored Procedure

Kenneth Fisher from SQLServerCentral.com

Recently I came across a post on http://www.StackOverflow.com that basically asked how to write a generic stored procedure to handle... More »

Question of the Day

Today's Question (by Steve Jones):

DBCC CHECKDB includes which 3 other DBCC checks?

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: Administration.

Did you miss yesterday's question, LEN and CONVERT: answer it now or check out the answer.

We'd love to give you credit for your own question and answer.
To submit a QOD, simply log in to the Contribution Center.

Featured Script

Views created per table

Dukagjin Maloku from SQLServerCentral.com

Hmmm... little code for the procedure to collect all views together with schema info to see how many views using the data from one table!

Short code, one input parameter and that's all you will have the results!

n'joy!

More »

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.

SQL Server 2005 : Administering

unable to connect with default instance - Hi, I have installed sql server 2008r2 enterprise edition on my system.i have got the following errors so uch as 1) unable...

unexpected transaction log growth - Hey all, we are running SQL 2005 Ent. x64 in production. The transaction log of one of the databases suddenly grew...

SP4 installation for SQL 2005 fails - I am trying to install SP4 for SQL 2005 and getting this error below even though I am a system...

SQL Server 2005 : Business Intelligence

Config File Package Configuration - The Scenario is that I am deploying the SSIS packages from test network to production server. The architecture of my...

SQL Server 2005 : SQL Server 2005 General Discussion

sql last batch not updating - Hi , I am running a huge update statement and I am a little confused. (please see the attached). The process...

multiple values from BATCH file - Hi, I am creating a batchfile that calls SQL query in a file the batch contains: [b]SET/P keyid1=Please enter multiple keyids: echo %keyid1% SQLCMD...

create table valued function - i need to create a function passing those two varaibales. How do i do that? Table valued function select DISTINCT bb.level...

How to join multiple tables to show all Exceptions but avoid cartesian product - Hi all, Ive got the following SQL query which takes all the trades from the trade table and joins a number...

SQL Server 2005 : SQL Server Express

After insert trigger not firing - I'm a newbie at SQL, so please go easy, LOL. I have an SQL Express 2008 R2 database that contains...

SQL Server 2005 : SQL Server 2005 Integration Services

Renaming SSIS files - .dtproj, .user, .database, .dtsx, .sln, folder - I'd like to rename these 6 items but don't want to break the package. Is there a prescribed way of doing...

SQL 2008, Unclosed quotation mark after the character string ' COMMIT TRAN'. - ALTER PROC [dbo].[usp_UploadSantam] (@ImportOriginator varchar (50)) AS DECLARE @Headers VARCHAR(1000) DECLARE @x VARCHAR(8000) DECLARE @Maxrows int DECLARE @RowCount int DECLARE @branch varchar(50) DECLARE @UploadID int DECLARE @InsurerID tinyint DECLARE...

Unable to Send Files to FTP Server - Hi, Sorry if the topic already exists. I want to process an excel report and send the file to FTP server....

delete files using ssis - Hi...I want to build an SSIS package that deletes the log files whose names are like Package20081002.txt. The names of...

SQL Server 2005 : T-SQL (SS2K5)

Problem with CTE and filter in Query - Hi, I have this query that if I filter by 'AND [ORG LEVEL 2] like '%ZSW' it gives me the monthly...

help with incrementing - I am not sure if "incrementing" is the right word to describe what I need but here it goes. I...

SQL Server 2005 : SQL Server Newbies

Need urgent help with query - Hello friends, One table (table1) cardno, datetime1, channel_no another table (table 2) cardno, datetime1, channel_no values in channel_no can be either 1 or 2. I...

Barcodes Code128 generator function - I'm looking for a [b]barcode generating Function[/b] (in SQL 2005), that uses the standard [u]Code128[/u]. The result of calling the...

SQL Server 7,2000 : Data Corruption

DBCC CheckDB And Consistency errors in table sys.sysobjvalues - Good day, I've setup a maint job on my SQL 2008 server. (I have not installed SP1 yet) For one of my...

SQL Server 7,2000 : SQL Server Newbies

attempting to recreate complex "multi-layer" Access queries in SSMS - Please excuse me if Im not usung the right terminology. I am a SQL Server newbie and have a basic...

SQL Server 2008 : SQL Server 2008 - General

openquery single quote - Hi All, I have an application which automatically generates SQL - To connect my application to my SAAS database I am...

Opening .dts package from SQL Server 2000 in Visual Studio 2008 - I can't believe I'm having this much trouble with this, but I am stuck. I have a .dts package that...

Catch text before symbol - Hi geniuses, consider: [code="sql"]create table #mytable ( Value varchar(50) ) INSERT INTO #mytable (Value) SELECT 'First.Second'[/code] [b]I need to isolate what's before the symbol: '.'[/b] I was...

Convert Varchar to Date?? - Hi I have a date field stored in a varchar as "Jul 24 2013 8:05AM" I would like to convert to a...

multiple insert from one table depending on the number of rows in another table - Hi I have 2 tables as below which I import to sql server from supplied text files. I would like...

ID and Exclude Top & Bottom 2.5 by Contract - Hi All, I'm trying to filter out my results the top and bottom 2.5 percent records by meeting lengths per...

CheckDB inconsistency error - hello there, I have an issue with CheckDB giving the error below. If DBCC printed error messages, contact your system administrator....

Migrating System Databases Between Clusters - Hi there, I have the need to migrate a 2008 R2 SQL Cluster onto a new site (unfortunately physically moving the...

Non-Pageable Memory - Suddenly got struck in a confusion(I might be wrong too). I will really thank and appreciate any light sheds. AWE is...

Table Partition - Hi All, I have partitioned VOICE_CALL table, size=130 GB(spill-ted into 10 ndf files) But before partition mdf files size 350 GB, After...

configure replication - How to configure replication in different domain ?

SQL Native Client - How can you tell it's being utilised as a connection? - Hi All, Apart from turning it off with all of the associated protocols, how can you tell it's being used? Thanks...

New Quick Search Addin for SQL Server Management Studio 2008/2012 - I have built a free Addin for SQL Server Management Studio 2008/2012 [url=http://sql-hunting-dog.com/]. It is a an instant search on...

Analytical function for my Q - Hi, Is there any analytical function in sql server for achieve results like below: I did this with 2 temp tables, but...

SSIS transferring unprintable characters between systems - We are using SSIS, Transfer SQL Server Objects Task Editor to move data from one SQL Server system to another. A...

Dynamic SQL Unpivoting and re - Pivoting seems overly complicated... - Hi All, It is fairly common where we work to have a questionnaire output in the form of two tables, one...

Email to Mutiple users with different subject i.e Subject variable - Hi, I stuck in a weekly report which i have to send to every user for their access. i want to send...

indentifing the spid - i would like to find the spid of the long running job with a query ? can any one send me...

Question about user and login - Hello I created new login and new user to exists login. Next step is log to database with created username database...

moving log files - Hi, I'm quite new to this SQL admin stuff. I need to move all the log files(user and system databases) on several...

Find and update the Schema changes of a table? - Hi Friends, I have around 25 tables where i am frequently using to put the data from live server to...

SAN disk size expansion - Hi, We were trying to expand SAN disk size more than 2 TB as part our requirment. But it failed due...

Conditional print for testing scripts. - Dear Reader, For testing I want to replace PRINT statements with a procedure call. A Global substitute should replace all 'PRINT' with...

Update table values if corresponding values change in another table - Hi, I am very new to SQL and really dont know how to phrase my question. There are 2 tables linked...

Handy and Simple tool for SSMS 2008 R2??? - Hello, I was wondering why SSMS does not have the standard builtIn plugin Quick Math (for example: sum, avg, max, min)....

SQL Server 2008 : T-SQL (SS2K8)

Email Step Logs Concatenated - Hi, I am fairly new to SQL Server, but I wanted to ask a question about step logs and email. I...

Salesman Running Totals by Date problem... - Hi All, SQL Server 2008. I have the following problem I need to try and solve... I have a list of salesmen and...

trigger to avoid disable or delete a job - Hi Friends, Let us assume that I have given SQLAgentOperator role to XXX Login. He has full permission of deleting a...

Find the last 6 Tuesdays or Wed or Whatever day. - I have a sales report that shows the previous days sales. I need to modify to a rolling report that...

Find the first record for each month - I'm trying to pull out the file size and backup size for each database using the msdb backup history table....

Update all but last two rows of each category - I would like to update the complete flag of all the rows of a table except the most recent two...

Select variable based upon sub query - I have the following SQL statement (It's actually MYSQL but the principal is the same ;-) ) that selects all the values...

Change sub query variable based upon sub query - I have the following SQL statement (It's actually MYSQL but the principal is the same ;-) ) that selects all the values...

Limit when a trigger runs - Is there any way to limit the trigger, so that it only runs when the app is a .Net SqlClient...

CAN ANY ONE WRITE QUERY FOR BELOW DESCRIPTION! - 345 0 Test Lane 0 0, Binder, CA 00002 (MLS ID: PD1LST32) 6 N Training Road 0, Binder, CA 00006 (MLS...

SQL Server 2008 : SQL Server Newbies

SQL Server 2005 and SQL Server 2012 - About start Project with upgrade to IPv6. Need advice on how SQL Server is affected to the 2005 and 2005...

need help with applying function within Query - Hi all Its my first post here! Glad to be here.Hopefully someone can help me with the following. If you look at...

% of participants that are retained - I am a school teacher very new to MS SQL server. Everyone is suggesting to try this site out. Here...

PRIMARY KEY VS UNIQUE KEY* - Hi everyone, Does anybody know any cases/example that we need to use UNIQUE KEY instead of PRIMARY KEY? I understand that...

Eager Spool - Dear All I am deleting rows from huge table. I am doing it in the batch of 1000 rows. This tables...

SQL Server 2008 : SQL Server 2008 High Availability

Very slow for running Query in Standby database? - Hi. Log shipping setup on of the table total Records count 1228976 in standby database, user have read access and using...

Transactional Replication Sloooow - Hi I have setup transactional replication between two sql 2008 instances and it is very slow in replicating. We have some jobs...

Splitting and shrink a Windows Volume without Cluster's downtime? - Ok. Got a quick question, maybe for Perry or whoever can clarify. Got a SQL 2012 failover instance running on Windows 2008...

SQL Server 2008 : SQL Server 2008 Administration

Monitoring performance after index deployment. - I am trying to figure out how to monitor performance of the database before and after deploying an index. Are...

How to give users access only to certain columns of certain tables in a database? - Hello, I am new to SQL Server 2008 administration and I have been asked to give a user access to only...

Install BIDS only - Our full MSSQL install file is 64 bit which prevents me from installing any components onto a 32 bit desktop. How...

Career : Employers and Employees

Client does not want to pay overtime. How to deal with it ? - I am hourly-paid employee of a consulting company, but work all the time at client site. Sometimes I have to...

SQLServerCentral.com : Anything that is NOT about SQL!

Who administers the SQL Backups in your company - Recently, our company has decided to go with CommVault as an enterprise backup and archiving solution. As a result, a...

Today's Random Word! - HI When you woke up today, or logged-onto Opera Forums, you may have had a dream, a thought, a scene...

Are the posted questions getting worse? - Is it me, or are the posted questions getting worse these days? I just read a post by someone apparently in...

Reporting Services : Reporting Services

nested IIF for font color - Hi I must have something missing unless I can't use IIF for font color? [b] iif(ReportItems!Textbox26.Value >0, "Red",iif(ReportItems!Textbox26.Value < 0, "Green","Black") ))[/b] Thanks In Advance Joe

Subscription email failure (MHTML) - Hi Everyone, Need some help on some strange behavior... I'm moving some existing (and working!) SSRS reports from a 2008 R2 install...

Help! MDX > 8.000 characters - Hi all, I have a complex MDX that was build within the front-end-tool our users use. Now I want to include...

SSRS Excel export with miscellanious error. - I have a simple tablix report built with SSRS 2008 R2. When I export the results in the Excel format...

Data Warehousing : Integration Services

DTS package conversion to SSIS - I'm fairly new at my position and one of the first assigned tasks was to convert an older DTS package...

Data Warehousing : Analysis Services

Dimension merge after migration - Hi, I'm going through a process of moving all our Cubes\DB's from SQL2000 to SQL2008 R2 (both SQL Server & SSAS)....

User defined heirchy levels and Excel Pivot Table - SSAS 2008 R2 Excel 2010 In SSQL Management Studio connected to an SSAS instance i am able to browse a cube. I...

To be removed from this list, please click here.
If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com.
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.
This transmission is ©2013 Red Gate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com