(Andy Warren) If you don’t have to deal with case sensitivity, count yourself lucky! SQL 2000 is much better than SQL 7 with regard for collations, supporting collations at database, table, and column level. In this article I’m going to delve into a interesting (or obvious?) item I noticed recen

(Ben Forta) In this lesson, you’ll learn what transactions are and how to use COMMIT and ROLLBACK statements to manage transaction processing.

(RudolfH) Indexes in any modern relational database system are important but perhaps even more important is how you make use of them. With Yukon the functionality and features around indexes have become magnitudes better. Take a look at the following list of index related enhancements: 1. Disabli

In Microsoft SQL Server 2000 Service Pack 3 (SP3), when you pass a distributed query to the @query parameter of the xp_sendmail stored procedure or the sp_makewebtask stored procedure, the procedure may fail and you may receive the following error message: Server: Msg 7410, Level 16, State 1,

(Krishna Sonti) A Linked Server is a Link to an external (remote) data source. The remote data source can be Oracle, Access, Excel or any other data source that uses an OLE DB provider. (R)

In Report Designer, if you use a graphical user interface control such as the Refresh Fields button in the Data view of a report, and you try to update the fields of the dataset of the report, you may receive an error message that is similar to the following: Could not generate a list of fields f

(Tom Rizzo) When companies first started deploying databases, internal security was the biggest concern for IT departments. Databases were locked down in a datacenter with limited access via discrete applications and most IT administrators were only worried about internal users accessing confidentia

(Bren Newman) Managing a distributed database system presents many challenges, not the least of which is the need to quickly synchronize updates. Transactional replication and merge replication are well-known, effective replication techniques, but each has limitations and can limit performance.

(Jeffrey Yao) As a DBA, I am often required by clients to look into a database “created by a previous DBA who has left the company”. Among various jobs, one is to document the table relationships in the database because “the original documents are not updated to reflect the current status of the dat

(Darren Green) There is often some confusion about the real value of a global variable at run-time, or the current execution location and security context. This simple script will illustrate what is really going on. When trying to debug a package and isolate the problem, it is not always practic