Many people know how to check which ports SQL Server instances are listening to by using the SQL Server Network Utility or by simply reading the SQL Server error log. But many people seem to forget, or simply don’t know, that UDP port 1434 also needs to be open to ensure that you can correctly acces

(Lisa Vaas) Spending on relational databases slid 6.9 percent, from a total of $7.1 billion in 2001 down to $6.6 billion in 2002, according to a report released Wednesday by Gartner Inc.

Many DBAs find a need for a script to generate object scripts for sql server objects. This short article shows how you can use Transact SQL to generate scripts.

By Phil Howard – Although it may seem a no-brainer today, SQL took some time to get established with by no means all vendors subscribing to the notion of a common database query language as a useful thing. That, remember, is what SQL was originally designed to do – provide set-based query processing

Get security recommendations on Microsoft® SQL Server™ installation, administration, and deployment, and dig into the details of the SQL Server security model. This paper applies to SQL Server 2000 Service Pack 3 (SP3). It is intended for administrators and developers.

It is easy to create a custom control in ASP.NET by deriving a new class from an already existing control. Creating a new ASP.NET control from scratch, on the other hand, is more challenging. When you need a Web server control and none of the existing ones meet your requirements, you can derive from

(Preethiviraj Kulasingham) – If you need to compare the data in two tables — either from the same database or from different databases or even from different servers — this procedure can help. (R)

Data Access Worldwide has announced that the latest revisions of the DataFlex Connectivity Kits (revision 2.2) for MS-SQL, IBM DB2 and ODBC have been released. We encourage developers who are currently using these Connectivity Kits to upgrade to revision 2.2 in order to take advantage of the latest

By Lisa Vaas – Database users who rely on Linux operating systems are drooling over the list of features promised by the soon-to-be-released 2.6 kernel.

by Roger Jennings – The RTM version of SQLXML 3.0 moves from attribute-centric to element-centric XML rowsets and returns DataSet objects from SQL Server 2000 stored procedures.