SQL Server contains two kinds of roles: standard roles and applicaton roles. Standard roles function like groups. For standard roles, users are assigned to the roles and then permissions are granted to those roles. Both types of roles can be created using the Enterprise Manager.
Author: SSWUG Research
A Web Services Primer
by Venu Vasudevan – Looking back over the last six years, it is hard to imagine networked computing without the Web. The reason why the Web succeeded where earlier hypertext schemes failed can be traced to a couple of basic factors: simplicity and ubiquity. From a service provider's (e.g. an e-s
W3C Working Draft on Media Queries Supports Single-Source Content for Multiple Devices
As part of the W3C Style Activity, the W3C CSS working group has released a working draft specification for Media Queries that would apply to CSS and HTML. According to the abstract: "HTML4 and CSS2 currently support media-dependent style sheets tailored for different media types. For example, a
MS SOAP Toolkit 2.0 Beta 1: Microsoft's ASP Implementation
SOAP Toolkit 2.0 Beta 1 makes it possible to call services and publish them according to two Application Program Interface (API) levels: high or low. The choice will depend on the characteristics of the SOAP message that you wish to send or the level of monitoring of the service to be called.
Beginning SQL Server 2000 for Visual Basic Developers
This manuscript is an abridged version of a chapter from the Wrox Press book Beginning SQL Server 2000 for Visual Basic Developers. This chapter explores new XML features in SQL Server 2000 and takes a look at how you can exploit them to your benefit. We will also take a look at how we can use XSL (
Advanced Transact-SQL for SQL Server 2000
"Advanced Transact-SQL for SQL Server 2000" by Itzik Ben-Gan (SQL Server MVP) and Tom Moreau Ph.D, published by Apress. Don't let the SQL Server 2000 in the title fool you. There is plenty of information that applies to both SQL Server 6.5 and SQL Server 7.0 in this book. Here is an e
A Brief History of SOAP
by Don Box – It's been a little more than three years since I first started working in XML in general and SOAP in particular. For the past year or so, my own SOAP work has been pretty minimal, mainly because without a stable XML Schema specification, the thought of building tons of SOAP support
Jato: Open Source Java/XML Translator
Andy Krumel recently announced the 'Beta 3 preview release 2' version of Jato, a new library for converting between Java and XML. The preview release contains the initial version of the Jato debugger and improved expression support. With development hosted on SourceForge, Jato is "a GPL
XML & Binary Data
XML solves varieties of problems. Keep in mind that XML is not only for web. It can be used for virtually any kind of application – depends on your imagination. It's best suited to pass data across machines running different platform/operating system, because everybody understands plain text
Performance Tuning Tips for Using Microsoft Access and SQL Server Together
If you are really interested in the fastest performance, don't use Access as a front-end to a SQL Server database. While Access is relatively easy to learn and fast to develop in, its performance if poor when compared to other front-end options. But if you like to develop in Access, or don't