Using SQLite

by Newebug 7. September 2010 13:59

Using SQLite
Jay A. Kreibich

  This book provides an introduction to the SQLite database product. SQLite is a zeroconfiguration, standalone, relational database engine that is designed to be embedded directly into an application. Database instances are self-contained within a single file, allowing easy transport and simple setup.

  Using SQLite is primarily written for experienced software developers that have never had a particular need to learn about relational databases. For one reason or another, you now find yourself with a large data  management task, and are hoping a product like SQLite may provide the answer. To help you out, the various chapters cover the SQL language, the SQLite C programming API, and the basics of relational database design, giving you everything you need to successfully integrate SQLite into your applications and development work.

  The book is divided into two major sections. The first part is a traditional set of chapters that are primarily designed to be read in order. The first two chapters provide an indepth look at exactly what SQLite provides and how it can be used. The third chapter covers downloading and building the library. Chapters Four and Five provide an introduction to the SQL language, while Chapter Six covers database design concepts. Chapter Seven covers the basics of the C API. Chapter Eight builds on that to cover more advanced topics, such as storing times and dates, using SQLite from scripting languages, and utilizing some of the more advanced extensions. Chapters Nine and Ten cover writing your own custom SQL functions, extensions, and modules. To complete the picture, the ten chapters are followed by several reference appendixes. These references cover all of the SQL commands, expressions, and built-in functions supported by SQLite, as well as documentation for the complete SQLite API.

Using SQLite Download:

using-sqlite.rar (3.68 MB)



Pro SQL Server 2008 Policy-Based Management

by Newebug 1. September 2010 14:32

Pro SQL Server 2008 Policy-Based Management
by Ken Simmons, Colin Stasiuk, Jorge Segarra

ISBN-13 (pbk): 978-1-4302-2910-0
ISBN-13 (electronic): 978-1-4302-2911-7

Pro SQL Server 2008 Policy-Based Management

About the Authors
  Ken Simmons is a database administrator, developer, and Microsoft SQL Server MVP. His other books on SQL Server include SQL Server 2008 Administration (Apress, 2009) and Pro SQL Server 2008 Mirroring (Apress, 2009). He has been working in the IT industry since 2000, and currently holds certifications for MCP, MCAD, MCSD, MCDBA, and MCTS for SQL Server 2005.
  Ken is active in the online community, and often participates in the SQL Server forums on MSDN and He enjoys sharing tips by writing articles for and When he is not working, Ken enjoys traveling with his wife Susan and son Nathan, and he can often be found on a cruise ship, at a Disney resort, or at the beach in his hometown of Pensacola, Florida.

  Colin Stasiuk is a database administrator and owner of Benchmark IT Consulting, based in Edmonton, Alberta, Canada. He has worked with SQL Server since 1996, and currently holds certifications for MCP, MCTS, and MCITP for Database Administration and Development. Colin is also the president of EDMPASS, the Edmonton-based chapter of the Professional Association for SQL Server (PASS), and his blog is syndicated at
  Colin (like any good Canadian boy) is an avid hockey fan, and enjoys spending quality time with his wife Heather, son Robbie, and daughter Lana.

  Jorge Segarra is a database and system administrator for University Community Hospital in Tampa, Florida. He has been administering SQL Server for more than five years, and holds certifications for MCP and MCTS.
  Jorge is very active in the online community and can be found on Twitter under the handle SQLChicken and at his blog He is also a founding member (or hypervisor) for the PASS Virtualization Virtual Chapter and a general volunteer for PASS. On the local level, he is a member of the Tampa SQL Server User Group as well as the Tampa Bay SQL Server Business Intelligence User Group. Jorge also enjoys traveling to various local user groups and events to present on all things SQL Server. When not being a total geek, Jorge enjoys spending time at home with his wife Jessica.

How This Book Is Structured
  This book introduces you to the basic concepts of Policy-Based Management as well as covering the advanced topics you need to know in order to enforce consistent rules across your organization. Here is a quick rundown of what you’ll learn:
  1 provides an overview of Policy-Based Management. It introduces many of the terms and concepts you’ll encounter throughout the rest of the book.
  2 covers the many different options for creating conditions and policies, including how to categorize policies to ease administration.
  3 explains the different evaluationmodes and walks you through the steps for evaluating and scheduling policies.
  4 shows you how you can extend the evaluation features offered in Policy-Based Management by using PowerShell.
  5 covers everything you need to know in order to receive an alert when a policy fails. Topics include setting up Database Mail, creating an operator, and creating alerts on the appropriate conditions.
  6 describes the tables, stored procedures, and system views in the msdb database where the Policy-Based Management information is stored, as well as the roles and permissions required to use Policy-Based Management.
  7 shows you how you can take advantage of the Enterprise Policy Management Framework as a central reporting tool for Policy-Based Management.
  8 provides you with some practical uses for Policy-Based Management. It discusses how to use a combination ofMicrosoft best practice policies and custom policies.
  9 addresses how you can use Policy-Based Management to meet the compliance needs of your organization.
  10 discusses the various resources you have to help you continue learning Policy-Based Management, as well as the support options you have if you need further assistance.

Contents at a Glance
 Contents at a Glance iv
 Contents v
 About the Authors xii
 About the Technical Reviewers xiii
 Acknowledgments xiv
 Introduction xv
 1: Introduction to Policy-Based Management 1
 2: Creating Policies 13
 3: Evaluating Policies 49
 4: Policy-Based Management Using PowerShell 89
 5: Receiving Alerts for Policy Violations 109
 6: Policy-Based Management Internals 131
 7: Practical Uses of Policy-Based Management 149
 8: Reporting 169
 9: Enforcing Compliance 185
 10: Where to Go from Here 207
 Appendix: Microsoft SQL Server Best Practice Policies 215
 Index 235

Pro SQL Server 2008 Policy-Based Management Download:

pro-sql-server-2008-policy-based-management.rar (9.74 MB)



Microsoft SQL Server 2008 Administrator's Pocket Consultant, Second Edition

by Newebug 30. August 2010 14:10

Microsoft SQL Server 2008 Administrator's Pocket Consultant, Second Edition

LCCN: 2010923882

Microsoft SQL Server 2008 Administrator's Pocket Consultant, Second Edition

  Microsoft SQL Server 2008 Administrator's Pocket Consultant, Second Edition, is designed to be a concise and compulsively usable resource for SQL Server 2008 and SQL Server 2008 Release 2 (R2) administrators. It covers everything you need to know to perform the core administrative tasks for SQL Server and is the readable resource guide that you'll want on your desk at all times. Because the focus is on giving you maximum value in a pocket-sized guide, you don't have to wade through hundreds of pages of extraneous information to find what you're looking for. Instead, you'll find exactly what you need to get the job done.
This book is designed to be the one resource you turn to whenever you have questions about SQL Server administration. To this end, the book zeroes in on daily administration procedures, frequently used tasks, documented examples, and options that are representative while not necessarily inclusive. One of the key goals is to keep content concise enough that the book is compact and easy to navigate while also ensuring that the book contains as much information as possible. Instead of a 1,000-page tome or a 100-page quick reference, you get a valuable resource guide that can help you quickly and easily perform common tasks, solve problems, and implement advanced SQL Server technologies such as replication, distributed queries, and multiserver administration.

Who Is This Book For?
  Microsoft SQL Server 2008 Administrator's Pocket Consultant, Second Edition, covers the Standard, Enterprise, Developer, Web, and Workgroup editions of SQL Server. The book is designed for:

  •  Current SQL Server database administrators
  •  Accomplished users who have some administrator responsibilities
  •  Administrators migrating to SQL Server 2008 and SQL Server 2008 R2 from previous versions
  •  Administrators transitioning from other database architectures


Microsoft SQL Server 2008 Administrator's Pocket Consultant, Second Edition Download:

microsoft-r-sql-server-r-2008-administrators-pocket-consultant.rar (11.00 MB)



Practical MDX Queries for Microsoft? SQL Server Analysis Services 2008

by Newebug 7. August 2010 04:50

Practical MDX Queries for Microsoft? SQL Server Analysis Services 2008
by Art Tennick

ISBN: 978-0-07-171337-5

Practical MDX Queries for Microsoft? SQL Server Analysis Services 2008

About the Author
  Art Tennick (Brighton, UK) has worked in relational database design and SQL queries for over 20 years. He has been involved in multidimensional database design, cubes, data mining, DMX, and MDX queries for 10 years. Based in the UK, he has been a software consultant, trainer, and writer for some 25 years. Recently, he has worked with several major retail and banking corporations to implement BI solutions using Microsoft SQL Server, SSAS, SSIS, SSRS, and Excel 2007/2010. This is his 17th book and he has also written over 300 articles for computer magazines in the USA, the UK, and Ireland. His Web site is

  Business intelligence (BI) is a very rapidly growing area of the software market. Microsoft’s core product in this field is SQL Server Analysis Services (SSAS). It is revolutionizing how companies view and work with data. Its purpose is to turn data into information, giving meaning to the data. There are two main objects in SSAS that support this goal—cubes and data-mining models. If these can be visualized easily, the information they contain is transformed into intelligence, thus leading to timely and effective decision making. Cube information can be extracted and visualized with Multidimensional Expressions (MDX) queries. Data-mining model information can
be extracted and visualized with Data Mining Extensions (DMX) queries. This book is devoted to cubes and the MDX language. It takes you from first principles in MDX query writing and builds into more and more sophisticated queries. This book is a practical one—with lots of syntax to try on nearly every page (and you can copy and paste from the download files for this book, if you prefer not to type).

Contents at a Glance
 1 Hello World: Easy Yet Effective Queries 1
 2 Astrophysical: Playing with Dimensions 11
 3 Families and Friends: Navigating Dimensions 39
 4 Bringing Order: Sorting Results 83
 5 Slice, Dice, and Filter: Using Where and Filter 99
 6 Using the Abacus: Introduction to Calculations 129
 7 Is Time a Dimension? Working with Dates and Times 143
 8 Clockwork: Calculations Using Dates and Times 159
 9 Venn Diagrams: Visualizing and Manipulating Sets 189
 10 Views on Cubes: Working with Subcubes 221
 11 Not All There: Dealing with Empty Cells 231
 12 Smiley Faces: Working with Key Performance Indicators (KPIs) 239
 13 Hodgepodge: A Chapter of Miscellaneous Techniques 247
 14 After You Finish 255
Index 259

Practical MDX Queries for Microsoft? SQL Server Analysis Services 2008 Download:

practical-mdx-queries-for-microsoft-sql-server-analysis-services-2008.rar (2.48 MB)



O'Reilly MySQL High Availability Tools for Building Robust Data Centers

by Newebug 7. August 2010 04:44

O'Reilly MySQL High Availability Tools for Building Robust Data Centers
by Charles Bell, Mats Kindahl, and Lars Thalmann

ISBN: 978-0-596-80730-6

O'Reilly MySQL High Availability Tools for Building Robust Data Centers

  This book is for MySQL professionals. We expect you to have a basic background in SQL, administering MySQL, and the operating system you are running. We will try to fill in background information about replication, disaster recovery, system monitoring, and other key topics of high availability. See Chapter 1 for other books that offer useful background.

Organization of This Book
  This book is written in three parts. Part I encompasses MySQL replication, including high availability and scale-out. Part II examines monitoring and performance concerns for building robust data centers. Part III examines some additional areas of MySQL, including cloud computing and MySQL clusters.

Part I, Replication
 1, Introduction, explains how this book can help you and gives you a context for reading it.
 2, MySQL Replication Fundamentals, discusses both manual and automated procedures for setting up basic replication.
 3, The Binary Log, explains the critical file that ties together replication and helps in disaster recovery, troubleshooting, and other administrative tasks.
 4, Replication for High Availability, shows a number of ways to recover from server failure, including the use of automated scripts.
 5, MySQL Replication for Scale-Out, shows a number of techniques and topologies for improving response time and handling large data sets.
 6, Advanced Replication, addresses a number of topics, such as secure data transfer and row-based replication.

Part II, Monitoring and Disaster Recovery
 7, Getting Started with Monitoring, presents the main operating system parameters you have to be aware of, and tools for monitoring them.
 8, Monitoring MySQL, presents several tools for monitoring database activity and performance.
 9, Storage Engine Monitoring, explains some of the parameters you need to monitor on a more detailed level, focusing on issues specific to MyISAM or InnoDB.
 10, Replication Monitoring, offers details about how to keep track of what masters and slaves are doing.
 11, Replication Troubleshooting, shows how to deal with failures and restarts, corruption, and other incidents.
 12, Protecting Your Investment, explains the use of backups and disaster recovery techniques.
 13, MySQL Enterprise, introduces a suite of tools that simplifies many of the tasks presented in earlier chapters.

Part III, High Availability Environments
 14, Cloud Computing Solutions, introduces the most popular cloud computing service, the AWS, and offers techniques for using MySQL in such virtualized environments.
 15, MySQL Cluster, shows how to use this tool to achieve high availability.

  The Appendix, Replication Tips and Tricks, offers a grab bag of procedures that are useful in certain situations.

O'Reilly MySQL High Availability Tools for Building Robust Data Centers Download:

mysql-high-availability-tools-for-building-robust-data-centers.rar (5.10 MB)




Comment RSS