If you need to parse or process text data in Linux or Unix, this useful book explains how to use flex and bison to solve your problems quickly. flex & bison is the long-awaited sequel to the classic O'Reilly book, lex & yacc. In the nearly two decades since the original book was published, the flex and bison utilities have proven to be more reliable and more powerful than the original Unix tools. flex & bison covers the same core functionality vital to Linux and Unix program development, along with several important new topics. You'll find revised tutorials for novices and references for advanced users, as well as an explanation of each utility's basic usage and simple, standalone applications you can create with them. With flex & bison, you'll discover the wide range of uses these flexible tools offer. Address syntax crunching that regular expressions tools can't handle Build compilers and interpreters, and handle a wide range of text processing functions Interpret code, configuration files, or any other structured format Learn key programming techniques, including abstract syntax trees and symbol tables Implement a full SQL grammar-with complete sample code Use new features such as pure (reentrant) lexers and parsers, powerful GLR parsers, and interfaces to C++

SQL Server 2008 Administration in Action offers over 100 DBA-tested, high-value, best practices that will help you tame the beast and keep it under control. Unlike the many comprehensive SQL Server reference tomes out there that attempt to cover the whole SQL Server feature set, this book drills down on the techniques, procedures, and practices that help you keep your database running like clockwork. About the Technology The integrity and security of your database is crucial to your business. SQL Server 2008 is a massive and mature product with a very large feature set. As a SQL Server administrator, you must be equipped to handle myriad day-to-day tasks to keep your database healthy, and you must also be prepared to act quickly when something unexpected happens. About the Book SQL Server 2008 Administration in Action focuses the production DBA, digging deep into the various tasks specific to that role. Expert author Rod Colledge — check him out at sqlCrunch.com — teaches you best practices that cover the lifecycle of a SQL Server system, including infrastructure design, installation, and operational maintenance. And while many of these techniques will work in any recent version of SQL Server, you'll find full coverage of emerging SQL Server 2008 best practices. Each technique is presented in a task-driven style, and in the order of the typical life cycle of a SQL Server system. This allows you to easily open the book at the appropriate page and focus on what you need to know for each specific situation. What's Inside Selecting and configuring server components Distributing I/O load over multiple controllers Selecting the appropriate stripe size Configuring storage cache Preparing for SQL Server clustering Configure the private network for cluster use only Configure the cluster network priority Prepare resources for a clustered SQL Server installation Index selection and maintenance Identify and drop unused indexes Identify and create missing indexes Select the appropriate clustered index Database mirroring Prepare the mirror server for failover Select the appropriate failover mode Consider disabling log stream compression for CPU bottlenecked systems Upgrading SQL Server Reduce downtime with T-Log backup/restore and the side-by-side upgrade method Prior to an upgrade, run DBCC checks and take full backups with verification Ensure read only is not enabled prior to the upgrade About the Reader This book is a DBA's best friend. It covers the most important and often overlooked areas that you need to maintain to keep your databases secure, in-tune, and well-protected in the event of disaster. About the Author Rod Colledge is an independent SQL Server consultant based in Brisbane, Australia. Since 1996, Rod has specialized in the development and administration of SQL Server database systems. His recent work has included the design and implementation of custom transactional replication and log shipping solutions, performance tuning large, high-volume databases, and developing procedures for operational maintenance of large database systems. In September 2007, Rod founded sqlCrunch.com, a website specializing in summarizing and categorizing links to SQL Server white papers and best practices. Quotes Simply loaded with excellent and immediately useful information. - Kevin Kline, Quest Software I thought I knew SQL Server until I read this book. - Tariq Ahmed, Coauthor of Flex 4 in Action A refreshing database administration book. - Michael Redman, Microsoft Required for any MS DBA. - Andrew Siemer, OTX Research It delivered way beyond my expectations...Packed with useful enterprise-level knowledge. - Darren Neimke, Author of ASP.NET 2.0 Web Parts in Action

Microsoft® SQL Server™ 2008 Reporting Services Unleashed Michael Lisin Jim Joseph Amit Goyal The authoritative, example-rich guide to Microsoft’s powerful reporting platform With Microsoft SQL Server 2008 Reporting Services you can quickly deliver relevant business intelligence data wherever it’s needed–across the entire enterprise, and through the entire reporting lifecycle. SQL Server 2008 Reporting Services Unleashed gives you all the authoritative information you’ll need to make the most of Microsoft’s most powerful reporting platform as a database professional, manager, or user. In-depth coverage makes this book an ideal reference, and its extensive set of practical examples help you address virtually any challenge in deployment, configuration, administration, or report building. The authors have extensively expanded this edition with deeper reference information, many more practical examples, and insider perspective into Reporting Services 2008’s powerful new enhancements. You’ll discover how to take full advantage of Reporting Services’ significant architectural changes, its flexible new Tablix control, improved visualization through charts and gauges, deep SharePoint integration through SharePoint Integrated Mode, new output presentation formats, and much more. Understand how to Learn about the new features of Service Pack 1 (SP1) and the SQL Server 2008 R2 release Quickly take advantage of Microsoft’s newest SQL Server Reporting Services enhancements Use Reporting Services to identify trends and solve real business problems Master report authoring–from basic, wizard-driven techniques to the cutting edge Group, sort, and aggregate data, and define the right scope for your information Utilize advanced report formatting techniques Work effectively with multidimensional sources Manage report data sources and models Secure reports against attacks and intrusions Customize Reporting Services with embedded functions, custom assemblies, URL access, Web Services, and other extensions Thoroughly integrate SQL Server reporting into any SharePoint site Michael Lisin, lead author of Microsoft SQL Server 2005 Reporting Services, has years of field experience working with SQL Server Reporting Services at Microsoft and delivering solutions for Microsoft’s enterprise customers. Jim Joseph, co-author of Microsoft SQL Server 2005 Reporting Services Unleashed, is an independent contractor with 10 years experience developing custom software solutions in a variety of industries. He has worked with SQL Server Reporting Services since the first beta release. Amit Goyal, lead program manager for Microsoft’s Reporting Services team, has extensive insider’s knowledge of SQL Server 2008 Reporting Services. ON THE WEB: Download all examples and source code presented in this book from informit.com/sams Category: Microsoft Databases Covers: Microsoft SQL Server 2008 Reporting Services User Level: Intermediate—Advanced

A unique book-and-video package for Knight's 24-Hour Trainer: Microsoft® SQL Server® 2008 Integration Services If you need a practical, hands-on introduction to Microsoft SQL Server 2008 Integration Services (SSIS), this book and video package from foremost SSIS authority Brian Knight gets you thoroughly up to speed. Each lesson in the book includes three major components: a thorough description of how each SSIS feature or process works; a tutorial that walks you through the process or technique; and a video lesson that demonstrates it. If you take full advantage of this comprehensive package, you will gain enough experience to tackle your first SSIS project with confidence. SQL Server Integration Services 2008 (SSIS) builds on the revolutionary database product suite first introduced by Microsoft in 2005 and is a powerful tool for performing extraction, transformation, and load (ETL) operations essential to data warehousing If you're just learning SSIS, the step-by-step tutorials in this book and video training package will ready you to tackle your own first project Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Ideal as a stand-alone primer or when used in conjunction with another introductory computer science text, SQL: The Programming Language will prepare students for core SQL programming courses offered in CS and CIS. With a clear, concise, and descriptive writing style, students will see real-world examples and cases of SQL functionality in database management. Screen shots and figures throughout the text allow readers to visualize important concepts discussed and student exercises urge them to explore problems on their own.

In "Mastering Oracle Scheduler in Oracle 11g Databases", you will unlock the full potential of Oracle Scheduler (DBMS_SCHEDULER), a powerful tool for automating and managing database tasks. This book provides a comprehensive guide with practical examples to help you optimize database performance and automate your workflows. What this Book will help me do Understand how to create and manage job schedules using Oracle Scheduler, catering to both simple and complex automation needs. Learn to integrate platform-independent execution of jobs into your Oracle database management strategies. Gain practical insights into debugging, monitoring, and optimizing jobs for enhanced database performance. Explore event-driven scheduling to develop intelligent automation solutions for your business processes. Master resource management techniques to handle large-scale job scheduling effectively. Author(s) Ronald Rood is a seasoned database administrator and developer specializing in Oracle technologies. With extensive experience in database performance tuning and automation, Ronald shares practical insights and expert guidance in his writing. His passion for teaching complex concepts in an engaging manner makes his books valuable resources for professionals. Who is it for? This book is ideal for Oracle Database administrators and developers who want to advance their automation and scheduler management skills. With a basic understanding of Oracle Database Management and proficiency in SQL and PL/SQL, readers aim to optimize jobs and improve overall performance. It's perfect for those transitioning from tools like cron or DBMS_JOB for more robust scheduling capabilities.

Essential Database Skills--Made Easy! Learn standard database design and management techniques applicable to any type of database. Featuring clear examples using both Microsoft Access and Oracle, Databases: A Beginner's Guide begins by showing you how to use Structured Query Language (SQL) to create and access database objects. Then, you'll discover how to implement logical design using normalization, transform the logical design into a physical database, and handle data and process modeling. You'll also get details on database security, online analytical processing (OLAP), connecting databases to applications, and integrating XML and object content into databases. Designed for Easy Learning Key Skills & Concepts--Chapter-opening lists of specific skills covered in the chapter Ask the Expert--Q&A sections filled with bonus information and helpful tips Try This--Hands-on exercises that show you how to apply your skills Notes--Extra information related to the topic being covered Self Tests--Chapter-ending quizzes to test your knowledge

The Fifth Edition of Sams Teach Yourself SQL in 21 Days More than 48,000 sold! In just one hour a day, you’ll have all the skills you need to begin creating effective SQL queries, reports, and database applications. With this complete tutorial, you’ll quickly master the basics and then move on to more advanced features and concepts: Quickly apply essential SQL techniques in useful, real-world queries Design trustworthy, high-performance databases Manipulate your data with views and transactions Leverage powerful features including stored procedures, triggers, and cursors Work with new objects introduced with the latest SQL standards Get practical, expert tips on implementing SQL in your business environment Learn on your own time, at your own pace No previous SQL or database experience required Learn techniques that work with any current version of SQL Discover how to write faster, more efficient queries Secure your data using best practices from experienced database administrators Build more powerful databases with features exclusive to Oracle SQL*Plus, Oracle PL/SQL, and Microsoft Transact-SQL Write queries for the free, open source MySQL database Embed your SQL code in other applications Ryan Stephens and Ron Plew are President and VP of Perpetual Technologies, Inc. (PTI) in Indianapolis, IN, providing managed services and consulting for top database implementations running Oracle, SQL Server, and other leading technologies. They taught for 5+ years as adjunct professors at Indiana University-Purdue University. Their books include Sams Teach Yourself SQL in 24 Hours, First through Fourth Editions, Sams Teach Yourself SQL in 21 Days, Second through Fourth Editions, and Database Design. Table of Contents Introduction 1 PART I: Introducing SQL LESSON 1: Getting Started with SQL 5 A Brief History of SQL 5 A Brief History of Databases 6 Today’s Database Landscape 11 A Cross-Product Language 12 Early Implementations 12 SQL and Client/Server Application Development 13 An Overview of SQL 13 Popular SQL Implementations 14 MySQL 14 Oracle 14 Microsoft SQL Server and Sybase 15 IBM DB2 16 Open Database Connectivity 16 Embedding SQL in Application Programming 17 LESSON 2: Introducing the Query 21 Exploring SQL’s Background 21 Learning Basic Query Syntax 22 The Building Blocks of Data Retrieval: SELECT and FROM 23 Applying Query Concepts 25 Writing Your First Query 26 Terminating a SQL Statement 28 Selecting Individual Columns 28 Changing the Order of the Columns 29 Selecting Different Tables 31 Selecting Distinct Values 31 Exercises 37 LESSON 3: Expressions, Conditions, and Operators 39 Working with Query Expressions 40 Placing Conditions on Queries 40 Learning How to Use Operators 42 Arithmetic Operators 42 Comparison Operators 55 Character Operators 63 Logical Operators 70 Set Operators 75 Miscellaneous Operators: IN and BETWEEN 78 LESSON 4: Clauses in SQL Queries 85 Specifying Criteria with the WHERE Clause 87 Order from Chaos: The ORDER BY Clause 89 The GROUP BY Clause 98 The HAVING Clause 105 Combining Clauses 112 Example 4.1 112 Example 4.2 113 Example 4.3 113 Example 4.4 115 LESSON 5: Joining Tables 121 Joining Multiple Tables in a Single SELECT Statement 121 Cross Joining Tables &

With special focus on the next major release of MySQL, this resource provides a solid framework for anyone new to MySQL or transitioning from another database platform, as well as experience MySQL administrators. The high-profile author duo provides essential coverage of the fundamentals of MySQL database management—including MySQL’s unique approach to basic database features and functions—as well as coverage of SQL queries, data and index types, stores procedure and functions, triggers and views, and transactions. They also present comprehensive coverage of such topics as MySQL server tuning, managing storage engines, caching, backup and recovery, managing users, index tuning, database and performance monitoring, security, and more.

FileMaker Pro 10 Bible provides information that grows with you no matter what your level when you start. Topics range from the general (how databases fit into real life and your business needs; comparisons with other database development tools; a broad discussion of integration with existing systems and software) through the building-blocks of FileMaker solutions, and on up to state-of-the-art advice on concepts of optimization, modularization, innovative and sophisticated user-interface design, dynamic elements, logic, cutting-edge calculations, publishing your database to the Web, and integrating tightly with SQL databases via "ESS". The book also includes the special developer tools available in FileMaker Pro Advanced, and covers topics too oft skipped over in other books on the market -- backup how-to's and strategies, must-read information about good database husbandry and file recovery, and so on. Much of the information in the book is documented nowhere else. This is the one must-have FileMaker book!

SQL Server 2008 is the latest update to Microsoft's flagship database management system. This is the largest update since SQL Server 2005, and it brings increased ability to deliver data across more platforms, and thus many different types of devices. New functionality also allows for easy storage and retrieval of digitized images and video. These attributes address the recent explosion in the popularity of web-based video and server and desktop virtualization. The Real MCTS SQL Server 2008 Exam 70-433 Prep Kit prepares readers for the Microsoft Certified Technology Specialist exam: SQL Server 2008, Database Development. This is a new exam in the SQL Server product family, and is comprised of some objectives from exam 70-431 from SQL Server 2005, and covers new, expanded query capabilities in SQL Server 2008. According to Microsoft: Exam 70-431 for SQL Server 2005 was passed by over 35,000 people. ~ 150,000 people passed a similar exam for SQL Server 2000. Additionally, this exam is a pre-requisite for those going on to obtain the MCITP: Database Developer 2008: Successful candidates for the SQL Server 2005 MCITP ~ 2,500. This is The 'Real' Microsoft Exam Prep Kit, and provides the reader with independent and unbiased exam tips and warnings everything they need to know to ensure certification success. Authored by Mark Horninger, a nationally recognized leader in SQL Server with over 50 Microsoft certifications to his credit; Mark knows what it takes to successfully navigate Microsoft exams.

SQL Server 2008 introduces many new features that will change database administration procedures; many DBAs will be forced to migrate to SQL Server 2008. This book teaches you how to develop the skills required to successfully administer a SQL Server 2008 database; no prior experience is required. The material covers system installation and configuration/architecting, implementing and monitoring security controls, configuring and managing network communications, automating administration tasks, disaster prevention and recovery, performance monitoring, optimizing and ensuring high availability, as well as major SQL Server 2008 components including Integration Services, Reporting Services, Analysis Services, and Service Broker.

Master the increasingly complex feature set of the latest release of Microsoft SQL Server with the information in Professional Microsoft SQL Server 2008 Programming. Review the new features of SQL Server that will be of interest to you as an experienced developer and move on to more detailed, practical code examples. Learn how to write complex queries, build different types of data structures, improve application speed and performance, manage advanced scripting and errors, and design advanced databases the latest edition of this valuable programming guide.

In "SOA Patterns with BizTalk Server 2009", author Richard Seroter offers a meticulous guide to applying service-oriented architecture (SOA) principles to BizTalk Server solutions. This book will help you enhance the reusability and flexibility of your BizTalk implementations while leveraging Windows Communication Foundation (WCF) features to build modern, robust solutions. What this Book will help me do Gain practical knowledge of applying SOA principles to BizTalk Server 2009 Learn how to efficiently create and consume WCF services in BizTalk solutions Understand advanced features such as the WCF SQL Server Adapter and ESB Guidance Master effective methods for designing loosely coupled orchestrations Discover strategies for maintaining, versioning, and enhancing BizTalk solutions Author(s) Richard Seroter is a highly experienced integration architect with hands-on expertise in BizTalk Server and related technologies. With years of practical experience designing scalable enterprise solutions, Richard is passionate about sharing knowledge through comprehensive resources. His approachable writing style ensures clarity and accessibility for developers and architects alike. Who is it for? This book is ideal for BizTalk professionals such as architects and developers who already have a foundational understanding of the platform. It caters to individuals looking to enhance their skills in building scalable and service-oriented solutions using BizTalk Server 2009. If you're focused on creating agile, reusable, and robust BizTalk applications, this book is an essential resource for you.

Teach yourself to use SQL Server 2008 Analysis Services for business intelligence one step at a time. You'll start by building your understanding of the business intelligence platform enabled by SQL Server and the Microsoft Office System, highlighting the role of Analysis Services. Then, you'll create a simple multidimensional OLAP cube and progressively add features to help improve, secure, deploy, and maintain an Analysis Services database. You'll explore core Analysis Services 2008 features and capabilities, including dimension, cube, and aggregation design wizards; a new attribute relationship designer; designer AMO warnings; and using dynamic management views to monitor resources. And as you complete each lesson, you can hone your skills using the practice exercises from the companion CD. Plus, you can review and download code samples illustrating the author's own, professional techniques direct from the companion Web site.

SQL Server 2008 is the latest update to Microsoft's flagship database management system. This is the largest update since SQL Server 2005. SQL Server 2008 is a much more significant update than SQL Server 2005, because it brings increased ability to deliver data across more platforms, and thus many different types of devices. New functionality also allows for easy storage and retrieval of digitized images and video. These attributes address the recent explosion in the popularity of web-based video and server and desktop virtualization. The Real MCTS SQL Server 2008 Exam 70-432 Prep Kit prepares readers for the Microsoft Certified Technology Specialist exam: SQL Server 2008, Implementation and Maintenance. This is The 'Real' Microsoft Exam Prep Kit, and provides the reader with independent and unbiased exam tips and warnings everything they need to know to ensure certification success. Authored by Mark Horninger, a nationally recognized leader in SQL Server with over 50 Microsoft certifications to his credit; Mark knows what it takes to successfully navigate Microsoft exams.

Tackle the toughest set-based querying and query tuning problems—guided by an author team with in-depth, inside knowledge of T-SQL. Deepen your understanding of architecture and internals—and gain practical approaches and advanced techniques to optimize your code’s performance. Discover how to: Move from procedural programming to the language of sets and logic Optimize query tuning with a top-down methodology Assess algorithmic complexity to predict performance Compare data-aggregation techniques, including new grouping sets Manage data modification—insert, delete, update, merge—for performance Write more efficient queries against partitioned tables Work with graphs, trees, hierarchies, and recursive queries Plus—Use pure-logic puzzles to sharpen your problem-solving skills

When used with the MDX query language, SQL Server Analysis Services allows developers to build full-scale database applications to support such business functions as budgeting, forecasting, and market analysis. Shows readers how to build data warehouses and multi-dimensional databases, query databases, and use Analysis Services and other components of SQL Server to provide end-to-end solutions Revised, updated, and enhanced, the book discusses new features such as improved integration with Office and Excel 2007; query performance enhancements; improvements to aggregation designer, dimension designer, cube and dimension wizards, and cell writeback; extensibility and personalization; data mining; and more

SQL Server 2008 Query Performance Tuning Distilled presents a direct trouble–shooting methodology for identifying poorly-performing stored procedures and queries, isolating the causes of that poor performance, and fixing the underlying problems. Each chapter is dedicated to one of the top causes of poorly performing queries and shows methods for identifying and dealing with the problems in that chapter's domain. Emphasis is always put upon or placed upon practical methods that you can put to immediate use in your day-to-day work. SQL Server 2008 functionality, tips, and tricks are emphasized in each subject area. Emphasizes the practical. Does not bury readers in theory. Gives readers practical techniques to immediately apply in their daily work. Dedicates a chapter to each of the most common, performance-related problem areas.

Delve inside the core SQL Server engine—and put that knowledge to work—with guidance from a team of well-known internals experts. Whether database developer, architect, or administrator, you’ll gain the deep knowledge you need to exploit key architectural changes—and capture the product’s full potential. Discover how SQL Server works behind the scenes, including: What happens internally when SQL Server builds, expands, shrinks, and moves databases How to use event tracking—from triggers to the Extended Events Engine Why the right indexes can drastically reduce your query execution time How to transcend normal row-size limits with new storage capabilities How the Query Optimizer operates Multiple techniques for troubleshooting problematic query plans When to force SQL Server to reuse a cached query plan—or create a new one What SQL Server checks internally when running DBCC How to choose among five isolation levels and two concurrency models when working with multiple concurrent users