All the mistakes you might make with SQL Server—and how to avoid them!100 SQL Server Mistakes and How To Avoid Them primes you on the pitfalls database professionals often fall into—from administration to development, availabili...Loe edasi...
Dive into DuckDB and start processing gigabytes of data with ease—all with no data warehouse.You don’t need expensive hardware or to spin up a whole new cluster whenever you want to analyze a big data set. You just need DuckDB! This mo...Loe edasi...
Using Test-Driven Development (TDD), thousands of agile developers are delivering software that is more rigorously tested, better designed, more robust, and easier to maintain. Until recently, however, database developers have b...Loe edasi...
Learn the basics of writing SQL scripts. Using Standard SQL as the starting point, this book teaches writing SQL in various popular dialects, including PostgreSQL, MySQL/MariaDB, Microsoft SQL Server, Oracle, and SQLite.The book st...Loe edasi...
The latest edition of Murach’s classic SQL Server book does a better job than ever of teaching the SQL statements that every database developer should know. Each chapter features clear examples, easy-to-understand explanations, best practices, and he...Loe edasi...
Intermediate-Advanced user level Use the graph table features in Azure SQL that were introduced in SQL Server 2017 and further refined in SQL Server 2019. This book shows you how to create data structures to capture complex connecti...Loe edasi...
Use this practical guide to analyze and troubleshoot SQL Server performance using wait statistics. Youll learn to identify precisely why your queries are running slowly. And youll know how to measure the amount of time consumed by each bottlenec...Loe edasi...
SQL is the ubiquitous language for software developers working with structured data. Most developers who rely on SQL are experts in their favorite language (such as Java, Python, or Go), but theyre not experts in SQL. They often depend on antipat...Loe edasi...
Run Windows nodes and seamlessly deploy .NET applications on a Kubernetes cluster.Kubernetes on Windows reveals how to operate Windows applications in Kubernetes. It teaches you how to create your own Windows-enabled Kubernetes...Loe edasi...
A Comprehensive Study of SQL - Practice and Implementation is designed as a textbook and provides a comprehensive approach to SQL (Structured Query Language), the standard programming language for defining, organizing, and exploring data in relati...Loe edasi...
Get your daily work done efficiently using this comprehensive guide for SQL Server DBAs that covers all that a practicing database administrator needs to know. Updated for SQL Server 2022, this edition includes coverage of new features, suc...Loe edasi...
This book is intended primarily for those who plan to become data scientists as wellas anyone who needs to perform data cleaning tasks. It contains a variety of features of NumPy and Pandas and how to create databases and tables in MySQL. Chapter 7 c...Loe edasi...
This in-depth look at the encryption tools available in SQL Server shows you how to protect data by encrypting it at rest with Transparent Data Encryption (TDE) and in transit with Transport Level Security (TLS). You will know how to add the...Loe edasi...
Troubleshoot slow-performing queries and make them run faster. Database administrators and SQL developers are constantly under pressure to provide more speed. This new edition has been redesigned and rewritten from scratch ba...Loe edasi...
Know how to use the new capabilities and cloud integrations in SQL Server 2022. This book covers the many innovative integrations with the Azure Cloud that make SQL Server 2022 the most cloud-connected edition ever. The book covers cutting-edge...Loe edasi...
Supercharging Node.js Applications with Sequelize will provide developers with the necessary knowledge needed for interacting with an SQL database and a Node.js application using the Sequelize library. This library will help make the production of y...Loe edasi...
Business Intelligence with Databricks SQL Analytics is a critically timed book for BI and data warehouse practitioners who want to get up to speed with the details and implications of adopting the Databricks Lakehouse Platform. The book will help yo...Loe edasi...
This book provides a one-stop solution for diving deep into data analytics with SQL. Youll also understand how to extract business insights from huge unorganized data....Loe edasi...
Learn dbatools in a Month of Lunches is a practical hands-on guide to automating SQL Server with PowerShell and the awesome dbatools module.An effective DBA is an efficient DBA. And if you work with SQL Server, dbatools is a lif...Loe edasi...
This book helps you get up to speed with both query engine internals and practical query optimization. As you progress, youll explore ready-to-use techniques for creating high-performance queries and applications....Loe edasi...
