Hands-on Azure Data Studio
Hands-on Azure Data Studio
About the Book
This book introduces Microsoft Azure Data Studio and shows how anyone working with data -- Database Developers, Data Analysts, Data Scientists, Database Administrators, and Software Developers -- can use Azure Data Studio to dramatically streamline and accelerate their daily work. Learn to connect to databases whether in the Azure cloud or hosted on premises in your corporate environment. You can even connect to databases from competing brands and from the world of open source. Then learn how you can query and analyze data using a fusion of languages such as Python, SQL, and PowerShell neatly wrapped in Jupyter Notebooks.
Azure Data Studio is a quickly emerging software platform from Microsoft meant to be a free-form toolbox for all sorts of data manipulation and analytics tasks. Going beyond just querying interactively, this book shows how you can maximize your work products, whether it’s a small code snippet, or an exhaustive notebook. You’ll learn how to benefit from Git and GitHub where your queries and analysis can be shared and improved by others in your organization, or perhaps collaborate with those on the outside. If you’re involved in a role working with data and you are looking for an open architecture platform for exploring your data, managing your data, and for collaborating with colleagues to derive business value by analyzing that data, then this is the book you'll want to read!
- Who this book was written for
- What you need to get the most from this book
Source Code and Notebook Samples
- Companion Database
- About the Author
- Why this book
Chapter 1 - Open Source, Cross-Platform, Multi-Database
What “Open Source” means for this new breed of Microsoft Software
- A perspective on Open Source
- Extend and Enhance ADS
- Contribute to ADS
The new options provided by “Cross-Platform” computing
- What about the Database ‘Platform’
- What “Multi-Database” means for your SQL experience
- What about ‘Management Studio’?
- Opening Azure Data Studio
- What “Open Source” means for this new breed of Microsoft Software
Chapter 2 - Everything Starts with a Connection
Creating, Using, and Managing Connections
- Connecting to SQL Server
- Connecting to Azure SQL Database
- Connecting to PostgreSQL
Grouping and Color Coding your Connections
- Color Coding Groups
Central Management Servers Extension
- Creating, Using, and Managing Connections
Chapter 3 - SQL Editing Reimagined
IntelliSense, Snippets and Object Definitions
- Code Snippets
- Object Definitions
- Saving Queries and Snippets
- Top Down View with Minimap
- SQL Queries via the Command Terminal
- IntelliSense, Snippets and Object Definitions
Chapter 4 - Visualizing and Exporting Your Queries
- Loading Sample Data
- Anatomy of the Results Pane
- Querying for Easy Visuals
- Getting Pixel Perfect
Chapter 5 - Getting Things Done with Notebooks
Notebook Building Blocks
- Comments on Steroids via Markdown
- Fun with Code Cells
- Story with a SQL Notebook
- Simple PowerShell Notebook
- Simple Python Notebook
- More to Come
- Notebook Building Blocks
Chapter 6 - Reaching Beyond SQL with PowerShell, the Terminal Window, and an Extension
Creating a Simple Dataflow
- Dataflow Components
- Getting Started
- Specifying the ‘Source’ Table
- Creating the ‘Destination’ Table
- Running the PowerShell Script in a Notebook
- Running the PowerShell Script in the Terminal
- Using the “Simple DataFlow” Extension for ADS
- Creating a Simple Dataflow
Chapter 7 - Source Control by Design
- Cloning this book’s repository
- Creating your own repository
- Using Git to Manage File Changes
- Publishing your ADS repository to GitHub
Chapter 8 - Free and Easy Extensions
- Installing and Managing your Extensions
- SQL Server Schema Compare
Simple Data Scripter
- Extension Wrap-up
Appendix A - Understanding the car_crash DataMart
- Sample Data
The Leanpub 45-day 100% Happiness Guarantee
Within 45 days of purchase you can get a 100% refund on any Leanpub purchase, in two clicks.
See full terms
Free Updates. DRM Free.
If you buy a Leanpub book, you get free updates for as long as the author updates the book! Many authors use Leanpub to publish their books in-progress, while they are writing them. All readers get free updates, regardless of when they bought the book or how much they paid (including free).
Most Leanpub books are available in PDF (for computers), EPUB (for phones and tablets) and MOBI (for Kindle). The formats that a book includes are shown at the top right corner of this page.
Finally, Leanpub books don't have any DRM copy-protection nonsense, so you can easily read them on any supported device.
Ansible for KubernetesJeff Geerling
Ansible is a powerful infrastructure automation tool. Kubernetes is a powerful application deployment platform. Learn how to use these tools to automate massively-scalable, highly-available infrastructure.
Functional Design and ArchitectureAlexander Granin
Software Design in Functional Programming, Design Patterns and Practices, Methodologies and Application Architectures. How to build real software in Haskell with less efforts and low risks. The first complete source of knowledge.
Production HaskellMatt Parsons
Are you excited about Haskell, but don't know where to begin? Are you thrilled by the technical advantages, but worried about the unknown pitfalls? This book has you covered.
Ansible for DevOpsJeff Geerling
Ansible is a simple, but powerful, server and configuration management tool. Learn to use Ansible effectively, whether you manage one server—or thousands.
Tame your Work FlowSteve Tendon and Daniel Doiron
Do you need a high performance enterprise governance approach improving management, execution and delivery while dealing with multiple projects/products, events, stakeholders and teams? Giving you better bottom line results, faster time to market, less work, better predictability, happier employees, and delighted clients? Then learn about TameFlow!
Practical FP in Scala: A hands-on approachGabriel Volpe
A practical book aimed for those familiar with functional programming in Scala who are yet not confident about architecting an application from scratch.
Together, we will develop a purely functional application using the best libraries in the Cats ecosystem, while learning about design patterns and best practices.
Composing SoftwareEric Elliott
All software design is composition: the act of breaking complex problems down into smaller problems and composing those solutions. Most developers have a limited understanding of compositional techniques. It's time for that to change.
Algebra-Driven DesignSandy Maguire
A how-to field guide on building leak-free abstractions and algebraically designing real-world applications.
Invest In Digital Health - The Medical Futurist's GuideDr. Bertalan Mesko
Artificial Intelligence and Digital Health are booming. In this book, we explain why now it's a good time to invest in Digital Health and give recommendations on where to invest by looking at the top 24 technological trends we find the most promising.
The Hundred-Page Machine Learning BookAndriy Burkov
Everything you really need to know in Machine Learning in a hundred pages.
The Tester's Library
8 BooksThe Tester's Library consists of eight five-star books that every software tester should read and re-read. As bound books, this collection would cost over $200. Even as e-books, their price would exceed $80, but in this bundle, their cost is only $49.99. Here are the books, and why they should be in your library: Perfect Software and Other...
11 BooksIn this bundle, you will find 10 different agile books. They are about different aspects of being agile. - finding a job - doing coding dojo's - Retrospectives - Personal kanban - a non-typical coaching book and even a book that gives you an insight in the lives of some agile people.
WTFlop 6M + HU - Beta Bundle
Marionette.js A to Z
Build A Better Backbone App
3 BooksThe best way to learn new development skills is through experience, but that takes time you don't have.Get the best of both worlds with this bundle: you'll learn how to produce modern web applications by learning from experienced developers like Derick Bailey and David Sulc. BackboneJS is one of the favorite tools on the web today, but it...
General Systems Thinker Bundle
5 BooksThe General Systems Thinker Bundle is just that: a bundle of five books to advance the reader one giant step toward improved thinking, based on General Systems principles. Four of the books are the complete General Systems Series. The fifth is fictional piece which shows some general systems thinkers in action. It's a mystery in which a group of...
Experiential Learning Bundle
4 BooksThis bundle provides all four volumes of the popular Experiential Learning Series at a savings of $20 over the price if purchased separately.
2 BooksAfter getting up and running with Ansible in Jeff Geerling's Ansible for DevOps, strengthen your skills managing tens to thousands of instances and services in Amazon's AWS cloud with Yan Kurniawan's Ansible for AWS.
Learn ECMAScript 6 inside and out
2 BooksFor any technology, it helps to get multiple points of view on the functionality to get the best possible understanding. For ECMAScript 6/2015, no two resources are recommended more frequently thanExploring ES6by Dr. Axel Rauschmayer andUnderstanding ECMAScript 6by Nicholas C. Zakas. These two points of view, investigating the specification and...
NetBeans Platform Starter Kit
2 BooksIn this bundle, you get a complete introduction to the NetBeans Platform APIs, together with many exercises, in the form of "NetBeans Platform for Beginners". This book is done and has been reviewed and is over 350 pages in length. It will continue to grow as more content is added over time. There will be monthly updates, with new sections,...