There is a stored procedure that must be run by only one user at a time. How do to I prevent multiple users from running the stored procedure at the same time?
SQL Server provides an application manageable lock mechanism through the sp_getapplock / sp_releaseapplock pair of system stored procedures. They provide a way for application … Read More →
Excel files can be read using the Python module Pandas. In this article we will read excel files using Pandas.
Data Analysis in Python with Pandas
Read Excel column names
We import the pandas module, including ExcelFile. The method read_excel() reads the data into a Pandas Data Frame, where the first parameter is the filename and the … Read More →
We can use Python urllib to get website content in python program.
We can also use it to call REST web services.
We can make GET and POST http requests.
This module allows us to make HTTP as well as HTTPS requests.
We can send request headers and also get information about response headers.
Response read() method returns the … Read More →
In a typical data warehousing application, quite often during the ETL cycle you need to perform INSERT, UPDATE and DELETE operations on a TARGET table by matching the records from the SOURCE table.
You would need to write separate INSERT, UPDATE and DELETE statements to refresh the target table with an updated product list or do … Read More →