Your email was sent successfully. Check your inbox.

An error occurred while sending the email. Please try again.

Proceed reservation?

Export
Filter
  • MPI Ethno. Forsch.  (42)
  • HU Berlin
  • BVB
  • Boston, Mass. :Safari Books Online,  (42)
  • SQL server  (42)
Datasource
  • MPI Ethno. Forsch.  (42)
  • HU Berlin
  • BVB
Material
Language
Years
Author, Corporation
Publisher
Keywords
  • 1
    Online Resource
    Online Resource
    SQL Server 2008 administration in action (2010)
    Greenwich, Conn. : Manning | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9781933988726 , 193398872X
    Language: English
    Pages: 1 v. (unpaged) , ill.
    Keywords: SQL server ; Database management ; Client/server computing ; Electronic books ; local
    Abstract: 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 help you tame the beast and keep it under control. Unlike the many comprehensive SQL Server reference tomes out there that attempt to cover the whole SQL Server feature set, this book drills down on the techniques, procedures, and practices that help you keep your database running like clockwork. SQL Server 2008 Administration in Action focuses the production DBA, digging deep into the various tasks specific to that role. Expert author Rod Colledge-check him out at sqlCrunch.com-teaches you best practices that cover the lifecycle of a SQL Server system, including infrastructure design, installation, and operational maintenance. And while many of these techniques will work in any recent version of SQL Server, you'll find full coverage of emerging SQL Server 2008 best practices. Each technique is presented in a task-driven style, and in the order of the typical life cycle of a SQL Server system. This allows you to easily open the book at the appropriate page and focus on what you need to know for each specific situation.
    Note: Title from resource description page. - Includes index
    URL: https://learning.oreilly.com/library/view/-/9781933988726/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 2
    Online Resource
    Online Resource
    Microsoft SQL server 2008 analysis services unleashed (2009)
    Indianapolis, Ind. : Sams Pub. | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780768686913 , 0768686911
    Language: English
    Pages: xviii, 865 p , ill. , 24 cm
    Parallel Title: Erscheint auch als
    Keywords: SQL server ; Client/server computing ; Relational databases ; Electronic books ; local
    Abstract: As the foundation of the Microsoft Business Intelligence Strategy, Microsoft SQL Server 2008 Analysis Services provides users with faster access to data and even more tools for managing and analyzing data across multidimensional objects (databases, dimensions, cubes). Microsoft SQL Server 2008 Analysis Services Unleashed is the ultimate guide for anyone who is planning to use the latest version of Analysis Services. It gives readers insight into the way Analysis Services functions, and explains practical methods for designing and creating multidimensional objects. It also provides valuable insight into the reasons behind the design decisions taken by the product development team. The authors have been involved with Analysis Services from its earliest days. They have documented in detail the internal features of Analysis Services 2008, explaining server architecture, main data structures, data processing, and query resolution algorithms. Discover the new functionality introduced in Analysis Services 2008 including MDX enhancements and new DMV (dynamic memory views) Work with the Business Intelligence Development Studio, the new Dimension Editor, and Aggregation Designer interfaces Enjoy complete coverage of new Shared Scalable Databases scale-out infrastructure Learn the key concepts of multidimensional modeling Explore the multidimensional object model and its definition language Integrate multidimensional and relational databases Build client applications to access data in Analysis Services Unravel the inner workings of the server architecture, including main data structures, data processing, and query resolution algorithms Learn the main concepts of the MDX language and gain an in-depth understanding of advanced MDX concepts Gain a deeper understanding of the internal and external protocols for data transfer, including the XML/A protocol Discover how Analysis Services manages memory Explore the security model, including role-based security, code-access security, and data security Category: Microsoft SQL Server Covers: Microsoft SQL Server 2008 Analysis Services User Level: Intermediate-Advanced $59.99 USA / $65.99 CAN / £38.99 Net UK±
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780768686913/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 3
    Online Resource
    Online Resource
    Microsoft SQL server 2008 management and administration (2009)
    Indianapolis, Ind. : Sams | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780768688870 , 0768688876
    Language: English
    Pages: xxv, 880 p , ill. , 21 cm
    Parallel Title: Erscheint auch als
    Keywords: SQL server ; Database management ; Electronic books ; local
    Abstract: If you need to deploy, manage, or secure Microsoft SQL Server 2008, this is the complete, fast-paced, task-based reference you've been searching for. Authored by a world-class expert on SQL Server in the enterprise, this book goes far beyond the basics, taking on the complex tasks that DBAs need to make the most of Microsoft's flagship database platform. SQL Server MVP, Ross Mistry presents proven techniques for SQL Server 2008 installation, upgrades, backup/restore, data transfer, indexing, high availability, security, and much more. He draws on extensive testing in high-profile production environments to offer step-by-step solutions and powerful tips you won't find anywhere else. Every chapter begins with a section identifying SQL Server 2008's most significant new improvements, and concludes with a convenient summary of best practices. Each chapter also outlines the benefits of leveraging Windows Server 2008. Understand how to: Master DBA tips, tricks, and best practices proven in actual enterprise environments Install, upgrade or transition to SQL Server 2008. Harden and Secure an implementation. Encrypt SQL Server from an end-to-end perspective. Implement high availability-and leverage SQL Server 2008's major improvements to failover clustering and database mirroring Save time with SQL Server 2008's new policy-based management tools Performance tune and troubleshoot a SQL Server 2008 environment. Optimize application performance and manage workloads with the powerful new Resource Governor Implement Performance Studio, maintenance plans, Transparent Data Encryption and much more... Bonus Content: The book is based on Windows Server 2008 Step by step instructions of how to implement a failover cluster on Windows Server 2008 SQL Server PoweShell Administration Tasks Consolidate and virtualize SQL Server with Hyper-V Step by step instructions on how to install Hyper-V Proactively Monitor SQL Server with Operations Manager Install Windows Server 2008 certificates to encrypt SQL Server data Contributing Writers include: Hilary Cotter - SQL Server MVP John Welch - SQL Server MVP Marco Shaw - PowerShell MVP Maciej Pilecki - SQL Server MVP Shirmattie Seenarine - Technical Writer
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780768688870/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 4
    Online Resource
    Online Resource
    Inside Microsoft SQL Server 2008 : T-SQL querying (2009)
    Redmond, Wash. : Microsoft Press | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780735634763 , 0735634769
    Language: English
    Pages: xxiv, 798 p , ill.
    Keywords: SQL server ; Client/server computing ; Relational databases ; Electronic books ; local
    Abstract: Tackle the toughest set-based querying and query tuning problems-guided by an author team with in-depth, inside knowledge of T-SQL. Deepen your understanding of architecture and internals-and gain practical approaches and advanced techniques to optimize your code's performance. Discover how to: Move from procedural programming to the language of sets and logic Optimize query tuning with a top-down methodology Assess algorithmic complexity to predict performance Compare data-aggregation techniques, including new grouping sets Manage data modification-insert, delete, update, merge-for performance Write more efficient queries against partitioned tables Work with graphs, trees, hierarchies, and recursive queries Plus-Use pure-logic puzzles to sharpen your problem-solving skills
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780735634763/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 5
    Online Resource
    Online Resource
    Microsoft SQL server 2008 : T-SQL fundamentals (2009)
    Redmond, Wash. : Microsoft Press | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 0735626014 , 9780735626010
    Language: English
    Pages: xviii, 394 p , ill. , 23 cm
    Keywords: SQL server ; SQL (Computer program language) ; Client/server computing ; Electronic books ; local
    Abstract: Master the foundations of T-SQL with the right balance of conceptual and practical content. Get hands-on guidance-including exercises and code samples-that show you how to develop code to query and modify data. You'll gain a solid understanding of the T-SQL language and good programming practices, and learn to write more efficient and powerful queries. Discover how to: Apply T-SQL fundamentals, create tables, and define data integrity Understand logical query processing Query multiple tables using joins and subqueries Simplify code and improve maintainability with table expressions Explore pivoting techniques and how to handle grouping sets Write code that modifies data Isolate inconsistent data and address deadlock and blocking scenarios
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780735626010/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 6
    Online Resource
    Online Resource
    Microsoft SQL server 2008 reporting services : step by step (2009)
    Redmond, Wash. : Microsoft Press | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780735626478 , 0735626472
    Language: English
    Pages: xxiii, 529 p , ill.
    Series Statement: Step by step
    Keywords: SQL server ; Client/server computing ; Electronic books ; local
    Abstract: Teach yourself how to build, manage, and access SQL Server 2008 reports one step at a time. Whether you re a report developer, IT administrator, or business user, this sequential, learn-by-doing tutorial shows you how to deliver the business intelligence information your organization needs. Discover how to: Install and configure Reporting Services Put Report Builder and Report Designer tools to work Create interactive, online reports that enable users to sort and filter data Add charts and gauges to present data visually Deploy reports to Microsoft Office SharePoint Server Monitor server performance and help secure content Use subscriptions to distribute reports via e-mail Build ad hoc reports and extend them with custom code CD features: Practice exercises and code samples Fully searchable eBook.
    Note: At head of t.p.: Microsoft. - Includes index
    URL: https://learning.oreilly.com/library/view/-/9780735626478/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 7
    Online Resource
    Online Resource
    Microsoft SQL server 2008 administrator's pocket consultant (2009)
    Redmond, Wash. : Microsoft Press | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780735625891 , 0735625891
    Language: English
    Pages: xxii, 696 p , ill. , 21 cm
    Keywords: SQL server ; Client/server computing ; Database management ; Electronic books ; local
    Abstract: Get the practical, pocket-sized guide for IT professionals who need to administer, maintain, and optimize SQL Server 2008. Written by award-winning author William Stanek, this portable reference delivers essential details for using SQL Server 2008 to help protect and manage your company s data whether automating tasks, creating indexes and views, performing backups and recovery, replicating transactions, tuning performance, managing server activity, importing and exporting data, or performing other key tasks. Featuring quick-reference tables, lists, and step-by-step instructions, this handy, one-stop guide provides fast, accurate answers on the spot whether you re at your desk or in the field! Key Book Benefits Provides fast facts and immediate reference for administering SQL Server 2008 Delivers must-know details for taking advantage of the improved scalability, security features, and management tools in SQL Server 2008 Features concise tables, easy-to-scan lists, and step-by-step instructions for fast answers, wherever you need them
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780735625891/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 8
    Online Resource
    Online Resource
    Programming Microsoft SQL Server 2008 (2009)
    Redmond, Wash. : Microsoft Press | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780735625990 , 0735625999
    Language: English
    Pages: xxxiii, 979 p , ill. , 23 cm
    Keywords: SQL server ; Client/server computing ; Electronic books ; local
    Abstract: Extend your programming skills with a comprehensive study of the key features of SQL Server 2008. Delve into the new core capabilities, get practical guidance from expert developers, and put their code samples to work. This is a must-read for Microsoft .NET and SQL Server developers who work with data access-at the database, business logic, or presentation levels. Discover how to: Query complex data with powerful Transact-SQL enhancements Use new, non-relational features: hierarchical tables, native file streaming, and geospatial capabilities Exploit XML inside the database to design XML-aware applications Consume and deliver your data using Microsoft LINQ, Entity Framework, and data binding Implement database-level encryption and server auditing Build and maintain data warehouses Use Microsoft Excel to build front ends for OLAP cubes, and MDX to query them Integrate data mining into applications quickly and effectively. Get code samples on the Web.
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780735625990/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 9
    Online Resource
    Online Resource
    SQL server fundamentals for the accidental DBA (2009)
    [United States?] : Addison-Wesley Professional | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780321601421 , 0321601424
    Language: English
    Pages: 1 streaming video file (6 hr., 10 min., 58 sec.) , digital, sd., col.
    Series Statement: LiveLessons
    Keywords: SQL server ; Database management ; Electronic videos ; local
    Abstract: "When SQL Servers are running, but are not being managed, they pose a security threat and can crash, causing loss of valuable data and disrupting resources. Many companies, especially smaller ones, simply do not have the resources to hire a designated database administrator (DBA). Because SQL Server is everywhere, it is vital that System Administrators and Developers learn the base skills to manage these services. While bits and pieces of "how-to" information can be found everywhere, until now, there has been no organized "start-to-finish" place for non-DBAs to access this critical information."--Resource description page.
    Note: Title from resource description page (viewed Jan. 14, 2009)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 10
    Online Resource
    Online Resource
    Microsoft SQL server 2008 integration services unleashed (2009)
    Indianapolis, Ind. : Sams | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780768687255 , 076868725X
    Language: English
    Pages: xix, 758 p , ill. , 23 cm
    Parallel Title: Erscheint auch als
    Keywords: SQL server ; Database management ; Data warehousing ; Electronic books ; local
    Abstract: Microsoft SQL Server Integration Services is Microsoft's powerful platform for building enterprise-level data integration and data transformation solutions. It's a powerful product, but it's also complex and can be confusing if you don't have a clear map for the journey. Microsoft SQL Server 2008 Integration Services Unleashed will be the only book you'll need to harness the power that Integration Services provides. Through clear, concise explanations and samples, you'll grasp a clear understanding of working in the Integration Services environment, including how to set up stock components, how to use the various designer features, and how to gain practical knowledge on configuring, deploying, securing, and managing packages. Sample packages are provided to reinforce the discussion and quickly help you gain hands-on experience, and more complex topics such as Data Flow Task internals and tuning, advanced transformations, and writing custom components are all illustrated in easy-to-understand graphics. In addition, there are several custom tasks and transformations and two useful utilities with full source code available for you to use and study, including an ADO.NET destination, a text file encryption task, and a data profiling transform. Detailed information on: Using the powerful Integration Services tools to create solutions without the need to write lines of code Creating packages programmatically or developing custom tasks via the Integration Services object Building robust packages to solve common requirements Securing packages for different environments Using often overlooked or unknown platform features Setting up all the stock components, including data flow components, tasks, Foreach enumerators, connection managers, and log providers Writing robust and useful custom tasks Building packages that seamlessly deploy to other environments Writing custom data flow adapters and transforms Using script tasks and components Easily modifying configurations for multiple packages simultaneously Writing a Task UI that looks just like the stock tasks Tapping into the power of Integration Services for accessing heterogeneous data sources Using expressions to make packages more responsive to the environment Migrating your DTS packages with no stress Kirk Haselden is the Group Program Manager for the Microsoft Master Data Management product forthcoming in the next wave of Office SharePoint Services and owns the long term strategy, vision, planning, ...
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780768687255/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 11
    Online Resource
    Online Resource
    Microsoft SQL server 2008 internals (2009)
    Redmond, Wash. : Microsoft Press | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780735634787 , 0735634785
    Language: English
    Pages: xxvi, 754 p , ill.
    Keywords: SQL server ; Database management ; Electronic books ; local
    Abstract: Delve inside the core SQL Server engine-and put that knowledge to work-with guidance from a team of well-known internals experts. Whether database developer, architect, or administrator, you'll gain the deep knowledge you need to exploit key architectural changes-and capture the product's full potential. Discover how SQL Server works behind the scenes, including: What happens internally when SQL Server builds, expands, shrinks, and moves databases How to use event tracking-from triggers to the Extended Events Engine Why the right indexes can drastically reduce your query execution time How to transcend normal row-size limits with new storage capabilities How the Query Optimizer operates Multiple techniques for troubleshooting problematic query plans When to force SQL Server to reuse a cached query plan-or create a new one What SQL Server checks internally when running DBCC How to choose among five isolation levels and two concurrency models when working with multiple concurrent users
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780735634787/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 12
    Online Resource
    Online Resource
    Smart business intelligence solutions with Microsoft SQL Server 2008 (2009)
    Redmond, Wash. : Microsoft Press | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 0735625808 , 9780735625808
    Language: English
    Pages: 1 v. (unpaged) , ill. , 23 cm
    Keywords: SQL server ; Relational databases ; Client/server computing ; Business intelligence ; OLAP technology ; Electronic books ; local
    Abstract: Get the end-to-end instruction you need to design, develop, and deploy more effective data integration, reporting, and analysis solutions using SQL Server 2008-whether you're new to business intelligence (BI) programming or a seasoned pro. With real-world examples and insights from an expert team, you'll master the concepts, tools, and techniques for building solutions that deliver intelligence-and business value-exactly where users want it. Discover how to: Manage the development life cycle and build a BI team Dig into SQL Server Analysis Services, Integration Services, and Reporting Services Navigate the Business Intelligence Development Studio (BIDS) Write queries that rank, sort, and drill down on sales data Develop extract, transform, and load (ETL) solutions Add a source code control system Help secure packages for deployment via encryption and credentials Use MDX and DMX Query Designers to build reports based on OLAP cubes and data mining models Create and implement custom objects using .NET code View reports in Microsoft Office Excel and Office SharePoint Serverook
    Note: Includes index. - Title from resource description page
    URL: https://learning.oreilly.com/library/view/-/9780735625808/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 13
    Online Resource
    Online Resource
    Microsoft SQL Server 2008 step by step (2009)
    Redmond, Wash. : Microsoft | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780735626041 , 0735626049
    Language: English
    Pages: xxv, 505 p , ill. , 23 cm +
    Keywords: SQL server ; Relational databases ; Client/server computing ; Electronic books ; local
    Abstract: Teach yourself SQL Server 2008-one step at a time. Get the practical guidance you need to build database solutions that solve real-world business problems. Learn to integrate SQL Server data in your applications, write queries, develop reports, and employ powerful business intelligence systems. 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 tuning plus optimization techniques to generate high-performing database applications Optimize availability through clustering, database mirroring, and log shipping Tap business intelligence tools-Reporting, Analysis, and Integration Services CD features: Practice exercises and code samples Fully searchable eBook For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780735626041/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 14
    Online Resource
    Online Resource
    Microsoft SQL server 2008 analysis services : step by step (2009)
    Redmond, Wash. : Microsoft Press | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780735626201 , 0735626200
    Language: English
    Pages: 1 v. (unpaged) , ill.
    Series Statement: Step by step
    Keywords: SQL server ; Database management ; Business intelligence ; Electronic books ; local
    Abstract: Teach yourself to use SQL Server 2008 Analysis Services for business intelligence one step at a time. You'll start by building your understanding of the business intelligence platform enabled by SQL Server and the Microsoft Office System, highlighting the role of Analysis Services. Then, you'll create a simple multidimensional OLAP cube and progressively add features to help improve, secure, deploy, and maintain an Analysis Services database. You'll explore core Analysis Services 2008 features and capabilities, including dimension, cube, and aggregation design wizards; a new attribute relationship designer; designer AMO warnings; and using dynamic management views to monitor resources. And as you complete each lesson, you can hone your skills using the practice exercises from the companion CD. Plus, you can review and download code samples illustrating the author's own, professional techniques direct from the companion Web site.
    Note: Title from resource description page. - Includes index
    URL: https://learning.oreilly.com/library/view/-/9780735626201/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 15
    Online Resource
    Online Resource
    SQL server forensic analysis (2009)
    Upper Saddle River, N.J. : Addison-Wesley | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780321533203 , 0321533208
    Language: English
    Pages: xix, 482 p , ill. , 24 cm. +
    Parallel Title: Erscheint auch als
    Keywords: SQL server ; Computer crimes ; Investigation ; Electronic books ; local
    Abstract: "What Kevvie Fowler has done here is truly amazing: He has defined, established, and documented SQL server forensic methods and techniques, exposing readers to an entirely new area of forensics along the way. This fantastic book is a much needed and incredible contribution to the incident response and forensic communities." -Curtis W. Rose, founder of Curtis W. Rose and Associates and coauthor of Real Digital Forensics The Authoritative, Step-by-Step Guide to Investigating SQL Server Database Intrusions Many forensics investigations lead to the discovery that an SQL Server database might have been breached. If investigators cannot assess and qualify the scope of an intrusion, they may be forced to report it publicly-a disclosure that is painful for companies and customers alike. There is only one way to avoid this problem: Master the specific skills needed to fully investigate SQL Server intrusions. In SQL Server Forensic Analysis, author Kevvie Fowler shows how to collect and preserve database artifacts safely and non-disruptively; analyze them to confirm or rule out database intrusions; and retrace the actions of an intruder within a database server. A chapter-length case study reinforces Fowler's techniques as he guides you through a real-world investigation from start to finish. The techniques described in SQL Server Forensic Analysis can be used both to identify unauthorized data access and modifications and to gather the information needed to recover from an intrusion by restoring the pre-incident database state. Coverage includes Determining whether data was actually compromised during a database intrusion and, if so, which data Real-world forensic techniques that can be applied on all SQL Server instances, including those with default logging Identifying, extracting, and analyzing database evidence from both published and unpublished areas of SQL Server Building a complete SQL Server incident response toolkit Detecting and circumventing SQL Server rootkits Identifying and recovering previously deleted database data using native SQL Server commands SQL Server Forensic Analysis is the first book of its kind to focus on the unique area of SQL Server incident response and forensics. Whether you're a digital forensics specialist, incident response team member, law enforcement officer, corporate security specialist, auditor, or database professional, you'll find this book an indispensable resource.
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780321533203/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 16
    Online Resource
    Online Resource
    SQL Server 2008 query performance tuning distilled (2009)
    Berkeley, Calif. : Apress | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9781430219026 , 1430219025
    Language: English
    Pages: xxvii, 531 p , ill. , 24 cm
    Series Statement: Expert's voice in SQL server
    Keywords: SQL server ; Client/server computing ; Database management ; Electronic books ; local
    Abstract: SQL Server 2008 Query Performance Tuning Distilled presents a direct trouble-shooting methodology for identifying poorly-performing stored procedures and queries, isolating the causes of that poor performance, and fixing the underlying problems. Each chapter is dedicated to one of the top causes of poorly performing queries and shows methods for identifying and dealing with the problems in that chapter's domain. Emphasis is always put upon or placed upon practical methods that you can put to immediate use in your day-to-day work. SQL Server 2008 functionality, tips, and tricks are emphasized in each subject area. Emphasizes the practical. Does not bury readers in theory. Gives readers practical techniques to immediately apply in their daily work. Dedicates a chapter to each of the most common, performance-related problem areas.
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/9781430219026/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 17
    Online Resource
    Online Resource
    Microsoft SQL server 2008 MDX : step by step (2009)
    Redmond, Wash. : Microsoft Press | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780735626188 , 0735626189
    Language: English
    Pages: xxiii, 352 p , ill., ports.
    Keywords: SQL server ; MDX (Computer program language) ; Client/server computing ; Relational databases ; Electronic books ; local
    Abstract: Teach yourself the Multidimensional Expressions (MDX) query language-one step at a time. With this practical, learn-by-doing tutorial, you'll build the core techniques for using MDX with Analysis Services to deliver high-performance business intelligence solutions. Discover how to: Construct and execute MDX queries Work with tuples, sets, and expressions Build complex sets to retrieve the exact data users need Perform aggregation functions and navigate data hierarchies Assemble time-based business metrics Customize an Analysis Services cube through the MDX script Implement dynamic security to control data access Develop MDX-driven reports in SQL Server Reporting Services CD features: Practice exercises Database and code samples Fully searchable eBook
    Note: At head of t.p.: Microsoft. - Includes index
    URL: https://learning.oreilly.com/library/view/-/9780735626188/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 18
    Online Resource
    Online Resource
    Pro SQL server 2008 relational database design and implementation (2008)
    Berkeley, [Calif.] : Apress | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 143020866X , 9781430208662
    Language: English
    Pages: xxvi, 650 p , ill. , 25 cm
    Series Statement: Expert's voice in SQL Server
    Keywords: SQL server ; Client/server computing ; Electronic books ; local
    Abstract: Learn effective and scalable database design techniques in a SQL Server environment. Pro SQL Server 2008 Relational Database Design and Implementation covers everything from design logic that business users will understand, all the way to the physical implementation of the design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, authors Louis Davidson, Kevin Kline, Scott Klein, and Kurt Windisch show how to 'get it right' in SQL Server database design and lay a solid groundwork for the future use of valuable business data. Solid foundation in best practices and relational theory Maximize SQL Server features to enhance security, performance, scalability Thorough treatment from conceptual design to an effective, physical implementation What you'll learn Develop conceptual models of client data using interviews and client documentation Normalize data models to enhance scalability and the long term use of valuable data Translate conceptual models into high-performing SQL Server databases Secure and protect the integrity of data as part of meeting regulatory requirements Take full advantage of new SQL Server features such as the spatial datatype, XML support, transparent data encryption, and more Create effective indexing to speed query performance Who this book is for Pro SQL Server 2008 Relational Database Design and Implementation is designed for programmers of all types who want to use SQL Server 2008 to store data. Rookie database programmers will find a complete course on the fundamentals of database design that includes conceptual designs and physical implementation. Seasoned veterans will find many tips and tricks for implementing database systems that will be well worth the time invested in reading this book.
    URL: https://learning.oreilly.com/library/view/-/9781430208662/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 19
    Online Resource
    Online Resource
    Pro SQL Server 2008 reporting services (2008)
    Berkeley, [Calif.] : Apress | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9781590599921 , 1590599926
    Language: English
    Pages: xxii, 401 p , ill. , 24 cm
    Keywords: SQL server ; Database management ; Client/server computing ; Electronic books ; local
    Abstract: Take full advantage of everything SQL Server 2008 Reporting Services has to offer and deliver customizable, web-enabled reports across your business at a reasonable cost. Learn best-practices from professionals who use SQL Server Reporting Services daily to deliver solutions to paying clients and gain the competitive edge on using Microsoft's enterprise-level reporting platform. Provides best-practices for using Reporting Services Written by practicing professionals with paying clients Your key to delivering business intelligence across the enterprise
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/9781590599921/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 20
    Online Resource
    Online Resource
    Pro T-SQL 2008 : programmer's guide (2008)
    Berkeley, [Calif.] : Apres | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 143021001X , 9781430210016
    Language: English
    Pages: xxviii, p , ill. , 24 cm
    Keywords: SQL server ; SQL (Computer program language) ; Electronic books ; local
    Abstract: 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
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/9781430210016/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 21
    Online Resource
    Online Resource
    SQL in a nutshell (2008)
    Sebastopol, [Calif.] : O'Reilly Media | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780596155322 , 0596155328
    Language: English
    Pages: [592] p
    Edition: 3rd ed.
    Parallel Title: Erscheint auch als
    Keywords: SQL server ; SQL (Computer program language) ; Clinet/server computing ; Electronic books ; local
    Abstract: For programmers, analysts, and database administrators, SQL in a Nutshell is the essential reference for the SQL language used in today's most popular database products. This new edition clearly documents every SQL command according to the latest ANSI standard, and details how those commands are implemented in Microsoft SQL Server 2008, Oracle 11g, and the MySQL 5.1 and PostgreSQL 8.3 open source database products. You'll also get a concise overview of the Relational Database Management System (RDBMS) model, and a clear-cut explanation of foundational RDBMS concepts -- all packed into a succinct, comprehensive, and easy-to-use format. This book provides: Background on the Relational Database Model, including current and previous SQL standards Fundamental concepts necessary for understanding relational databases and SQL commands An alphabetical command reference to SQL statements, according to the SQL2003 ANSI standard The implementation of each command by MySQL, Oracle, PostgreSQL, and SQL Server An alphabetical reference of the ANSI SQL2003 functions, as well as the vendor implementations Platform-specific functions unique to each implementation Beginning where vendor documentation ends, SQL in a Nutshell distills the experiences of professional database administrators and developers who have used SQL variants to support complex enterprise applications. Whether SQL is new to you, or you've been using SQL since its earliest days, you'll get lots of new tips and techniques in this book.
    Note: Title from title screen. - Includes index
    URL: https://learning.oreilly.com/library/view/-/9780596155322/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 22
    Online Resource
    Online Resource
    Microsoft SQL server 2008 : reporting services (2008)
    [New York] : McGraw-Hill | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780071548083 , 0071548084
    Language: English
    Pages: xxii, 822 p , ill.
    Keywords: SQL server ; Client/server computing ; Database management ; Electronic books ; local
    Abstract: The Definitive Guide to Microsoft SQL Server 2008 Reporting Services Create and deliver data-rich reports across the enterprise using this complete server-based reporting solution. Written by a member of the original Reporting Services development team, Microsoft SQL Server 2008 Reporting Services covers the entire report-building and distribution process, including data extraction, integration with desktop and Web applications, and end-user access. The book explains how to maximize all of the powerful features, including the new Tablix data format, as well as enhanced performance, scalability, and visualization capabilities. Install, configure, and customize SQL Server 2008 Reporting Services Create SELECT queries to extract data Generate reports from the Report Wizard and from scratch Add charts, images, and gauges Build reusable report templates Use the new Tablix data format to create reports with any structure Export reports to Word, Excel, PDF, HTML, XML, and other formats Enable end-user access to reports via the Report Server and its Report Manager web interface
    Note: Title from resource description page (viewed Apr. 23, 2009). - Includes index
    URL: https://learning.oreilly.com/library/view/-/9780071548083/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 23
    Online Resource
    Online Resource
    Beginning SQL server 2008 express for developers : from novice to professional (2008)
    Berkeley, Calif. : Apress | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9781430210900 , 1430210907
    Language: English
    Pages: xxiv, 497 p , ill.
    Series Statement: Expert's voice in SQL server
    Parallel Title: Erscheint auch als
    Keywords: SQL server ; Client/server computing ; Database management ; Electronic books ; local
    Abstract: Beginning SQL Server 2008 Express for Developers: From Novice to Professional takes a developer, and even a database administrator, from knowing nothing about SQL Server 2008 Express Edition to being ready to design and build a fully functioning system that is secure, reliable, maintainable, and robust. The Express Edition of SQL Server is a free resource commonly used by students, developers of small systems, and those transferring skills from other databases. This book focuses on the features within the Express Edition and therefore will not confuse readers with coverage of features found only in the Development Edition. By the end of the book, readers will be ready to move on to Accelerated SQL Server 2008 as well as other books within the Apress SQL Server lineup such as Pro SQL Server 2008 Reporting Services . Covers using the free Express Edition of SQL Server Describes creating a database from scratch and builds on this Provides an understanding of SQL Server Express 2008, allowing you to build future solutions for you and your business
    Note: Title from resource description page (viewed May 13, 2009). - Includes index
    URL: https://learning.oreilly.com/library/view/-/9781430210900/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 24
    Online Resource
    Online Resource
    ADO.NET 3.5 cookbook (2008)
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780596101404 , 0596101406
    Language: English
    Pages: xxii, 955 p , ill. , 24 cm
    Edition: 2nd ed.
    Keywords: ActiveX ; SQL server ; Database design ; Object-oriented programming (Computer science) ; Microsoft .NET ; Electronic books ; local
    Abstract: This guide is strikingly different from other books on Microsoft ADO.NET. Rather than load you down with theory, the new edition of ADO.NET 3.5 Cookbook gives you more than 200 coding solutions and best practices for real problems you're likely to face with this technology using Visual Studio 2008 and the .NET 3.5 platform. Organized to help you find the topic and specific recipe you need quickly and easily, this book is more than just a handy compilation of cut-and-paste C# code. ADO.NET 3.5 Cookbook also offers clear explanations of how and why each code solution works, and warns you of potential pitfalls so you can learn to adapt the book's problem-solving techniques to different situations. This collection of timesaving recipes covers vital topics including: Connecting to data Retrieving and managing data Transforming and analyzing data Modifying data Binding data to .NET user interfaces Optimizing .NET data access Enumerating and maintaining database objects Maintaining database integrity Ideal for ADO.NET programmers at all levels, from the relatively inexperienced to the most sophisticated, this new edition covers the significant 3.5 upgrade, including new programming tools such as LINQ. ADO.NET 3.5 Cookbook offers a painless way for those of you who prefer to learn by doing when it comes to expanding your skills and productivity.
    Note: Title from title screen. - Includes index. - "Building data-centric .NET applications"--Cover. - "Updated for .NET 3.5, LINQ, and SQL Server 2008"--Cover
    URL: https://learning.oreilly.com/library/view/-/9780596101404/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 25
    Online Resource
    Online Resource
    Microsoft SQL Server 2008 for dummies (2008)
    Hoboken, N.J. : Wiley | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780470224656 , 0470224657
    Language: English
    Pages: xviii, 383 p , ill. , 24 cm
    Series Statement: --For dummies
    Keywords: SQL server ; SQL (Computer program language) ; Database management ; Client/server computing ; Electronic books ; local
    Abstract: If you're a database administrator, you know Microsoft SQL Server 2008 is revolutionizing database development. Get up to speed on SQL Server 2008, impress your boss, and improve your company's data management - read Microsoft SQL Server 2008 For Dummies! SQL Server 2008 lets you build powerful databases and create database queries that give your organization the information it needs to excel. Microsoft SQL Server 2008 For Dummies helps you build the skills you need to set up, administer, and troubleshoot SQL Server 2008. You'll be able to: Develop and maintain a SQL Server system Design databases with integrity and efficiency Turn data into information with SQL Server Reporting Services Organize query results, summarizing data with aggregate functions and formatting output Import large quantities of data with SSIS Keep your server running smoothly Protect data from prying eyes Develop and implement a disaster recovery plan Improve performance with database snapshots Automate SQL Server 2008 administration Microsoft SQL Server 2008 For Dummies is a great first step toward becoming a SQL Server 2008 pro!
    Note: Title from resource description page (viewed June 1, 2009). - Includes index
    URL: https://learning.oreilly.com/library/view/-/9780470224656/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 26
    Online Resource
    Online Resource
    A developer's guide to data modeling for SQL server : covering SQL server 2005 and 2008 (2008)
    Upper Saddle River, N.J. : Addison-Wesley | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780321497642 , 0321497643
    Language: English
    Pages: xix, 277 p , ill. , 24 cm
    Series Statement: Addison-Wesley Microsoft technology series
    Keywords: SQL server ; Database design ; Data structures (Computer science) ; Electronic books ; local
    Abstract: " A Developer's Guide to Data Modeling for SQL Server explains the concepts and practice of data modeling with a clarity that makes the technology accessible to anyone building databases and data-driven applications. "Eric Johnson and Joshua Jones combine a deep understanding of the science of data modeling with the art that comes with years of experience. If you're new to data modeling, or find the need to brush up on its concepts, this book is for you." - Peter Varhol , Executive Editor, Redmond Magazine Model SQL Server Databases That Work Better, Do More, and Evolve More Smoothly Effective data modeling is essential to ensuring that your databases will perform well, scale well, and evolve to meet changing requirements. However, if you're modeling databases to run on Microsoft SQL Server 2008 or 2005, theoretical or platform-agnostic data modeling knowledge isn't enough: models that don't reflect SQL Server's unique real-world strengths and weaknesses often lead to disastrous performance. A Developer's Guide to Data Modeling for SQL Server is a practical, SQL Server-specific guide to data modeling for every developer, architect, and administrator. This book offers you invaluable start-to-finish guidance for designing new databases, redesigning existing SQL Server data models, and migrating databases from other platforms. You'll begin with a concise, practical overview of the core data modeling techniques. Next, you'll walk through requirements gathering and discover how to convert requirements into effective SQL Server logical models. Finally, you'll systematically transform those logical models into physical models that make the most of SQL Server's extended functionality. All of this book's many examples are available for download from a companion Web site. This book enables you to Understand your data model's physical elements, from storage to referential integrity Provide programmability via stored procedures, user-defined functions, triggers, and .NET CLR integration Normalize data models, one step at a time Gather and interpret requirements more effectively Learn an effective methodology for creating logical models Overcome modeling problems related to entities, attribute, data types, storage overhead, performance, and relationships Create physical models-from establishing naming guidelines through implementing business rules and constraints Use SQL Server's unique indexing capabilities, and overcome their limitations Create abstracti...
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780321497642/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 27
    Online Resource
    Online Resource
    MCITP SQL server 2005 database administration exam guide (2008)
    New York : McGraw-Hill | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780071496094 , 0071496092
    Language: English
    Pages: xxxvii, 752 p , ill. , 24 cm. +
    Series Statement: All-in-one
    Parallel Title: Erscheint auch als
    Keywords: Electronic data processing personnel ; Certification ; Microsoft software ; Examinations ; Study guides ; Database design ; Examinations ; Study guides ; SQL server ; Database management ; Electronic books ; local
    Abstract: All-in-One is All You Need Get complete coverage of all three Microsoft Certified IT Professional database administration exams for SQL Server 2005 in this comprehensive volume. Written by a SQL Server expert and MCITP, this definitive exam guide features learning objectives at the beginning of each chapter, exam tips, practice questions, and in-depth explanations. Detailed and authoritative, the book serves as both a complete certification study guide and an essential on-the-job reference. Get full details on all exam topics including how to: Install and configure SQL Server 2005 Use Transact-SQL Manage server infrastructure design Optimize databases Secure databases and servers Ensure high availability Implement backup and recovery strategies Maximize the built-in administration tools Use Business Intelligence tools, including SSIS and SSRS Manage concurrency Electronic content features: Six full practice exams--two for each exam: 70-431, 70-443, and 70-444 Scripts from the step-by-step exercises in the book Video training clips from the author
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780071496094/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 28
    Online Resource
    Online Resource
    Pro SQL server 2008 XML (2008)
    Berkeley, Calif. : Apress ; | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9781590599839 , 1590599837
    Language: English
    Pages: xxviii, 466 p , ill., maps , 25 cm
    Series Statement: The expert's voice in SQL server
    Keywords: SQL server ; XML (Document markup language) ; Client/server computing ; Electronic books ; local
    Abstract: Knowledge and ability to apply XML are de rigueur in today's world, and SQL Server developers and administrators are no exception to that rule. Pro SQL Server 2008 XML is your key to unlocking the powerful XML feature set first introduced in SQL Server 2005 and since refined in SQL Server 2008. Author Michael Coles shows how to store XML using SQL Server's built-in XML data type. Learn to query and manipulate XML data using standard technologies such as XQuery and XSLT. No SQL Server database professional can afford to be without knowledge of the XML feature set. Pro SQL Server 2008 XML delivers on the knowledge that you need to remain competitive in your career. Shows how to store, query, and manipulate XML documents in SQL Server Provides step-by-step examples showing best practices and advanced features Accurately discusses how SQL Server's XML feature set stacks up against the ISO XML standards
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/9781590599839/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 29
    Online Resource
    Online Resource
    Microsoft SQL Server 2008 all-in-one desk reference for dummies (2008)
    Hoboken, N.J. : Wiley | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780470179543 , 0470179546
    Language: English
    Pages: iv, 724 p , ill.
    Series Statement: --For dummies
    Keywords: SQL server ; Client/server computing ; Relational databases ; Electronic books ; local
    Abstract: If you're in charge of database administration, developing database software, or looking for database solutions for your company, Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies can help you get a handle on this extremely popular relational database management system. Here you'll find what's new in the latest version; how to choose and install the right variation for your needs; how to monitor, maintain, and protect your data; and what it takes to keep your database healthy. You'll discover how to: Build and maintain tables Design a database and communicate with it Retrieve, analyze, and report data Build solid, robust database applications Use the SQL Server Optimizer and Query Designer Navigate SQL Server with Visual Studio Develop useful reports with the Report Builder and Report Designer Create Business Intelligence solutions with Business Intelligence Development Studio Configure your server and perform major administrative tasks To help you quickly find what you need, Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies is divided into nine minibooks: Essential Concepts Designing and Using Databases Interacting With Your Data Database Programming Reporting Services Analysis Services Performance Tips and Tricks Database Administration Appendixes Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies gets you started, helps you solve problems, and will even answer your questions down the road!
    Note: Title from resource description page (viewed May 15, 2009). - Includes index
    URL: https://learning.oreilly.com/library/view/-/9780470179543/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 30
    Online Resource
    Online Resource
    MCITP SQL server 2005 database developer : exam guide (exams 70-431, 70-441, and 70-442) (2008)
    New York : McGraw Hill | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780071546690 , 0071546693
    Language: English
    Pages: xxxii, 903 p , ill. , 24 cm. +
    Series Statement: All-in-one
    Parallel Title: Erscheint auch als
    Keywords: Electronic data processing personnel ; Certification ; Database design ; Examinations ; Study guides ; Microsoft software ; Examinations ; Study guides ; SQL server ; Database management ; Electronic books ; local
    Abstract: All-in-One is All You Need Get complete coverage of all three Microsoft Certified IT Professional database developer exams for SQL Server 2005 in this comprehensive volume. Written by a SQL Server expert and MCITP, this definitive exam guide features learning objectives at the beginning of each chapter, exam tips, practice questions, and in-depth explanations. Detailed and authoritative, the book serves as both a complete certification study guide and an essential on-the-job reference. Get full details on all exam topics including how to: Install and configure SQL Server 2005 Manage database design Use Transact-SQL and XML Work with functions, triggers, and CLR integration Optimize, monitor, and secure databases Create stored procedures Handle disaster recovery Work with Service Broker, Web Services, and MARS Use SQL Server Reporting Services and Notification Services Manage locks, deadlocks, and cursors Transfer data using Replication and SQL Server Integration Services The CD-ROM features: Six full practice exams-two for each exam: 70-431, 70-441, & 70-442 Scripts from the step-by-step exercises in the book Video training clips from the author Complete electronic book
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780071546690/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 31
    Online Resource
    Online Resource
    MCTS 70-431 : implementing and maintaining Microsoft SQL Server 2005 (2007)
    [Indianapolis, Ind.] : Que Pub. | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 0789735881
    Language: English
    Pages: ix, 337 p , ill.
    Keywords: SQL server ; Electronic data processing personnel ; Certification ; Microsoft software ; Examinations ; Study guides ; Database design ; Examinations ; Study guides ; Electronic books ; local
    Abstract: The MCTS 70-431 Exam Cram is a must-have resource in your MCTS 70-431 exam preparation. The Exam Cram focuses on exactly what you need to know to get certified. This includes features like: Complete coverage of all 70-431 exam objectives Exam alerts, practice questions, notes, tips, sidebars, cautions, test-taking strategies, and time-saving tips Access to MeasureUp practice questions and innovative testing software The popular Cram Sheet tear card, giving you the key facts you should review before you enter the testing center Insight from author Thomas Moore , a Microsoft Certified Trainer (MCT) and SQL Server expert who has helped hundreds of students earn their SQL Server certifications
    Note: Includes bibliographical references (p. [293]-298) and index
    URL: https://learning.oreilly.com/library/view/-/0789735881/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 32
    Online Resource
    Online Resource
    Best damn Exchange, SQL and IIS book period (2007)
    Burlington, Mass. : Syngress | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9781597492195 , 1597492191
    Language: English
    Pages: xxxiii, 1189 p , ill. , 24 cm
    Keywords: Microsoft Internet information server ; SQL server ; Microsoft Exchange server ; Client/server computing ; Electronic books ; local ; Electronic books
    Abstract: Exchange, SQL and IIS are at the core of most Microsoft enterprise servers. The 2007 releases of these products, along with the release of Windows Vista and Windows 2008 Server, represents the biggest overhaul of Windows enterprise products since Windows 2000. The dramatic changes to security tools and the addition of features that support "anywhere access" present IT professionals with a steep learning curve. Making certain that these products are configured to meet regulatory compliance requirements adds addtionaly complexity to day-to-day management network management. The Best Damn Exchange, SQL and IIS Book Period delivers an all-in-one reference for Windows System Administrators deploying the 2007 releases of these core Microsoft servers. The coverage is comprehensive, and provides users with just about everything they need to manage a Windows enterprise server. Special Bonus coverage includes how to gather and analyze the many log files generated by these servers. All-in-one coverage includes Exchange, SQL, and IIS Servers Integrated coverage on all key security features Bonus coverage includes analyzing server logs and integrating Communicator 2007
    Note: Includes index
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 33
    Online Resource
    Online Resource
    Expert SQL server 2005 development (2007)
    Berkeley, [Calif.] : Apress | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 159059729X , 9781590597293
    Language: English
    Pages: xx, 449 p , ill. , 23 cm
    Series Statement: Expert's voice in SQL server programming
    Keywords: SQL server ; Client/server computing ; Electronic books ; local
    Abstract: While building on the skills you already have, Expert SQL Server 2005 Development will help you become an even better developer by focusing on best practices and demonstrating how to design high-performance, maintainable database applications. This book starts by reintroducing the database as a integral part of the software development ecosystem. You'll learn how to think about SQL Server development as you would any other software development. For example, there's no reason you can't architect and test database routines just as you would architect and test application code. And nothing should stop you from implementing the types of exception handling and security rules that are considered so important in other tiers, even if they are usually ignored in the database. You'll learn how to apply development methodologies like these to produce high-quality encryption and SQLCLR solutions. Furthermore, you'll discover how to exploit a variety of tools that SQL Server offers in order to properly use dynamic SQL and to improve concurrency in your applications. Finally, you'll become well versed in implementing spatial and temporal database designs, as well as approaching graph and hierarchy problems.
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/9781590597293/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 34
    Online Resource
    Online Resource
    Foundations of SQL Server 2005 business intelligence (2007)
    Berkeley, [Calif.] : Apress | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 1590598342 , 9781590598344
    Language: English
    Pages: xvii, 396 p , ill. , 23 cm
    Series Statement: Expert's voice in SQL server
    Keywords: SQL server ; Relational databases ; Client/server computing ; Business intelligence ; OLAP technology ; Electronic books ; local
    Abstract: Just as every business needs to effectively employ business intelligence (BI) to stay competitive, every IT professional needs to master BI to stay employed in this fastest-growing segment of information technology. Foundations of SQL Server 2005 Business Intelligence is the quickest path to understanding BI, and it is essential reading for all who work with SQL Server 2005. It is written from a practical perspective, perfect for anyone who uses the tools in SQL Server 2005s extraordinarily rich BI product suite. This book explains how best to use Analysis Services, SQL Server Integration Services, SQL Server Reporting Services, and SQL Server Data Mining. It also describes best practices for implementing end-to-end BI solutions in small, medium, and large business environments. And it provides important information about integrating BI with various client tools, including Excel, Business Scorecards, Proclarity, and SharePoint Portal Server. Developers, end users, and even managers will find this an enlightening guide to the power and promise of SQL Server 2005 BI.
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/9781590598344/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 35
    Online Resource
    Online Resource
    Hands-on Microsoft SQL server 2005 integration services (2007)
    New York : McGraw-Hill | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780072263190 , 0072263199
    Language: English
    Pages: xix, 570 p , ill. , 24 cm
    Keywords: SQL server ; Database management ; Electronic books ; local
    Abstract: In-depth coverage of Microsoft's powerful new data integration tool Learn to maximize the features of SQL Server 2005 Integration Services from this essential guide. Hands-On Microsoft SQL Server 2005 Integration Services makes learning SSIS easy through the use of extensive real-world exercises structured around every component within the tool. You will learn to collect corporate data from various sources and transform that data for analysis, mining, and reporting.
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780072263190/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 36
    Online Resource
    Online Resource
    The Microsoft data warehouse toolkit : with SQL Server 2005 and the Microsoft Business Intelligence toolset (2006)
    Indianapolis, Ind. : Wiley | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780471267157 , 0471267155
    Language: English
    Pages: xliii, 714 p , ill.
    Keywords: SQL server ; Data warehousing ; Electronic books ; local
    Abstract: This groundbreaking book is the first in the Kimball Toolkit series to be product-specific. Microsoft's BI toolset has undergone significant changes in the SQL Server 2005 development cycle. SQL Server 2005 is the first viable, full-functioned data warehouse and business intelligence platform to be offered at a price that will make data warehousing and business intelligence available to a broad set of organizations. This book is meant to offer practical techniques to guide those organizations through the myriad of challenges to true success as measured by contribution to business value. Building a data warehousing and business intelligence system is a complex business and engineering effort. While there are significant technical challenges to overcome in successfully deploying a data warehouse, the authors find that the most common reason for data warehouse project failure is insufficient focus on the business users and business problems. In an effort to help people gain success, this book takes the proven Business Dimensional Lifecycle approach first described in best selling The Data Warehouse Lifecycle Toolkit and applies it to the Microsoft SQL Server 2005 tool set. Beginning with a thorough description of how to gather business requirements, the book then works through the details of creating the target dimensional model, setting up the data warehouse infrastructure, creating the relational atomic database, creating the analysis services databases, designing and building the standard report set, implementing security, dealing with metadata, managing ongoing maintenance and growing the DW/BI system. All of these steps tie back to the business requirements. Each chapter describes the practical steps in the context of the SQL Server 2005 platform. Intended Audience The target audience for this book is the IT department or service provider (consultant) who is: Planning a small to mid-range data warehouse project; Evaluating or planning to use Microsoft technologies as the primary or exclusive data warehouse server technology; Familiar with the general concepts of data warehousing and business intelligence. The book will be directed primarily at the project leader and the warehouse developers, although everyone involved with a data warehouse project will find the book useful. Some of the book's content will be more technical than the typical project leader will need; other chapters and sections will focus on business issues that are interestin...
    Note: Title from resource description page (viewed Apr. 27, 2009). - Includes index
    URL: https://learning.oreilly.com/library/view/-/9780471267157/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 37
    Online Resource
    Online Resource
    A developer's guide to SQL server 2005 (2006)
    Upper Saddle River, NJ : Addison-Wesley | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 0321382188
    Language: English
    Pages: lvii, 997 p , ill.
    Keywords: SQL server ; Client/server computing ; Relational databases ; Electronic books ; local
    Abstract: "I come from a T-SQL background, so when I first laid my eyes on SQL Server 2005, I was shocked--and then, I was scared! I didn't have a CLR or XML background and suddenly had an urgent need to learn it. SQL Server 2005 is too big of a release to learn from the books online. Fortunately, now there is a book for developers who need to go from SQL Server 2000 to SQL Server 2005 and to do it as painlessly as possible. Basically, it's one-stop shopping for serious developers who have to get up to speed quickly. I'll keep this one on my desk--not on my bookshelf. Well done, Bob and Dan!" --Dr. Tom Moreau SQL Server MVP and Monthly Columnist SQL Server Professional, Brockman Moreau Consulting Inc. "A SQL book truly for developers, from two authorities on the subject. I'll be turning to this book first when I need to understand a component of SQL Server 2005." --Matt Milner Instructor Pluralsight "An excellent book for those of us who need to get up to speed on what's new in SQL Server 2005. The authors made sure this book includes the final information for the release version of the product. Most other books out now are based on beta versions. It covers key areas from XML and SQLCLR to Notification Services. Although the wide variety of information is great, my favorite part was the advice given on when to use what, and how performance is affected." --Laura Blood Senior Software Developer Blue Note Computing, Inc. "SQL Server 2005 is a massive release with a large number of new features. Many of these features were designed to make SQL Server a great application development platform. This book provides comprehensive information about the SQL Server features of most interest to application developers. The lucid text and wealth of examples will give a developer a clear understanding of how to use SQL Server 2005 to a whole new class of database applications. It should be on every SQL Server developer's bookshelf." --Roger Wolter Solutions Architect Microsoft Corporation "While there will be a lot of good books on SQL Server 2005 development, when people refer to the 'bible,' they'll be talking about this book." --Dr. Greg Low Senior Consultant Readify Pty Ltd "SQL Server 2005 is loaded with new features and getting a good overview is essential to understand how you can benefit from SQL Server 2005's features as a developer. Bob and Dan's book goes beyond enumerating the new SQL Server 2005 features, and will provide you with lots of good examples. The...
    Note: Includes bibliographical references (p. 963-964) and index
    URL: https://learning.oreilly.com/library/view/-/0321382188/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 38
    Online Resource
    Online Resource
    Microsoft SQL server 2005 : applied techniques (2006)
    Redmond, Wash. : Microsoft Press | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 0735623163 , 9780735623163
    Language: English
    Series Statement: Step by step
    Keywords: SQL server ; Client/server computing ; Relational databases ; Electronic books ; local
    Abstract: SQL Server 2005 is Microsoft's next-generation data management and analysis solution that delivers increased security, scalability, and availability to enterprise data and analytical applications while making them easier to create, deploy, and manage. This book shows readers with fundamental SQL Server skills, as well as new-to-topic but experienced database developers, techniques to design, build, test, deploy, and maintain better SQL Server databases. The format is a hands-on, sequential, developer's companion, providing beyond-the-basics guidance. This book is not a feature-driven reference manual, but a highly practical learning experience demonstrating how to build database solutions to solve business problems.
    Note: Title from title screen. - "Authors, Herbert Albert ... [et al.]"--Acknowledgments. - Includes bibliographical references and index
    URL: https://learning.oreilly.com/library/view/-/0735623163/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 39
    Online Resource
    Online Resource
    Administrator's guide to SQL server 2005 (2006)
    Upper Saddle River, NJ : Addison-Wesley | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 0321397975
    Language: English
    Pages: xviii, 626 p , ill.
    Keywords: SQL server ; Client/server computing ; Electronic books ; local
    Abstract: "Buck Woody's new book will help new and experienced users alike in getting productive with SQL Server 2005 quickly. His special attention to security and performance make this an exceptional reference that is sure to remain relevant for some time." -Chip Andrews, CISSP, MCDBA, Director of Research and Development Special Ops Security, Inc. "SQL 2005 is the most exciting upgrade to come out of Redmond in years; this book will help you get up and running quickly to take full advantage of it! If you are looking for a book about upgrading to SQL 2005, look no further, this one is all you need. It gives you all you need to take advantage of everything SQL 2005 has to offer, and that is a lot!" -Doug Ellis, Area Technical Manager, Cognos "Buck Woody provides insight into administering SQL Server 2005 that all developers and database administrators will find useful; the book assumes very little knowledge by providing 'DBA 101' sections which will not alienate the experienced reader while providing the necessary introduction to topics for those less experienced." -Doug Holland, Visual C# MVP, Precision Objects "SQL Server 2005 is a landmark release and this title does an awesome job of hitting everything new in SQL 2005. It covers new and improved administration tools, and contains an overview of Notification Services, SQL Server Service Broker, Reporting Services, Integration Services, and Analysis Services. As a result, you'll be able to work on your own SQL Server 2005 solutions quickly and painlessly. Ultimately, this book provides you with a starting point, a roadmap, and then the tools and knowledge to exploit this powerful new database server to its fullest power. So, start your computer and get ready to learn SQL Server 2005!" -Alexzander N. Nepomnjashiy, SQL Server DBA, NeoSystems NorthWest "A solid introduction to administering SQL 2005. The 'DBA 101' sections provide useful tips for the new DBA, good review for the experienced DBA, and the 101 label enables the seasoned DBA to skip basic material and jump ahead to where the REAL action is.... Buck's conversational writing style makes this an enjoyable and refreshing contrast to the majority of tech books written these days." -Brad Russell, MCDBA, Visionary Integration Professionals The Complete, Practical, 100% Useful Guide for Every SQL Server 2005 DBA! This book has one goal: to help database administrators and their managers run SQL Server 2005 with maximum efficiency, reliability, and pe...
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/0321397975/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 40
    Online Resource
    Online Resource
    Sams teach yourself Microsoft SQL Server 2005 Express in 24 hours (2006)
    [Indianapolis, Ind.] : Sams Pub. | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 0672327414
    Language: English
    Pages: 436 p , ill. +
    Keywords: SQL server ; Relational databases ; Client/server computing ; Electronic books ; local
    Abstract: Written with clarity and a down-to-earth approach, Sams Teach Yourself SQL Server 2005 Express in 24 Hours covers the basics of Microsoft's latest version of SQL Server. Expert author Alison Balter takes you from basic concepts to an intermediate level in 24 one-hour lessons. You will learn all of the basic tasks necessary for the administration of SQL Server 2005. You will also learn how to write and fully utilize: SQL Server stored procedures Functions Triggers using T-SQL, VB.NET, and C# You will also learn how to output SQL Server data to reports and the Internet. Sams Teach Yourself SQL Server 2005 Express in 24 Hours is a well-organized, authoritative introduction that will quickly have you up and running with SQL Server 2005.
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/0672327414/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 41
    Online Resource
    Online Resource
    Microsoft SQL Server 2005 administrator's pocket consultant (2005)
    Redmond, Wash. : Microsoft Press | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 0735621071 , 9780735621077
    Language: English
    Keywords: SQL server ; Client/server computing ; Relational databases ; Electronic books ; local
    Abstract: Here's the utterly practical, pocket-sized reference for IT professionals who need to administer, optimize, and maintain Microsoft SQL Server 2005 in their organization. This unique guide provides essential details for using Microsoft SQL Server 2005 to help protect and manage your company's data-whether automating tasks; creating indexes and views; performing backups and recovery; replicating transactions; tuning performance; managing server activity; importing and exporting data; or performing other key tasks. Featuring quick-reference tables, lists, and step-by-step instructions, this handy, one-stop guide provides fast, accurate answers on the spot-whether you're at your desk or in the field!
    Note: Title from title screen. - Includes bibliographical references and index
    URL: https://learning.oreilly.com/library/view/-/0735621071/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 42
    Online Resource
    Online Resource
    Microsoft SQL server 2005 : reporting services (2005)
    [New York] : McGraw-Hill | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780072262391 , 0072262397
    Language: English
    Pages: xvi, 736 p , ill.
    Keywords: SQL server ; Client/server computing ; Database management ; Electronic books ; local
    Abstract: Microsoft's Reporting Services product is a vital part of the SQL Server 2005 business intelligence platform, but it works with virtually any data source. This hands-on guide explains how to transform data into insightful and interactive Web-based reports using Microsoft SQL Server 2005 Reporting Services. With coverage of everything from installation to administration, the book demonstrates how to use this powerful server-based reporting solution to improve business decision-making and facilitate company-wide -- even worldwide -- communication.
    Note: Title from resource description page (viewed Apr. 23, 2009). - Includes index
    URL: https://learning.oreilly.com/library/view/-/9780072262391/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
Close ⊗
This website uses cookies and the analysis tool Matomo. More information can be found here...