Day 4. SQL Server interraction with pyodbc

In this video we'll find out how to get connection string for Python ODBC connection in three ways: manual, with SSMS and using online generators. Also, the speaker talks about query executing and committing at examples SELECT and INSERT queries.


Комментарии

Отправить комментарий

Популярные сообщения из этого блога

Tips to increase the likelihood of correct geo-coding

Изображение
What is sent to Bing Maps? The Power BI service and Power BI Desktop send Bing the geo data it needs to create the map visualization. This may include the data in the Location, Latitude, and Longitude buckets of the visual's field well. Exactly what is sent varies by map type. For maps (bubble, scatter, and dot plot maps), if latitude and longitude are provided, then no data is sent to Bing. Otherwise, any data in the Location bucket is sent to Bing. Filled maps require a field in the Location bucket; even if latitude and longitude are provided. Whatever data is in the Location, Latitude, or Longitude bucket is sent to Bing. In the example below, the field PostalCode is being used for geo-coding, so the values in the PostalCode column are sent to Bing. Data from the Size bucket is not sent to Bing. In this second example below, the field Territory is being used for geo-coding, so the values in the Territory column are sent to Bing. Data from the Legend bucket (and the Col...
Далее...

Data Table Filters within Charts in Power BI

Изображение
To show underlying data for a chart visualization in Power BI, follow these steps: Select the chart visual that you want to view the underlying data for. Click on the "ellipses" (...) at the top right corner of the visual to open the dropdown menu. From the dropdown menu, select "Show as a table" option. Power BI will then display a table with the underlying data for the chart visual. You can scroll through the table to view all the data. If you want to export the underlying data to a CSV or Excel file, click on the "Export data" button at the top right corner of the table. If  you need to show background data related to some point at the chart, use "Show data point as a table" from chart figure context menu. The underlying data depends on selected Legend data field columns and source data table cannot be created by selecting several records from a chart.
Далее...