Pro SQL Server 2012 Administration is a one-stop source for all the
knowledge you'll need to professionally manage a database under
Microsoft SQL Server 2012. SQL Server administration is a complex field
requiring an unusually broad and well-rounded skill set. A good database
administrator must be part system administrator, part database design
expert, and part SQL tuning optimization guru. Above all, he or she must
be capable of restoring a damaged database at any time. Database
administration requires excellent people skills for dealing with
management and clients, and solid technical skills for dealing with the
hardware and the software.
Pro SQL Server 2012 Administration addresses all aspects of database
administration, regardless of the size of the implementation. Install
SQL Server 2012 and create new database environments. Develop a sound
backup strategy for your database. Perform recovery as needed, which
many consider to be job #1. Authors Ken Simmons and Sylvester
Carstarphen also help you automate your work through the use of
policy-based management. Performance optimization gets good coverage, so
that you can render assistance when developers need help with problem
queries.
Practical PHP and MySQL Website Databases is a project-oriented book
that demystifies building interactive, database-driven websites. The
focus is on getting you up and running as quickly as possible. In the
first two chapters you will set up your development and testing
environment, and then build your first PHP and MySQL database-driven
website. You will then increase its sophistication, security, and
functionality throughout the course of the book. The PHP required is
taught in context within each project so you can quickly learn how PHP
integrates with MySQL to create powerful database-driven websites.
Each project is fully illustrated, so you will see clearly what you are
building as you create your own database-driven website. You will build a
form for registering users, and then build an interface so that an
administrator can view and administer the user database. You will create
a message board for users and a method for emailing them. You will also
learn the best practices for ensuring that your website databases are
secure. Later chapters describe how to create a blog, a product catalog,
and a simple e-commerce site. You will also discover how to migrate a
database to a remote host. Because you are building the interactive
pages yourself, you will know exactly how the MySQL and PHP work, and
you will be able to add database interactivity to your own websites with
ease.
Fill the gap between planning and doing with SSIS 2014
The 2014 release of Microsoft’s SQL Server Integration Services provides
enhancements for managing extraction, transformation, and load
operations, plus expanded in-memory capabilities, improved disaster
recovery, increased scalability, and much more. The increased
functionality will streamline your ETL processes and smooth out your
workflow, but the catch is that your workflow must change. New tools
come with new best practices, and Professional Microsoft SQL Server 2014
Integration Services will keep you ahead of the curve. SQL Server MVP
Brian Knight is the most respected name in the business, and your
ultimate guide to navigating the changes to use Microsoft SQL Server
Integration Services 2014 to your utmost advantage.
Implement new best practices for effective use of SSIS
Work through tutorials for hands-on learning of complex techniques
Read case studies that illustrate the more advanced concepts
Learn directly from the foremost authority on SSIS
SQL Server Integration Services is a complex tool, but it’s the
lifeblood of your work. You need to know it inside out, and you must
understand the full potential of its capabilities in order to use it
effectively. You need to make sure the right architecture is in
place.Professional Microsoft SQL Server 2014 Integration Services is
your roadmap to understanding SSIS on a fundamental level, and setting
yourself up for success.
Fill the gap between planning and doing with SSIS 2014 The 2014 release
of Microsoft?s SQL Server Integration Services provides enhancements for
managing extraction, transformation, and load operations, plus expanded
in-memory capabilities, improved disaster recovery, increased
scalability, and much more. The increased functionality will streamline
your ETL processes and smooth out your workflow, but the catch is that
your workflow must change. New tools come with new best practices, and
Professional Microsoft SQL Server 2014 Integration Services will keep
you ahead of the curve. SQL Server MVP Brian Knight is the most
respected name in the business, and your ultimate guide to navigating
the changes to use Microsoft SQL Server Integration Services 2014 to
your utmost advantage.
Implement new best practices for effective use of SSIS Work through
tutorials for hands-on learning of complex techniques Read case studies
that illustrate the more advanced concepts Learn directly from the
foremost authority on SSIS SQL Server Integration Services is a complex
tool, but it?s the lifeblood of your work. You need to know it inside
out, and you must understand the full potential of its capabilities in
order to use it effectively. You need to make sure the right
architecture is in place. Professional Microsoft SQL Server 2014
Integration Services is your roadmap to understanding SSIS on a
fundamental level, and setting yourself up for success.
Your hands-on, step-by-step guide to building applications with Microsoft® SQL Server® 2012.
Teach yourself the programming fundamentals of SQL Server 2012—one step
at a time. Ideal for beginning SQL Server database administrators and
developers, this tutorial provides clear guidance and practical,
learn-by-doing exercises for building database solutions that solve
real-world business problems.
Discover how to:
Install and work with core components and tools
Create tables and index structures
Manipulate and retrieve data
Secure, manage, back up, and recover databases
Apply techniques for building high-performing applications
Use clustering, database mirroring, and log shipping Microsoft SQL Server 2012 Step by Step
Master the Next-Generation Business Intelligence Tools in SQL Server 2008 R2
Effectively convey meaningful business insights to users across your
enterprise with help from this practical guide. Written by a team of
business intelligence experts, Microsoft SQL Server 2008 R2 Analytics
& Data Visualization shows how to achieve greater information
absorption using the latest reporting tools. Learn how to build maps and
gauges, integrate OLAP data, and develop dashboards. Security,
performance tuning, and cloud computing techniques are also covered in
this comprehensive resource.
Design and deploy chart-based reports using SSRS 2008 R2
Display geo-spatial map data with location-based indicators
Visually represent metrics and KPIs on graphs and gauges
Distribute reports through SharePoint and PerformancePoint
Create and publish web page parts, dashboards, and mash-ups
Set up and manage cloud-based services using SQL Azure
Incorporate data mining and forecasting features with Visio
Integrate large amounts of data using PowerPoint for Excel
Derive matrix, table, and chart data from OLAP cubes Microsoft SQL Server 2008 R2 Analytics & Data Visualization
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.
Expert MySQL is the leading reference for learning, understanding, and extending the MySQL server. It unlocks the full promise of open source by showing how to modify the code, create your own storage engine, build your own authentication plugins, and even add your own functions and commands to the SQL language. No other book provides the level of detail or the extensive examples of the inner workings of MySQL that have taken engineers years to master. Expert MySQL is a must have book for all systems integrators, engineers, and software developers working with the MySQL server code.
Expert MySQL is also a wealth of information on key aspects of MySQL internals. You’ll learn about internal query representation, how the optimizer creates execution plans, and how to exert control over those plans for optimal performance in your environment. You'll even learn to build your own query optimizer, giving insight that can help you understand and resolve tough performance problems. High-availability and replication are also covered, making Expert MySQL a must-have book for anyone doing high-end work involving MySQL. Shows how to customize MySQL and its storage and authentication engines Provides in-depth knowledge of internals for use in query tuning and performance troubleshooting Covers high-end features such as high-availability and replication. Expert MySQL
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. Expert Performance Indexing for SQL Server 2012
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.
Pro SQL Server 2012 Practices is an anthology of high-end wisdom from a
group of accomplished database administrators who are quietly but
relentlessly pushing the performance and feature envelope of Microsoft
SQL Server 2012. With an emphasis upon performance—but also branching
into release management, auditing, and other issues—the book helps you
deliver the most value for your company’s investment in Microsoft’s
flagship database system
* Goes beyond the manual to cover good techniques and best practices
* Delivers knowledge usually gained only by hard experience
* Focuses upon performance, scalability, reliability
* Helps achieve the predictability needed to be in control at all times
What you’ll learn
* Migrate to the new Extended Events framework for troubleshooting performance problems
* Automate the tracking of key performance indicators such as
available disk space, cpu utilization, index fragmentation, and more
* Design performance into your database and its applications from the very beginning
* Manage staged releases from development to test through to production
* Diagnose resource and performance problems via dynamic management views
* Analyze I/O patterns and plan reliably to obtain the performance you need
Who this book is for
Pro SQL Server 2012 Practices is aimed at SQL Server professionals who
want to further their careers through expert-level practices in
performance management, scalability, predictability, and security.
If your organization plans to move to a cloud infrastructure from a LAN or WAN, this book shows you how to do it efficiently with Windows Server 2012. Experienced Windows administrators will learn how to deploy, configure, and manage the server’s expanded capabilities and features step-by-step, using clear examples and numerous screen shots. You’ll also discover how to integrate employees’ private mobile devices into your corporate network.
Whether you intend to take your infrastructure to a public, private, or hybrid cloud environment, Windows Server 2012 provides the virtualization technology to get you there. This book helps you put it to work.
Control your entire Windows infrastructure from the Server Manager console Learn how Active Directory Domain Services provide more centralized network administration Use Dynamic Access Control to manage data and user permissions Provide data integrity and fault tolerance with Storage Spaces and ReFS Gain robust management of virtual environments with Hyper V R3 Master networking tools such as IPAM to help you move to the cloud Connect clients to network resources through Unified Remote Access
In 2011, a big corporation suffered a 23-day network outage after a breach of security that allowed the theft of millions of registered accounts on its gaming network. A month later, hackers claimed in a press release to have stolen personal information of 1 million users by a single SQL injection attack. In these days of high-profile hacking, SQL Server 2012 database security has become of prime importance.
???Microsoft SQL Server 2012 Security Cookbook??? will show you how to secure your database using cutting-edge methods and protect it from hackers and other security threats. You will learn the latest techniques for data and code encryption, user authentication and authorization, protection against brute force attacks, denial-of-service attacks, and SQL Injection, securing business intelligence, and more.
We will start with securing SQL Server right from the point where you install it. You will learn to secure your server and network with recipes such as managing service SIDs, configuring a firewall for SQL Server access, and encrypting the session by SSL. We will then address internal security : creating logins to connect to SQL Server, and users to gain access to a database. We will also see how to grant privileges to securable objects on the server or inside the database.
After having managed authentication through logins and users, we will assign privileges inside a database using permissions. We will then learn about symmetric keys, asymmetric keys and certificates, which can be used to encrypt data or sign data and modules with a choice of cipher algorithms, as well as creating hash representations of data.
Then we will cover methods to protect your database against brute force attacks, denial-of-service attacks, and SQL Injection. Finally we will learn about auditing and compliance and securing SQL Server Analysis Services (SSAS) and Reporting Services (SSRS).
What you will learn from this book
Start securing your database right from the first step when you install it
Protect your database against brute force attacks, denial-of-service attacks, and SQL Injection
Secure SQL Server Analysis Services (SSAS) and Reporting Services (SSRS)
Use a SQL or Web Application Firewall
Perform user authentication and authorization
Manage object ownership and protect data through views and stored procedures
Create and use certificates, and symmetric and asymmetric encryption keys
Authenticate stored procedures by signatures
Monitor SQL Server logs and use DML and DDL trigger for auditing
Configure SQL Server database audit and manage audit resilience after a crash
Over 80 quick and advanced recipes that focus on real-world techniques
and solutions to manage, design, and build data warehouse and business
intelligence projects.
Full of illustrations, diagrams, and tips with clear step-by-step
instructions and real time examples to perform key steps and functions
on your project
Practical ways to estimate the effort of a data warehouse solution based on a standard work breakdown structure.
Learn to effectively turn the project from development to a live solution
Best practices to create a blueprint for the business intelligence solution
In Detail
Oracle Database 11g is a comprehensive database platform for data
warehousing and business intelligence that combines industry-leading
scalability and performance, deeply-integrated analytics, and embedded
integration and data-quality all in a single platform running on a
reliable, low-cost grid infrastructure. This book steps through the
lifecycle of building a data warehouse with key tips and techniques
along the way.
Business Intelligence Cookbook: A Project Lifecycle Approach Using
Oracle Technology outlines the key ways to effectively use Oracle
technology to deliver your business intelligence solution. This is a
practical guide starting with key recipes for project management then
moving onto project delivery.
Business Intelligence Cookbook: A Project Lifecycle Approach Using
Oracle Technology is a practical guide for performing key steps and
functions on your project.
This book starts with setting the foundation for a highly repeatable
efficient project management approach by assessing your current
methodology to see how suitable it is for a business intelligence
program. We also learn to set up the project delivery phases to
consistently estimate the effort for a project. Along the way we learn
to create blueprints for the business intelligence solution that help to
connect and map out the destination of the solution. We then move on to
analyze requirements, sources, and data. Finally we learn to secure the
data as it is an important asset within the organization and needs to
be secured efficiently and effectively.
What you will learn from this book
Master some of the key techniques and components to enable you to visualise and interrogate information effectively
Understand additional and advanced techniques to enhance your ETL/ELT solution
Learn to build the data model using Oracle SQL Data Modeller and the
Oracle Database to build your logical and physical data model and OBIEE
to build the presentation data model.
Develop data discovery scripts to uncover data issues and gaps
Learn to reverse engineer source data models and map data sources to business requirements using Oracle SQL Data Modeller.
Get to grips with mapping information into semantic definitions
Understand the ways to define a security model
Approach
This book is written in a simple, easy to understand format with lots of screenshots and step-by-step explanations.
Who this book is written for
If you are Project Managers or IT professionals looking to design and
develop a data warehouse and business intelligence solution, then this
is the best guide for you.
This book assumes that you have a fundamental knowledge of data warehouse and business intelligence projects.
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
Microsoft SQL Server implements extensive support for location-based
data. Pro Spatial with SQL Server 2012 introduces SQL 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 up—no 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 examples that 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 2012 is 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#.
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.
Get up to speed on the extensive changes to the newest release of Microsoft SQL Server
The 2012 release of Microsoft SQL Server changes how you develop
applications for SQL Server. With this comprehensive resource, SQL
Server authority Robert Vieira presents the fundamentals of database
design and SQL concepts, and then shows you how to apply these concepts
using the updated SQL Server. Publishing time and date with the 2012
release, Beginning Microsoft SQL Server 2012 Programming begins with a
quick overview of database design basics and the SQL query language and
then quickly proceeds to show you how to implement the fundamental
concepts of Microsoft SQL Server 2012.
You'll explore the key additions and changes to this newest version,
including conditional action constructs, enhanced controls for results
paging, application integration with SharePoint and Excel, and
development of BI applications.
Covers new features such as SQL Azure for cloud computing,
client-connectivity enhancements, security and compliance, data
replication, and data warehouse performance improvements
Addresses essential topics including managing keys, writing scripts, and working with store procedures
Shares helpful techniques for creating and changing tables,
programming with XML, and using SQL Server Reporting and Integration
Services
Beginning Microsoft SQL Server 2012 Programming demystifies even the
most difficult challenges you may face with the new version of Microsoft
SQL Server
