Q. How can I turn an IP address held as strings into binary values? A. With SQL Server 2000, you can use the following function:
Author: SSWUG Research
Microsoft To Debut Step-Up License Program For Server Software
By Joseph F. Kovar & Paula Rooney – Microsoft has doled out another change to its Software Assurance maintenance policy designed to ease the financial burden on those who wish to move from standard editions of Windows and application servers to enterprise servers. At Gartner’s Software Asset
Oracle Offers New PLM Tools
By Renee Boucher Ferguson – Product lifecycle management users and project management managers are getting a boost this week with new functionalities from Oracle Corp.At its AppsWorld London conference Oracle, of Redwood Shores, Calif., announced Tuesday the availability of its Oracle Advanc
Rainbow-colored Relax NG
Hans Fugal has released a Vim syntax highlighting file for Relax NG compact syntax (RNC). It joins a couple of other options available for working with and viewing syntax-highlighted RNC schema instances: an Emacs mode and a set of stylesheets for generating HTML versions of RNC schemas.
What admins need to consider in advance of Yukon
By Margie Semilof – At the TechEd conference earlier this month, IT executives picked up a few details about Microsoft’s database strategy. First, the company said it would add reporting services for SQL Server 2000; they will appear sometime later this year. And, second, officials said that Microso
Oracle: The Database Comes First
by Demir Barlas – In a keynote entitled, “Spend Less, Know More,” delivered at Oracle AppsWorld in London, Oracle CEO Larry Ellison regaled listeners with his vision of IT’s past and future. Ellison believes that most companies have spent years overspending on IT, and wasn’t shy to include hi
Online Exam using XML & ASP
by Mohamed Najeeb – This week we’re bringing you an online exam system that pulls it’s data from an xml file on the server. The question list for the user is sent to the browser via Microsoft’s XMLHTTP Object. Using this same object, the questions are retrieved from the server and displayed on the p
Bind XmlDocument Objects
by Dan Wahlin – Normally, you can’t bind an XmlDocument object directly to a control. But with just a few extra lines of code, you can convert it to a DataSet for the same result.
Control Replication with ActiveX
By Jeannine Hall Gailey – When you use ActiveX controls along with the administration functionality that SQL-DMO provides, you can programmatically administer, customize, and control an entire replication topology.
Book Review: SQL Server 2000 Fast Answers for DBAs and developers
Review by Vyas Kondreddi – This book is completely focused towards helping aspiring DBAs and database developers. It has answers for all those questions that generally trouble a budding DBA. Shows you how to setup an SQL Server, administer it, secure it and develop database code.