Skip to main content

Using Azure Data Studio and SQL Database

 


 

As part of one of my Data Science Scholarships, I am allowed to download the database files.

So I thought, why not stick them in a database on Azure for some learning. 

They didn't say I couldn't.

 LEARN LEARN LEARN.

After opening Azure Data Studio, hit 'New Connection'. In order to get the entire server name, go back to azure and your SQL Database, and under 'Settings' on the far left, hit 'Connection Strings'.


It's not a neat and tidy way, but you're smart, you can parse the correct information.


 
Upon logging in, I had to create a firewall rule to allow myself in. Appreciate that level of security!.

 
My Azure SQL Database is now logged into via my Azure Data Studio!
 
 
 
I can now add the open database I have to my test bucket.

 My database name was testav.

In the Azure Portal, I can run queries. I started the orders database file until I went "Oh boy that might cost me more than 2$," and stopped it.


In Data Studio, I can run Python (at least print statements):



Back in Azure, here is how much data I'm storing; Big numbers here, folks.


I couldn't see my local files in Azure despite attaching them. Perhaps by using the Storage Explorer that I've explored previously would make it show up.

Comments

Popular posts from this blog

Connecting IoT Devices to a Registration Server (Packet Tracer, Cisco)

In Packet Tracer, a demo software made by Cisco Systems. It certainly has changed a lot since 2016. It's almost an Olympic feat to even get started with it now, but it does look snazzy. This is for the new CCNA, that integrates, among other things, IoT and Automation, which I've worked on here before. Instructions here . I don't know if this is an aspect of "Let's make sure people are paying attention and not simply following blindly", or an oversight - The instructions indicate a Meraki Server, when a regular one is the working option here. I have to enable the IoT service on this server. Also, we assign the server an IPv4 address from a DHCP pool instead of giving it a static one. For something that handles our IoT business, perhaps that's safer; Getting a new IPv4 address every week or so is a minimal step against an intruder, but it is a step. There are no devices associated with this new server; In an earlier lab (not shown), I attached them to 'H

What Do You Need? [AKA; List of Offered Services / My Next Role] (2020)

UPDATED 2021 I am a trusted outsourced remote consultant for your company.   I enjoy having the flexibility to take on temporary projects from time to time! I start at part-time, temp work for now. If we like each other, we can renegotiate. If anything sounds weird, out there, or unusual - Feel free to e-mail me , because I probably think it's awesome. 3 Services Offered Technical: Cloud Technician     Azure [ See tag ] Subcategories: Infrastructure As Code (Specifically Terraform/Azure and CloudFormation/AWS ) Azure Networking I really like the Azure space, and will continue down that path.  Support [Web: Example Job Description ] [Text : Example Description ]     I help you with adjustments in HTML, CSS, and Javascript.     When you email a business a question and they answer? That's me.   Auditing :  Something doesn't work on your page or in your app. I can find it. [ Here ] [ Example Job Description ]   I really enjoy testing apps and webpage concepts! I have an

Contactless Tech’s Role in the New Guest Experience ft. INTELITY and The George

 Contactless hospitality technology is growing. You want to get away, and you'll be damned if a little thing like a deadly virus will stop you! But you still don't want to touch things. Ew. During the chat between INTELITY CEO Robert Stevenson and THE GEORGE Director of Operations Kerrie Hunter, you’ll learn how the historic boutique hotel has adapted a mobile-first guest experience in the wake of COVID-19—and how they see contactless technology affecting the future of hospitality. I don't remember how I found INTELITY (probably hoping to score a position with them), but I liked them enough to stay on the e-mail lists.