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

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

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 .  3 Services Offered Writing :      You want to pay me to write more of *waves hand* this blog? I am game .     I write B2C e-mails going out to over 280 people weekly. [ Example Job Description ]        Auditing :        Something doesn't work on your page or in your app. I can find it, or you can lose business. [ Here ] [ Example Job Description ]   I really enjoy testing apps and webpage concepts! I have an iPhone and Android phones ready. Technical: Still as-needed, always remote, contract, or temporary. IT Operations Tech [ Example Job Description ]     Hardware and SaaS support.     Cisco routing and switching (Networking). CCNA, A+, Sec+, Azure certified WORKING ON: Junos

Portfolio of UX/Product Feedback [Vol. 1]

I browse websites and apps, while making note of things I find frustrating for end users. You have probably been linked here from a form or my resume. If you have any questions about what I'm looking for in a role, click here .   This post is not to shame, but to point out errors and hopefully make my talent for finding and documenting such mistakes clear to someone hiring. Contents: Instances where I offer constructive feedback on someone's website, logo, or app. Actions that were taken by the developers or artists.  I'm glad you want your webpages to be the best they can be with my help; If you need your sites audited, e-mail me . Latest Update -  November 20th, 2020.   Vol. 2 is here .

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.