In this article, Andy Warren presents his views on why obtaining certification is not a good idea. Read this one and the one by Steve Jones that supports certification - which has the more compelling argument
Steve Jones presents his case for why certifications should be required. Read this and the counter point article by Andy Warren to hear the other side of this argument - then post your comments
The XML features of Microsoft® SQL Server® 2000 and the subsequent XML for SQL Server 2000 Web releases enable a whole new class of XML-aware applications. This article shows you how to improve the performance of this new feature.
In this product review Andy takes a look at Data Compare, the second of three products in the SQL Bundle available from Red-Gate software. It's a very handy program that lets you compare data between two tables and optionally generate sql statements to syncronize the data. An interesting alternative to replication!
One of the largest security "issues" in SQL Server 7.0 is that a user must be in the SysAdmin role to run the BULK INSERT command. This article by Paul Ibison shows you a workaround.
This article examines how index statistics are used in SQL Server 6.5
Microsoft® SQL Server 2000 introduced several new features for querying database tables and receiving the results as an XML document. Web release 1 of SQLXML (XML for SQL Server) added Updategrams and XML Bulk Load functionality, as well as a host of other features to the SQL Server 2000 base.
One of the most pain-staking tasks a developer and DBA must often accomplish is to create an install procedure for the database. This involves creating the necessary DDL to create the tables, relationships and indexes. Inevitably in this process you forget about the data. AutoInserts to the rescue!
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Vidalista is a trusted platform to purchase Vidalista tablets, a popular and effective treatment...
Comments posted to this topic are about the item DML Trigger Types
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
How many types of DML triggers are there?
See possible answers