Catalog Search Results
Author
Series
Description
Protect your data from attack by using SQL Server technologies to implement a defense-in-depth strategy for your database, consisting of multiple layers of protection. Learn to perform threat analysis, and to encrypt sensitive data as a last line of defense against compromise. The multi-layered approach in this book helps ensure that a single breach doesn't lead to loss or compromise of your data that is confidential and important to the business....
Series
Description
Chapter 5: SQL Server Management and Development Tools; Organizing the Interface; Registered Servers; Object Explorer; Using the Query Editor; Using the Solution Explorer; Getting a Jumpstart on Code with Templates and Code Snippets; Summary; Part II: Building Databases and Working with Data; Chapter 6: Introducing Basic Query Flow; Understanding Query Flow; FROM Clause Data Sources; WHERE Conditions; (0 row(s) affected)Columns, Stars, Aliases, and...
Author
Formats
Description
The integrity and security of your database is crucial to your business. SQL Server 2008 is a massive and mature product with a very large feature set. As a SQL Server administrator, you must be equipped to handle myriad day-to-day tasks to keep your database healthy, and you must also be prepared to act quickly when something unexpected happens. SQL Server 2008 Administration in Action offers over 100 DBA-tested, high-value, best practices that will...
Series
Description
The new edition of the successful previous version is 25 percent revised and packed with more than 200 pages of new material on the 2008 release of SQL Server Integration Services (SSIS).; Renowned author Brian Knight and his expert coauthors show developers how to master the 2008 release of SSIS, which is both more powerful and more complex than ever.; Case studies and tutorial examples acquired over the three years since the previous edition will...
Author
Description
Get the most out of the rich development capabilities of SQL Server 2016 to build efficient database applications for your organization About This Book Utilize the new enhancements in Transact-SQL and security features in SQL Server 2016 to build efficient database applications Work with temporal tables to get information about data stored in the table at any point in time A detailed guide to SQL Server 2016, introducing you to multiple new features...
Author
Series
Description
Improve your ability to develop, manage, and troubleshoot SQL Server solutions by learning how different components work "under the hood," and how they communicate with each other. The detailed knowledge helps in implementing and maintaining high-throughput databases critical to your business and its customers. You'll learn how to identify the root cause of each problem and understand how different design and implementation decisions affect performance...
Author
Description
There is a lot at stake for administrators taking care of servers, since they house sensitive data like credit cards, social security numbers, medical records, and much more. In Securing SQL Server you will learn about the potential attack vectors that can be used to break into your SQL Server database, and how to protect yourself from these attacks. Written by a Microsoft SQL Server MVP, you will learn how to properly secure your database, from both...
Author
Series
Description
Teach yourself the fundamentals of SQL Server Reporting Services-one step at a time. With this practical, learn-by-doing tutorial, you get the guidance you need to build flexible and powerful solutions that support the reporting needs of your organization. Discover how to: Install and configure Reporting Services Author, manage, and access reportsCreate attractive, information-rich reports with the Report DesignerCalculate values, organize information,...
Series
Description
This book is a how-to guide for experienced DBAs. The book is loaded with unique tips, tricks and workarounds for handling the most difficult SQL Server admin issues, including: managing and monitoring SQL Server, automating administration, security, change management, performance tuning, scaling and replication, clustering, backup and recovery.
Author
Series
Description
An authoritative guide to designing effective solutions for data cleansing, ETL, and file management with SQL Server 2008 Integration Services SQL Server Integration Services (SSIS) is the leading tool in the data warehouse industry, used for performing extraction, transformation, and load operations. After an overview of SSIS architecture, the authors walk you a series of real-world problems and show various techniques for handling them. Shows you...
Description
Hands-on troubleshooting methods on the most recent release of SQL Server The 2012 release of SQL Server is the most significant one since 2005 and introduces an abundance of new features. This critical book provides in-depth coverage of best practices for troubleshooting performance problems based on a solid understanding of both SQL Server and Windows internals and shows experienced DBAs how to ensure reliable performance. The team of authors shows...
Author
Description
The industry's most complete, useful, and up-to-date guide to SQL Server 2014. You'll find start-to-finish coverage of SQL Server's core database server and management capabilities: all the real-world information, tips, guidelines, and examples you'll need to install, monitor, maintain, and optimize the most complex database environments. The provided examples and sample code provide plenty of hands-on opportunities to learn more about SQL Server...
Author
Series
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,...
Author
Description
This practical book provides a comprehensive overview of troubleshooting and performance tuning best practices for Microsoft SQL Server. Database engineers, including database developers and administrators, will learn how to identify performance issues, troubleshoot the system in a holistic fashion, and properly prioritize tuning efforts to attain the best system performance possible. Author Dmitri Korotkevitch, Microsoft Data Platform MVP and Microsoft...
Author
Description
Use Microsoft SQL Server 2019 to implement, administer, and secure a robust database solution that is disaster-proof and highly available Key Features Explore new features of SQL Server 2019 to set up, administer, and maintain your database solution successfully Develop a dynamic SQL Server environment and streamline big data pipelines Discover best practices for fixing performance issues, database access management, replication, and security Book...
Author
Series
Description
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...
In Interlibrary Loan
Didn't find what you need? Items not owned by Alachua County Library District can be requested from other Interlibrary Loan libraries to be delivered to your local library for pickup.
Didn't find it?
Can't find what you are looking for? Try our Suggest Materials Service. Submit Request