Ihre E-Mail wurde erfolgreich gesendet. Bitte prüfen Sie Ihren Maileingang.

Leider ist ein Fehler beim E-Mail-Versand aufgetreten. Bitte versuchen Sie es erneut.

Vorgang fortführen?

Exportieren
Filter
  • MPI Ethno. Forsch.  (59)
  • Regensburg UB
  • HBZ
  • Online-Ressource  (59)
  • Boston, Mass. :Safari Books Online,  (42)
  • [Place of publication not identified] : Apress  (17)
  • SQL server  (59)
Datenlieferant
  • MPI Ethno. Forsch.  (59)
  • Regensburg UB
  • HBZ
Materialart
  • Online-Ressource  (59)
Sprache
Erscheinungszeitraum
Verfasser
Verlag/Herausgeber
Schlagwörter
  • 1
    Online-Ressource
    Online-Ressource
    Selecting data from multiple tables : using T-SQL for joins and unions in SQL server (2019)
    [Place of publication not identified] : Apress
    Details
    ISBN: 9781484249055
    Sprache: Englisch
    Seiten: 1 online resource (1 streaming video file (44 min., 38 sec.)) , digital, sound, color
    Schlagwort(e): SQL server ; SQL (Computer program language) ; Electronic videos ; local
    Kurzfassung: "Extend your SELECT statements to retrieve data simultaneously from multiple tables in a SQL Server database. This video covers these joins and shows how they are fundamental to getting maximum value from any relational database engine. It is impossible to write professional-level queries without a solid grounding in joins. Selecting Data from Multiple Tables helps you to attain that level of expertise. You will start with an introduction to relationships and joins with a look at the differences between a parent and child table. You'll learn how to define rows in two tables to correspond to each other through a common value column, or through a set of such columns held in common in both tables. The examples show that such relationships can record and store a wide variety of master-detail data points such as, for example, the line items in a customer order. Segments in the video examine the major different join types, including inner joins, left and right outer joins, and full outer joins. You'll also work with self joins and cross joins. Finally, the video goes through various union operations that you can also use to combine rows from two or more tables, but in a manner different from a join. Union operations covered in this video include the basic union, and intersection and exception operations."--Resource description page.
    Anmerkung: Title from title screen (viewed June 4, 2019). - Date of publication from resource description page
    URL: lizenzpflichtig
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 2
    Online-Ressource
    Online-Ressource
    Using T-SQL functions and summarizing results : analyzing and summarizing data in SQL server (2019)
    [Place of publication not identified] : Apress
    Details
    ISBN: 9781484245484
    Sprache: Englisch
    Seiten: 1 online resource (1 streaming video file (48 min., 29 sec.)) , digital, sound, color
    Schlagwort(e): SQL server ; SQL (Computer program language) ; Electronic videos ; local
    Kurzfassung: "The video begins with an introduction to basic functions to work with character data and NULL values. From there you'll move on to functions dealing with conditional structures, NULL values, and formatting. You'll also cover aggregate functions to average, count, and summarize data. Finally, this video discusses how to group result sets by a field using the GROUP BY clause, and how to filter those results after they have been grouped -- using the HAVING clause. Functions are the doorway to an ever-increasing number of powerful database engine features and capabilities. There is so much more that you can do in SQL other than simply SELECT data. Functions enable you to take full advantage of the power that's available to you in Microsoft's flagship database engine. This video is the second in a series and leaves you well positioned to step into the next video covering how to select data from multiple tables."--Resource description page.
    Anmerkung: Title from title screen (viewed June 3, 2019). - Date of publication from resource description page
    URL: lizenzpflichtig
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 3
    Online-Ressource
    Online-Ressource
    SQL server 2017 query performance tuning : troubleshoot and optimize query performance (2018)
    [Place of publication not identified] : Apress
    Details
    ISBN: 9781484238882
    Sprache: Englisch
    Seiten: 1 online resource (1 volume) , illustrations
    Ausgabe: Fifth edition.
    Schlagwort(e): SQL server ; Client/server computing ; Querying (Computer science) ; Relational databases ; Database management ; Electronic books ; local ; Electronic books
    Kurzfassung: Identify and fix causes of poor performance. You will learn Query Store, adaptive execution plans, and automated tuning on the Microsoft Azure SQL Database platform. Anyone responsible for writing or creating T-SQL queries will find valuable the insight into bottlenecks, including how to recognize them and eliminate them. This book covers the latest in performance optimization features and techniques and is current with SQL Server 2017. If your queries are not running fast enough and you're tired of phone calls from frustrated users, then this book is the answer to your performance problems. SQL Server 2017 Query Performance Tuning is about more than quick tips and fixes. You'll learn to be proactive in establishing performance baselines using tools such as Performance Monitor and Extended Events. You'll recognize bottlenecks and defuse them before the phone rings. You'll learn some quick solutions too, but emphasis is on designing for performance and getting it right. The goal is to head off trouble before it occurs. What You'll Learn Use Query Store to understand and easily change query performance Recognize and eliminate bottlenecks leading to slow performance Deploy quick fixes when needed, following up with long-term solutions Implement best practices in T-SQL to minimize performance risk Design in the performance that you need through careful query and index design Utilize the latest performance optimization features in SQL Server 2017 Protect query performance during upgrades to the newer versions of SQL Server Who This Book Is For Developers and database administrators with responsibility for application performance in SQL Server environments. Anyone responsible for writing or creating T-SQL queries will find valuable the insight into bottlenecks, including how to recognize them and eliminate them.
    Anmerkung: Description based on online resource; title from cover (Safari, viewed October 17, 2018)
    URL: lizenzpflichtig
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 4
    Online-Ressource
    Online-Ressource
    SQL Server advanced data types : JSON, XML, and beyond : taking full advantage of SQL Server's ever-growing support for modern data (2018)
    [Place of publication not identified] : Apress
    Details
    ISBN: 9781484239018
    Sprache: Englisch
    Seiten: 1 online resource (1 volume) , illustrations
    Schlagwort(e): SQL server ; Data types (Computer science) ; JSON (Document markup language) ; XML (Document markup language) ; Electronic books ; local ; Electronic books
    Kurzfassung: Deliver advanced functionality faster and cheaper by exploiting SQL Server's ever-growing amount of built-in support for modern data formats. Learn about the growing support within SQL Server for operations and data transformations that have previously required third-party software and all the associated licensing and development costs. Benefit through a better understanding of what can be done inside the database engine with no additional costs or development time invested in outside software. Widely used types such as JSON and XML are well-supported by the database engine. The same is true of hierarchical data and even temporal data. Knowledge of these advanced types is crucial to unleashing the full power that's available from your organization's SQL Server database investment. SQL Server Advanced Data Types explores each of the complex data types supplied within SQL Server. Common usage scenarios for each complex data type are discussed, followed by a detailed discussion on how to work with each data type. Each chapter demystifies the complex data and you learn how to use the data types most efficiently. The book offers a practical guide to working with complex data, using real-world examples to demonstrate how each data type can be leveraged. Performance considerations are also discussed, including the implementation of special indexes such as XML indexes and spatial indexes. What You'll Learn Understand the implementation of basic data types and why using the correct type is so important Work with XML data through the XML data type Construct XML data from relational result sets Store and manipulate JSON data using the JSON data type Model and analyze spatial data for geographic information systems Define hierarchies and query them efficiently through the HierarchyID type Who This Book Is For SQL Server developers and application developers who need to store and access complex data structures
    Anmerkung: Description based on online resource; title from cover (Safari, viewed September 17, 2018)
    URL: lizenzpflichtig
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 5
    Online-Ressource
    Online-Ressource
    Beginning backup and restore for SQL Server : data loss management and prevention techniques : practical application of data protection principles (2018)
    [Place of publication not identified] : Apress
    Details
    ISBN: 9781484234563
    Sprache: Englisch
    Seiten: 1 online resource (1 volume) , illustrations
    Schlagwort(e): SQL server ; Database management ; Client/server computing ; Electronic data processing ; Backup processing alternatives ; Electronic books ; local ; Electronic books
    Kurzfassung: Be guided through the techniques to back up and restore databases and files in SQL Server. Multiple techniques are presented for ensuring the integrity and consistency of database backups, as well as the reliability and manageability of restoring from backups. In today's data-driven world, the most important asset that a company has is its data. Data recovery strategies can be wide ranging; from the practically non-existent backup without verification to a very complex, distributed, and redundant system. An important objective for any database administrator is data loss prevention, and in a catastrophic data loss event, pre-defined data recovery techniques must be employed in order to get the databases back up and running efficiently and quickly. Using a tutorial method of teaching, Beginning Backup and Restore for SQL Server explores the many facets behind the principles of backing up and restoring data from your database, and then shows practical application methods for getting the work done quickly and correctly. This book is an essential guide toward discovering the correct path to protecting the data for your organization. What You'll Learn Be instructed on backup and restore techniques and principles Understand the importance of a fully implemented backup plan in SQL Server Agent Integrate backup and restore techniques into an existing environment Consider space and time requirements for backup and restore operations Master the principles for common deployment types Who This Book Is For Administrators who need to learn or refresh their knowledge of how to back up and restore SQL Server databases in various scenarios
    Anmerkung: Description based on online resource; title from cover (Safari, viewed July 16, 2018)
    URL: lizenzpflichtig
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 6
    Online-Ressource
    Online-Ressource
    Beginning Entity Framework Core 2.0 : database access from .NET : work directly with data through domain-specific objects and methods (2018)
    [Place of publication not identified] : Apress
    Details
    ISBN: 9781484233757
    Sprache: Englisch
    Seiten: 1 online resource (1 volume) , illustrations
    Schlagwort(e): Microsoft .NET Framework ; Entity Framework (Software framework) ; SQL server ; Relational databases ; Electronic books ; local ; Electronic books
    Kurzfassung: Use the valuable Entity Framework Core 2.0 tool in ASP.NET and the .NET Framework to eliminate the tedium around accessing databases and the data they contain. Entity Framework Core 2.0 greatly simplifies access to relational databases such as SQL Server that are commonly deployed in corporate settings. By eliminating tedious data access code that developers are otherwise forced to use, Entity Framework Core 2.0 enables you to work directly with the data in a database through domain-specific objects and methods. Beginning Entity Framework Core 2.0 is a carefully designed tutorial. Throughout the book you will encounter examples that you can use in your day-to-day coding, and you will build a solid foundation on which to create database-backed applications. If you are looking for a way to get started without getting buried under details you are only going to forget, then this is the book for you. The author aims to leave you comfortably able to connect to, access, modify, and delete data from a relational database. The book provides a clear, straightforward approach and includes code that you can look back at months later and understand. What You'll Learn Study easy-to-follow, real-world examples you can use every day Focus on DbContext and the Database First approach Understand how to work with single and multiple tables Use the LINQ query language to manipulate data Who This Book Is For C# and ASP.NET programmers looking for an easier way of accessing data in a relational database than writing in SQL-a way that meshes better into object-oriented application development
    Anmerkung: Description based on online resource; title from cover (Safari, viewed March 20, 2018)
    URL: lizenzpflichtig
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 7
    Online-Ressource
    Online-Ressource
    T-SQL querying : writing a SELECT statement (2018)
    [Place of publication not identified] : Apress
    Details
    ISBN: 9781484243336
    Sprache: Englisch
    Seiten: 1 online resource (1 streaming video file (48 min., 33 sec.)) , digital, sound, color
    Schlagwort(e): SQL server ; SQL (Computer program language) ; Client/server computing ; Electronic videos ; local
    Kurzfassung: "This video provides you with the knowledge to write SELECT statements to retrieve data from a SQL Server database. The video begins with an explanation of fields and records, followed by the anatomy of a SELECT statement. It continues with how to use a WHERE clause to filter specific records into the result set. Since a field can store various data types, the filter section shows how to work with those data types. Finally, there is coverage of how to sort and order a result set. Also covered is the four-part naming convention for tables in SQL Server. A proper understanding of table naming is important as queries become more involved and complex. Table and column aliases are covered as well, which are names that you can provide as substitutes for canonical names that are often long and cumbersome. Aliases provide a level of insulation in your queries from changes to names in the tables and columns that are being queried. While this video is about T-SQL and includes examples specific to SQL Server, the bulk of what you will learn is applicable to any vendor's implementation of the SQL language."--Resource description page.
    Anmerkung: Title from resource description page (Safari, viewed February 8, 2019)
    URL: lizenzpflichtig
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 8
    Online-Ressource
    Online-Ressource
    Expert SQL Server transactions and locking : concurrency internals for SQL Server practitioners (2018)
    [Place of publication not identified] : Apress
    Details
    ISBN: 9781484239575
    Sprache: Englisch
    Seiten: 1 online resource (1 volume) , illustrations
    Schlagwort(e): SQL server ; Client/server computing ; Application software ; Development ; Electronic books ; local ; Electronic books
    Kurzfassung: Master SQL Server's Concurrency Model so you can implement high-throughput systems that deliver transactional consistency to your application customers. This book explains how to troubleshoot and address blocking problems and deadlocks, and write code and design database schemas to minimize concurrency issues in the systems you develop. SQL Server's Concurrency Model is one of the least understood parts of the SQL Server Database Engine. Almost every SQL Server system experiences hard-to-explain concurrency and blocking issues, and it can be extremely confusing to solve those issues without a base of knowledge in the internals of the Engine. While confusing from the outside, the SQL Server Concurrency Model is based on several well-defined principles that are covered in this book. Understanding the internals surrounding SQL Server's Concurrency Model helps you build high-throughput systems in multi-user environments. This book guides you through the Concurrency Model and elaborates how SQL Server supports transactional consistency in the databases. The book covers all versions of SQL Server, including Microsoft Azure SQL Database, and it includes coverage of new technologies such as In-Memory OLTP and Columnstore Indexes. What You'll Learn Know how transaction isolation levels affect locking behavior and concurrency Troubleshoot and address blocking issues and deadlocks Provide required data consistency while minimizing concurrency issues Design efficient transaction strategies that lead to scalable code Reduce concurrency problems through good schema design Understand concurrency models for In-Memory OLTP and Columnstore Indexes Reduce blocking during index maintenance, batch data load, and similar tasks Who This Book Is For SQL Server developers, database administrators, and application architects who are developing highly-concurrent applications. The book is for anyone interested in the technical aspects of creating and troubleshooting high-throughput systems that respond swiftly to user requests.
    Anmerkung: Description based on online resource; title from cover (Safari, viewed November 6, 2018)
    URL: lizenzpflichtig
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 9
    Online-Ressource
    Online-Ressource
    The Biml book : business intelligence and data warehouse automation (2017)
    [Place of publication not identified] : Apress
    Details
    Sprache: Englisch
    Seiten: 1 online resource (1 volume) , illustrations
    Schlagwort(e): SQL server ; Management information systems ; Information technology ; Management ; Client/server computing ; Business ; Data processing ; Electronic books ; Electronic books ; local
    Kurzfassung: Learn Business Intelligence Markup Language (Biml) for automating much of the repetitive, manual labor involved in data integration. We teach you how to build frameworks and use advanced Biml features to get more out of SQL Server Integration Services (SSIS), Transact-SQL (T-SQL), and SQL Server Analysis Services (SSAS) than you ever thought possible. The first part of the book starts with the basics-getting your development environment configured, Biml syntax, and scripting essentials. Whether a beginner or a seasoned Biml expert, the next part of the book guides you through the process of using Biml to build a framework that captures both your design patterns and execution management. Design patterns are reusable code blocks that standardize the approach you use to perform certain types of data integration, logging, and other key data functions. Design patterns solve common problems encountered when developing data integration solutions. Because you do not have to build the code from scratch each time, design patterns improve your efficiency as a Biml developer. In addition to leveraging design patterns in your framework, you will learn how to build a robust metadata store and how to package your framework into Biml bundles for deployment within your enterprise. In the last part of the book, we teach you more advanced Biml features and capabilities, such as SSAS development, T-SQL recipes, documentation autogeneration, and Biml troubleshooting. The Biml Book : Provides practical and applicable examples Teaches you how to use Biml to reduce development time while improving quality Takes you through solutions to common data integration and BI challenges What You'll Learn Master the basics of Business Intelligence Markup Language (Biml) Study patterns for automating SSIS package generation Build a Biml Framework Import and transform database schemas Automate generation of scripts and projects Who This Book Is For BI developers wishing to quickly locate previously tested solutions, Microsoft BI specialists, those seeking more information about solution automation and code generation, and practitioners of Data Integration Lifecycle Management (DILM) in the DevOps enterprise
    Anmerkung: Description based on online resource; title from cover (Safari, viewed November 15, 2018)
    URL: https://learning.oreilly.com/library/view/-/9781484231357/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 10
    Online-Ressource
    Online-Ressource
    Building custom tasks for SQL Server Integration Services : taking a low-cost approach to applying the power of .NET in ETL solutions (2017)
    [Place of publication not identified] : Apress
    Details
    Sprache: Englisch
    Seiten: 1 online resource (1 volume) , illustrations
    Schlagwort(e): SQL server ; Microsoft Visual studio ; Microsoft .NET Framework ; Client/server computing ; Database management ; Electronic books ; Electronic books ; local
    Kurzfassung: Learn to build custom SSIS tasks using Visual Studio Community Edition and Visual Basic. Bring all the power of Microsoft .NET to bear on your data integration and ETL processes, and for no added cost over what you've already spent on licensing SQL Server. If you already have a license for SQL Server, then you do not need to spend more money to extend SSIS with custom tasks and components. Why are custom components necessary? Because even though the SSIS catalog of built-in tasks and components is a marvel of engineering, there do remain gaps in the functionality that is provided. These gaps are especially relevant to enterprises practicing Data Integration Lifecycle Management (DILMS) and/or DevOps. One of the gaps is a limitation of the SSIS Execute Package task. Developers using the stock version of that task are unable to select SSIS packages from other projects. Yet it's useful to be able to select and execute tasks across projects, and the example used throughout this book will help you to create an Execute Catalog Package task that does in fact allow you to execute a task from another project. Building on the example's pattern, you can create any task that you like, custom tailored to your specific, data integration and ETL needs. What You Will Learn Configure and execute Visual Studio in the way that best supports SSIS task development Create a class library as the basis for an SSIS task, and reference the needed SSIS assemblies Properly sign assemblies that you create in order to invoke them from your task Implement source code control via Visual Studio Team Services, or your own favorite tool set Code not only your tasks themselves, but also the associated task editors Troubleshoot and then execute your custom tasks as part of your own project Who This Book Is For Database administrators and developers who are involved in ETL projects built around SQL Server Integration Services (SSIS). Readers should have a background in programming along with a desire to optimize their ETL efforts by creating custom-tailored tasks for execution from SSIS packages.
    Anmerkung: Includes bibliographical references. - Description based on online resource; title from cover (Safari, viewed November 28, 2018)
    URL: https://learning.oreilly.com/library/view/-/9781484229408/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 11
    Online-Ressource
    Online-Ressource
    Pro SQL server internals (2016)
    [Place of publication not identified] : Apress
    Details
    Sprache: Englisch
    Seiten: 1 online resource (1 volume) , illustrations
    Ausgabe: Second edition.
    Serie: The expert's voice in SQL
    Schlagwort(e): SQL server ; Database management ; Client/server computing ; Electronic books ; Electronic books ; local
    Kurzfassung: Improve your ability to develop, manage, and troubleshoot SQL Server solutions by learning how different components work "under the hood," and how they communicate with each other. The detailed knowledge helps in implementing and maintaining high-throughput databases critical to your business and its customers. You'll learn how to identify the root cause of each problem and understand how different design and implementation decisions affect performance of your systems. New in this second edition is coverage of SQL Server 2016 Internals, including In-Memory OLTP, columnstore enhancements, Operational Analytics support, Query Store, JSON, temporal tables, stretch databases, security features, and other improvements in the new SQL Server version. The knowledge also can be applied to Microsoft Azure SQL Databases that share the same code with SQL Server 2016. Pro SQL Server Internals is a book for developers and database administrators, and it covers multiple SQL Server versions starting with SQL Server 2005 and going all the way up to the recently released SQL Server 2016. The book provides a solid road map for understanding the depth and power of the SQL Server database server and teaches how to get the most from the platform and keep your databases running at the level needed to support your business. The book: Provides detailed knowledge of new SQL Server 2016 features and enhancements Includes revamped coverage of columnstore indexes and In-Memory OLTP Covers indexing and transaction strategies Shows how various database objects and technologies are implemented internally, and when they should or should not be used Demonstrates how SQL Server executes queries and works with data and transaction log What You Will Learn Design and develop database solutions with SQL Server. Troubleshoot design, concurrency, and performance issues. Choose the right database objects and technologies for the job. Reduce costs and improve availability and manageability. Design disaster recovery and high-availability strategies. Improve performance of OLTP and data warehouse systems through in-memory OLTP and Columnstore indexes. Who This Book Is For Developers and database administrators who want to design, develop, and maintain systems in a way that gets the most from SQL Server. This book is an excellent choice for people who prefer to understand and fix the root cause of a problem rather than applying a 'band aid' to it.
    Anmerkung: Description based on online resource; title from cover (Safari, viewed March 1, 2017)
    URL: https://learning.oreilly.com/library/view/-/9781484219645/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 12
    Online-Ressource
    Online-Ressource
    Securing SQL Server : DBAs defending the database (2016)
    [Place of publication not identified] : Apress
    Details
    Sprache: Englisch
    Seiten: 1 online resource (1 volume) , illustrations.
    Serie: The expert's voice in SQL
    Schlagwort(e): SQL server ; Database security ; Electronic books ; Electronic books ; local
    Kurzfassung: Protect your data from attack by using SQL Server technologies to implement a defense-in-depth strategy, performing threat analysis, and encrypting sensitive data as a last line of defense against compromise. The multi-layered approach in this book helps ensure that a single breach doesn't lead to loss or compromise of your data that is confidential and important to the business. Database professionals in today's world deal increasingly often with repeated data attacks against high-profile organizations and sensitive data. It is more important than ever to keep your company's data secure. Securing SQL Server demonstrates how administrators and developers can both play their part in the protection of a SQL Server environment. This book provides a comprehensive technical guide to the security model, and to encryption within SQL Server, including coverage of the latest security technologies such as Always Encrypted, Dynamic Data Masking, and Row Level Security. Most importantly, the book gives practical advice and engaging examples on how to defend your data -- and ultimately your job! -- against attack and compromise. Covers the latest security technologies, including Always Encrypted, Dynamic Data Masking, and Row Level Security Promotes security best-practice and strategies for defense-in-depth of business-critical database assets Gives advice on performing threat analysis and reducing the attack surface that your database presents to the outside world What You Will Learn Perform threat analysis Implement access level control and data encryption Avoid non-reputability by implementing comprehensive auditing Use security metadata to ensure your security policies are enforced Apply the latest SQL Server technologies to increase data security Mitigate the risk of credentials being stolen Who This Book Is For SQL Server database administrators who need to understand and counteract the threat of attacks against their company's data. The book is also of interest to database administrators of other platforms, as several of the attack techniques are easily generalized beyond SQL Server and to other database brands.
    Anmerkung: Description based on online resource; title from cover (Safari, viewed November 22, 2016)
    URL: https://learning.oreilly.com/library/view/-/9781484222652/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 13
    Online-Ressource
    Online-Ressource
    Pro SQL server relational database design and implementation (2016)
    [Place of publication not identified] : Apress
    Details
    Sprache: Englisch
    Seiten: 1 online resource (1 volume) , illustrations.
    Ausgabe: Fifth edition.
    Serie: The expert's voice in SQL
    Schlagwort(e): SQL server ; Client/server computing ; Relational databases ; Electronic books ; Electronic books ; local
    Kurzfassung: Learn effective and scalable database design techniques in a SQL Server 2016 and higher environment. This book is revised to cover in-memory online transaction processing, temporal data storage, row-level security, durability enhancements, and other design-related features that are new or changed in SQL Server 2016. Designing an effective and scalable database using SQL Server is a task requiring skills that have been around for forty years coupled with technology that is constantly changing. Pro SQL Server Relational Database Design and Implementation covers everything from design logic that business users will understand, all the way to the physical implementation of design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, Louis Davidson shows how to "get it right" in SQL Server database design and lay a solid groundwork for the future use of valuable business data. The pace of change in relational database management systems has been tremendous these past few years. Whereas in the past it was enough to think about optimizing data residing on spinning hard drives, today one also must consider solid-state storage as well as data that are constantly held in memory and never written to disk at all except as a backup. Furthermore, there is a trend toward hybrid cloud and on-premise database configurations as well a move toward preconfigured appliances. Pro SQL Server Relational Database Design and Implementation guides in the understanding of these massive changes and in their application toward sound database design. Gives a solid foundation in best practices and relational theory Covers the latest implementation features in SQL Server 2016 Helps you master in-memory OLTP and use it effectively Takes you from conceptual design to an effective, physical implementation What You Will Learn Develop conceptual models of client data using interviews and client documentation Recognize and apply common database design patterns 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 data integrity as part of meeting regulatory requirements Create effective indexing to speed query performance Who This Book Is For Programmers and database administrators of all types who want to use SQL Server to store data. The book is especially useful to those wanting to learn the very latest design f...
    Anmerkung: Includes index. - Description based on online resource; title from title page (Safari, viewed April 28, 2017)
    URL: https://learning.oreilly.com/library/view/-/9781484219720/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 14
    Online-Ressource
    Online-Ressource
    Expert scripting and automation for SQL Server DBAs : amplifying your personal productivity and impact as a database administrator (2016)
    [Place of publication not identified] : Apress
    Details
    Sprache: Englisch
    Seiten: 1 online resource (1 volume) , illustrations.
    Serie: The expert's voice in SQL server
    Schlagwort(e): SQL server ; SQL (Computer program language) ; Electronic books ; Electronic books ; local
    Kurzfassung: Automate your workload and manage more databases and instances with greater ease and efficiency by combining metadata-driven automation with powerful tools like PowerShell and SQL Server Agent. Automate your new instance-builds and use monitoring to drive ongoing automation, with the help of an inventory database and a management data warehouse. The market has seen a trend towards there being a much smaller ratio of DBAs to SQL Server instances. Automation is the key to responding to this challenge and continuing to run a reliable database platform service. Expert Scripting and Automation for SQL Server DBAs guides you through the process of automating the maintenance of your SQL Server enterprise. Expert Scripting and Automation for SQL Server DBAs shows how to automate the SQL Server build processes, monitor multiple instances from a single location, and automate routine maintenance tasks throughout your environment. You will also learn how to create automated responses to common or time consuming break/fix scenarios. The book helps you become faster and better at what you do for a living, and thus more valuable in the job market. Extensive coverage of automation using PowerShell and T-SQL Detailed discussion and examples on metadata-driven automation Comprehensive coverage of automated responses to break/fix scenarios What You Will Learn Automate the SQL Server build process Create intelligent, metadata-drive routines Automate common maintenance tasks Create automated responses to common break/fix scenarios Monitor multiple instance from a central location Utilize T-SQL and PowerShell for administrative purposes Who This Book Is For Expert Scripting and Automation for SQL Server DBAs is a book for SQL Server database administrators responsible for managing increasingly large numbers of databases across their business enterprise. The book is also useful for any database administrator looking to ease their workload through automation. The book addresses the needs of these audiences by showing how to get more done through less effort by implementing an intelligent, automated-processes service model using tools such as T-SQL, PowerShell, Server Agent, and the Management Data Warehouse.
    Anmerkung: Includes index. - Description based on online resource; title from cover (Safari, viewed September 19, 2016)
    URL: https://learning.oreilly.com/library/view/-/9781484219430/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 15
    Online-Ressource
    Online-Ressource
    High performance SQL Server : the go faster book : bringing consistent response time to mission-critical applications (2016)
    [Place of publication not identified] : Apress
    Details
    Sprache: Englisch
    Seiten: 1 online resource (1 volume) , illustrations.
    Serie: The expert's voice in SQL
    Schlagwort(e): SQL server ; Database management ; Client/server computing ; Electronic books ; Electronic books ; local
    Kurzfassung: Design and configure SQL Server instances and databases in support of high-throughput applications that are mission-critical and provide consistent response times in the face of variations in user numbers and query volumes. Learn to configure SQL Server and design your databases to support a given instance and workload. You'll learn advanced configuration options, in-memory technologies, storage and disk configuration, and more, all toward enabling your desired application performance and throughput. Configuration doesn't stop with implementation. Workloads change over time, and other impediments can arise to thwart desired performance. High Performance SQL Server covers monitoring and troubleshooting to aid in detecting and fixing production performance problems and minimizing application outages. You'll learn a variety of tools, ranging from the traditional wait analysis methodology to the new query store, and you'll learn how improving performance is really an iterative process. High Performance SQL Server is based on SQL Server 2016, although most of its content can be applied to prior versions of the product. This book is an excellent complement to performance tuning books focusing on SQL queries, and provides the other half of what you need to know by focusing on configuring the instances on which mission-critical queries are executed. Covers SQL Server instance-configuration for optimal performance Helps in implementing SQL Server in-memory technologies Provides guidance toward monitoring and ongoing diagnostics What You Will Learn Understand SQL Server's database engine and how it processes queries Configure instances in support of high-throughput applications Provide consistent response times to varying user numbers and query volumes Design databases for high-throughput applications with focus on performance Record performance baselines and monitor SQL Server instances against them Troubleshot and fix performance problems Who This Book Is For SQL Server database administrators, developers, and data architects. The book is also of use to system administrators who are managing and are responsible for the physical servers on which SQL Server instances are run.
    Anmerkung: "Covers SQL Server 2016.". - Description based on online resource; title from cover (Safari, viewed March 29, 2017)
    URL: https://learning.oreilly.com/library/view/-/9781484222713/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 16
    Online-Ressource
    Online-Ressource
    Pro SQL Server on Microsoft Azure (2016)
    [Place of publication not identified] : Apress
    Details
    Sprache: Englisch
    Seiten: 1 online resource (1 volume) , illustrations
    Schlagwort(e): Microsoft Azure SQL Database ; SQL server ; Electronic books ; Electronic books ; local
    Kurzfassung: Learn the basics of Microsoft Azure and see how SQL Server on Azure VMs (Infrastructure-as-a-Service) and Azure SQL Databases (Platform-as-a-Service) work. This concise book shows you how to deploy, operate, and maintain your data using any one or a combination of these offerings along with your on-premise environment. Pro SQL Server on Microsoft Azure is a quintessential book for any IT professional who is planning to host their data on Microsoft Azure. This book will not only equip you with the tips, tricks, and tools to manage SQL Server offerings on Azure, but will also help you in deciding between PaaS, IaaS, or hybrid. In the ever-changing world of operations, IT administrators and SQL Server DBAs often find that the biggest challenges occur once they've deployed to the cloud. This is precisely why Pro SQL Server on Microsoft Azure was written; it will help you master today's cloud world. What You'll Learn Understand the Microsoft Azure IaaS architecture Work with Azure Storage and Networking Deploy SQL Server on Azure VMs using best practices Apply effective security principles to SQL Azure Databases Measure and optimize the performance of SQL Server offerings on Azure Implement Business continuity and disaster recovery options with Azure SQL Databases Who This Book Is For This book is for IT admins and SQL Server DBAs who are managing or would be managing SQL Server deployments on Microsoft Azure.
    Anmerkung: Includes index. - Description based on online resource; title from cover (Safari, viewed September 19, 2016)
    URL: https://learning.oreilly.com/library/view/-/9781484220832/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 17
    Online-Ressource
    Online-Ressource
    Beginning SQL server reporting services (2016)
    [Place of publication not identified] : Apress
    Details
    Sprache: Englisch
    Seiten: 1 online resource (1 volume) , illustrations
    Schlagwort(e): SQL server ; SQL (Computer program language) ; Database management ; Client/server computing ; Electronic books ; Electronic books ; local
    Kurzfassung: Learn SQL Server Reporting Services and become current with the 2016 edition. Develop interactive, dynamic reports that combine graphs, charts, and tabular data into attractive dashboards and reports to delight business analysts and other users of corporate data. Deliver mobile reports to anywhere and any device. Build vital knowledge of Reporting Services at a time when Microsoft's dominance in business intelligence is on the rise. Beginning SQL Server Reporting Services turns novices into skilled report developers. The book begins by explaining how to set up the development environment. It then walks you through creating your first reports using the built-in wizard. After showing what is possible, the book breaks down and explains the skills needed to create reports from scratch. And not just reports! But also dashboards with charts, graphs, and maps. Each chapter builds on knowledge gained in the previous chapters with step-by-step tutorials. Beginning SQL Server Reporting Services boosts your skills and provides you additional career options. Don't be without those options. Grab and read this book today. Build reports with and without the built-in wizard. Build interactive features such as drill-through reports. Build dashboards full of charts, graphs, and maps. Build mobile reports. What You Will Learn Set up your development environment. Organized projects and share components among reports. Create report using a wizard. Create reports from scratch, including grouping levels, parameters, and drill through features. Build interactive dashboard with graphs, charts, and maps. Deploy and manage reports for use by others in the business. Who This Book Is For Database professionals of all experience levels who have some experience in databases and want to make the leap into business intelligence reporting. The book is an excellent choice for those needing to add Reporting Services to their current list of skills, or who are looking for a skill set that is in demand for in order to break into IT.
    Anmerkung: Description based on online resource; title from cover (Safari, viewed November 21, 2016)
    URL: https://learning.oreilly.com/library/view/-/9781484219904/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 18
    Online-Ressource
    Online-Ressource
    SQL Server 2008 administration in action (2010)
    Greenwich, Conn. : Manning | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9781933988726 , 193398872X
    Sprache: Englisch
    Seiten: 1 v. (unpaged) , ill.
    Schlagwort(e): SQL server ; Database management ; Client/server computing ; Electronic books ; local
    Kurzfassung: 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.
    Anmerkung: Title from resource description page. - Includes index
    URL: https://learning.oreilly.com/library/view/-/9781933988726/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 19
    Online-Ressource
    Online-Ressource
    Microsoft SQL server 2008 analysis services unleashed (2009)
    Indianapolis, Ind. : Sams Pub. | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780768686913 , 0768686911
    Sprache: Englisch
    Seiten: xviii, 865 p , ill. , 24 cm
    Paralleltitel: Erscheint auch als
    Schlagwort(e): SQL server ; Client/server computing ; Relational databases ; Electronic books ; local
    Kurzfassung: 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±
    Anmerkung: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780768686913/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 20
    Online-Ressource
    Online-Ressource
    Microsoft SQL server 2008 : T-SQL fundamentals (2009)
    Redmond, Wash. : Microsoft Press | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 0735626014 , 9780735626010
    Sprache: Englisch
    Seiten: xviii, 394 p , ill. , 23 cm
    Schlagwort(e): SQL server ; SQL (Computer program language) ; Client/server computing ; Electronic books ; local
    Kurzfassung: 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
    Anmerkung: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780735626010/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 21
    Online-Ressource
    Online-Ressource
    Microsoft SQL server 2008 administrator's pocket consultant (2009)
    Redmond, Wash. : Microsoft Press | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780735625891 , 0735625891
    Sprache: Englisch
    Seiten: xxii, 696 p , ill. , 21 cm
    Schlagwort(e): SQL server ; Client/server computing ; Database management ; Electronic books ; local
    Kurzfassung: 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
    Anmerkung: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780735625891/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 22
    Online-Ressource
    Online-Ressource
    Microsoft SQL server 2008 analysis services : step by step (2009)
    Redmond, Wash. : Microsoft Press | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780735626201 , 0735626200
    Sprache: Englisch
    Seiten: 1 v. (unpaged) , ill.
    Serie: Step by step
    Schlagwort(e): SQL server ; Database management ; Business intelligence ; Electronic books ; local
    Kurzfassung: 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.
    Anmerkung: Title from resource description page. - Includes index
    URL: https://learning.oreilly.com/library/view/-/9780735626201/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 23
    Online-Ressource
    Online-Ressource
    Microsoft SQL server 2008 reporting services : step by step (2009)
    Redmond, Wash. : Microsoft Press | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780735626478 , 0735626472
    Sprache: Englisch
    Seiten: xxiii, 529 p , ill.
    Serie: Step by step
    Schlagwort(e): SQL server ; Client/server computing ; Electronic books ; local
    Kurzfassung: 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.
    Anmerkung: At head of t.p.: Microsoft. - Includes index
    URL: https://learning.oreilly.com/library/view/-/9780735626478/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 24
    Online-Ressource
    Online-Ressource
    Microsoft SQL server 2008 integration services unleashed (2009)
    Indianapolis, Ind. : Sams | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780768687255 , 076868725X
    Sprache: Englisch
    Seiten: xix, 758 p , ill. , 23 cm
    Paralleltitel: Erscheint auch als
    Schlagwort(e): SQL server ; Database management ; Data warehousing ; Electronic books ; local
    Kurzfassung: 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, ...
    Anmerkung: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780768687255/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 25
    Online-Ressource
    Online-Ressource
    Programming Microsoft SQL Server 2008 (2009)
    Redmond, Wash. : Microsoft Press | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780735625990 , 0735625999
    Sprache: Englisch
    Seiten: xxxiii, 979 p , ill. , 23 cm
    Schlagwort(e): SQL server ; Client/server computing ; Electronic books ; local
    Kurzfassung: 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.
    Anmerkung: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780735625990/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 26
    Online-Ressource
    Online-Ressource
    Microsoft SQL server 2008 management and administration (2009)
    Indianapolis, Ind. : Sams | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780768688870 , 0768688876
    Sprache: Englisch
    Seiten: xxv, 880 p , ill. , 21 cm
    Paralleltitel: Erscheint auch als
    Schlagwort(e): SQL server ; Database management ; Electronic books ; local
    Kurzfassung: 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
    Anmerkung: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780768688870/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 27
    Online-Ressource
    Online-Ressource
    SQL server forensic analysis (2009)
    Upper Saddle River, N.J. : Addison-Wesley | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780321533203 , 0321533208
    Sprache: Englisch
    Seiten: xix, 482 p , ill. , 24 cm. +
    Paralleltitel: Erscheint auch als
    Schlagwort(e): SQL server ; Computer crimes ; Investigation ; Electronic books ; local
    Kurzfassung: "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.
    Anmerkung: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780321533203/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 28
    Online-Ressource
    Online-Ressource
    SQL Server 2008 query performance tuning distilled (2009)
    Berkeley, Calif. : Apress | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9781430219026 , 1430219025
    Sprache: Englisch
    Seiten: xxvii, 531 p , ill. , 24 cm
    Serie: Expert's voice in SQL server
    Schlagwort(e): SQL server ; Client/server computing ; Database management ; Electronic books ; local
    Kurzfassung: 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.
    Anmerkung: Includes index
    URL: https://learning.oreilly.com/library/view/-/9781430219026/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 29
    Online-Ressource
    Online-Ressource
    Smart business intelligence solutions with Microsoft SQL Server 2008 (2009)
    Redmond, Wash. : Microsoft Press | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 0735625808 , 9780735625808
    Sprache: Englisch
    Seiten: 1 v. (unpaged) , ill. , 23 cm
    Schlagwort(e): SQL server ; Relational databases ; Client/server computing ; Business intelligence ; OLAP technology ; Electronic books ; local
    Kurzfassung: 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
    Anmerkung: Includes index. - Title from resource description page
    URL: https://learning.oreilly.com/library/view/-/9780735625808/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 30
    Online-Ressource
    Online-Ressource
    Inside Microsoft SQL Server 2008 : T-SQL querying (2009)
    Redmond, Wash. : Microsoft Press | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780735634763 , 0735634769
    Sprache: Englisch
    Seiten: xxiv, 798 p , ill.
    Schlagwort(e): SQL server ; Client/server computing ; Relational databases ; Electronic books ; local
    Kurzfassung: 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
    Anmerkung: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780735634763/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 31
    Online-Ressource
    Online-Ressource
    Microsoft SQL server 2008 internals (2009)
    Redmond, Wash. : Microsoft Press | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780735634787 , 0735634785
    Sprache: Englisch
    Seiten: xxvi, 754 p , ill.
    Schlagwort(e): SQL server ; Database management ; Electronic books ; local
    Kurzfassung: 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
    Anmerkung: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780735634787/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 32
    Online-Ressource
    Online-Ressource
    Microsoft SQL server 2008 MDX : step by step (2009)
    Redmond, Wash. : Microsoft Press | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780735626188 , 0735626189
    Sprache: Englisch
    Seiten: xxiii, 352 p , ill., ports.
    Schlagwort(e): SQL server ; MDX (Computer program language) ; Client/server computing ; Relational databases ; Electronic books ; local
    Kurzfassung: 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
    Anmerkung: At head of t.p.: Microsoft. - Includes index
    URL: https://learning.oreilly.com/library/view/-/9780735626188/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 33
    Online-Ressource
    Online-Ressource
    Microsoft SQL Server 2008 step by step (2009)
    Redmond, Wash. : Microsoft | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780735626041 , 0735626049
    Sprache: Englisch
    Seiten: xxv, 505 p , ill. , 23 cm +
    Schlagwort(e): SQL server ; Relational databases ; Client/server computing ; Electronic books ; local
    Kurzfassung: 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.
    Anmerkung: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780735626041/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 34
    Online-Ressource
    Online-Ressource
    SQL server fundamentals for the accidental DBA (2009)
    [United States?] : Addison-Wesley Professional | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780321601421 , 0321601424
    Sprache: Englisch
    Seiten: 1 streaming video file (6 hr., 10 min., 58 sec.) , digital, sd., col.
    Serie: LiveLessons
    Schlagwort(e): SQL server ; Database management ; Electronic videos ; local
    Kurzfassung: "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.
    Anmerkung: Title from resource description page (viewed Jan. 14, 2009)
    URL: lizenzpflichtig
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 35
    Online-Ressource
    Online-Ressource
    Pro SQL server 2008 relational database design and implementation (2008)
    Berkeley, [Calif.] : Apress | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 143020866X , 9781430208662
    Sprache: Englisch
    Seiten: xxvi, 650 p , ill. , 25 cm
    Serie: Expert's voice in SQL Server
    Schlagwort(e): SQL server ; Client/server computing ; Electronic books ; local
    Kurzfassung: 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
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 36
    Online-Ressource
    Online-Ressource
    Microsoft SQL Server 2008 for dummies (2008)
    Hoboken, N.J. : Wiley | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780470224656 , 0470224657
    Sprache: Englisch
    Seiten: xviii, 383 p , ill. , 24 cm
    Serie: --For dummies
    DDC: 005.7565
    Schlagwort(e): SQL server ; SQL (Computer program language) ; Database management ; Client/server computing ; Electronic books ; local
    Kurzfassung: 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!
    Anmerkung: Title from resource description page (viewed June 1, 2009). - Includes index
    URL: https://learning.oreilly.com/library/view/-/9780470224656/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 37
    Online-Ressource
    Online-Ressource
    Pro T-SQL 2008 : programmer's guide (2008)
    Berkeley, [Calif.] : Apres | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 143021001X , 9781430210016
    Sprache: Englisch
    Seiten: xxviii, p , ill. , 24 cm
    Schlagwort(e): SQL server ; SQL (Computer program language) ; Electronic books ; local
    Kurzfassung: 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
    Anmerkung: Includes index
    URL: https://learning.oreilly.com/library/view/-/9781430210016/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 38
    Online-Ressource
    Online-Ressource
    ADO.NET 3.5 cookbook (2008)
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780596101404 , 0596101406
    Sprache: Englisch
    Seiten: xxii, 955 p , ill. , 24 cm
    Ausgabe: 2nd ed.
    Schlagwort(e): ActiveX ; SQL server ; Database design ; Object-oriented programming (Computer science) ; Microsoft .NET ; Electronic books ; local
    Kurzfassung: 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.
    Anmerkung: 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
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 39
    Online-Ressource
    Online-Ressource
    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
    Sprache: Englisch
    Seiten: xix, 277 p , ill. , 24 cm
    Serie: Addison-Wesley Microsoft technology series
    Schlagwort(e): SQL server ; Database design ; Data structures (Computer science) ; Electronic books ; local
    Kurzfassung: " 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...
    Anmerkung: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780321497642/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 40
    Online-Ressource
    Online-Ressource
    Beginning SQL server 2008 express for developers : from novice to professional (2008)
    Berkeley, Calif. : Apress | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9781430210900 , 1430210907
    Sprache: Englisch
    Seiten: xxiv, 497 p , ill.
    Serie: Expert's voice in SQL server
    Paralleltitel: Erscheint auch als
    Schlagwort(e): SQL server ; Client/server computing ; Database management ; Electronic books ; local
    Kurzfassung: 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
    Anmerkung: Title from resource description page (viewed May 13, 2009). - Includes index
    URL: https://learning.oreilly.com/library/view/-/9781430210900/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 41
    Online-Ressource
    Online-Ressource
    SQL in a nutshell (2008)
    Sebastopol, [Calif.] : O'Reilly Media | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780596155322 , 0596155328
    Sprache: Englisch
    Seiten: [592] p
    Ausgabe: 3rd ed.
    Paralleltitel: Erscheint auch als
    Schlagwort(e): SQL server ; SQL (Computer program language) ; Clinet/server computing ; Electronic books ; local
    Kurzfassung: 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.
    Anmerkung: Title from title screen. - Includes index
    URL: https://learning.oreilly.com/library/view/-/9780596155322/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 42
    Online-Ressource
    Online-Ressource
    Microsoft SQL server 2008 : reporting services (2008)
    [New York] : McGraw-Hill | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780071548083 , 0071548084
    Sprache: Englisch
    Seiten: xxii, 822 p , ill.
    Schlagwort(e): SQL server ; Client/server computing ; Database management ; Electronic books ; local
    Kurzfassung: 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
    Anmerkung: Title from resource description page (viewed Apr. 23, 2009). - Includes index
    URL: https://learning.oreilly.com/library/view/-/9780071548083/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 43
    Online-Ressource
    Online-Ressource
    MCITP SQL server 2005 database administration exam guide (2008)
    New York : McGraw-Hill | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780071496094 , 0071496092
    Sprache: Englisch
    Seiten: xxxvii, 752 p , ill. , 24 cm. +
    Serie: All-in-one
    Paralleltitel: Erscheint auch als
    Schlagwort(e): Electronic data processing personnel ; Certification ; Microsoft software ; Examinations ; Study guides ; Database design ; Examinations ; Study guides ; SQL server ; Database management ; Electronic books ; local
    Kurzfassung: 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
    Anmerkung: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780071496094/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 44
    Online-Ressource
    Online-Ressource
    Pro SQL Server 2008 reporting services (2008)
    Berkeley, [Calif.] : Apress | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9781590599921 , 1590599926
    Sprache: Englisch
    Seiten: xxii, 401 p , ill. , 24 cm
    Schlagwort(e): SQL server ; Database management ; Client/server computing ; Electronic books ; local
    Kurzfassung: 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
    Anmerkung: Includes index
    URL: https://learning.oreilly.com/library/view/-/9781590599921/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 45
    Online-Ressource
    Online-Ressource
    Pro SQL server 2008 XML (2008)
    Berkeley, Calif. : Apress ; | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9781590599839 , 1590599837
    Sprache: Englisch
    Seiten: xxviii, 466 p , ill., maps , 25 cm
    Serie: The expert's voice in SQL server
    Schlagwort(e): SQL server ; XML (Document markup language) ; Client/server computing ; Electronic books ; local
    Kurzfassung: 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
    Anmerkung: Includes index
    URL: https://learning.oreilly.com/library/view/-/9781590599839/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 46
    Online-Ressource
    Online-Ressource
    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
    Sprache: Englisch
    Seiten: iv, 724 p , ill.
    Serie: --For dummies
    Schlagwort(e): SQL server ; Client/server computing ; Relational databases ; Electronic books ; local
    Kurzfassung: 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!
    Anmerkung: Title from resource description page (viewed May 15, 2009). - Includes index
    URL: https://learning.oreilly.com/library/view/-/9780470179543/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 47
    Online-Ressource
    Online-Ressource
    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
    Sprache: Englisch
    Seiten: xxxii, 903 p , ill. , 24 cm. +
    Serie: All-in-one
    Paralleltitel: Erscheint auch als
    Schlagwort(e): Electronic data processing personnel ; Certification ; Database design ; Examinations ; Study guides ; Microsoft software ; Examinations ; Study guides ; SQL server ; Database management ; Electronic books ; local
    Kurzfassung: 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
    Anmerkung: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780071546690/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 48
    Online-Ressource
    Online-Ressource
    MCTS 70-431 : implementing and maintaining Microsoft SQL Server 2005 (2007)
    [Indianapolis, Ind.] : Que Pub. | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 0789735881
    Sprache: Englisch
    Seiten: ix, 337 p , ill.
    Schlagwort(e): SQL server ; Electronic data processing personnel ; Certification ; Microsoft software ; Examinations ; Study guides ; Database design ; Examinations ; Study guides ; Electronic books ; local
    Kurzfassung: 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
    Anmerkung: Includes bibliographical references (p. [293]-298) and index
    URL: https://learning.oreilly.com/library/view/-/0789735881/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 49
    Online-Ressource
    Online-Ressource
    Best damn Exchange, SQL and IIS book period (2007)
    Burlington, Mass. : Syngress | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9781597492195 , 1597492191
    Sprache: Englisch
    Seiten: xxxiii, 1189 p , ill. , 24 cm
    DDC: 005.71376
    Schlagwort(e): Microsoft Internet information server ; SQL server ; Microsoft Exchange server ; Client/server computing ; Electronic books ; local ; Electronic books
    Kurzfassung: 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
    Anmerkung: Includes index
    URL: lizenzpflichtig
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 50
    Online-Ressource
    Online-Ressource
    Foundations of SQL Server 2005 business intelligence (2007)
    Berkeley, [Calif.] : Apress | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 1590598342 , 9781590598344
    Sprache: Englisch
    Seiten: xvii, 396 p , ill. , 23 cm
    Serie: Expert's voice in SQL server
    Schlagwort(e): SQL server ; Relational databases ; Client/server computing ; Business intelligence ; OLAP technology ; Electronic books ; local
    Kurzfassung: 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.
    Anmerkung: Includes index
    URL: https://learning.oreilly.com/library/view/-/9781590598344/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 51
    Online-Ressource
    Online-Ressource
    Hands-on Microsoft SQL server 2005 integration services (2007)
    New York : McGraw-Hill | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780072263190 , 0072263199
    Sprache: Englisch
    Seiten: xix, 570 p , ill. , 24 cm
    Schlagwort(e): SQL server ; Database management ; Electronic books ; local
    Kurzfassung: 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.
    Anmerkung: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780072263190/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 52
    Online-Ressource
    Online-Ressource
    Expert SQL server 2005 development (2007)
    Berkeley, [Calif.] : Apress | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 159059729X , 9781590597293
    Sprache: Englisch
    Seiten: xx, 449 p , ill. , 23 cm
    Serie: Expert's voice in SQL server programming
    Schlagwort(e): SQL server ; Client/server computing ; Electronic books ; local
    Kurzfassung: 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.
    Anmerkung: Includes index
    URL: https://learning.oreilly.com/library/view/-/9781590597293/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 53
    Online-Ressource
    Online-Ressource
    Administrator's guide to SQL server 2005 (2006)
    Upper Saddle River, NJ : Addison-Wesley | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 0321397975
    Sprache: Englisch
    Seiten: xviii, 626 p , ill.
    Schlagwort(e): SQL server ; Client/server computing ; Electronic books ; local
    Kurzfassung: "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...
    Anmerkung: Includes index
    URL: https://learning.oreilly.com/library/view/-/0321397975/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 54
    Online-Ressource
    Online-Ressource
    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
    Sprache: Englisch
    Seiten: xliii, 714 p , ill.
    Schlagwort(e): SQL server ; Data warehousing ; Electronic books ; local
    Kurzfassung: 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...
    Anmerkung: Title from resource description page (viewed Apr. 27, 2009). - Includes index
    URL: https://learning.oreilly.com/library/view/-/9780471267157/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 55
    Online-Ressource
    Online-Ressource
    Sams teach yourself Microsoft SQL Server 2005 Express in 24 hours (2006)
    [Indianapolis, Ind.] : Sams Pub. | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 0672327414
    Sprache: Englisch
    Seiten: 436 p , ill. +
    Schlagwort(e): SQL server ; Relational databases ; Client/server computing ; Electronic books ; local
    Kurzfassung: 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.
    Anmerkung: Includes index
    URL: https://learning.oreilly.com/library/view/-/0672327414/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 56
    Online-Ressource
    Online-Ressource
    A developer's guide to SQL server 2005 (2006)
    Upper Saddle River, NJ : Addison-Wesley | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 0321382188
    Sprache: Englisch
    Seiten: lvii, 997 p , ill.
    Schlagwort(e): SQL server ; Client/server computing ; Relational databases ; Electronic books ; local
    Kurzfassung: "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...
    Anmerkung: Includes bibliographical references (p. 963-964) and index
    URL: https://learning.oreilly.com/library/view/-/0321382188/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 57
    Online-Ressource
    Online-Ressource
    Microsoft SQL server 2005 : applied techniques (2006)
    Redmond, Wash. : Microsoft Press | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 0735623163 , 9780735623163
    Sprache: Englisch
    Serie: Step by step
    Schlagwort(e): SQL server ; Client/server computing ; Relational databases ; Electronic books ; local
    Kurzfassung: 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.
    Anmerkung: Title from title screen. - "Authors, Herbert Albert ... [et al.]"--Acknowledgments. - Includes bibliographical references and index
    URL: https://learning.oreilly.com/library/view/-/0735623163/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 58
    Online-Ressource
    Online-Ressource
    Microsoft SQL server 2005 : reporting services (2005)
    [New York] : McGraw-Hill | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780072262391 , 0072262397
    Sprache: Englisch
    Seiten: xvi, 736 p , ill.
    Schlagwort(e): SQL server ; Client/server computing ; Database management ; Electronic books ; local
    Kurzfassung: 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.
    Anmerkung: Title from resource description page (viewed Apr. 23, 2009). - Includes index
    URL: https://learning.oreilly.com/library/view/-/9780072262391/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
  • 59
    Online-Ressource
    Online-Ressource
    Microsoft SQL Server 2005 administrator's pocket consultant (2005)
    Redmond, Wash. : Microsoft Press | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 0735621071 , 9780735621077
    Sprache: Englisch
    Schlagwort(e): SQL server ; Client/server computing ; Relational databases ; Electronic books ; local
    Kurzfassung: 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!
    Anmerkung: Title from title screen. - Includes bibliographical references and index
    URL: https://learning.oreilly.com/library/view/-/0735621071/?ar
    Bibliothek Standort Signatur Band/Heft/Jahr Verfügbarkeit
    BibTip Andere fanden auch interessant ...
    Online-Ressource
    MPI Ethno. Forsch.
Schließen ⊗
Diese Webseite nutzt Cookies und das Analyse-Tool Matomo. Weitere Informationen finden Sie hier...