Welcome to SQL Server Magazine’s monthly, Web-only series of SQL Server tips brought to you by the Microsoft SQL Server Most Valuable Professionals (MVPs). Here are a few of the questions being answered: How do you copy permissions from a user to a database role or vice versa?How do y
Community
SQL basics: SELECT statement options
In the last article, we covered some database terminology and looked at the four basic data query types. We also explained the WHERE clause and conditional statements and provided examples of the various query types.In this article, we’ll pick up where we left off with some additional functi
Oracle prepares pricing guide
By Joris Evers – Oracle plans to release a pricing guide later this year to clear up confusion among users about its licensing policies, an executive of the Redwood Shores, Calif., software maker said Tuesday.
Microsoft says .NET will impact Internet’s evolution
BY: Catherine Ketcher – In his keynote speech at last Thursday’s DCI Microsoft .NET and Solution Offerings conference, Dan’l Lewin, a Microsoft executive vice president, called .NET the software that will connect information, people, devices and systems.The building blocks for successful Int
XML security who’s who
By Shelley Doll – When a standard is deployed as openly as XML, businesses are bound to have security concerns. The need to control content’s distribution and ensure its integrity keeps many companies from deploying XML without an extranet. Proposed standards will address security issues, and these
New Book: Definitive XML Application Development
Prentice Hall has released Definitive XML Application Development, by Lars Marius Garshol. The book details application development that uses XML, focusing on Python in most of the examples.
XML Finds Its Voice
By Jim Wagner – The voice browser working group of the World Wide Web Consortium (W3C) gave its seal of approval Wednesday for further consideration and testing of a voice XML standard.
Altova’s XML Spy 4 Suite Earns Web Services Journal Readers’ Choice Award
Altova, Inc. (www.xmlspy.com), the leading producer of XML and Web Services editing tools, announced that their XML Spy 4 Suite was selected as the best Web Services Training Tool in the Web Services Journal Readers Choice Awards competition.
Enforcing Association Cardinality
by Will Provost – In this article, we’ll practice a bit of that merciless science. Specifically, we’ll look at ways to control the cardinality of associations between XML elements. The basic implementation, which we’ll review momentarily, of an association between two types is simple enough but is o
Copy Archive Logs
This script will copy archived redo logs to a secondary standby destination for an NT database.