by Brian Lockwood – Learn how to return milliseconds from the SQL Server datetime data type using ADO and VB.

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

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.

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.

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

Marcin Policht’s latest article in the ‘SQL Server Management with WMI’ series continues a discussion on using Windows Management Instrumentation (WMI) for managing SQL Server and includes sample scripts for several SQL Server and database maintenance tasks.

By Gary Zaika – Information about setting up server-requested SSL encryption in a clustered SQL Server environment is hard to come by. But these clear steps pave the way to a straightforward implementation.

by Brian Lockwood – Stored Procedures offer an opportunity to improve your database security. By denying read (SELECT) and write (INSERT, UPDATE, and DELETE) access to all database tables and providing only EXECUTE privileges to your stored procedures, you can ensure that your data can be accessed i

When your business outgrows your database systems, using globally unique identifier (GUID) values in Access and SQL Server can offer a timely solution.

By Joe McKendrick – They’re big, and they’re getting bigger. New statistics out of Winter Corporation – an analyst firm that tracks database size on an annual basis – find that databases are poised to hit the 100-terabyte mark within the next two years. Remarkable, considering that just a year ago,