ISBN
9781788833080
Leverage Splunk's operational intelligence capabilities to unlock new hidden business insights and drive success :
This book is intended for data professionals who are looking to leverage the Splunk Enterprise platform as a valuable operational intelligence tool. The recipes provided in this book will appeal to individuals from all facets of business, IT, security, product, marketing, and many more! Even the existing users of Splunk who want to upgrade and get up and running with Splunk 7.x will find this book to be of great value.
Author/Authors: Diakun, Josh | Johnson, Paul R
Pages: 541 | Published Date: 43248
Category: Data
ISBN
9781785283611
Over 150 real-world recipes to simplify database management, automate repetitive tasks, and enhance your productivity :
Over 150 real-world recipes to simplify database management, automate repetitive tasks, and enhance your productivity About This Book • This book helps you build a strong foundation to get you comfortable using PowerShell with SQL Server, empowering you to create more complex scripts for your day-to-day job • The book provides numerous guidelines, tips, and explanations on how and when to use PowerShell cmdlets, WMI, SMO, .NET classes, or other components • It offers easy-to-follow, practical recipes to help you get the most out of SQL Server and PowerShell Who This Book Is For If you are a SQL Server database professional (DBA, developer, or BI developer) who wants to use PowerShell to automate, integrate, and simplify database tasks, this books is for you. Prior knowledge of scripting would be helpful, but it is not necessary. What You Will Learn • Explore database objects and execute queries on multiple servers • Manage and monitor the running of SQL Server services and accounts • Back up and restore databases • Create an inventory of database properties and server configuration settings • Maintain permissions and security for users • Work with CLR assemblies, XML, and BLOB objects in SQL • Manage and deploy SSIS packages and SSRS reports In Detail PowerShell can be leveraged when automating and streamlining SQL Server tasks. PowerShell comes with a rich set of cmdlets, and integrates tightly with the .NET framework. Its scripting capabilities are robust and flexible, allowing you to simplify automation and integration across different Microsoft applications and components. The book starts with an introduction to the new features in SQL Server 2014 and PowerShell v5 and the installation of SQL Server. You will learn about basic SQL Server administration tasks and then get to know about some security-related topics such as the authentication mode and assigning permissions. Moving on, you will explore different methods to back up and restore your databases and perform advanced administration tasks such as working with Policies, Filetables, and SQL audits. The next part of the book covers more advanced HADR tasks such as log shipping and data mirroring, and then shows you how to develop your server to work with BLOB, XML, and JSON. Following on from that, you will learn about SQL Server's BI stack, which includes SSRS reports, the SSIS package, and the SSAS cmdlet and database. Snippets not specific to SQL Server will help you perform tasks quickly on SQL servers. Towards the end of the book, you will find some useful information, which includes a PowerShell tutorial for novice users, some commonly-used PowerShell and SQL Server syntax, and a few online resources. Finally, you will create your own SQL Server Sandbox VMs. All these concepts will help you to efficiently manage your administration tasks. Style and approach SQL Server 2014 with PowerShell v5 Cookbook is an example-focused book that provides step-by-step instructions on how to accomplish specific SQL Server tasks using PowerShell. Each recipe is followed by an analysis of the steps or design decisions taken and additional information about the task at hand. Working scripts are provided for all examples so that you can dive in right away. You can read this book sequentially by chapter or you can pick and choose which topics you need right away.
Author/Authors: Santos, Donabel
Pages: 760 | Published Date: 42342
Category: Data
ISBN
9781786460745
Get the most out of the rich development capabilities of SQL Server 2016 to build efficient database applications for your organization :
This book is for database developers and solution architects who plan to use the new SQL Server 2016 features for developing efficient database applications. It is also ideal for experienced SQL Server developers who want to switch to SQL Server 2016 for its rich development capabilities. Some understanding of the basic database concepts and Transact-SQL language is assumed.
Author/Authors: Sarka, Dejan | Radivojević, Miloš | Durkin, William
Pages: 616 | Published Date: 42816
Category: Data
ISBN
9781787280922
Data exploration, modeling, and advanced analytics :
R Services was one of the most anticipated features in SQL Server 2016, improved significantly and rebranded as SQL Server 2017 Machine Learning Services. Prior to SQL Server 2016, many developers and data scientists were already using R to connect to SQL Server in siloed environments that left a lot to be desired, in order to do additional data analysis, superseding SSAS Data Mining or additional CLR programming functions. With R integrated within SQL Server 2017, these developers and data scientists can now benefit from its integrated, effective, efficient, and more streamlined analytics environment. This book gives you foundational knowledge and insights to help you understand SQL Server 2017 Machine Learning Services with R. First and foremost, the book provides practical examples on how to implement, use, and understand SQL Server and R integration in corporate environments, and also provides explanations and underlying motivations. It covers installing Machine Learning Services;maintaining, deploying, and managing code;and monitoring your services. Delving more deeply into predictive modeling and the RevoScaleR package, this book also provides insights into operationalizing code and exploring and visualizing data. To complete the journey, this book covers the new features in SQL Server 2017 and how they are compatible with R, amplifying their combined power.
Author/Authors: Kaštrun, Tomaž | Koesmarno, Julie
Pages: 338 | Published Date: 43158
Category: Data
ISBN
9781786467997
Create interactive cross-platform reports and dashboards using SQL Server 2016 Reporting Services :
This book is for software professionals who develop and implement reporting solutions using Microsoft SQL Server. It is especially relevant for professionals who are software engineers, software architects, DW/BI engineers, and DW/BI architects who perform simple to complex report authoring implementations. This book is also suitable for those who develop software solutions that integrate reporting solutions and are keen to learn about Microsoft SQL Server 2016’s features and capabilities.
Author/Authors: Priyankara, Dinesh | Cain, Robert C.
Pages: 596 | Published Date: 42703
Category: Data
ISBN
9781786467324
One stop solution for DBAs to monitor, manage, and maintain enterprise databases :
Take advantage of the real power of SQL Server 2017 with all its new features, in addition to covering core database administration tasks. This book will give you a competitive advantage by helping you quickly learn how to design, manage, and secure your database solution. You will learn how to set up your SQL Server and configure new (and existing) environments for optimal use. After covering the designing aspect, the book delves into performance-tuning aspects by teaching you how to effectively use indexes. The book will also teach you about certain choices that need to be made about backups and how to implement a rock-solid security policy and keep your environment healthy. Finally, you will learn about the techniques you should use when things go wrong, and other important topics - such as migration, upgrading, and consolidation - are covered in detail. Integration with Azure is also covered in depth. Whether you are an administrator or thinking about entering the field, this book will provide you with all the skills you need to successfully create, design, and deploy databases using SQL Server 2017.
Author/Authors: Chmel, Marek | Mužný, VladimÃÂr
Pages: 434 | Published Date: 43081
Category: Data
ISBN
9781788479936
A professional guide to designing and developing enterprise database applications :
Microsoft SQL Server 2017 is the next big step in the data platform history of Microsoft as it brings in the power of R and Python for machine learning and containerization-based deployment on Windows and Linux. Compared to its predecessor, SQL Server 2017 has evolved into Machine Learning with R services for statistical analysis and Python packages for analytical processing. This book prepares you for more advanced topics by starting with a quick introduction to SQL Server 2017’s new features and a recapitulation of the possibilities you may have already explored with previous versions of SQL Server. The next part introduces you to enhancements in the Transact-SQL language and new database engine capabilities and then switches to a completely new technology inside SQL Server: JSON support. We also take a look at the Stretch database, security enhancements, and temporal tables. Furthermore, the book focuses on implementing advanced topics, including Query Store, columnstore indexes, and In-Memory OLTP. Towards the end of the book, you’ll be introduced to R and how to use the R language with Transact-SQL for data exploration and analysis. You’ll also learn to integrate Python code in SQL Server and graph database implementations along with deployment options on Linux and SQL Server in containers for development and testing. By the end of this book, you will have the required information to design efficient, high-performance database applications without any hassle.
Author/Authors: Sarka, Dejan | Radivojevic, Miloš | Durkin, William
Pages: 816 | Published Date: 43175
Category: Data
ISBN
9781786460875
Harness the power of SQL Server 2017 Integration Services to build your data integration solutions with ease :
This book is ideal for software engineers, DW/ETL architects, and ETL developers who need to create a new, or enhance an existing, ETL implementation with SQL Server 2017 Integration Services. This book would also be good for individuals who develop ETL solutions that use SSIS and are keen to learn the new features and capabilities in SSIS 2017.
Author/Authors: Cote, Christian | Lah, Matija | Sarka, Dejan
Pages: 558 | Published Date: 42916
Category: Data
ISBN
9781849689816
More than 100 recipes to develop Business Intelligence solutions using Analysis Services :
A practical cookbook packed with recipes to help developers produce data cubes as quickly as possible by following step by step instructions, rather than explaining data mining concepts with SSAS.If you are a BI or ETL developer using SQL Server Analysis services to build OLAP cubes, this book is ideal for you. Prior knowledge of relational databases and experience with Excel as well as SQL development is required.
Author/Authors: Dewald, Baya | Hughes, Steve | Turley, Paul
Pages: 340 | Published Date: 41634
Category: Data
ISBN
9781788294720
Bring the performance and security of SQL Server to Linux :
This book is for the Linux users who want to learn SQL Server on their favorite Linux distributions. It is not important if you are experienced database user or a beginner as we are starting from scratch. However, it is recommended that you have basic knowledge about relational models. More advanced readers can pick the chapters of their interest and study specific topics immediately. Users from Windows platform can also benefit from this book to expand their frontiers and become equally efficient on both platforms.
Author/Authors: Azemović, Jasmin
Pages: 222 | Published Date: 42961
Category: Data
ISBN
9781783001439
Practical guidance on how to turn your passion, idea, and technical skills into a successful business :
If your find yourself daydreaming about your own business and not just your next promotion, this book will help you shape your ideas as you begin your enrepreneurial journey.
Author/Authors: Zwilling, Martin
Pages: 236 | Published Date: 41974
Category: Business & Other
ISBN
9781849512091
Take control of your data and produce superior statistical analysis with R. :
This is a practical, step by step guide that will help you to quickly become proficient in the data analysis using R. The book is packed with clear examples, screenshots, and code to carry on your data analysis without any hurdle. If you are a data analyst, business or information technology professional, student, educator, researcher, or anyone else who wants to learn to analyze the data effectively then this book is for you. No prior experience with R is necessary. Knowledge of other programming languages, software packages, or statistics may be helpful, but is not required.
Author/Authors: Quick, John M.
Pages: 300 | Published Date: 40477
Category: Data
ISBN
9781788622264
Software Implementation Illustrated with R and Python :
If you want to have a brief understanding of the nature of data and perform advanced statistical analysis using both R and Python, then this book is what you need. No prior knowledge is required. Aspiring data scientist, R users trying to learn Python and vice versa
Author/Authors: Tattar, Prabhanjan Narayanachar
Pages: 432 | Published Date: 42978
Category: Data
ISBN
9781788295345
Get your statistics basics right before diving into the world of data science :
This book is intended for those developers who are willing to enter the field of data science and are looking for concise information of statistics with the help of insightful programs and simple explanation. Some basic hands on R will be useful.
Author/Authors: Miller, James D.
Pages: 286 | Published Date: 43056
Category: Data
ISBN
9781788291224
Build Machine Learning models with a sound statistical understanding. :
This book is intended for developers with little to no background in statistics, who want to implement Machine Learning in their systems. Some programming knowledge in R or Python will be useful.
Author/Authors: Dangeti, Pratap
Pages: 442 | Published Date: 42937
Category: Data
