Develop the skill you need in the real world. Hit the ground running with the street-smart training you'll find in this practical book. Using a "Year in the life" approach, it gives you an inside look at SQL Server 2005 database administration, with key information organized around the actual day-to-day tasks, scenarios, and challenges you'll face in the field. This valuable training tool is loaded with hands-on, step-by-step exercises covering all phases of SQL Server 2005 administration, including: * Installing and configuring SQL Server * High availability and disaster recovery * Maintenance and automation * Monitoring and troubleshooting An Invaluable study tool This no-nonsense book also maps to the common tasks and objectives for Microsoft's MCTS SQL Server (TM) 2005 Implementation and Maintenance exam (70-431). So whether you're preparing for certification or seeking practical skills to break into the field, you'll find the instruction you need, including: * Upgrading from a previous version of SQL Server * Configuring an operating mode * Restoring a database * Creating a Transact-SQL user-defined type * Using Windows(r) System Monitor to Monitor performance THE STREET SMARTS SERIES is designed to help current or sparing IT professionals put their certification to work for them. Full of practical, real world scenarios, each book features actual tasks from the field and then offers step-by-step exercises that teach the skills necessary to complete those tasks. And because the exercises are based upon exam objectives from leading technology certifications, each Street Smarts book can be used as a lab manual for certification prep.

Develop the skills you need in the real world Hit the ground running with the street-smart training you'll find in this practical book. Using a "year in the life" approach, it gives you an inside look at Linux administration, with key information organized around the actual day-to-day tasks, scenarios, and challenges you'll face in the field. This valuable training tool is loaded with hands-on, step-by-step exercises covering all phases of Linux administration, including: * Working on the command line * Configuring hardware and the kernel * Managing software and processes * Documenting the system * Working with partitions and file systems * Configuring network features * Managing security An invaluable study tool This no-nonsense book also maps to the common tasks and exam objectives for the Linux Professional Institute (LPI) LPIC-1 certification exam and CompTIA's Linux+ certification exam. So whether you're preparing for certification or seeking practical skills to break into the field, you'll find the instruction you need, such as: * Using the command shell history * Redirecting input and output * Resolving hardware conflicts * Reconfiguring the login screen * Managing RPM and Debian packages * Protecting your system from runaway processes * Monitoring your system for degraded performance and security problems * Using journaling filesystems * Configuring common server software The Street Smarts Series is designed to help current or aspiring IT professionals put their certification to work for them. Full of practical, real world scenarios, each book features actual tasks from the field and then offers step-by-step exercises that teach the skills necessary to complete those tasks. And because the exercises are based upon exam objectives from leading technology certifications, each Street Smarts book can be used as a lab manual for certification prep.

Get the communication skills you need for career success with this unique book. Preparing you for exams and beyond, the valuable content delves into the issues that you’ll face in corporate, retail, and remote support environments. The book offers more than fifty scenarios depicting typical workplace situations, possible responses-and appropriate solutions to guide you. With this approach, you’ll gain valuable insight into becoming a team player and learn strategies to communicate more effectively with coworkers and customers.

bull; Contains the most depth and breadth of coverage of any book on SQL Server architecture, internals, and tuning bull; Will be a key reference for anyone working with SQL Server, no matter what their skill level bull; The latest book in the bestselling series of Guru's Guides from Ken Henderson

"SQL Server Administration with Perl" consists of a series of scenarios covering a wide range of SQL Server administrative topics. These are real-world scenarios that you hear DBAs discussing on the SQL Server forums and newsgroups-scenarios that DBAs run into in their day-to-day development or production environments. Readers will walk away from this book with two things: a DBA toolkit with well over 150 Perl scripts and problem-solving techniques they can apply to create even more tools for attacking other SQL Server administrative problems.

Explore the impressive storage and analytic tools available with the in-cloud and on-premises versions of Microsoft SQL Server 2019. Key FeaturesGain insights into what’s new in SQL Server 2019Understand use cases and customer scenarios that can be implemented with SQL Server 2019Discover new cross-platform tools that simplify management and analysisBook Description Microsoft SQL Server comes equipped with industry-leading features and the best online transaction processing capabilities. If you are looking to work with data processing and management, getting up to speed with Microsoft Server 2019 is key. Introducing SQL Server 2019 takes you through the latest features in SQL Server 2019 and their importance. You will learn to unlock faster querying speeds and understand how to leverage the new and improved security features to build robust data management solutions. Further chapters will assist you with integrating, managing, and analyzing all data, including relational, NoSQL, and unstructured big data using SQL Server 2019. Dedicated sections in the book will also demonstrate how you can use SQL Server 2019 to leverage data processing platforms, such as Apache Hadoop and Spark, and containerization technologies like Docker and Kubernetes to control your data and efficiently monitor it. By the end of this book, you'll be well versed with all the features of Microsoft SQL Server 2019 and understand how to use them confidently to build robust data management solutions. What you will learnBuild a custom container image with a DockerfileDeploy and run the SQL Server 2019 container imageUnderstand how to use SQL server on LinuxMigrate existing paginated reports to Power BI Report ServerLearn to query Hadoop Distributed File System (HDFS) data using Azure Data StudioUnderstand the benefits of In-Memory OLTPWho this book is for This book is for database administrators, architects, big data engineers, or anyone who has experience with SQL Server and wants to explore and implement the new features in SQL Server 2019. Basic working knowledge of SQL Server and relational database management system (RDBMS) is required.

This hands-on guide provides much-needed information and guidance for the Access power user or developer wanting to exploit the power of SQL Server. It provides readers with the practical knowledge they need to harness the enterprise-level power and scalability SQL Server offers, while using the Access tools with which they are more familiar.