Sql Server Xquery
|
|
XQuery $39.99 With the XQuery 1.0 standard, you finally have a tool that will make it much easier to search, extract and manipulate information from XML content stored in databases. This in-depth tutorial not only walks you through the XQuery specification, but also teaches you how to program with this widely anticipated query language. XQuery is for query writers who have some knowledge of XML basics, but not necessarily advanced knowledge of XML-related technologies. It can be used both as a tutorial, by reading cover to cover, and as a reference, by using the comprehensive index and appendixes. Either way, you will find the background knowledge in namespaces, schemas, built-in types and regular expressions that is relevant to writing XML queries. This book provides: A high-level overview and quick tour of XQuery Information to write sophisticated queries, without being bogged down by the details of types, namespaces, and schemas Advanced concepts for users who want to take advantage of modularity, namespaces, typing and schemas Guidelines for working with specific types of data, such as numbers, strings, dates, URIs and processing instructions A complete alphabetical reference to the built-in functions and typesYou will also learn about XQuery’s support for filtering, sorting, and grouping data, as well as how to use FLWOR expressions, XPath, and XQuery tools for extracting and combining information. With this book, you will discover how to apply all of these tools to a wide variety of data sources, and how to recombine information from multiple sources into a single final output result. Whether you’re coming from SQL, XSLT, or starting from scratch, this carefully paced tutorial takes you through the final 1.0 standard in detail. |
|
|
Xquery $35.39 With the XQuery 1.0 standard, you finally have a tool that will make it much easier to search, extract and manipulate information from XML content stored in databases. This in-depth tutorial not only walks you through the XQuery specification, but also teaches you how to program with this widely anticipated query language. XQuery is for query writers who have some knowledge of XML basics, but not necessarily advanced knowledge of XML-related technologies. It can be used both as a tutorial, by reading cover to cover, and as a reference, by using the comprehensive index and appendixes. Either way, you will find the background knowledge in namespaces, schemas, built-in types and regular expressions that is relevant to writing XML queries. This book provides: A high-level overview and quick tour of XQuery Information to write sophisticated queries, without being bogged down by the details of types, namespaces, and schemas Advanced concepts for users who want to take advantage of modularity, namespaces, typing and schemas Guidelines for working with specific types of data, such as numbers, strings, dates, URIs and processing instructions A complete alphabetical reference to the built-in functions and types You will also learn about XQuery’s support for filtering, sorting, and grouping data, as well as how to use FLWOR expressions, XPath, and XQuery tools for extracting and combining information. With this book, you will discover how to apply all of these tools to a wide variety of data sources, and how to recombine information from multiple sources into a single final output result. Whether you’re coming from SQL, XSLT, or starting from scratch, this carefully paced tutorialtakes you through the final 1.0 standard in detail. |
|
|
Pro SQL Server 2008 XML $59.99 Knowledge and ability to apply XML are de rigueur in today s world, and SQL Server developers and administrators are no exception to that rule. Pro SQL Server 2008 XML is your key to unlocking the powerful XML feature set first introduced in SQL Server 2005 and since refined in SQL Server 2008. Author Michael Coles shows how to store XML using SQL Server s built in XML data type. Learn to query and manipulate XML data using standard technologies such as XQuery and XSLT. No SQL Server database professional can afford to be without knowledge of the XML feature set. Pro SQL Server 2008 XML delivers on the knowledge that you need to remain competitive in your career. * Shows how to store, query, and manipulate XML documents in SQL Server * Provides step by step examples showing best practices and advanced features * Accurately discusses how SQL Server s XML feature set stacks up against the ISO XML standards |
|
|
Beginning Mark Logic with Xquery and Marklogic Server $45.77 This book, Beginning MarkLogic with XQuery and MarkLogic Server, is one that will enable you to start using this exciting technology quickly. You will learn essential techniques and functions for using XQuery and MarkLogic Server. Each chapter is carefully structured so that it takes very little time to learn and master. The chapters in the XQuery section contains hands-on code examples that you can practice as you are reading it. This book helps you to understand the technology and how to work with it, and gain confidence so you can succeed in your real work environment. MarkLogic chapters cover fundamental knowledge in MarkLogic Server architecture, search, thesaurus, lexicons, spelling, geospatial functions, creating alerts, error handling, and how to work with MarkLogic documents and databases. XQuery chapters covers essential XQuery skills such as working with XML documents from various locations, predicates, data types, string manipulation, working with numbers, date and time, grouping, sorting, navigating within the XML document, and good programming practices. This book is an introduction to MarkLogic Server and XQuery. The content of this book is designed for the reader who has no knowledge of MarkLogic Server and XQuery. We hope this book will help our readers to acquire some essential skills and knowledge so they can become comfortable working with these technologies. We simply assume readers have some basic knowledge about XML to understand the examples in these chapters. This book is not intended to help readers who have already worked with MarkLogic Server and XQuery for a while. Most information in this book is focused on the very basics. The materials in this book also place more emphasis on development than administration. |
|
|
Inside Microsoft SQL Server 2008: T-SQL Programming $39.99 Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database developers and administrators get best practices, expert techniques, and code samples to master the intricacies of this programming language—solving complex problems with real-world solutions. Discover how to: Work with T-SQL and CLR user-defined functions, stored procedures, and triggers. Handle transactions, concurrency, and error handling. Efficiently use temporary objects, including temporary tables, table variables, and table expressions. Evaluate when to use set-based programming techniques and when to use cursors. Work with dynamic SQL in an efficient and secure manner. Treat date- and time-related data in a robust manner. Develop CLR user-defined types and learn about temporal support in the relational model. Use XML and XQuery and implement a dynamic schema solution. Work with spatial data using the new geometry and geography types and spatial indexes. Track access and changes to data using extended events, SQL Server Audit, change tracking, and change data capture. Use Service Broker for controlled asynchronous processing in database applications. All the book’s code samples will be available for download from the companion Web site. |
|
|
Foundations Book II: Understanding SQL Server 2005 Supporting Technology (XML, XSLT, XQuery, XPath, MS Schemas, DTD’s, Namespaces). $34.72 … |
|
|
Foundations Book II: Understanding SQL Server 2005 Supporting Technology (XML, XSLT, XQuery, XPath, MS Schemas, DTD’s, Namespaces). $34.73 … |
Thwart the Three Biggest Internet Threats of 2007
The same Internet connection that lets you reach out and touch millions of Web servers, e-mail addresses, and other digital entities across the globe also endangers your PC and the information it contains about you. Here's how to stymie the three gravest Internet risks.
Threat1: IE
Internet Explorer heads the list of top Internet security attack targets in the most recent joint report of the FBI and security organization SANS Institute.
One reason: As the most widely used browser, IE provides the biggest payoff for malicious hackers who set out to exploit its flaws. The biggest problem with IE is its reliance on Microsoft ActiveX technology, which allows Web sites to run executable programs on your PC via your browser.
Security patches and upgrades, including Windows XP Service Pack 2 and the recently released IE 7, make ActiveX safer, but the inevitable flaws that allow malware to circumvent those security measures--combined with the reality that we computer users are often a credulous lot--make ActiveX a risk not worth taking.
Happily, with very few exceptions (such as Microsoft Windows Update site), you can browse the Internet effectively without ActiveX.
To disable ActiveX in IE 6 and 7, choose Tools, Internet Options, Security, Custom Level, scroll to 'Run ActiveX controls and plug-ins, and select Disable.
Click OK, Yes, and OK to close the dialog boxes. To enable ActiveX on a known and trusted site, click Tools, Internet Options, Security, choose Trusted Sites, click Sites, enter the site address in the text box, and click Add. Uncheck Require server verification (https:) for all sites in this zone, and click Close and OK.
If you leave ActiveX enabled, you may quickly encounter malware-harboring sites and e-mail attachments that ask you to let them install their ActiveX controls on your system. Unless you are 100 percent certain that the control is safe and legitimate, do not allow it.
Regardless of which browser is set as the default on your system, always keep Windows (and IE) updated to minimize your risk.
To keep Windows XP up-to-date, visit update.microsoft.com (you will have to use Internet Explorer) and install Service Pack 2, if you have not already. Next, choose Start, Control Panel, System, and click the Automatic Updates tab.
Select Automatic (recommended) If you trust Microsoft implicitly, Download updates for me, but let me choose when to install them if you trust the company a little bit, or Notify me but do not automatically download or install them to play it safest. (Click "Do not Let a Windows Update Bring You Down" for more on Windows updates.)
Whichever option you choose, click OK to download and install the most recent security patches.
If you stick with IE, upgrade to version 7, which improves ActiveX security. Still, the best way to reduce your PC vulnerability to ActiveX exploits is to download and install another browser, and set it as your default browser.
Mozilla Firefox is the most popular IE alternative. Unfortunately, Firefox growing popularity has enticed malware authors to exploit its own flaws. While no software is perfectly secure, many experts think the Opera browser is safer than either IE or Firefox.
Threat 2: Phishing and Identity Theft
You have probably seen your share of phishing attacks, which look like communications from your bank, PayPal, eBay, or another online account. The message may ask you to click a link that leads to a bogus Web page, complete with realistic user-name and password log-in fields, or it might ask for a credit-card number.
The fake address often resembles the real institution URL--'citibank.fakesite.com' in place of 'citibank.com', for example. The phishers site and e-mail message may even load images from your bank, or have links to the institution own Web site.
When you take the bait, the phisher harvests your data, and either sells it to someone else, or uses it to drain your account right away. A variant called spear phishing identifies you by name in the lure message or Web site, making the sham even harder to spot.
You may have read that your bank will never send you an e-mail asking you to log in to your account, and it should not, though it does happen on occasion. The vast majority of messages that appear to come from financial institutions are phishing attacks, so assume that such messages are bogus and avoid opening them at all, let alone clicking any links they contain.
If you are concerned that the bank or other service is really trying to notify you of a problem with your account, open your browser manually and log in to the site directly, or better yet, pick up the phone and call a customer service agent (if you can find one via the bank automated phone system).
The place you are most likely to notice that your credit card or bank account has been compromised by a phishing attack or identity theft is on the statement you receive from them via mail. Check it carefully for unauthorized charges, and report any to the institution immediately.
IE 7 asks you a couple of times if you had like to enable its phishing filter during installation; say yes. To enable this feature, choose Tools, Phishing Filter, Turn On Automatic Website Checking, and click OK.
Firefox 2 phishing filter is enabled by default, but it uses a static downloaded list of known phishing sites. Many firewalls and other security programs include identity-protection features that scan the stream of data leaving your PC for sensitive information, such as passwords or social security and credit card numbers, and then block the unauthorized transfers.
Resist the temptation to post personal information on your Web page, blog, or social site (Facebook/MySpace) account. Identity thieves, spammers, and online predators are always on the lookout for such data. Browse to "Safeguard Your Reputation While Socially Networking" for an explanation of the risks to both adults and children, and for tips on what you can do to avoid the dangers.
Threat 3: Malware
Every day, virus, spyware, and adware creators come up with new, ingenious ways to gain access to your PC.
These steps will help keep you safe:
Think before you click.Use a spam filter. Update your antivirus software.Download with discretion.Use a bidirectional firewall.Use antispyware.Cher K Markov articles on various subjects and has a treasure chest of information and resources onSoftware Downloadsat http://online-downloads.blogspot.com
Article Source: http://www.simplysearch4it.com/article/52135.html
|
|
Beginning XML Databases $39.99 Supported by all major database systems, XML provides an easy, standardized method of transferring data between databases and to and from the Web, independent of the software in useOffers database programmers and data-driven Web developers detailed guidance on how to understand and work with XML as dataNumerous hands-on, step-by-step examples help readers learn to simplify database work using XMLShows how to use XML to exchange data between multiple databases either internally or with external customers and partnersCovers XML in popular databases including Oracle Database, SQL Server, and brief coverage of DB2 DatabaseCovers basic syntax for XML, the XML DOM, and XSL - with an emphasis on database use, and native XML databasesAdditional topics covered include Native XML databases, XPath, XQuery, XLink, XPointer, DTDs, XML Schemas, among others |
|
|
Beginning XML Databases $5.64 The union of XML and relational databases creates a powerful tool with the ability to transfer information between two completely unrelated databases. With this book, veteran author Gavin Powell shows you how this confluence of two technologies can simplify your database work and provide a more standardized way to exchange data between multiple databases and web sites.You'll get an in-depth look at specific XML datatypes that are considered the most critical alliances between XML and a relational database. Plus, an introduction to the basics of SQL and numerous XML standards prove to be essential so that you can grasp database structure and comprehend how XML is used with the Oracle® and SQL Server relational databases. Throughout the book, valuable exercises and a surfeit of step-by-step examples will help you get an overall understanding of the topics at hand.What you will learn from this bookThe platform independence capability that comes from using XML— including independence from database vendorsThe basics of XML, XSL, the XML DOM, and SQLXML datatypes and features in Oracle Database and SQL ServerHow to move data anywhere using XML (B2B)Ways to read XML documents using XQuery and navigate documents using XPath®XML, the object data model, native XML databases, and industry applications of XMLWho this book is forThis book is for anyone—from novice to expert—who is interested in learning the details of XML and database technology as applied to both XML and relational database technology, working together.Wrox Beginning guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved. |