Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Sign up for free
Menu
Search
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Pricing
Search
Sign in
Sign up for free
Global Azure 2022 - Desenvolvimento e Administr...
Search
Sponsored
·
Your Podcast. Everywhere. Effortlessly.
Share. Educate. Inspire. Entertain. You do you. We'll handle the rest.
→
William Lino Oliveira
June 07, 2022
Technology
33
0
Share
Embed
Copy iframe code
Copy JS code
Copy link
Start on current slide
Global Azure 2022 - Desenvolvimento e Administração em SQL Server com Python
https://www.youtube.com/watch?v=RpV0EACbfdw&t=184s
William Lino Oliveira
June 07, 2022
Transcript
14 slides
Desenvolvimento e Administração em SQL Server com Python William Lino
Oliveira
>whoami_ William Lino Oliveira Microsoft MVP Data Platform DBRE @
C6 Bank Co-Fundador & CSA @ Data Tuning & Flapper 7x Microsoft Certifications 5x AWS Certifications 1x Hashicorp Certifications Linkedin.com/company/data-tuning
[email protected]
https://datatuning.com.br/blog https://codedataops.com Youtube.com/c/DataTuningChannel
Motivação 12k + Bancos de dados Integrações entre sistemas ITSM
API’s e Microserviços 1 2 3 4 5 6 Auto-Serviço Automação e Cloud Hardening e Compliance
Instalando pacotes Python EXEC sp_configure 'show advanced options', 1 RECONFIGURE
WITH OVERRIDE EXEC sp_configure 'external scripts enabled', 1 RECONFIGURE WITH OVERRIDE
IDE`s para Desenvolver: Executando um script Python • Python IDLE
• PyCharm • Visual Studio Code • Vim • Sublime Text • Atom • Cmd • Terminal • Power Shell Para executar:
sp_execute_external_script Executando dentro do SQL Server
Opções: Executando dentro do SQL Server • Chamadas ao SO
• Rede • Disco • Processador • Data Science • Machine Learning • Chamadas de API • Integrações com outras tecnologias de banco
Opções: Python em tarefas administrativas • Construção de scripts •
Automação • Alertas • Alta disponibilidade • Criação de bibliotecas para sistemas • Integrações entre tecnologias
Instalação e Configuração de Infra:
Criação de Bancos de Dados:
Deploy de aplicações: Devs DBAs ADs
Próximas Palestras:
Referências: • https://docs.microsoft.com/pt-br/sql/relational-databases/system-stored- procedures/sp-execute-external-script-transact-sql?view=sql-server-2017 • https://docs.microsoft.com/en-us/sql/advanced-analytics/tutorials/quickstart- python-create-script?view=sql-server-2017 • https://docs.microsoft.com/pt-br/sql/advanced-analytics/concepts/extensibility- framework?view=sql-server-2017
• https://docs.microsoft.com/en-us/sql/advanced-analytics/install/sql-machine- learning-services-windows-install?view=sql-server-2017 • https://github.com/giampaolo/psutil/blob/master/scripts/disk_usage.py • https://linuxacademy.com/guide/14209-automating-aws-with-python-and-boto3/ • https://docs.aws.amazon.com/AmazonRDS/latest/APIReference/API_CreateDBInstanc e.html • https://www.tutorialspoint.com/amazonrds/amazonrds_ms_sql_features.htm
None
More Decks by William Lino Oliveira
See All by William Lino Oliveira
TDC Connections Trilha Cloud: Distribuição e Escalabilidade de Bancos de Dados em Cloud
williamloliveira
0
67
Vitess: Banco de Dados Distribuído Nativo para K8s
williamloliveira
0
35
AWS Community Day Brasil 2021 - Distribuindo Dados Globalmente com Aurora, DynamoDB e EslatiCache.
williamloliveira
0
69
HashiTalks: Brasil 2021 - Contruindo Ambientes Seguros de Bancos de Dados com Terraform e Vault
williamloliveira
0
60
Other Decks in Technology
See All in Technology
ワークフローからハーネスへ — Web フレームワークの作者たちが AI エージェントに向かう理由
azukiazusa1
2
980
専門家に使ってもらうAIプロダクトをつくる - 病院の医事課向けDPCコーディング支援システムの設計と評価
hagino3000
4
1k
個人ASを取得して、自宅Kubernetes上のVMをグローバルIPで公開した話
munenick
0
230
Welcome JXL!
dynamis
0
120
技術書典で本を売る流れ
yoshimura_datam
0
140
落とし穴にハマってわかった 開発生産性を測るときに気をつけたいこと
munakata
3
490
IVRy における AI 時代のデータプロダクトと事業開発
ivry_presentationmaterials
0
110
Platform Engineering をベースとした Agentic Software Factory の実践
110y
3
970
常時稼働エージェントの作り方(Claude公式ブログを資料化)
minorun365
PRO
20
29k
MCPでネットワーク障害調査を自動化する前に直すべき3つのこと
yama3133
1
660
パスワードのない鍵で、 データを手元に置く
ginjihayashi
0
400
「個社」ではなく「業界」の課題を解く AI 対話開発 ー 価値を広げる設計と、価値を守るエンジニアリング ー
ivry_presentationmaterials
4
870
Featured
See All Featured
AI Search: Implications for SEO and How to Move Forward - #ShenzhenSEOConference
aleyda
1
1.5k
How GitHub (no longer) Works
holman
316
150k
How to Grow Your eCommerce with AI & Automation
katarinadahlin
PRO
2
360
The Director’s Chair: Orchestrating AI for Truly Effective Learning
tmiket
1
360
The Success of Rails: Ensuring Growth for the Next 100 Years
eileencodes
47
8.4k
A Soul's Torment
seathinner
9
3.9k
[RailsConf 2023 Opening Keynote] The Magic of Rails
eileencodes
31
10k
Sam Torres - BigQuery for SEOs
techseoconnect
PRO
0
620
The Mindset for Success: Future Career Progression
greggifford
PRO
0
570
Believing is Seeing
oripsolob
1
290
The Curious Case for Waylosing
cassininazir
1
630
Beyond borders and beyond the search box: How to win the global "messy middle" with AI-driven SEO
davidcarrasco
3
310