Pro SQL Server 2012 Reporting Services opens the door to delivering customizable, web-enabled reports across your business at reasonable cost. Reporting Services is Microsoft's enterprise-level reporting platform. It is included with many editions of SQL Server, and is something you'll want to take advantage of if you're running SQL Server as your database engine. Reporting Services provides a full set of tools with which to create and deploy reports. Create interactive reports for business users. Define reporting models from which business users can generate their own ad hoc reports. Pull data from relational databases, from XML, and from other sources. Present that data to users in tabular and graphical forms, and more. Reporting Services experts Brian McDonald, Rodney Landrum, and Shawn McGehee show how to do all this and much more in this third edition of their longstanding book on the topic.* Provides best practices for using Reporting Services * Covers the very latest in new features for SQL Server 2012 * Your key to delivering business intelligence across the enterprise What you'll learn * Write efficient queries on which to base a report * Build and lay out a report using Report Designer * Enable end users to create ad hoc reports on demand * Combine Reporting Services with Analysis Services, SharePoint Server, and other technologies to deliver business intelligence across the enterprise * Secure and audit your reports as part of your regulatory compliance efforts * Customize your reports using C# assemblies and embedded Visual Basic .NET code Who this book is for Pro SQL Server 2012 Reporting Services is aimed at data analysts, developers, database administrators, and others who develop and deploy reports using Microsoft SQL Server Reporting Services. Table of Contents1. Introducing the Reporting Services Architecture 2. Report Authoring: Designing Efficienc Queries 3. Introduction to Reporting Services Design with SQL Server Data Tools 4. Laying Out A Report 5. Implementing Dashboard-Style Report Objects 6. Building Reports 7. Using Custom .NET Code with Reports 8. Deploying Reports 9. Rendering Reports from .NET Applications 10. Managing Reports 11. Securing Reports 12. Delivering Business Intelligence using SSRS 13. Creating Reports using Report Builder 1.0, 2.0, and 3.0

SQL Server 2012 T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server 2012. It provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, insert and update data, generate reports, secure your data, and more. Tasks and their solutions are broken down into a problem/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on. Solutions in this book are divided into chapters by problem domain. Each chapter is a collection of solutions around a single facet of the language such as writing queries, developing triggers, and applying aggregate functions. Each solution is presented code-first, giving you a working code example to copy from and implement immediately in your own environment. Following each example is an in-depth description of how and why the given solution works. Tradeoffs and alternative approaches are also discussed. * Focused on solutions: Look up what you need to do. Learn how to do it. Do it.* Current: Newly updated for SQL Server 2012 * Comprehensive: Covers all common T-SQL problem domains What you'll learn * Create databases, tables, and indexes * Query and manipulate data * Store and manage XML inside the database * Move business logic into the database * Resolve common performance problems. * Build reports that matter to your business. * Perform common backup and recovery tasks. Who this book is for SQL Server 2012 T-SQL Recipes is aimed at technically-oriented users of SQL Server desiring to extract the full power of the platform through it's powerful, built-in programming and scripting language. Target readers include developers who use Microsoft SQL Server 2012 as their back--end database, and the database administrators who create, manage, and secure those databases.

Business intelligence projects do not need to cost multi-millions of dollars or take months or even years to complete Using rapid application development (RAD) techniques along with Microsoft SQL Server 2012, this book guides database administrators, SQL programmers, and report specialists in creating practical, cost-effective business intelligence solutions for their companies and departments. Pro SQL Server 2012 BI Solutions provides practical examples of cost-effective business intelligence projects. Readers will be guided through several complete projects that build a foundation for real-world solutions. Even with limited experience using Microsoft's SQL Server, Integration Server, Analysis Server, and Reporting Server, you can leverage your existing knowledge of SQL programming and database design to provide users with the business intelligence reports they need.* Provides recipes for multiple business intelligence scenarios * Progresses from simple to advanced projects using several examples * Shows Microsoft SQL Server technology used to complete real-world business intelligence projects What you'll learn * How to plan and implement cost-effective business intelligence projects * How to create practical data warehouse databases * How to extract, transform, and load data with Integration Services * How to develop OLAP cubes and dimensions on Analysis Server * How to create Reporting Server reports using both SQL and MDX * How to apply performance-tuning techniques to get the most from your solutions Who this book is for Pro SQL Server 2012 BI Solutions is aimed at database administrators, SQL programmers, and report developers who create business intelligence solutions for midsized businesses and departments.Table of Contents * Business Intelligence Solutions * A Big Picture Overview * Planning Solutions * Designing a Data Warehouse * Creating a Data Warehouse * ETL Processing with SQL * Beginning the ETL Process with SSIS * Concluding the ETL Process with SSIS * Beginning the SSAS Project * Configuring Dimensions with SSAS * Creating and Configuring SSAS Cubes * Additional Cube and Dimension Configurations * Creating Reports with SQL Queries * Reporting with MDX Queries * Reporting with Microsoft Excel * Creating Reports with SSRS * Configuring Reports with SSRS * Testing and Tuning BI Solutions * Approve, Release, and Prepare

Expert Performance Indexing for SQL Server 2012 is a deep dive into perhaps the single-most important facet of good performance: indexes, and how to best use them. The book begins in the shallow waters with explanations of the types of indexes and how they are stored in databases. Moving deeper into the topic, and further into the book, you will look at the statistics that are accumulated both by indexes and on indexes. All of this will help you progress towards properly achieving your database performance goals. What you'll learn from Expert Performance Indexing for SQL Server 2012 will help you understand what indexes are doing in the database and what can be done to mitigate and improve their effects on performance. The final destination is a guided tour through a number of real-world scenarios and approaches that can be taken to investigate, mitigate, and improve the performance of your database.* Defines indexes and provides an understanding of their role * Uncovers and explains the statistics that are kept in indexes * Teaches strategies and approaches for indexing databases What you'll learn * Fully understand the index types at your disposal * Recognize and remove unnecessary indexes * Review statistics to understand indexing choices made by the optimizer * Properly apply strategies such as covering indexes, included columns, index intersections, and more * Write queries to make good use of the indexes already in place * Design effective indexes for full-text, spatial, and XML data types * Manage the big picture: Encompassing all indexes in a database, and all database instances on a server Who this book is for Expert Performance Indexing for SQL Server 2012 is intended for database administrators and developers who are ready to boost the performance of their environments without the need to go in blindly building indexes. Table of Contents * Index Fundamentals * Index Storage Fundamentals * Index Statistics * XML, Spatial and FULLTEXT * Index Myths and Best Practices * Index Maintenance * Indexing Tools * Index Strategies * Query Strategies * Index Analysis

Use window functions to write simpler, better, more efficient T-SQL queries Most T-SQL developers recognize the value of window functions for data analysis calculations. But they can do far more, and recent optimizations make them even more powerful. In T-SQL Window Functions, renowned T-SQL expert Itzik Ben-Gan introduces breakthrough techniques for using them to handle many common T-SQL querying tasks with unprecedented elegance and power. Using extensive code examples, he guides you through window aggregate, ranking, distribution, offset, and ordered set functions. You'll find a detailed section on optimization, plus an extensive collection of business solutions - including novel techniques available in no other book. Microsoft MVP Itzik Ben-Gan shows how to: * Use window functions to improve queries you previously built with predicates * Master essential SQL windowing concepts, and efficiently design window functions * Effectively utilize partitioning, ordering, and framing * Gain practical in-depth insight into window aggregate, ranking, offset, and statistical functions * Understand how the SQL standard supports ordered set functions, and find working solutions for functions not yet available in the language * Preview advanced Row Pattern Recognition (RPR) data analysis techniques * Optimize window functions in SQL Server and Azure SQL Database, making the most of indexing, parallelism, and more * Discover a full library of window function solutions for common business problems About This Book * For developers, DBAs, data analysts, data scientists, BI professionals, and power users familiar with T-SQL queries * Addresses any edition of the SQL Server 2019 database engine or later, as well as Azure SQL Database Get all code samples at: MicrosoftPressStore.com/TSQLWindowFunctions/downloads

Queries not running fast enough? Tired of the phone calls from frustrated users? Grant Fritchey's bookSQL Server 2012 Query Performance Tuning is the answer to your SQL Server query performance problems. The book is revised to cover the very latest in performance optimization features and techniques. It is current with SQL Server 2012. It provides the tools you need to approach your queries with performance in mind. SQL Server 2012 Query Performance Tuning leads you through understanding the causes of poor performance, how to identify them, and how to fix them. You'll learn to be proactive in establishing performance baselines using tools like Performance Monitor and Extended Events. You'll learn to recognize bottlenecks and defuse them before the phone rings. You'll learn some quick solutions too, but emphasis is on designing for performance and getting it right, and upon heading off trouble before it occurs. Delight your users. Silence that ringing phone. Put the principles and lessons from SQL Server 2012 Query Performance Tuning into practice today. Establish performance baselines and monitor against them Troubleshoot and eliminate bottlenecks that frustrate users Plan ahead to achieve the right level of performance What you'll learn Establish performance baselines and monitor against them Recognize and eliminate bottlenecks leading to slow performance Deploy quick fixes when needed, following up with long term solutions Implement best-practices in T-SQL so as to minimize performance risk Design in the performance that you need through careful query and index design Take advantage of the very latest performance optimization features in SQL Server 2012 Who this book is for

SQL Server 2012 Query Performance Tuning is aimed at developers and database administrators having responsibility for application performance in SQL Server environments. Programmers and administrators alike will find the book a trove of good insight into bottlenecks, how to recognize them, how to eliminated them. SQL Server 2012 Query Performance Tuning provides the tools and techniques readers need to create good-performing applications that delight their users. Table of Contents SQL Query Performance Tuning System Performance Analysis SQL Query Performance Analysis Index Analysis Database Engine Tuning Advisor Lookup Analysis Statistics Analysis Fragmentation Analysis Execution Plan Analysis Query Recompilation Analysis Query Design Analysis Blocking Analysis Deadlock Analysis Cursor Cost Analysis Testing Query Performance Database Workload Optimization SQL Server Optimization Checklist

Pro T--SQL 2012 Programmer's Guide is every developer's key to making full use of SQL Server 2012's powerful, built--in Transact--SQL language. Discussing new and existing features, the book takes you on an expert guided tour of Transact--SQL functionality. Fully functioning examples and downloadable source code bring technically accurate and engaging treatment of Transact--SQL into your own hands. Step--by--step explanations ensure clarity, and an advocacy of best--practices will steer you down the road to success. Transact--SQL is the language developers and DBAs use to interact with SQL Server. It's used for everything from querying data, to writing stored procedures, to managing the database. New features in T-SQL 2012 include full support for window functions, stored sequences, the ability to throw errors, data paging, and more. All these important new features are covered in this book. Developers and DBAs alike can benefit from the expressive power of Transact-SQL, and Pro T-SQL 2012 Programmer's Guide provides the gateway to success in applying this increasingly important database language to everyday business and technical tasks.What you'll learn * Take full advantage of window functions and other new features in T-SQL 2012 * Move business logic into the database via procedures and functions * Develop using advanced features such as encryption and full-text search * Store and retrieve XML data using XQuery and XPath * Debug and Optimize T-SQL Execution * Build ADO.NET Client Applications Who this book is for Pro T--SQL 2012 Programmer's Guide is written for SQL Server and Transact--SQL developers who want to implement best--practices and take full advantage of all that SQL Server has to offer. NET programmers will find the book helpful in showing how to run .NET code within SQL Server. Database administrators who need to write triggers and the occasional stored procedure will also benefit from the book.

Microsoft SQL Server implements extensive support for location-based data.Pro Spatial with SQL Server 2012 introducesSQL Server's spatial feature set, and covers everything you'll need to know to store, manipulate, and analyze information about the physical location of objects in space. You'll learn about the geography and geometry datatypes, and how to apply them in practical situations involving the spatial relationships of people, places, and things on Earth. Author Alastair Aitchison first introduces you to SQL Server's spatial feature set and the fundamental concepts involved in working with spatial data, including spatial references and co-ordinate systems. You'll learn to query, analyze, and interpret spatial data using tools such as Bing Maps and SQL Server Reporting Services. Throughout, you'll find helpful code examples that you can adopt and extend as a basis for your own projects. Explains spatial concepts from the ground upno prior knowledge is necessary Provides comprehensive guidance for every stage of working with spatial data, from importing through cleansing and storing, to querying, and finally for retrieval and display of spatial data in an application layer Brilliantly illustrated with code examplesthat run in SQL Server 2012, that you can adapt and use as the basis for your own projects. What you'll learn The fundamental concepts involved in working with spatial data, including spatial references and co-ordinate systems How to create and store spatial data using the geometry and geography data types How to use of spatial indexes in the design of highly-performant databases Write spatial queries to answer practical, business questions Pass spatial data seamlessly between database and application layers using T-SQL and C# Overcome common issues, including how to deal with invalid, imprecise, or erroneous spatial data Apply advanced techniques such as routefinding and clustering Who this book is for

Pro Spatial with SQL Server 2012is the go-to book for anyone involved in spatial applications involving Microsoft SQL Server 2012. The book helps database administrators create and optimize the performance of spatial database. The book gives developers what they need to know in order to make effective use of the extensive support for location-based data provided by SQL Server, T-SQL, and C#. Table of Contents 1. Spatial Reference Systems 2. Spatial Features 3. Spatial Datatypes 4. Creating Spatial Data 5. Importing Spatial Data 6. Geocoding 7. Precision, Validity, and Errors 8.Transformation and Reprojection 9. Examining Spatial Properties 10.Modification and Simplification 11. Aggregation and Combination 12. Testing Spatial Relationships 13. Clustering and Distribution Analysis 14. Route Finding 15. Triangulation and Tesselation 16. Visualization and User Interface 17. Reporting Services 18. Indexing 19.

Prepare for Microsoft Exam 70-765-and help demonstrate your real-world mastery of provisioning SQL Server databases both on premise and in SQL Azure. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: * Implement SQL in Azure * Manage databases and instances * Manage storage This Microsoft Exam Ref: * Organizes its coverage by exam objectives * Features strategic, what-if scenarios to challenge you * Assumes you have working knowledge of SQL Server administration and maintenance, as well as Azure skills Provisioning SQL Databases About the Exam Exam 70-765 focuses on skills and knowledge for provisioning, upgrading, and configuring SQL Server; managing databases and files; and provisioning, migrating, and managing databases in the Microsoft Azure cloud. About Microsoft Certification Passing this exam as well as Exam 70-764: Administering a SQL Database Infrastructure earns you MCSA: SQL 2016 Database Administration certification, qualifying you for a position as a database administrator or infrastructure specialist. See full details at: microsoft.com/learning

SQL Server 2012 Integration Services Design Patterns is a book of recipes for SQL Server Integration Services (SSIS). Design patterns in the book show how to solve common problems encountered when developing data integration solutions. Because you do not have to build the code from scratch each time, using design patterns improves your efficiency as an SSIS developer. In SSIS Design Patterns, we take you through several of these snippets in detail, providing the technical details of the resolution. SQL Server 2012 Integration Services Design Patterns does not focus on the problems to be solved; instead, the book delves into why particular problems should be solved in certain ways. You'll learn more about SSIS as a result, and you'll learn by practical example. Where appropriate, SQL Server 2012 Integration Services Design Patterns provides examples of alternative patterns and discusses when and where they should be used. Highlights of the book include sections on ETL Instrumentation, SSIS Frameworks, and Dependency Services.* Takes you through solutions to several common data integration challenges * Demonstrates new features in SQL Server 2012 Integration Services * Teaches SSIS using practical examples What you'll learn * Load data from flat file formats * Explore patterns for executing SSIS packages * Discover a pattern for loading XML data * Migrate SSIS packages through your application lifecycle without editing connections * Take advantage of SSIS 2012 Dependency Services * Build an SSIS Framework to support your application needs Who this book is for SQL Server 2012 Integration Services Design Patterns is for the data integration developer who is ready to take their SQL Server Integration Services (SSIS) skills to a more efficient level. It's for the developer interested in locating a previously-tested solution quickly. SQL Server 2012 Integration Services Design Patterns is a great book for ETL (extract, transform, and load) specialists and those seeking practical uses for new features in SQL Server 2012 Integration Services. It's an excellent choice for business intelligence and data warehouse developers.Table of Contents * Metadata Collection * Execution Operations * Scripting * SQL Server Source Patterns * Data Cleansing * DB2 Source * Flat File Source Patterns * Parallel Data Warehouse * XML * Expression Language Patterns * Data Warehouse * Logging * Slowly Changing Dimensions * Loading the Cloud * Reporting * Parent-Child Patterns * BIML * Configuration * Deployment * Estimating ETL Projects

Beginning SQL Server 2012 for Developers is the perfect book for developers new to SQL Server and planning to create and deploy applications against Microsoft's market-leading database system for the Windows platform. Now in its third edition, the book is enhanced to cover the very latest developments in SQL Server 2012. Also new in the book is coverage of the no-cost Express Edition. Whether you have no knowledge of databases, or have knowledge of desktop databases such as Microsoft Access, or even come from another brand such as Oracle Database, Beginning SQL Server 2012 for Developers provides the insights to get up and running with SQL Server 2012. Within the book, there are plenty of examples of tasks that developers routinely perform. You'll learn to create tables and indexes, and best practices for securing your valuable data. You'll learn design tradeoffs and find out how to make sound decisions resulting in scalable databases and maintainable code. Beginning SQL Server 2012 for Developers takes you through the entire database development process, from installing the software to creating a database to writing the code to connect to that database and move data in and out. By the end of the book, you'll be able to design and create solid and reliable database solutions using SQL Server 2012. * Takes you through the entire database application development lifecycle * Includes brand new coverage of SQL Server 2012 features * Introduces the freely-available Express Edition What you'll learn * How to install SQL Server 2012 * How to build a database application from start to finish * How to create tables and indices to manage your data * How to write stored code to execute directly in the database server * How to back up, recover, and otherwise maintain your database * How to connect to your database from client languages such as C# and VB .NET Who this book is for Beginning SQL Server 2012 for Developers is ideal for developers starting out with SQL Server 2012. There is no prerequisite background in developing database applications.Developers from other platforms and those brand new to database programming alike will find in Beginning SQL Server 2012 for Developers an excellent introduction to using and programming Microsoft's database platform. Table of Contents * Overview and Installation * SQL Server Management Studio * Database Design and Creation * Security and Compliance * Defining Tables * Creating Indexes and Database Diagramming * Database Backups and Recovery * Database Maintenance * Inserting and Deleting Data * Selecting and Updating Data * Building a View * Stored Procedures, Functions, and Security * Essentials for Effective Coding * Advanced T-SQL * Triggers * Connecting from Client Code

With the increasing popularization of personal hand-held mobile devices, more people use them to establish network connectivity and to query and share data among themselves in the absence of network infrastructure, creating mobile social networks (MSNet). Since users are only intermittently connected to MSNets, user mobility should be exploited to bridge network partitions and forward data. Currently, data route/forward approaches for such intermittently connected networks are commonly "store-carry-and-forward" schemes, which exploit the physical user movements to carry data around the network and overcome path disconnection. And since the source and destination may be far away from each other, the delay for the destination to receive the data from the source may be long. MSNets can be viewed as one type of socially-aware delay tolerant networks (DTNs). Observed from social networks, the contact frequencies are probably different between two friends and two strangers, and this difference should be taken into consideration when designing data dissemination and query schemes in MSNets. In this book, the fundamental concepts of MSNets are introduced including the background, key features and potential applications of MSNets, while also presenting research topics, such as, MSNets as realistic social contact traces and user mobility models. Because the ultimate goal is to establish networks that allow mobile users to quickly and efficiently access interesting information, particular attention is paid to data dissemination and query schemes in subsequent sections. Combined with geography information, the concepts of community and centrality are employed from a social network perspective to propose several data dissemination and query schemes, and further use real social contact traces to evaluate their performance, demonstrating that such schemes achieve better performance when exploiting more social relationships between users.

Foundations of SQL Server 2008 R2 Business Intelligence introduces the entire exciting gamut of business intelligence tools included with SQL Server 2008. Microsoft has designed SQL Server 2008 to be more than just a database. It's a complete business intelligence (BI) platform. The database is at its core, and surrounding the core are tools for data mining, modeling, reporting, analyzing, charting, and integration with other enterprise-level software packages. SQL Server 2008 puts an incredible amount of BI functionality at your disposal. But how do you take advantage of it? That's what this book is all about. Authors Guy Fouche and Lynn Langit show how to implement end-to-end BI solutions using SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and other tools in the Microsoftbusiness intelligencetoolkit. You'll learn about all-features such as PowerPivot and Report Builder 3.0. Also provided are clear examples of predictive analysis made possible through powerful data mining features in SQL Server. If you're an analyst or developer working with SQL Server 2008 who is charged with delivering results that drive business success, you can't afford to be without this book; you can't afford to ignore the powerfulbusiness intelligencesuite that Microsoft has placed at your disposal. Provides the big picture of Microsoft's BI tool suite Covers PowerPivot and other game-changing technologies introduced alongside SQL Server 2008 Release 2 Gives a practical analysis of features based on real-world practices What you'll learn Apply dimensional- and fact-based modeling to create OLAP schemas Optimize data extraction and transformation with SQL Server Integration Services Develop OLAP and data-mining solutions using SQL Server Analysis Services Create compelling reports using the new Report Builder 3.0 in SQL Server Reporting Services Deliver self-service business-intelligence via Microsoft PowerPivot Manage and maintain control over your business intelligence environment Who this book is for

Foundations of SQL Server 2008 R2 Business Intelligence is for business intelligence analysts and developers wanting to employ the full stack of business intelligence tools that are part of SQL Server. The book also appeals to database administrators managing databases in support of business intelligence efforts. Table of Contents What Is Business Intelligence? OLAP Modeling Concepts Introducing OLAP Modeling with SSAS Intermediate OLAP Modeling with SSAS Advanced OLAP Modeling with SSAS Cube Storage and Aggregation Introducing SSIS Intermediate SSIS Advanced SSIS Reporting Tools Data Mining with Excel Introducing PowerPivot Introduction to MDX Introduction to Data Mining

Every day, organizations large and small fall victim to attacks on their data. Encryption provides a shield to help defend against intruders. Because of increasing pressure from government regulators, consumers, and the business community at large, the job descriptions of SQL DBAs and developers are expanding to include encryption. Expert SQL Server 2008 Encryption will show you how to efficiently implement SQL Server 2008 encryption functionality and features to secure your organizational data.Introduces encryption, guiding readers through its implementation in SQL Server Demonstrates advanced techniques such as the use of hardware security modules Covers all that a SQL Server database administrator needs to know about encryption What you'll learn Take advantage of hardware security modules via extensible key management Implement targeted encryption of individual columns Secure an entire database at once with Transparent Data Encryption Encrypt disk volumes using BitLocker encryption Effectively design and manage encryption as part of your total security solution Digitally sign documents stored in your database Who this book is for

The audience for this book includes SQL Server DBAs, SQL developers, and .NET developers who want to take advantage of the powerful encryption functionality available in SQL Server 2008. The features of SQL Server 2008 provide a powerful set of tools to secure your most sensitive data, helping protect it from theft. Table of Contents Introduction to Encryption Encryption Key Management Symmetric Encryption Asymmetric Encryption Extensible Key Management Transparent Data Encryption Hashing SQL CLR Cryptography Indexing Encrypted Data Encrypting Connections to SQL Server 2008 Regulatory Requirements

PHP and MySQL Web Development, Fifth Edition The definitive guide to building database-driven Web applications with PHP and MySQL PHP and MySQL are popular open-source technologies that are ideal for quickly developing database-driven Web applications. PHP is a powerful scripting language designed to enable developers to create highly featured Web applications quickly, and MySQL is a fast, reliable database that integrates well with PHP and is suited for dynamic Internet-based applications. PHP and MySQL Web Development shows how to use these tools together to produce effective, interactive Web applications. It clearly describes the basics of the PHP language, explains how to set up and work with a MySQL database, and then shows how to use PHP to interact with the database and the server. This practical, hands-on book consistently focuses on real-world applications, even in the introductory chapters. The authors cover important aspects of security and authentication as they relate to building a real-world website and show you how to implement these aspects in PHP and MySQL. They also introduce you to the integration of front-end and back-end technologies by using JavaScript in your application development. The final part of this book describes how to approach real-world projects and takes the reader through the design, planning, and building of several projects, including: User authentication and personalization Web-based email Social media integration Shopping cart The fifth edition of PHP and MySQL Web Development has been thoroughly updated, revised, and expanded to cover developments in PHP through versions 5.6 and 7, as well as features introduced in recent stable releases of MySQL. Free Access to Web Edition Purchase of this book in any format, electronic or print, includes free access to the corresponding Web Edition. The Web Edition can be viewed on all types of computers and mobile devices with any modern web browser that supports HTML5. Contents at a Glance Part I: Using PHP 1 PHP Crash Course 2 Storing and Retrieving Data 3 Using Arrays 4 String Manipulation and Regular Expressions 5 Reusing Code and Writing Functions 6 Object-Oriented PHP 7 Error and Exception Handling Part II: Using MySQL 8 Designing Your Web Database 9 Creating Your Web Database 10 Working with Your MySQL Database 11 Accessing Your MySQL Database from the Web with PHP 12 Advanced MySQL Administration 13 Advanced MySQL Programming Part III: Web Application Security 14 Web Application Security Risks 15 Building a Secure Web Application 16 Implementing Authentication Methods with PHP Part IV: Advanced PHP Techniques 17 Interacting with the File System and the Server 18 Using Network and Protocol Functions 19 Managing the Date and Time 20 Internationalization and Localization 21 Generating Images 22 Using Session Control in PHP 23 Integrating JavaScript and PHP 24 Other Useful Features Part V: Building Practical PHP and MySQL Projects 25 Using PHP and MySQL for Large Projects 26 Debugging and Logging 27 Building User Authentication and Personalization 28 (PDF with Product Registration) Building a Web-Based Email Client with Laravel Part I 29 (PDF with Product Registration) Building a Web-Based Email Client with Laravel Part II 30 (PDF with Product Registration) Social Media Integration Sharing and Authentication 31 (PDF with Product Registration) Building a Shopping Cart Part VI: Appendix A Installing Apache, PHP, and MySQL

Extensive coverage of PHP and MySQL-more than any other book for beginners Updated for PHP 5.3 Author W. Jason Gilmore is a well-known and highly respected PHP developer and author as well as the organizer of CodeMash Beginning PHP and MySQL: From Novice to Professional, Fourth Edition is a major update of W. Jason Gilmore's authoritative book on PHP and MySQL. The fourth edition includes complete coverage of PHP 5.3 features, including namespacing, an update of AMP stack installation and configuration, updates to Zend Framework, coverage of MySQL Workbench, and much more. You'll not only receive extensive introductions to the core features of PHP, MySQL, and related tools, but you'll also learn how to effectively integrate them in order to build robust data- driven applications. Gilmore has seven years of experience working with these technologies, and he has packed this book with practical examples and insight into the real-world challenges faced by developers. Accordingly, you will repeatedly return to this book as both a valuable instructional tool and reference guide.

Outside of the world of enterprise computing, there is one database that enables a huge range of software and hardware to flex relational database capabilities, without the baggage and cost of traditional database management systems. That database is SQLite-an embeddable database with an amazingly small footprint, yet able to handle databases of enormous size. SQLite comes equipped with an array of powerful features available through a host of programming and development environments. It is supported by languages such as C, Java, Perl, PHP, Python, Ruby, TCL, and more. The Definitive Guide to SQLite, Second Edition is devoted to complete coverage of the latest version of this powerful database. It offers a thorough overview of SQLite's capabilities and APIs. The book also uses SQLite as the basis for helping newcomers make their first foray into database development. In only a short time you can be writing programs as diverse as a server-side browser plug-in or the next great iPhone or Android application! Learn about SQLite extensions for C, Java, Perl, PHP, Python, Ruby, and Tcl. Get solid coverage of SQLite internals. Explore developing iOS (iPhone) and Android applications with SQLite. SQLite is the solution chosen for thousands of products around the world, from mobile phones and GPS devices to set-top boxes and web browsers. You almost certainly use SQLite every day without even realizing it!

Pro SQL Server 2008 Mirroring is your complete guide to planning, using, deploying, and maintaining database mirroring as a high-availability option. Mirroring protects you by maintaining one or more duplicate copies of your database for use in the event the primary copy is damaged. It is a key component of any production-level, high-availability solution. This book covers the full spectrum of database mirroring, taking you from the planning phase through the implementation to the maintenance phase and beyond.Easy to follow, step-by-step instructions for beginner and intermediate users In-depth, detailed information for advanced and expert users Covers all phases of database mirroring from planning to sustained maintenance What you'll learn Plan effectively for database mirroring. Learn what questions to ask and what problems to anticipate Get step-by-step instructions on how to set up database mirroring Automate the initial setup and the ongoing maintenance of mirrored databases Monitor database mirroring, detect failures, and generate automated alerts Build a system that automatically responds to and fixes common problems Build in support for the missing facets of database mirroring, such as support for cross-database dependencies Define groups of databases that all fail over together to their mirrors when just one of those databases fails Create operational processes so that even nontechnical staff can manage mirrored databases Who this book is for

General audience: Pro SQL Server 2008 Database Mirroring is aimed at SQL Server 2008 database administrators, and especially those who desire to mirror their databases in support of high availability. System administrators and operational engineers who manage Windows Server systems that support mirrored database environments will also find much in the book of interest. Table of Contents High Availability Options Database Mirroring Overview Planning and Best Practices Database Mirroring Setup Automating Setup Maintenance Simplified Monitoring and Alerting Upgrading to SQL Server 2008 Reporting Considerations Planning for Failure

Even if you have little or no knowledge of T-SQL, Beginning T-SQL 2008 will bring you up to intermediate level and teach you best practices along the way. You'll learn how to write code that will help you to achieve the best-performing applications possible.

You'll find an introduction to databases, normalization, and SQL Server Management Studio. You'll understand how data is stored in a database and learn how to use at least one of the available tools to get to that data.

Each subsequent chapter teaches an aspect of T-SQL, building on the skills learned in previous chapters. Exercises are included in each chapter because the only way to learn T-SQL is to write some code.

This book will do more than just give the syntax and examples. It will teach you techniques to help you avoid common errors and create robust and well-performing code.Imparts best practices for writing T-SQL Helps readers avoid common errors Shows how to write scalable code that yields good performance What you'll learn Understand the fundamentals of relational theory, upon which Transact-SQL is based Write accurate queries that are scalable and perform well Combine set-based and procedural processing, obtaining the best from both worlds Embed business logic in your database through stored procedures and functions Simplify your work through new and advanced features such as common-table expressions and virtual tables Enhance performance by knowing when to apply features such table value parameters Who this book is for

This book is for developers who will be writing database applications against SQL Server databases. Table of Contents Getting Started Writing Simple SELECT Queries Using Functions and Expressions Querying Multiple Tables Grouping and Summarizing Data Manipulating Data Understanding T-SQL Programming Logic Moving Logic to the Database Working with New Data Types Writing Advanced Queries Where to Go Next?

Beginning SQL Server 2008 Administration is essential for anyone wishing to learn about implementing and managing SQL Server 2008 database. From college students, to experienced database administrators from other platforms, to those already familiar with SQL Server and wanting to fill in some gaps of knowledge, this book will bring all readers up to speed on the enterprise platform Microsoft SQL Server 2008.Clearly describes relational database concepts Explains the SQL Server database engine and supporting tools Shows various database maintenance scenarios What you'll learn To understand core concepts of relational databases How to install SQL Server in your environment How to use the tools that come with SQL Server to perform daily administrative tasks How to design and implement a database maintenance plan in SQL Server Configuring database security and protect your sensitive data from intruders How to meet regulatory and government compliance requirements like Sarbanes-Oxley and the Payment Card Industry (PCI) regulations Who this book is for

This book is primarily for those who are aspiring to become SQL Server 2008 database administrators. Reading this book gives you a great foundation of knowledge upon which to build a future career in database administration. You might be new to SQL Server 2008, or you might have experience with competing products such as Oracle. Either way, this book gets you up to speed quickly in managing SQL Server 2008, helping you transfer your existing knowledge into the SQL Server 2008 environment. Table of Contents The Database Administration Profession Planning and Installing SQL Server 2008 What's in the Toolbox? Creating Tables and Other Objects Transact-SQL SQL Server Internals Storage Management Strategies Database Backup Strategies Database Restore Strategies Common Database Maintenance Tasks Automation Through SQLCMD and PowerShell Database Maintenance Plans Performance Tuning and Optimization SQL Server Security Auditing, Encryption, and Compliance SQL Server in the Enterprise Where to Go Next?

Pro SQL Server 2008 Replication is for Microsoft database developers and administrators who want to learn about the different types of replication and those best suited to SQL Server 2008. This book will also cover advanced topics like replication with heterogeneous databases, backup and recovery of replicated databases, database mirroring with replication, log shipping with replication, troubleshooting, plus optimization and tuning. Tools like tablediff, SQLCMD, DTA, SQL Profiler, and Replication Monitor will be discussed to demonstrate the different techniques used in monitoring, administering, and troubleshooting replication. Examines the detailed configuration and the internal workings of the different replication types using reallife scenarios Covers replication with database mirroring and troubleshooting Discusses replication administration using different tools Table of Contents Introduction Replication Basics Types of Replication Configuring Snapshot Replication Using the GUI Configuring Snapshot Replication Using T-SQL Snapshot Generation Internals of Snapshot Replication Configuring Transactional Replication Using the GUI Configuring Transactional Replication Using T-SQL Internals of Transactional Replication Configuring Merge Replication Using the GUI Web Synchronization with Merge Replication Configuring Merge Replication Using T-SQL The Internals of Merge Replication Backup and Recovery of Snapshot and Transactional Replication Backup and Recovery of Merge Replication Optimizing Snapshot Replication Optimizing Transactional Replication Optimizing Merge Replication Heterogeneous Replication

Pro SQL Server 2008 Analytics provides everything you need to know to develop sophisticated and visually appealing sales and marketing dashboards using SQL Server 2008 and to integrate those dashboards with SharePoint, PerformancePoint, and other key Microsoft technologies.

The book begins by addressing the many misconceptions that surround the use of key performance indicators (KPIs) and giving a brief overview of the business intelligence (BI) and reporting tools that can be combined on the Microsoft platform to help you generate the results that you need.

The focus of the book is to help you implement a successful business intelligence project of your own. The text discusses many of the required project planning components, provides overviews and examples associated with Microsoft's BI tools, and gives detailed examples of successful dashboard implementations. What you'll learn The key functional and technical components of a successful report/dashboard implementation What Microsoft tools are provided both within and without SQL Server 2008 to help you achieve an integrated solution How to determine whether your performance indicators are correct for your business and how to roll them out to your organization in an effective way Who this book is for

This book is for entrepreneurs, technologists, and developers who want to bring clear-cut, reliable reporting into their organization. No prior experience of building analytics and reporting dashboards is required, but basic familiarity with SQL Server 2008 is assumed. Table of Contents An Overview of Analytics Seven Keys to Successful Reporting Projects Key Performance Indicators Microsoft Platform Components for Dashboards Core Components of SQL Server 2008 SQL Server Analysis Services Performance Management Implementation and Maintenance of the Integrated System Case Studies

Microsoft SQL Server 2008 introduces new geography and geometry spatial datatypes that enable the storage of structured data describing the shape and position of objects in space. This is an interesting and exciting new feature, with many potentially useful applications.

Beginning Spatial with SQL Server 2008 covers everything you need to know to begin using these new spatial datatypes, and explains how to apply them in practical situations involving the spatial relationships of people, places, and things on the earth.All of the spatial concepts introduced are explained from the ground up, so you need not have any previous knowledge of working with spatial data. Every section is illustrated with code examples that you can use directly in SQL Server. All of the topics covered in this book apply to all versions of SQL Server 2008, including the freely available SQL Server 2008 Express. What you'll learn Understand the fundamental concepts involved in working with spatial data, including spatial references and coordinate systems.Apply these concepts in the collection and storage of spatial data in SQL Server 2008, using the new geometry and geography field types.Create different types of spatial data objectspoints, lines, and polygonsand use these to describe realworld objects.Learn how to analyze spatial data using a range of supported methods, and be aware of a number of different practical applications for these methods.Be shown how to integrate SQL Server with other tools, such as Microsoft Virtual Earth, to display a visual representation of spatial data.Know how to ensure the performance of spatially enabled databases by creating appropriate spatial indexes. Who this book is for

SQL Server developers who wish to use spatial data in Microsoft SQL Server 2008.

Beginning SQL Server 2008 Express for Developers: From Novice to Professional takes a developer, and even a database administrator, from knowing nothing about SQL Server 2008 Express Edition to being ready to design and build a fully functioning system that is secure, reliable, maintainable, and robust. The Express Edition of SQL Server is a free resource commonly used by students, developers of small systems, and those transferring skills from other databases. This book focuses on the features within the Express Edition and therefore will not confuse readers with coverage of features found only in the Development Edition. By the end of the book, readers will be ready to move on to Accelerated SQL Server 2008 as well as other books within the Apress SQL Server lineup such as Pro SQL Server 2008 Reporting Services.Covers using the free Express Edition of SQL Server Describes creating a database from scratch and builds on this Provides an understanding of SQL Server Express 2008, allowing you to build future solutions for you and your business What you'll learn Learn what features exist within SQL Server 2008 Express Edition and how to install and upgrade the product and set up security. Design and create a database. Build database objects, such as tables and stored procedures, graphically as well as programmatically. Work with datainserting, updating, deleting, and retrievingusing simple and complex queries, programs, and data views. Generate reports from data. Implement a solid database maintenance strategy that includes backing up and restoring your data when necessary. Take advantage of advanced TransactSQL techniques to get the most out of your data. Ensure good performance by building the right indexes, defining the right relationships between tables, and joining tables in the most optimal manner. Who this book is for

Anyone interested in working with SQL Server as a database, and particularly those who wish for a no-cost database platform that plays well in the .NET environment. Ideal for those starting out in IT or who have to prior database experience.

Learn effective and scalable database design techniques in a SQL Server environment.Pro SQL Server 2008 Relational Database Design and Implementation covers everything from design logic that business users will understand, all the way to the physical implementation of the design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, authors Louis Davidson, Kevin Kline, Scott Klein, and Kurt Windisch show how to 'get it right' in SQL Server database design and lay a solid groundwork for the future use of valuable business data. Solid foundation in best practices and relational theory Maximize SQL Server features to enhance security, performance, scalability Thorough treatment from conceptual design to an effective, physical implementation What you'll learn Develop conceptual models of client data using interviews and client documentation Normalize data models to enhance scalability and the long term use of valuable data Translate conceptual models into high-performing SQL Server databases Secure and protect the integrity of data as part of meeting regulatory requirements Take full advantage of new SQL Server features such as the spatial datatype, XML support, transparent data encryption, and more Create effective indexing to speed query performance Who this book is for

Pro SQL Server 2008 Relational Database Design and Implementation is designed for programmers of all types who want to use SQL Server 2008 to store data. Rookie database programmers will find a complete course on the fundamentals of database design that includes conceptual designs and physical implementation. Seasoned veterans will find many tips and tricks for implementing database systems that will be well worth the time invested in reading this book.