Product Description
A comprehensive guide to programming for Access 2010 and 2007 Millions of people use the Access database applications, and hundreds of thousands of developers work with Access daily. Access 2010 brings better integration with SQL Server and enhanced XML support; this Wrox guide shows developers how to take advantage of these and other improvements.
With in-depth coverage of VBA, macros, and other programming methods for building Access applications, this book also provides real-world code examples to demonstrate each topic.
- Access is the leading database that is used worldwide
- While VBA remains the favored method for Access programming, more options are available for Access 2010, and this book covers them all
- Covers the Access Object model, using VBA with ADO, VBA execution and error handling, creating database objects, creating and enhancing forms and reports, using the Windows Registry, and much more [click to continue…]
Product Description
300+ ready-to-use, powerful MDX queries
This hands-on guide shows you how to use Multi-Dimensional Expressions (MDX) to extract business intelligence from multi-dimensional cubes. Practical MDX Queries contains more than 300 downloadable MDX queries that can be applied across a wide variety of business intelligence-related problems. The use, syntax, and results of each query are described in detail. The book emphasizes MDX for use with SSAS within SSMS, but the techniques and queries also apply to SSRS, SSIS, MDX in SQL, MDX in DMX, MDX in XMLA, WinForms, WebForms, PerformancePoint Server, ProClarity, and many third-party applications.
- Work with dimensions, hierarchies, levels, and members
- Navigate both horizontally and vertically across dimensions and hierarchies
- Sort the results of your queries
- Access subsets of dimension members and measure values using the Where clause and Filter function
- Use MDX query calculations
- Extract and manipulate dates and times [click to continue…]
Product Description
- Taking readers through the basics of the language, right up to some more advanced topics, this book is a practical, hands-on resource and aims to keep the reader involved at all times
- Focuses on the SQL standard and is loaded with detailed examples and code; each chapter includes practice exercises that readers can challenge themselves with before looking at the sample solutions in the appendix
- Paul Wilton is a successful Wrox “Beginning” book author and is an ideal author to write for those who want a firm grasp of standard SQL before learning the details specific to a particular database product
- SQL is an international standard for manipulating data in databases and is used by database programmers in all major database systems: Microsoft, IBM, Oracle, MySQL, and many others
From the Back Cover
SQL works with databases to insert and extract data and is an international standard for manipulating data in databases. This hands-on resource covers everything from a review of SQL basics and database design to creating your own databases and using the SQL language in a variety of database applications.Packed with essential code, theories, concepts, and techniques, as well as a cache of useful examples, this comprehensive text will have you quickly designing your own databases and writing SQL code sufficient for many real-world situations. Practice exercises in each chapter help speed up your comprehension. By the end of the book, you’ll be prepared to handle any surprise that SQL might throw your way.
[click to continue…]
Product Description
SQL is the international standard language for creating and maintaining relational databases. This book is a compendium of information about SQL and relational database design, development, and maintenance. The nine mini-books cover the full spectrum of issues that arise in building, using, and maintaining relational database systems.Book I: SQL Concepts
Book II: Relational Database Development
Book III: SQL Queries
Book IV: Data Security
Book V: SQL and Programming
Book VI: SQL and XML
Book VII: Database Tuning Overview
Book VIII: Appendixes
From the Back Cover
Master queries for any SQL database!Your one-stop guide to building and maintaining relational databases with SQL
If you’re looking for a good general reference on SQL, look no further. This all-in-one guide delivers the goods on all major SQL topics, from basic concepts to the latest XML data-handling functions. Whether you’re a database developer or DBA, you’ll find fast answers to your SQL questions and savvy tips on building databases that are robust, secure, and efficient. [click to continue…]
Product Description
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 [click to continue…]
