Dynamic SQL

Applications, Performance, and Security
Author: Ed Pollack
Publisher: Apress
ISBN: 1484218116
Category: Computers
Page: 279
View: 2061

Continue Reading →

This book is an introduction and deep-dive into the many uses of dynamic SQL in Microsoft SQL Server. Dynamic SQL is key to large-scale searching based upon user-entered criteria. It’s also useful in generating value-lists, in dynamic pivoting of data for business intelligence reporting, and for customizing database objects and querying their structure. Executing dynamic SQL is at the heart of applications such as business intelligence dashboards that need to be fluid and respond instantly to changing user needs as those users explore their data and view the results. Yet dynamic SQL is feared by many due to concerns over SQL injection attacks. Reading Dynamic SQL: Applications, Performance, and Security is your opportunity to learn and master an often misunderstood feature, including security and SQL injection. All aspects of security relevant to dynamic SQL are discussed in this book. You will learn many ways to save time and develop code more efficiently, and you will practice directly with security scenarios that threaten companies around the world every day. Dynamic SQL: Applications, Performance, and Security 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. Discusses many applications of dynamic SQL, both simple and complex. Explains each example with demos that can be run at home and on your laptop. Helps you to identify when dynamic SQL can offer superior performance. Pays attention to security and best practices to ensure safety of your data. What You Will Learn Build flexible applications that respond fast to changing business needs. Take advantage of unconventional but productive uses of dynamic SQL. Protect your data from attack through best-practices in your implementations. Know about SQL Injection and be confident in your defenses against it Run at high performance by optimizing dynamic SQL in your applications. Troubleshoot and debug dynamic SQL to ensure correct results. Who This Book is For Dynamic SQL: Applications, Performance, and Security is for developers and database administrators looking to hone and build their T-SQL coding skills. The book is ideal for advanced users wanting to plumb the depths of application flexibility and troubleshoot performance issues involving dynamic SQL. The book is also ideal for beginners wanting to learn what dynamic SQL is about and how it can help them deliver competitive advantage to their organizations.

Pro SQL Server Wait Statistics


Author: Enrico van de Laar
Publisher: Apress
ISBN: 1484211391
Category: Computers
Page: 308
View: 8289

Continue Reading →

Pro SQL Server Wait Statistics is a practical guide for analyzing and troubleshooting SQL Server performance using wait statistics. Whether you are new to wait statistics, or already familiar with them, this book will help you gain a deeper understanding on how wait statistics are generated and what they can mean for your SQL Server’s performance. Besides the most common wait types, Pro SQL Server Wait Statistics goes further into the more complex and performance threatening wait types. The different wait types are categorized by their area of impact, and include CPU, IO, Lock, and many more different wait type categories. Filled with clear examples, Pro SQL Server Wait Statistics helps you gain practical knowledge of why and how specific wait times increase or decrease, and how they impact your SQL Server’s performance.

Pro T-SQL 2012 Programmer's Guide


Author: Michael Coles,Scott Shaw,Jay Natarajan,Rudi Bruchez
Publisher: Apress
ISBN: 1430245964
Category: Computers
Page: 696
View: 8566

Continue Reading →

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. Table of Contents Foundations of T-SQL Tools of the Trade Procedural Code and CASE Expressions User Defined Functions Stored Procedures Triggers Encryption Common Table Expressions Advanced Features Integrated Full-Text Search XML XQuery and XPath Catalog Views and Dynamic Management Views SQL CLR Programming .NET Client Programming Data Services Error Handling and Dynamic SQL Performance Monitoring and Tuning Appendix A Appendix B Appendix C Appendix D

Pro T-SQL 2008 Programmer's Guide


Author: Michael Coles
Publisher: Apress
ISBN: 1430210028
Category: Computers
Page: 688
View: 2356

Continue Reading →

Discussing new and existing features, SQL Server designer and administrator Michael Coles takes you on an expert guided tour of Transact–SQL functionality in SQL Server 2008 in his book, Pro T–SQL 2008 Programmer's Guide. Fully functioning examples and downloadable source code bring Coles' 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. Pro T–SQL 2008 Programmer's Guide is every developer's key to making full use of SQL Server 2008's powerful, built–in Transact–SQL language. 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 SQL Server 2008 include a spatial data type, SQLCLR integration, the MERGE statement, a dramatically improved and market–leading XML feature set, and support for encryption—all of which are covered in this book

High Performance SQL Server

The Go Faster Book
Author: Benjamin Nevarez
Publisher: Apress
ISBN: 1484222717
Category: Computers
Page: 201
View: 4688

Continue Reading →

Design and configure SQL Server instances and databases in support of high-throughput applications that are mission-critical and provide consistent response times in the face of variations in user numbers and query volumes. Learn to configure SQL Server and design your databases to support a given instance and workload. You’ll learn advanced configuration options, in-memory technologies, storage and disk configuration, and more, all toward enabling your desired application performance and throughput. Configuration doesn’t stop with implementation. Workloads change over time, and other impediments can arise to thwart desired performance. High Performance SQL Server covers monitoring and troubleshooting to aid in detecting and fixing production performance problems and minimizing application outages. You'll learn a variety of tools, ranging from the traditional wait analysis methodology to the new query store, and you'll learn how improving performance is really an iterative process. High Performance SQL Server is based on SQL Server 2016, although most of its content can be applied to prior versions of the product. This book is an excellent complement to performance tuning books focusing on SQL queries, and provides the other half of what you need to know by focusing on configuring the instances on which mission-critical queries are executed. Covers SQL Server instance-configuration for optimal performance Helps in implementing SQL Server in-memory technologies Provides guidance toward monitoring and ongoing diagnostics What You Will Learn Understand SQL Server's database engine and how it processes queries Configure instances in support of high-throughput applications Provide consistent response times to varying user numbers and query volumes Design databases for high-throughput applications with focus on performance Record performance baselines and monitor SQL Server instances against them Troubleshot and fix performance problems Who This Book Is For SQL Server database administrators, developers, and data architects. The book is also of use to system administrators who are managing and are responsible for the physical servers on which SQL Server instances are run.

Data and Applications Security XXII

22nd Annual IFIP WG 11.3 Working Conference on Data and Applications Security London, UK, July 13-16, 2008, Proceedings
Author: Vijay Atluri
Publisher: Springer Science & Business Media
ISBN: 354070566X
Category: Business & Economics
Page: 345
View: 2739

Continue Reading →

This book constitutes the refereed proceedings of the 22nd Annual IFIP WG 11.3 Working Conference on Data and Applications Security held in London, UK, in July 2008. The 22 revised full papers presented together with 1 keynote lecture and 1 invited talk were carefully reviewed and selected from 56 submissions. The papers are organized in topical sections on access control, audit and logging, privacy, systems security, certificate management, trusted computing platforms, security policies and metrics, as well as Web and pervasive systems.

Pro T-SQL 2005 Programmer's Guide


Author: Michael Coles
Publisher: Apress
ISBN: 1430203870
Category: Computers
Page: 560
View: 2049

Continue Reading →

T-SQL is the fundamental language for database programming in SQL Server 2005. All professional SQL Server users need a convenient single source of information and advice. This book provides that, clearly and comprehensively. Both database administrators and developers will find this highly readable, detailed description of T-SQL an eye-opening and invaluable reference for as long as they work with SQL Server 2005.

Performance Tuning with SQL Server Dynamic Management Views


Author: Louis Davidson,Tim Ford
Publisher: Fastprint Publishing
ISBN: 9781906434472
Category: Computers
Page: 344
View: 9663

Continue Reading →

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions. Why, then, aren't all DBAs using them? Why do many DBAs continue to ignore them in favour of "tried and trusted" tools such as sp_who2, DBCC OPENTRAN, and so on, or make do with the "ready made" reports built into SSMS? Why do even those that do use the DMVs speak wistfully about "good old sysprocesses"? There seem to be two main factors at work. Firstly, some DBAs are simply unaware of the depth and breadth of the information that is available from the DMvs, or how it might help them troubleshoot common issues. This book investigates all of the DMVs that are most frequently useful to the DBA in investigating query execution, index usage, session and transaction activity, disk IO, and how SQL Server is using or abusing the operating system. Secondly, the DMVs have a reputation of being difficult to use. In the process of exposing as much useful data as possible, sysprocesses has been de-normalized, and many new views and columns have been added. This fact, coupled with the initially-baffling choices of what columns will be exposed where, has lead to some DBAs to liken querying DMVs to "collecting mystic spells." In fact, however, once you start to write your own scripts, you'll see the same tricks, and similar join patterns, being used time and again. As such, a relatively small core set of scripts can be readily adapted to suit any requirement. This book is here to de-mystify the process of collecting the information you need to troubleshoot SQL Server problems. It will highlight the core techniques and "patterns" that you need to master, and will provide a core set of scripts that you can use and adapt for your own systems, including how to: * Root out the queries that are causing memory or CPU pressure on your system * Investigate caching, and query plan reuse * Identify index usage patterns * Track fragmentation in clustered indexes and heaps * Get full details on blocking and blocked transactions, including the exact commands being executed, and by whom. * Find out where SQL Server is spending time waiting for resources to be released, before proceeding * Monitor usage and growth of tempdb The DMVs don't make existing, built-in, performance tools obsolete. On the contrary, they complement these tools, and offer a flexibility, richness and granularity that are simply not available elsewhere. Furthermore, you don't need to master a new GUI, or a new language in order to use them; it's all done in a language all DBAs know and mostly love: T-SQL.

Introducing Microsoft SQL Server 2016

Mission-Critical Applications, Deeper Insights, Hyperscale Cloud, Preview 2
Author: Stacia Varga,Denny Cherry,Joseph D'Antoni
Publisher: Microsoft Press
ISBN: 1509301941
Category: Computers
Page: 65
View: 2818

Continue Reading →

With Microsoft SQL Server 2016, a variety of new features and enhancements to the data platform deliver breakthrough performance, advanced security, and richer, integrated reporting and analytics capabilities. In this Preview 2 ebook, we introduce three new security features: Always Encrypted, Row-Level Security, and dynamic data masking; discuss enhancements that enable you to better manage performance and storage: TempDB configuration, query store, and Stretch Database; review several improvements to Reporting Services; and also describe AlwaysOn Availability Groups, tabular enhancement, and R integration. This book is a preview edition because it’s not complete; the final edition will be available Spring of 2016.

Security Functions of IBM DB2 10 for z/OS


Author: Paolo Bruni,Marcelo Antonelli,Hyun Baek,Rick Butler,Ernie Mancill,IBM Redbooks
Publisher: IBM Redbooks
ISBN: 0738436038
Category: Computers
Page: 456
View: 5555

Continue Reading →

IBM® DB2® 9 and 10 for z/OS® have added functions in the areas of security, regulatory compliance, and audit capability that provide solutions for the most compelling requirements. DB2 10 enhances the DB2 9 role-based security with additional administrative and other finer-grained authorities and privileges. This authority granularity helps separate administration and data access that provide only the minimum appropriate authority. The authority profiles provide better separation of duties while limiting or eliminating blanket authority over all aspects of a table and its data. In addition, DB2 10 provides a set of criteria for auditing for the possible abuse and overlapping of authorities within a system. In DB2 10, improvements to security and regulatory compliance focus on data retention and protecting sensitive data from privileged users and administrators. Improvements also help to separate security administration from database administration. DB2 10 also lets administrators enable security on a particular column or particular row in the database complementing the privilege model. This IBM Redbooks® publication provides a detailed description of DB2 10 security functions from the implementation and usage point of view. It is intended to be used by database, audit, and security administrators.

Oracle Database Performance and Scalability

A Quantitative Approach
Author: Henry H. Liu
Publisher: John Wiley & Sons
ISBN: 111805699X
Category: Computers
Page: 694
View: 7968

Continue Reading →

A data-driven, fact-based, quantitative text on Oracleperformance and scalability With database concepts and theories clearly explained inOracle's context, readers quickly learn how to fully leverageOracle's performance and scalability capabilities at every stage ofdesigning and developing an Oracle-based enterprise application.The book is based on the author's more than ten years of experienceworking with Oracle, and is filled with dependable, tested, andproven performance optimization techniques. Oracle Database Performance and Scalability is dividedinto four parts that enable readers to progressively learn andapply new skills: Part 1, Getting Started with Oracle, describes how to set up aworking Oracle environment, offering a quick tour to illustratemajor database concepts Part 2, Oracle Architecture from Performance and ScalabilityPerspectives, explains all the major database concepts andarchitectural features that readers need to know to optimize Oracleperformance and scalability Part 3, Optimizing Oracle Performance and Scalability, offershands-on instructions to optimize and fine-tune performance andscalability for all database applications Part 4, Case Studies: Oracle Meeting Real-World Performance andScalability Challenges, sets forth quantitative case studies basedon the author's first-hand experience that demonstrate how readerscan apply proven techniques to dramatically improve the performanceand scalability of actual database products In addition to case studies, this book offers a detailed secureonline banking application as an example, making it possible forreaders to fully explore Oracle's performance and scalabilityfeatures on their own. Oracle Database Performance andScalability is an ideal text for pre-conditioning collegestudents and training software developers.

Expert PL/SQL Practices

for Oracle Developers and DBAs
Author: Michael Rosenblum,Dominic Delmolino,Lewis Cunningham,Riyaj Shamsudeen,Connor McDonald,Melanie Caffrey,Sue Harper,Torben Holm,Robyn Sands,John Beresniewicz,Ron Crisco,Martin Büchi,Adrian Billington,Stéphan Petit,Arup Nanda
Publisher: Apress
ISBN: 1430234857
Category: Computers
Page: 512
View: 8996

Continue Reading →

Expert PL/SQL Practices is a book of collected wisdom on PL/SQL programming from some of the best and the brightest in the field. Each chapter is a deep-dive into a specific problem, technology, or feature set that you’ll face as a PL/SQL programmer. Each author has chosen their topic out of the strong belief that what they share can make a positive difference in the quality and scalability of code that you write. The path to mastery begins with syntax and the mechanics of writing statements to make things happen. If you’ve reached that point with PL/SQL, then let the authors of Expert PL/SQL Practices show you how to combine syntax and mechanics with features and techniques to really make the language sing. You’ll learn to do more with less effort, to write code that scales and performs well, and to eliminate and avoid defects. These authors are passionate about PL/SQL and the power it places at your disposal. They want you to succeed, to know all that PL/SQL can offer. Let Expert PL/SQL Practices open your eyes to the full power of Oracle’s world-class language for the database engine. Goes beyond the manual to cover good techniques and best practices Delivers knowledge usually gained only by hard experience Covers the functionality that distinguishes PL/SQL as a powerful and scalable programming language for deploying logic inside the database engine What you’ll learn Learn when PL/SQL is best used, and when to avoid it Move data efficiently using bulk SQL operations Write code that scales through pipelining, parallelism, and profiling Choose the right PL/SQL cursor type for any given application Reduce coding errors through sound development practices such as unit-testing Create and execute SQL and PL/SQL dynamically at runtime Who this book is for Expert PL/SQL Practices is for PL/SQL developers who want to develop deep expertise in key aspects of the language and its use in database programming. Any developer writing code against Oracle’s class-leading database engine will find value from the collected wisdom in this book. Some knowledge of PL/SQL is assumed. Readers should at least be past the beginning stage with the language. Table of Contents Do Not Use Dynamic SQL: Handling the Unknown PL/SQL and Parallel Processing Warnings and Conditional Compilation PL/SQL Unit Testing Bulk SQL Operations Know Your Code Contract-Oriented Programming PL/SQL from SQL Choosing the Right Cursor PL/SQL Programming in the Large Evolutionary Data Modeling Profiling for Performance Coding Conventions and Error Handling Dependencies and Invalidations

Cloud Database Development and Management


Author: Lee Chao
Publisher: CRC Press
ISBN: 1466565063
Category: Computers
Page: 487
View: 9609

Continue Reading →

Although today’s job market requires IT professionals to understand cloud computing theories and have hands-on skills for developing real-world database systems, there are few books available that integrate coverage of both. Filling this void, Cloud Database Development and Management explains how readers can take advantage of the cloud environment to develop their own fully functioning database systems without any additional investment in IT infrastructure. Filled with step-by-step instructions, examples, and hands-on projects, the book begins by providing readers with the required foundation in database systems and cloud-based database development tools. It supplies detailed instructions on setting up data storage on Windows Azure and also explains how readers can develop their own virtual machines with Windows Server 2012 as the guest operating system. The book’s wide-ranging coverage includes database design, database implementation, database deployment to the cloud environment, SQL Database, Table Storage service, Blob Storage service, Queue Storage service, and database application development. The text deals with all three aspects of database design: conceptual design, logical design, and physical design. It introduces the SQL language, explains how to use SQL to create database objects, and introduces the migration of the database between Windows Azure and the on-premises SQL Server. It also discusses the management tasks that keep both SQL Database and Windows Azure running smoothly. Detailing how to design, implement, and manage database systems in the cloud, the book provides you with tools that can make your cloud database development much more efficient and flexible. Its easy-to-follow instructions will help you develop the hands-on skills needed to store and manage critical business information and to make that data available anytime through the Internet.

Oracle Web Application Programming for PL/SQL Developers


Author: Susan Boardman,Melanie Caffrey,Solomon Morse,Benjamin Rosenzweig
Publisher: Prentice Hall Professional
ISBN: 9780130477316
Category: Computers
Page: 745
View: 3895

Continue Reading →

Learn to use Oracle 9i to build dynamic, data-driven Web sites. Get step-by-step details on creating and deploying Web applications using PL/SQL, HTML, Java, XML, WML, Peri and PHP. This book covers everything users need to know to master Web application development in an Oracle environment - using PL/SQL.

The National Guide to Educational Credit for Training Programs


Author: Jo Ann Robinson,Troy Polite,Nancy Musick
Publisher: N.A
ISBN: 9781573566056
Category: School credits
Page: 1924
View: 9995

Continue Reading →

For more than 25 years, this guide has been the trusted source of information on thousands of educational courses offered by business, labor unions, schools, training suppliers, professional and voluntary associations, and government agencies. These courses provide academic credit to students for learning acquired at such organizations as AT&T, Citigroup, Delta Air Lines, General Motors University, NETg, and Walt Disney World Resort. Each entry in the comprehensive INational GuideR provides: L L DBL Course title L DBL Location of all sites where the course is offeredL DBL Length in hours, days, or weeks L DBL Period during which the credit recommendation appliesL DBL Purpose for which the credit was designed L DBL Learning outcomes L DBL Teaching methods, materials, and major subject areas coveredL DBL College credit recommendations offered in four categories (by level of degrees) and expressed in semester hours and subject areas(s) in which credit is applicable. L L The introductory section includes ACE Transcript Service information. For more than 25 years, this guide has been the trusted source of information on thousands of educational courses offered by business, labor unions, schools, training suppliers, professional and voluntary associations, and government agencies. These courses provide academic credit to students for learning acquired at such organizations as AT&T, Citigroup, Delta Air Lines, General Motors University, NETg, and Walt Disney World Resort. Each entry in the comprehensive INational GuideR provides: L L DBL Course title L DBL Location of all sites where the course is offeredL DBL Length in hours, days, or weeks L DBL Period during which the credit recommendation appliesL DBL Purpose for which the credit was designed L DBL Learning outcomes L DBL Teaching methods, materials, and major subject areas coveredL DBL College credit recommendations offered in four categories (by level of degrees) and expressed in semester hours and subject areas(s) in which credit is applicable. L L The introductory section includes ACE Transcript Service information.

DB2 SQL Procedural Language for Linux, UNIX, and Windows


Author: Paul Yip
Publisher: Prentice Hall Professional
ISBN: 9780131007727
Category: Computers
Page: 315
View: 2627

Continue Reading →

This certification guide offers a complete, start-to-finish coverage of DB2 Universal Database Version 8 administration. With Version 8 key topics such as Performance Enhancements, Manageability Enhancements, etc. are addressed.

High Performance MySQL

Optimization, Backups, and Replication
Author: Baron Schwartz,Peter Zaitsev,Vadim Tkachenko
Publisher: "O'Reilly Media, Inc."
ISBN: 1449332501
Category: Computers
Page: 826
View: 8115

Continue Reading →

How can you bring out MySQL’s full power? With High Performance MySQL, you’ll learn advanced techniques for everything from designing schemas, indexes, and queries to tuning your MySQL server, operating system, and hardware to their fullest potential. This guide also teaches you safe and practical ways to scale applications through replication, load balancing, high availability, and failover. Updated to reflect recent advances in MySQL and InnoDB performance, features, and tools, this third edition not only offers specific examples of how MySQL works, it also teaches you why this system works as it does, with illustrative stories and case studies that demonstrate MySQL’s principles in action. With this book, you’ll learn how to think in MySQL. Learn the effects of new features in MySQL 5.5, including stored procedures, partitioned databases, triggers, and views Implement improvements in replication, high availability, and clustering Achieve high performance when running MySQL in the cloud Optimize advanced querying features, such as full-text searches Take advantage of modern multi-core CPUs and solid-state disks Explore backup and recovery strategies—including new tools for hot online backups

Securing SQL Server

DBAs Defending the Database
Author: Peter A. Carter
Publisher: Apress
ISBN: 1484222652
Category: Computers
Page: 165
View: 4319

Continue Reading →

Protect your data from attack by using SQL Server technologies to implement a defense-in-depth strategy, performing threat analysis, and encrypting 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. Database professionals in today's world deal increasingly often with repeated data attacks against high-profile organizations and sensitive data. It is more important than ever to keep your company’s data secure. Securing SQL Server demonstrates how administrators and developers can both play their part in the protection of a SQL Server environment. This book provides a comprehensive technical guide to the security model, and to encryption within SQL Server, including coverage of the latest security technologies such as Always Encrypted, Dynamic Data Masking, and Row Level Security. Most importantly, the book gives practical advice and engaging examples on how to defend your data -- and ultimately your job! -- against attack and compromise. Covers the latest security technologies, including Always Encrypted, Dynamic Data Masking, and Row Level Security Promotes security best-practice and strategies for defense-in-depth of business-critical database assets Gives advice on performing threat analysis and reducing the attack surface that your database presents to the outside world What You Will Learn Perform threat analysis Implement access level control and data encryption Avoid non-reputability by implementing comprehensive auditing Use security metadata to ensure your security policies are enforced Apply the latest SQL Server technologies to increase data security Mitigate the risk of credentials being stolen Who This Book Is For SQL Server database administrators who need to understand and counteract the threat of attacks against their company’s data. The book is also of interest to database administrators of other platforms, as several of the attack techniques are easily generalized beyond SQL Server and to other database brands.