Book Description:

From the author and series editor of the immensely popular ADMINISTRATOR’S POCKET CONSULTANT series from Microsoft Press®-this pocket-size guide delivers fast, accurate answers on the spot for IT professionals.

Microsoft® SQL Server® 2008 Administrator’s Pocket Consultant, 2nd Edition is the ideal concise, immediate reference you’ll want with you at all times as you deal with Microsoft® SQL Server® 2008 and SQL Server® 2008 R2 administration. Whether you handle administration for 50 users or 5000, this hands-on, fast answers guide focuses on what you need to do to get the job done quickly. With extensive easy-to-read tables, lists, and step-by-step instructions, it’s the portable, readable guide that you consistently save you time and minimize system downtime by giving you the right information right now. Get fast facts to:

• Plan, deploy, and configure SQL Server® 2008 R2
• Administer server and surface security, access, and network configuration
• Import, export, transform, and replicate data
• Use SQL Server® Management Studio for core administrative tasks
• Manipulate schemas, tables, indexes, and views
• Automate maintenance and implement policy-based management
• Monitor server activity and tune performance
• Manage log shipping and database mirroring
• Perform backups and recovery

Book Description:

* Full coverage of SQL Server tools, from installation Query Analyzer to English Query applications.

* Shows how to integrate SQL Server into your VB applications using ADO.

* Extensive coverage of Transact-SQL, and particularly building stored procedures and calling them from VB code.

* Coverage extends right down to advanced topics like SQL Server XML and building web reports.

Book Description:

PowerShell for SQL Server Essentials helps us to manage and monitor server administration and application deployment. Use PowerShell along with SQL Server to perform common DBA tasks.

Starting with a basic introduction to PowerShell, the initial chapters will provide the SQL Server professional PowerShell fundamentals, covering topics such as PowerShell notations and syntax, cmdlets, pipeline, and getting help. Succeeding chapters build upon these fundamentals, and illustrate how to administer and automate SQL Server. Tasks covered throughout include profiling the SQL Server instance, performing backup and restores, invoking T-SQL scripts using PowerShell, and monitoring jobs, security, and permissions.

Packed with practical examples and numerous ready-to-use snippets, this book gets you to an intermediate level in using PowerShell for SQL Server.

Book Description:

If you have mastered the fundamentals of the PL/SQL language and are now looking for an in-depth, practical guide to solving real problems with PL/SQL stored procedures, then this is the book for you.

Book Description:

Take a deep dive into the many uses of dynamic SQL in Microsoft SQL Server. This edition has been updated to use the newest features in SQL Server 2016 and SQL Server 2017 as well as incorporating the changing landscape of analytics and database administration. Code examples have been updated with new system objects and functions to improve efficiency and maintainability.

Executing dynamic SQL is key to large-scale searching based on user-entered criteria. Dynamic SQL can generate lists of values and even code with minimal impact on performance. Dynamic SQL enables dynamic pivoting of data for business intelligence solutions as well as customizing of database objects. Yet dynamic SQL is feared by many due to concerns over SQL injection or code maintainability.

Dynamic SQL: Applications, Performance, and Security in Microsoft SQL Server helps you bring the productivity and user-satisfaction of flexible and responsive applications to your organization safely and securely. Your organization’s increased ability to respond to rapidly changing business scenarios will build competitive advantage in an increasingly crowded and competitive global marketplace. With a focus on new applications and modern database architecture, this edition illustrates that dynamic SQL continues to evolve and be a valuable tool for administration, performance optimization, and analytics.

What You’ill Learn

• Build flexible applications that respond to changing business needs
• Take advantage of creative, innovative, and productive uses of dynamic SQL
• Know about SQL injection and be confident in your defenses against it
• Address performance concerns in stored procedures and dynamic SQL
• Troubleshoot and debug dynamic SQL to ensure correct results
• Automate your administration of features within SQL Server

Developers and database administrators looking to hone and build their T-SQL coding skills. The book is ideal for developers wanting to plumb the depths of application flexibility and troubleshoot performance issues involving dynamic SQL. The book is also ideal for programmers wanting to learn what dynamic SQL is about and how it can help them deliver competitive advantage to their organizations.

Book Description:

Publisher’s Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

The Essential Guide to Scaling Your Business Solution

Written by Oracle ACE Director and MySQL expert Ronald Bradford, with coauthor Chris Schneider, Effective MySQL: Replication Techniques in Depth describes what is needed to understand and implement MySQL replicationto build scalable solutions. This book includes detailed syntax examples to demonstrate the features, options, and limitations of native MySQL replication. Providing an evaluation of various new replication features andadditional third-party product implementations, this Oracle Press guide helps to ensure your MySQL environment can support the various high-availability needs of your business.

• Master the strengths and limitations of native asynchronous replication in a MySQL topology
• Identify the important features to improve replication for growing business requirements
• Recognize the key business factors to determine your optimal highavailability needs
• Understand the benefits of using MySQL replication for failover scenarios
• Identify the key configuration variables and SQL commands affecting master/ slave replication
• Learn about the advancements in replication techniques provided by new products, including Tungsten Replicator and Galera
• Optimize your replication management with various utilities and toolkits

Find additional detailed information and presentations at EffectiveMySQL.com.

Book Description:

Get ready to make SQL easy!

Updated for the latest version of SQL, the new edition of this perennial bestseller shows programmers and web developers how to use SQL to build relational databases and get valuable information from them. Covering everything you need to know to make working with SQL easier than ever, topics include how to use SQL to structure a DBMS and implement a database design; secure a database; and retrieve information from a database; and much more.

SQL is the international standard database language used to create, access, manipulate, maintain, and store information in relational database management systems (DBMS) such as Access, Oracle, SQL Server, and MySQL. SQL adds powerful data manipulation and retrieval capabilities to conventional languages—and this book shows you how to harness the core element of relational databases with ease.

• Server platform that gives you choices of development languages, data types, on-premises or cloud, and operating systems
• Find great examples on the use of temporal data
• Jump right in—without previous knowledge of database programming or SQL

As database-driven websites continue to grow in popularity—and complexity—SQL For Dummies is the easy-to-understand, go-to resource you need to use it seamlessly.

Book Description:

Book Description:

Get the basics on four key web programming tools in one great book!

PHP, JavaScript, and HTML5 are essential programming languages for creating dynamic websites that work with the MySQL database. PHP and MySQL provide a robust, easy-to-learn, open-source solution for creating superb e-commerce sites and content management. JavaScript and HTML5 add support for the most current multimedia effects. This one-stop guide gives you what you need to know about all four! Seven self-contained minibooks cover web technologies, HTML5 and CSS3, PHP programming, MySQL databases, JavaScript, PHP with templates, and web applications.

• Addresses how PHP, MySQL, JavaScript, and HTML5 are vital tools for creating dynamic, database-driven websites and are especially important for e-commerce sites
• Serves as essential reading for web designers who are new to these technologies, offering a crash course covering all of these powerful technologies in this handy volume of seven self-contained minibooks
• Covers how to program in PHP and how to create and administer a MySQL database as well as how to manipulate MySQL data via a web interface
• Shows how to create a secure website and how to code popular e-business applications such as login programs and shopping carts

With seven books in one, PHP, MySQL, JavaScript & HTML5 All-in-One For Dummies will turn your website into the center of attention in no time at all.

Book Description:

Identify and fix causes of poor performance. You will learn Query Store, adaptive execution plans, and automated tuning on the Microsoft Azure SQL Database platform. Anyone responsible for writing or creating T-SQL queries will find valuable the insight into bottlenecks, including how to recognize them and eliminate them.

This book covers the latest in performance optimization features and techniques and is current with SQL Server 2017. If your queries are not running fast enough and you’re tired of phone calls from frustrated users, then this book is the answer to your performance problems.

SQL Server 2017 Query Performance Tuning is about more than quick tips and fixes. You’ll learn to be proactive in establishing performance baselines using tools such as Performance Monitor and Extended Events. You’ll 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. The goal is to head off trouble before it occurs.

What You’ll Learn

• Use Query Store to understand and easily change query performance
• 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 to minimize performance risk
• Design in the performance that you need through careful query and index design
• Utilize the latest performance optimization features in SQL Server 2017
• Protect query performance during upgrades to the newer versions of SQL Server

Developers and database administrators with responsibility for application performance in SQL Server environments. Anyone responsible for writing or creating T-SQL queries will find valuable the insight into bottlenecks, including how to recognize them and eliminate them.

Book Description:

This book aims to give IBM i technical users basic to intermediate SQL knowledge and tools they can use to get more out of the IBM i database. The book can be useful to veteran IBM i programmers, who have RPG and COBOL roots, system administrators looking to get more information out of their IBM i system, or even Java and .NET developers who need to “talk” to IBM i database. The author provides comprehensive examples and exercises to help readers understand and practice what they have learned.

Book Description:

Administrators who need to learn or refresh their knowledge of how to back up and restore SQL Server databases in various scenarios

Book Description:

Build a core level of competency in SQL so you can recognize the parts of queries and write simple SQL statements. SQL knowledge is essential for anyone involved in programming, data science, and data management. This book covers features of SQL that are standardized and common across most database vendors. You will gain a base of knowledge that will prepare you to go deeper into the specifics of any database product you might encounter.

Book Description:

As a DBA you must have encountered a slow running application on SQL Server, but there are various factors that could be affecting the performance. If you find yourself in this situation, don’t wait, pick up this book and start working towards improving performance of your SQL Server 2012. SQL Server 2012 Performance Tuning Cookbook is divided into three major parts — Performance Monitoring, Performance Tuning, and Performance Management–that are mandatory to deal with performance in any capacity.

SQL Server 2012 Performance Tuning Cookbook offers a great way to manage performance with effective, concise, and practical recipes. You will learn how to diagnose performance issues, fix them, and take precaution to avoid common mistakes.

Each recipe given in this book is an individual task that will address different performance aspects to take your SQL Server’s Performance to a higher level.

The first part of this book covers Monitoring with SQL Server Profiler, DTA, System statistical function, SPs with DBCC commands, Resource Monitor & Reliability, and Performance Monitor and Execution Plan.

The second part of the book offers Execution Plan, Dynamic Management Views, and Dynamic Management Functions, SQL Server Cache and Stored Procedure Recompilations, Indexes, Important ways to write effective TSQL, Statistics, Table and Index Partitioning, Advanced Query tuning with Query Hints and Plan Guide, Dealing with Locking, Blocking and Deadlocking and Configuring SQL Server for optimization to boost performance.

The third and final part gives you knowledge of performance management with help of Policy Based Management and Management with Resource Governor.

What will you learn from this book

• Monitoring SQL Server Performance with Profiler, Execution Plan, and system statistical function
• Finding performance bottleneck with the help of Resource Monitor and DTA
• Creating and Managing Indexes efficiently to boost performance
• Creating and Managing Partition efficiently
• Managing database files efficiently
• Planning Guide and Query Hints
• Dealing with locking, blocking, and deadlocking
• Configuring SQL Server instance option for achieving performance benefit
• Managing Performance with Policy based management and Resource Governor

Book Description:

Implement, maintain, and repair SQL Server 2012 databases

As the most significant update since 2008, Microsoft SQL Server 2012 boasts updates and new features that are critical to understand. Whether you manage and administer SQL Server 2012 or are planning to get your MCSA: SQL Server 2012 certification, this book is the perfect supplement to your learning and preparation. From understanding SQL Server’s roles to implementing business intelligence and reporting, this practical book explores tasks and scenarios that a working SQL Server DBA faces regularly and shows you step by step how to handle them.

• Includes practice exams and coverage of exam objectives for those seeking MSCA: SQL Server 2012 certification
• Explores the skills you’ll need on the job as a SQL Server 2012 DBA
• Discusses designing and implementing database solutions
• Walks you through administrating, maintaining, and securing SQL Server 2012
• Addresses implementing high availability and data distribution
• Includes bonus videos where the author walks you through some of the more difficult tasks expected of a DBA

Featuring hands-on exercises and real-world scenarios, this resource guides you through the essentials of implementing, maintaining, and repairing SQL Server 2012 databases.

Book Description:

Here is the ideal field guide for data warehousing implementation. This book first teaches you how to build a data warehouse, including defining the architecture, understanding the methodology, gathering the requirements, designing the data models, and creating the databases. Coverage then explains how to populate the data warehouse and explores how to present data to users using reports and multidimensional databases and how to use the data in the data warehouse for business intelligence, customer relationship management, and other purposes. It also details testing and how to administer data warehouse operation.

Book Description:

Optimize reporting and BI with Microsoft SQL Server 2016

Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports provides a comprehensive lesson in business intelligence (BI), operational reporting and Reporting Services architecture using a clear, concise tutorial approach. You’ll learn effective report solution design based upon many years of experience with successful report solutions. Improve your own reports with advanced, best-practice design, usability, query design, and filtering techniques. Expert guidance provides insight into common report types and explains where each could be made more efficient, while providing step-by step instruction on Microsoft SQL Server 2016. All changes to the 2016 release are covered in detail, including improvements to the Visual Studio Report Designer (SQL Server Data Tools) and Report Builder, Mobile Dashboard Designer, the new Report Portal Interface, HTML-5 Rendering, Power BI integration, Custom Parameters Pane, and more.

The Microsoft SQL Server 2016 release will include significant changes. New functionality, new capabilities, re-tooled processes, and changing support require a considerable update to existing knowledge. Whether you’re starting from scratch or simply upgrading, this book is an essential guide to report design and business intelligence solutions.

• Understand BI fundamentals and Reporting Services architecture
• Learn the ingredients to a successful report design
• Get up to speed on Microsoft SQL Server 2016
• Grasp the purpose behind common designs to optimize your reporting

Microsoft SQL Server Reporting Services makes reporting faster, easier, and more powerful than ever in web, desktop and portal solutions. Compatibility with an extensive variety of data sources makes it a go-to solution for organizations across the globe. The 2016 release brings some of the biggest changes in years, and the full depth and breadth of these changes can create a serious snag in your workflow. For a clear tutorial geared toward the working professional, Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports is the ideal guide for getting up to speed and producing successful reports.

Book Description:

Get a fast start to using AlwaysOn, the SQL Server solution to high-availability and disaster recovery. This second edition is newly-updated to cover the 2016 editions of both SQL Server and Windows Server. Also in this edition is all-new content on troubleshooting and metadata. The book provides a solid and accurate understanding of how to implement systems requiring consistent and continuous uptime, as well as how to troubleshoot those systems in order to keep them running an reliable.

Begin with an introduction to high-availability and disaster recovery concepts such as Recovery Point Objectives (RPOs), Recovery Time Objectives (RTO), availability levels, and the cost of downtime. Then move into detailed coverage of implementing and configuring the AlwaysOn feature set in order to meet the business objectives set by your organization.

SQL Server AlwaysOn Revealed offers real-world advice on how to build and configure the most appropriate topology to meet the high-availability and disaster recovery requirements you are faced with. Content includes strong coverage on implementing clusters, on building AlwaysOn failover clustered instances, and on configuring AlwaysOn Availability Groups. This is a practical and hand-on book to get you started quickly in using one of the most talked-about SQL Server feature sets.

• Teaches you to build HA and DR solutions using the AlwaysOn feature set
• Provides real-world advice on configuration and performance considerations
• Demonstrates administrative techniques for the AlwaysOn feature set

What You Will Learn

• Understand high availability and disaster recovery in SQL Server 2016
• Build and configure a Windows Cluster
• Create and configure an AlwaysOn failover clustered instance
• Implement AlwaysOn Availability Groups and appropriately configure them
• Administer AlwaysOn technologies post implementation
• Troubleshoot and resolve problems with misbehaving systems

Who This Book Is For

Database administrators interested in growing their knowledge and skills in Microsoft SQL Server’s high-availability and disaster recovery feature set.

Book Description:

Microsoft SQL Server Reporting Services 2008 is the third generation Microsoft reporting software that is more tightly integrated with SQL Server 2008 than ever before. It provides a complete server-based platform that is designed to support a wide variety of reporting needs, including managed enterprise reporting, special purpose reporting, embedded reporting, and web-based reporting.

Ideal for beginners who need to create reports as quickly as possible, this book will lead you through practical examples to teach you a full range of skills for reporting with SQL Server 2008 Reporting Services. A series of carefully picked exercises help you practice the most important aspects of report creation. By the end of the book, you will have the confidence to take on the most complex of reports, and be producing reports that will make you the envy of your organization.

What you will learn from this book?

• Install SQL Server 2008 and configure the SQL Server Reporting Services
• Learn the various components and tools that enable end-to-end support for all reporting activities
• Use the report viewer control to get started with the essentials of retrieving and displaying data
• Create a Report Model using the Visual Studio 2008 Template
• Learn to modify reports on a report server and create linked files with report manager
• Embed Microsoft Report Viewer Controls in web and Windows applications
• Create interactive reports with charts and gauges using Report Builder
• Create several kinds of reports with Report Builder 2.0
• Create server reports and report models and deploy them
• Get the full details of available programming interfaces and their usage
• Learn to work with Crystal Reports 2008
• Import reports created using MS Access
• Learn how to use the Programming API, convert Report file types, use command-line utilities and more

Book Description:

The ability to use SQLite with iOS provides a great opportunity to build amazing apps. Apple’s iOS SDK provides native support for SQLite databases. This combination offers the potential to create powerful, data-persistent applications.

This book starts with the architecture of SQLite database and introduces you to concepts in SQL . You will find yourself equipped to design your own database system, administer it, and maintain it. Further, you will learn how to operate your SQLite databases smoothly using SQL commands.

You will be able to extend the functionality of SQLite by using its vast arsenal of C API calls to build some interesting, exciting, new, and intelligent data-driven applications. Understand how Xcode, HTML5, and Phonegap can be used to build a cross-platform modern app which can benefit from all these technologies – all through creating a complete, customizable application skeleton that you can build on for your own apps.

What you will learn

• Explore Swift’s basic language statements
• Connect to SQLite and execute SQL statements
• Extend the SQLite language to create your own software extensions
• Use HTML5 with Phonegap on iOS
• Set up a Swift project using XCode with SQLite
• Administer SQLite databases in an easy and effective way