talk-data.com
Activities & events
| Title & Speakers | Event |
|---|---|
|
Advanced Techniques in SQL Server Performance & Optimization
2024-09-12 · 16:00
Advanced Techniques in SQL Server Performance & OptimizationDescriptionJoin this session to explore advanced techniques for optimizing SQL Server performance. Learn how to fine-tune queries, utilize indexing strategies effectively, and optimize database schema designs for maximum efficiency. Discover insights into query execution plans and performance monitoring tools to identify and resolve bottlenecks. Gain practical tips on memory management, caching strategies, and best practices for maintaining high-performance databases. Whether you're managing large-scale data or enhancing application responsiveness, this session equips you with essential skills to elevate SQL Server performance and optimize database operations. Register for Future Data Driven Summit 2024 |
Advanced Techniques in SQL Server Performance & Optimization
|
|
Alberto Ferrari
– author
,
Marco Russo
– author
Now expanded and updated with modern best practices, this is the most complete guide to Microsoft's DAX language for business intelligence, data modeling, and analytics. Expert Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization. You'll learn exactly what happens under the hood when you run a DAX expression, and use this knowledge to write fast, robust code. This edition focuses on examples you can build and run with the free Power BI Desktop, and helps you make the most of the powerful syntax of variables (VAR) in Power BI, Excel, or Analysis Services. Want to leverage all of DAX's remarkable capabilities? This no-compromise "deep dive" is exactly what you need. Related Content Video: Introduction to Microsoft Power BI (Video), Data Analysis Fundamentals with Excel (Video) Perform powerful data analysis with DAX for Power BI, SQL Server, and Excel · Master core DAX concepts, including calculated columns, measures, and calculation groups · Work efficiently with basic and advanced table functions · Understand evaluation contexts and the CALCULATE and CALCULATETABLE functions · Perform time-based calculations · Use calculation groups and calculation items · Use syntax of variables (VAR) to write more readable, maintainable code · Express diverse and unusual relationships with DAX, including many-to-many relationships and bidirectional filters · Master advanced optimization techniques, and improve performance in aggregations · Optimize data models to achieve better compression · Measure DAX query performance with DAX Studio and learn how to optimize your DAX |
O'Reilly SQL Books
|
|
Ahmad Osama
– author
Professional Azure SQL Database Administration serves as your comprehensive guide to mastering the management and optimization of cloud-based Azure SQL Database solutions. With the differences and unique features of Azure SQL Database compared to the on-premise SQL Server, this book offers a clear roadmap to efficiently migrate, secure, scale, and maintain these databases in the cloud. What this Book will help me do Understand the differences between Azure SQL Database and on-premise SQL Server and their practical implications. Learn techniques to migrate existing SQL Server databases to Azure SQL Database seamlessly. Discover advanced ways to optimize database performance and scalability leveraging cloud capabilities. Master security strategies for Azure SQL databases, including backup, disaster recovery, and automated tasks. Develop proficiency in using tools such as PowerShell to automate and manage routine database administration tasks. Author(s) Ahmad Osama is an experienced database professional and author specializing in SQL Server and Azure SQL Database administration. With a robust background in database migration, maintenance, and performance tuning, Ahmad expertly bridges the gap between theory and practice. His approachable writing style makes complex database topics accessible to professionals seeking to expand their expertise. Who is it for? Professional Azure SQL Database Administration is an essential resource for database administrators, developers, and IT professionals keen on developing their knowledge about Azure SQL Database administration and cloud database solutions. Whether you're transitioning from traditional SQL Server environments or looking to optimize your database strategies in the cloud, this book caters to professionals with intermediate to advanced experience in database management and programming with SQL. |
|
|
Learn T-SQL Querying
2019-05-03
Pam Lahoud
– author
,
Pedro Lopes
– author
Dive into the world of T-SQL with 'Learn T-SQL Querying,' a book designed to enhance your database querying skills and help you master Microsoft's SQL Server and Azure SQL Database. Through this guide, you'll explore best practices, learn advanced techniques for analyzing execution plans, and create efficient T-SQL queries. What this Book will help me do Understand the fundamentals of query optimization to write performant T-SQL queries. Analyze query execution plans to identify and troubleshoot performance issues effectively. Utilize dynamic management views and functions to monitor and optimize query performance. Implement features like Query Store to streamline troubleshooting and maintain performance changes. Avoid common T-SQL anti-patterns and embrace best practices to ensure scalable query design. Author(s) Pedro Lopes and None Lahoud bring years of expertise in SQL Server and database systems. Pedro has extensive experience as a database engineer, where he specializes in query processing and optimization. None has a deep understanding of T-SQL development, focusing on practical solutions. Together, they provide in-depth insights and actionable advice. Who is it for? This book is perfect for database administrators, database developers, and data analysts at any level looking to improve their T-SQL expertise. Beginners will gain foundational skills in T-SQL querying, while experienced professionals will find advanced strategies for optimizing SQL Server performance. Readers aiming to master both practical querying and troubleshooting will benefit the most. |
|
|
Ahmad Osama
– author
Learn everything you need to manage Azure SQL Database with 'Professional Azure SQL Database Administration'. This book covers critical tasks such as migration, performance optimization, security, and disaster recovery. Perfect for those transitioning to the cloud, it equips you with skills to ensure your database runs smoothly and efficiently. What this Book will help me do Effectively migrate on-premise SQL Server databases to Azure. Master backup, restore, and security operations with Azure SQL Database. Optimize performance and scalability using monitoring and tuning techniques. Implement high availability and disaster recovery strategies. Simplify database management through automation and advanced techniques. Author(s) Ahmad Osama is a seasoned database admin and Azure expert with extensive experience in SQL Server and cloud database management. As a consultant and trainer, he has guided numerous organizations through cloud transitions. Ahmad's teaching philosophy blends practical insights with clear instruction. Who is it for? This book is intended for database administrators and developers looking to transition their skills to Azure SQL Database. If you have some experience with on-premise SQL Server and are familiar with PowerShell, you'll find this guide invaluable. Ideal for those wanting to develop, migrate, or manage Azure SQL solutions. |
|
|
Conquer SQL Server 2017 administration—from the inside out Dive into SQL Server 2017 administration—and really put your SQL Server DBA expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds—all you need to plan, implement, manage, and secure SQL Server 2017 in any production environment: on-premises, cloud, or hybrid. Four SQL Server experts offer a complete tour of DBA capabilities available in SQL Server 2017 Database Engine, SQL Server Data Tools, SQL Server Management Studio, and via PowerShell. Discover how experts tackle today’s essential tasks—and challenge yourself to new levels of mastery. • Install, customize, and use SQL Server 2017’s key administration and development tools • Manage memory, storage, clustering, virtualization, and other components • Architect and implement database infrastructure, including IaaS, Azure SQL, and hybrid cloud configurations • Provision SQL Server and Azure SQL databases • Secure SQL Server via encryption, row-level security, and data masking • Safeguard Azure SQL databases using platform threat protection, firewalling, and auditing • Establish SQL Server IaaS network security groups and user-defined routes • Administer SQL Server user security and permissions • Efficiently design tables using keys, data types, columns, partitioning, and views • Utilize BLOBs and external, temporal, and memory-optimized tables • Master powerful optimization techniques involving concurrency, indexing, parallelism, and execution plans • Plan, deploy, and perform disaster recovery in traditional, cloud, and hybrid environments For Experienced SQL Server Administrators and Other Database Professionals • Your role: Intermediate-to-advanced level SQL Server database administrator, architect, developer, or performance tuning expert • Prerequisites: Basic understanding of database administration procedures |
|
|
Includes Coverage of Oracle and Microsoft SQL Implementations In just 24 lessons of one hour or less, Sams Teach Yourself SQL in 24 Hours, Sixth Edition, helps you use SQL to build effective databases, efficiently retrieve data, and manage everything from performance to security. This book’s straightforward, step-by-step approach shows you how to work with database structures, objects, queries, tables, and more. In just hours, you will be applying advanced techniques, including views, transactions, web connections, and powerful Oracle and SQL Server extensions. Every lesson builds on what you’ve already learned, giving you a rock-solid foundation for real-world success. Step-by-step instructions carefully walk you through the most common SQL tasks. Practical, hands-on examples show you how to apply what you learn. Quizzes and exercises help you test your knowledge and stretch your skills. Notes and tips point out shortcuts and solutions. Learn how to… • Define efficient database structures and objects • “Normalize” raw databases into logically organized tables • Edit relational data and tables with DML • Manage transactions • Write effective, well-performing queries • Categorize, summarize, sort, group, and restructure data • Work with dates and times • Join tables in queries, use subqueries, and combine multiple queries • Master powerful query optimization techniques • Administer databases and manage users • Secure databases and protect data • Use views, synonyms, and the system catalog • Extend SQL to the enterprise and Internet • Master important Oracle and Microsoft extensions to ANSI SQL Register your product at informit.com/register for convenient access to downloads, updates, and corrections as they become available. |
O'Reilly SQL Books
|
|
Delve into the concepts and practices of PostgreSQL server-side programming with this practical and insightful guide. Learn how to extend PostgreSQL functionality through user-defined functions, various procedural languages, and effective debugging techniques. Gain a deeper understanding of PostgreSQL 9.4's features to optimize your database's capabilities. What this Book will help me do Master PostgreSQL's PL/pgSQL and other procedural languages for server-side programming. Craft powerful user-defined functions to provide database functionality specific to your needs. Explore debugging techniques and tools, including PL/pgSQL debugging extensions and NOTIFY. Scale and optimize databases effectively using tools like PL/Proxy. Leverage new features in PostgreSQL 9.4, such as event triggers, to enhance database performance. Author(s) The book is authored by experienced PostgreSQL professionals None Dar, None Krosing, and Jim Mlodgenski. Together, they bring years of expertise in database design, architecture, and development. Their combined backgrounds ensure a comprehensive and practical learning experience for readers. They aim to share practical insights and structured knowledge for database enthusiasts. Who is it for? This book is ideal for database professionals with a moderate to advanced understanding of PostgreSQL. Readers should have experience with SQL, query optimization concepts, and basic programming in languages like Python, Perl, or C. If you are aiming to enhance your knowledge of PostgreSQL in-depth capabilities and get hands-on with advanced features such as server programming and database scale optimization, this book is suitable for you. |
|
|
SQL Server 2014 Development Essentials
2014-07-25
Basit A. Masood-Al-Farooq
– author
This book is your ultimate guide to mastering database development using Microsoft SQL Server 2014. By diving into this hands-on resource, you will explore the essentials of database design, implementation, and deployment to create robust solutions that meet modern enterprise needs. What this Book will help me do Gain a deep understanding of SQL Server 2014's new features and enhancements. Master database design principles for scalable and efficient solutions. Develop and optimize SQL queries for robust data retrieval and manipulation. Understand advanced database object topics and effective error handling. Learn performance optimization techniques for maintaining database efficiency. Author(s) None A. Masood-Al-Farooq is a seasoned database professional with extensive experience in SQL Server development and administration. They have worked on numerous critical projects in enterprise data management and have a practical, results-driven approach to database solutions. As an author, they focus on equipping readers with actionable insights and techniques through clear explanations and real-world examples. Who is it for? This book is ideal for database developers, administrators, and architects who work with Microsoft SQL Server and wish to expand their expertise in its 2014 version. Beginners to intermediate-level professionals will find it accessible and straightforward, while advanced users can discover new features and optimizations. It caters to anyone looking to design or optimize database solutions effectively. Whether you manage databases or are diving into database software development, this book will enhance your SQL Server 2014 skills. |
|
|
Pro SQL Server 2008 Administration
2009-08-27
Ken Simmons
– author
,
Sylvester Carstarphen
– author
Pro SQL Server 2008 Administration is critical for database administrators seeking in-depth knowledge on administering SQL Server 2008. This book covers the impact of the new features available in SQL Server 2008 specifically targeted for database administrators, along with the tried-and-true advanced techniques required to support and maintain Microsoft SQL Server. Introduces new administration features of SQL Server 2008 Shows how to manage a SQL Server 2008 database at professional level Provides guidance on performance optimization |
|
|
Susan Lawson
– author
,
Richard Yevich
– author
IBM's definitive, authoritative DB2 for OS/390 and z/OS reference and self-study guide! The only comprehensive IBM(r) DB2 UDB V7.1 for OS/390 certification prep guide Covers administration, security, SQL, application development, tuning, and much more Contains dozens of expert DB2 tips, techniques and guidelines CD-ROM contains complete DB2 for OS/390 sample exam Written by IBM Gold Consultants for DB2 and S/390 The total resource for every professional running DB2 UDB V7.1 in OS/390 and z/OS environments Database administration, security, monitoring, tuning, SQL, and application development Sample test questions help you prepare for IBM's new DB2 UDB V7.1 for OS/390 exams The CD-ROM included with this book contains a complete IBM DB2 for OS/390 certification sample exam. IBM's DB2 Universal Database Version 7.1 for OS/390 delivers unparalleled performance, scalability, and reliability in today's enterprise e-business environments! Now, there's a complete, authoritative guide to deploying, managing, and developing applications with DB2 UDB V7.1 in both OS/390 and z/OS environments—and preparing for IBM's updated DB2 UDB V7.1 for OS/390 certification exam! Direct from IBM, this comprehensive day-to-day reference for running DB2 UDB in OS/390 and z/OS environments is also the only book with the in-depth knowledge professionals need in order to pass IBM's latest DB2 for OS/390DBA certification exam. Full of expert tips, techniques, and guidelines, it covers virtually every aspect of working with DB2 UDB in enterprise server: administration, connectivity, development, and much more. IBM Gold Consultants Richard Yevich and Susan Lawson present start-to-finish coverage of DB2's latest and most powerful enhancements, tools, and utilities, showing how to make the most of DB2 running on both OS/390 and next-generation z/OS platforms. Coverage includes: An overview of the DB2 UDB product family DB2 in OS/390 and z/OS environments: address spaces, attachments, interfaces, commands, and utilities Comprehensive security coverage, including access controls and auditing techniques SQL in depth: DB2 data structures, database objects, basic database design, and advanced coding DB2 UDB administration: maintaining data, backup/recovery, and more Performance monitoring and optimization: access paths, indexes, parallelism, buffer pool tuning, and subsystem tuning Data sharing: architecture and implementation in a Parallel Sysplex environment Detailed application development coverage: database extenders, cursors, stored procedures, triggers, object-relational extensions, locking, and concurrency Whether you're deploying DB2 UDB V7.1 in an OS/390 environment, managing DB2 UDB V7.1, preparing for DB2 UDB V7.1 certification, or all three, DB2 Universal Database Version 7.1 for OS/390 Certification Guide will be your single most valuable resource. |
|