by Brian Lockwood – Learn how to return milliseconds from the SQL Server datetime data type using ADO and VB.
Other News
ANSI JOIN vs. Previous OUTER JOIN Syntax
Q. Can I improve performance by using the ANSI-style joins instead of the old-style joins? A. You will not get any performance gain by switching to the ANSI-style JOIN syntax. However, when you are dealing with outer joins, the old-style JOIN (=* or *=) is not the exact equivalent of the ANSI
Microsoft SQL Server 2000 Resource Kit (With CD-ROM)
This book/CD-ROM kit offers tools, samples, and best practices for using this software. It includes information about core functionality and new features of SQL Server 2000, covering data warehousing, security, failover clustering, scalability, XML, and digital dashboards.
Procedure to create synonyms
(Jaime Alberto Marin Jimenez) This tip will allow you to create synonyms and grant privileges for a user or a user’s group, on one object or all objects from a specific user. You can run this procedure from your system account without connecting to each user. It has been tested on Oracle v8.1.7. (R
Sending E-mails from Oracle Database
In his first article for DBAsupport.com, Amar Kumar Padhi details how to take advantage of an e-mail server option in Oracle 8i that allows you to send mail from within your code.
XML class warfare
By Uche Ogbuji – It seems there is no escaping class warfare. XML is a young society, but it is already succumbing to age-old divisions. The most direct roots of XML are in the processing of text documents, and XML is fundamentally a text-processing format. Many XML users, however, come from backgro
Using OLEDB Templates to Retrieve XML Data Through XPath Query
The Oledbxpath.exe sample demonstrates how to use the ATL OLE DB consumer templates to extract an XML stream for a SQL Server 2000 Databases using an XPath query.
Normalizing XML, Part 2
by Will Provost – In part one of this article, we observed that while XML’s hierarchical model is somewhat at odds with the rectangular structure of relational data, the goals of data normalization as stated in the relational are certainly worthwhile.In this second and final part, we’ll look
Microsoft Preps Next-Gen Database Beta Release
By Barbara Darrow – Microsoft is zeroing in on dates for the beta release of its next-generation SQL Server database, code-named Yukon.The company is working to provide 1,500 customers and partners with the Yukon beta code by February or March, development team members told one analyst.
True DBA Blooper #8: Cleaning up disk drive mess
By Ellen O’Brien – Experienced DBA Peter Gooley had to dig deep in his memory archives to come up with his favorite blunders, mistakes that make him laugh today, but were not so funny then. He shared his two blunders, one that started as a mystery and another that began with bored DBAs playing silly