A number of different processes that can be used to make sure your data validates against your business rules. This article discusses how you can use database "check constraints" to validate your data within the SQL Server database engine.
2009-04-10
2,542 reads
Quite frequently I find myself in situation where I need to get detailed information on performance monitor counters. For example I need to determine which processes are consuming all CPU at certain times.
2009-04-09
3,720 reads
Learn how application and full regression testing can ensure a successful SQL Server upgrade – and save on money and performance headaches.
2009-04-09
2,403 reads
Learn how container control flow tasks within SSIS can be used by database developers to provide a structure to a package and repeat control flows.
2009-04-08
1,619 reads
I am new to SQL Server 2005/2008 having administered SQL Server 2000 and below. I have heard there are a lot of new permissions at the database level. What are they and what do they give rights to perform?
2009-04-08
4,866 reads
Learn about the benefits of SQL Server 2008 consolidation on Windows 2008, with details on the different consolidation strategies available to organizations.
2009-04-07
2,707 reads
This short tip shows how you can convert an integer date, such as those stored in msdb to a real datetime value.
2009-04-03
3,612 reads
Although adding multiprocessing capabilities to applications is labor-intensive and error-prone, adding multicore capability to SQL query processing can be automatic, benefiting huge numbers of applications with little developer effort.
2009-04-02
2,311 reads
Recent installments of our series dedicated to SQL Server 2005 Express Edition have focused on error handling techniques that leverage Service Broker's transactional nature. This article describes Poison Message detection characteristics and presents an example demonstrating its use.
2009-04-02
1,585 reads
Too many authors in the field of relational theory have neglected the concept of Cardinal Reciprocity. This can cause a number of subtle problems with database design in terms of its derivability, redundancy, and consistency. . Increasingly, this little-understood aspect of relational theory, that emphasises the cardinality of the attributes of tuples in a relation and the reciprocity with isomorphic foreign key restraints, is becoming a hot forum topic.
2009-04-01
2,846 reads
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
The STIG is detailed, which is a good thing, but I found myself wanting...
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Comments posted to this topic are about the item RegEx Functions III
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Comments posted to this topic are about the item Finely Tuned Models
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers