How to work with Python in Azure Data Studio
Learn how to use Python code with Azure Data Studio to work with SQL Server data.
2022-10-03
5,910 reads
Jupyter Notebook
Creating Markdown Formatted Text for Results from T-SQL
Markdown documents are becoming increasingly more popular and relevant with the emergence of notebooks. Markdown is a markup language for creating formatted text. It is widely used in tools for collaboration, tools for creating documentation and notebooks. Formatting is easy to understand, readable, simple to adopt, and agnostic. I can use a markdown document on […]
2021-11-29
7,189 reads
Step by Step Guide to Install Jupyter Notebook
Whether you work as a Data Engineer or a Data Scientist, a Jupyter Notebook is a helpful tool. One of the projects I was working required a comparison of two parquet files. This is mainly a schema comparison, not a data comparison. Though the two .parquet were created from two different sources, the outcome should […]
2021-05-17
4,319 reads
Automate your Morning Checklist
A morning checklist is a good thing, but an automated one is better.
2020-04-06
28,550 reads
Embedding Notebooks on a Website
Eduardo Pivaral shows how to embed the results of a Jupyter notebook created in Azure Data Studio on a website: Notebooks are a functionality available in Azure Data Studio, that...
2019-05-15
Using Notebooks in Azure Data Studio
Learn how to use the notebook feature of Azure Data Studio to keep a set of queries together with some documentation.
2020-11-27 (first published: 2019-04-11)
17,364 reads
Blogs
Using a tnsnames.ora file with the Microsoft Connector for Oracle in SSIS
One of the nice things about the Microsoft Connector for Oracle is that it...
ChatGpt Experiments–Getting Documentation
By Steve Jones
I get asked questions by salespeople all the time. Usually this is because a...
A New Word: Jouska
By Steve Jones
jouska – a hypothetical conversation that you compulsively play out in your head –...
Forums
How Can I Speed This Query Up?
Hi everyone My SQL query is close to 1000 lines with 17 separate calcs...
partitioning a huge table
Hi folks I would like to get your views about partitioning a huge table...
SQL Website Development: A Comprehensive Guide to Building Dynamic Web Applicati
Introduction to SQL Website Development What is SQL? Importance of SQL in web development...
Ask SSC