By Peter Galli – Network software stalwart Novell Inc. is planning to ship a commercial version of the open-source MySQL database, which has been optimized for its NetWare 6 network operating system, by the end of the year.
Tag: sql server
Troubleshooting DTS Problems
In his latest article, Alexander Chigrik presents a checklist of troubleshooting tips to find potential solutions should you have problems working with Data Transformation Services (DTS) in SQL Server.
Replicating data from SQL Server 2000 to Oracle
By Sravan Kasarla – This tip is useful for understanding the replication options between SQL Server 2000 and Oracle 8i databases. It will help DBAs enable the sharing of data in a heterogeneous environment that is a common challenge in most IT departments.
Microsoft steps on three more bugs
By Joe Wilcox – Microsoft issued three security warnings late Wednesday affecting its popular SQL Server database, Windows XP operating system, and Word and Excel applications. The SQL Server flaw, which Microsoft deemed critical, is the most serious of the lot. Exploitation of the flaw would
Configuration errors at the root of most security woes
By Edward Hurley – When looking at the recently released SANS/FBI Top 20 list of Internet security vulnerabilities, one is struck by how many items on the list are related to system configuration mistakes.
SQL Server 2000 Support
Altova has teamed up with Microsoft to integrate support for SQLXML XSD Mapping Schemas for SQL Server 2000 – into the graphical XML Schema editor, which is part of xmlspy® 5.
How to Use ListIndexedColumns in SQL-DMO Using Visual Basic
This article provides an example, written in Microsoft Visual Basic 5.0, that shows how to use ListIndexedColumns with SQL Distributed Management Objects (SQL-DMO).
Microsoft fixes privilege-level flaw in SQL Server
By Gillian Law – MICROSOFT’S SQL SERVER 7.0 and 2000 software both contain a critical flaw that allows low-privilege users to elevate their privilege level and make changes to tasks created by other users, the company said Wednesday.
SQL Server Magazine Goes Digital
By Brian Moran – SQL Server Magazine’s digital version downloads automatically to your computer and opens ready for you to highlight, annotate, and archive. Now all it needs is a reliable Web installer.
Avoiding the Autoclose and Autoshrink Options
In the Microsoft SQL Server 2000 Resource Kit, I read about a procedure that checks all databases for options that you should avoid using. I understand why I should avoid using options such as offline, DBO-use only, statistics off, truncate log on checkpoint, and so on. However, the inclusion of two
