All the mistakes you might make with SQL Serverand how to avoid them!100 SQL Server Mistakes and How To Avoid Them primes you on the pitfalls database professionals often fall intofrom administration to development, availabili...Lasīt vairāk
Dive into DuckDB and start processing gigabytes of data with easeall with no data warehouse.You dont 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...Lasīt vairāk
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...Lasīt vairāk
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...Lasīt vairāk
The latest edition of Murachs 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...Lasīt vairāk
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...Lasīt vairāk
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...Lasīt vairāk
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...Lasīt vairāk
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...Lasīt vairāk
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...Lasīt vairāk
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...Lasīt vairāk
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...Lasīt vairāk
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...Lasīt vairāk
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...Lasīt vairāk
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...Lasīt vairāk
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...Lasīt vairāk
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...Lasīt vairāk
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....Lasīt vairāk
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...Lasīt vairāk
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....Lasīt vairāk
