Skip to main content

Posts

Showing posts from September, 2025

Python code to compare Blob files vs filesnames in sql server

  import pandas as pd from azure.storage.blob import BlobServiceClient import pyodbc # ------------------ Azure Blob Storage Configuration ------------------ blob_connection_string = 'COnncetionstring' blob_container_name = 'Blobcontainer Name' # Connect to Blob Storage blob_service_client = BlobServiceClient.from_connection_string(blob_connection_string) container_client = blob_service_client.get_container_client(blob_container_name) # Fetch file names from Blob Storage blob_file_names = [blob.name for blob in container_client.list_blobs()] df_blob_files = pd.DataFrame(blob_file_names, columns =[ 'FileName' ]) # ------------------ Azure SQL Database Configuration ------------------ sql_server = 'Server Name' sql_database = 'Databse' sql_username = 'user name' sql_password = 'password' sql_driver = 'ODBC Driver 17 for SQL Server' sql_table = 'FileName table' # Connect to SQL Server and fetch file names sql_conn_str...
Post a Comment
Read more

New Card Visual in Power BI

 Please look into the below video to view of reference labels and details in new card visual Link to video--- https://www.youtube.com/watch?v=XTLo64sydck Link to download pbix File-- https://github.com/powerbibro/powerbibro/blob/main/PBI%20-%2020240309%20-%20Reference%20Label%20Updates.pbix
Post a Comment
Read more

AI Tools for Developers

 The video outlines a "SMART" framework for software engineers to leverage AI, and it recommends several tools under each letter of this framework to enhance productivity and skill. Here's a summary of the tools mentioned: S - Study This section focuses on using AI to study and learn effectively. Perplexity : Described as an "AI Sherlock Holmes," this tool investigates multiple sources, connects information, and provides deductive conclusions with proof. It synthesizes information from various sources to give comprehensive answers, unlike traditional search engines where users have to piece together information. It's particularly useful for tasks like building a real-time chat application, explaining pros and cons of technologies (e.g., websockets vs. WebRTC), and recommending libraries. It provides citations and real-time web results, making it more accurate than tools like ChatGPT. NotebookLM : This tool is compared to "Doctor Strange of AI...
Post a Comment
Read more

Websites to Analyze Intrinsic value of a stock

Video Link -- https://www.youtube.com/watch?v=TqVm4q_XzbM&t=42s Seeking Alpha ( seekingalpha.com ) : Provides essential investment information, including stock movement data, company profiles, profitability metrics (gross profit and Avid margins) for financial health, and capital structure details. Kai emphasizes checking short interest , a "super super important" number, advising to generally avoid stocks with over 2% short interest as it indicates many are betting against the stock. Yahoo Finance ( finance.yahoo.com ) : A "classic" and "powerful tool". Its graph features a strong comparison tool to trend multiple companies over time and show percentage changes. Kai highlights recent insider transactions as crucial, suggesting significant insider selling might signal a potential stock drop. Wallmine.com ( wallmine.com ) : Consolidates most information onto a single page , which Kai finds convenient. It offers quick explanations when hovering over...
Post a Comment
Read more