Regular readers of this blog are aware of my current outsourcing assignment. I am managing very large outsourcing project in India. One thing is very special in all Indian offices are “Tea Time.” Everybody wants to attend Tea Time not only for tea or coffee but for the interesting discussion occurs at that time. This is the time when all the department employees are together and discussing whatever they wish.Today there was an interesting discussion about Quality Assurance (QA) and Quality Control (QC).
SQLAuthority News – Book Review – A Practitioner’s Guide to Software Test Design
A Practitioner’s Guide to Software Test Design is one book containing all the important latest test design approaches. This book makes life of software tester very easy. Software tester can find all the information in this book instead of searching through hundreds of books, periodicals and websites.
SQL SERVER – TRUNCATE Can’t be Rolled Back Using Log Files After Transaction Session Is Closed
You might have listened and read either of following sentence many many times. “DELETE can be rolled back and TRUNCATE can not be rolled back”. OR “DELETE can be rolled back as well as TRUNCATE can be rolled back”. As soon as above sentence is completed, someone will object it…
Read MoreSQL SERVER – Mirrored Backup Introduction and Explanation
SQL Server 2005 Enterprise Edition and Development Edition supports mirrored backup. Mirroring a media set increases backup reliability by adding redundancy of backup media which effectively reduces the impact of backup-device failing. While taking backup of database, same backup is taken on multiple media or locations. T-SQL code to take…
Read MoreSQL SERVER – Delete Duplicate Records – Count Duplicate Records Links
I have wrote following two articles for Duplicate Rows Management in SQL Server. SQL SERVER – Count Duplicate Records – Rows SQL SERVER – Delete Duplicate Records – Rows Reference : Pinal Dave (https://blog.sqlauthority.com)
Read MoreSQL SERVER – Object Oriented Database Management Systems
I have received few emails and comments about why I do not write about Object Oriented Database Management Systems (OODBMS). The reason for that is that I am big follower of Relational Database Management Systems (RDBMS) and that particularly of Microsoft SQL Server. If you are interested in reading about…
Read MoreSQLAuthority News – Download Microsoft SQL Server 2000/2005 Management Pack
Note: Download Microsoft SQL Server 2000/2005 Management Pack by Microsoft The SQL Server Management Pack monitors the availability and performance of SQL Server 2000 and 2005 and can issue alerts for configuration problems. Availability and performance monitoring is done using synthetic transactions. In addition, the Management Pack collects Event Log…
Read More