techsapphire
techsapphire
  • Видео 178
  • Просмотров 2 892 948
Document similarity in SQL Server and PostgreSQL using cosine similarity
Document similarity in SQL Server and PostgreSQL using cosine similarity.
Script: github.com/yogimehla/AdhocScripts/blob/main/Similarity.sql
Просмотров: 115

Видео

Create stable AI agents for research using Langchain
Просмотров 2532 месяца назад
In this example, we will use three AI agents: Manager Researcher Example Generator We will provide a prompt to the Manager Agent to break down the information into topics. The Researcher Agent will conduct detailed research on each topic. The Example Generator will create and write examples for each topic, which will be stored in the example folder.
Convert SQL Server Stored Procedure into Postgres function using AI Automatically
Просмотров 1982 месяца назад
In this tutorial, we demonstrate how to leverage the power of AI and LangChain to seamlessly convert SQL Server stored procedures into PostgreSQL functions. Join us as we explore innovative techniques and tools that simplify this complex transformation process, making it easier and more efficient.
Devika AI vs OpenDevin your personal virtual employee
Просмотров 6442 месяца назад
Note: On Windows environment OpenDevin is better suited. Imagine you are having an free employee of your own, you can build apps with it and make money :D OpenAI API is used in this integration with google as search engine. Prompt used in the video: I want to create TechsapphireAgent and folder, which will do outbound calls using local text-to-voice package for response and start with opening a...
SQL Server to Postgres data migration using Trino
Просмотров 73010 месяцев назад
This video demonstrate data migration between sql server and postgres using ANSI SQL. Tool used in the videos are: Trino dbeaver SSMS SQL Server Postgres
Topics to learn for data architect profile
Просмотров 156Год назад
If someone wants to change there profile to data architect, then they should know these topics as it will allow them to know best tool for their data. #shorts
Semantic search in SQL Server using wordnet
Просмотров 1,6 тыс.Год назад
Semantic search help you search things with more meaning to them. By default, SQL Server semantic search is not easy and flexible to use. I am using wordnet dictionary to provide more meanings to searches. Download source code from: techsapphire.net/semantic-search-in-sql-server-using-word-net/
SQL Server Graph Table schema design, migration and performance
Просмотров 3,7 тыс.Год назад
SQL Server Graph Table is very good option to maintain application like social media. This video covers in depth explanation about graph table and answers: How we can design schema using Graph table? Benefits of using Graph table Performance Advance queries on graph table
Implementing Row Level Security on SQL Server
Просмотров 6 тыс.Год назад
Implementing row level security become very important if you are using SQL Server as warehouse or implementing multi tenancy.
Thermal print using react native
Просмотров 9 тыс.Год назад
This is demonstration of printing on thermal printer from react native
Creating video streaming app using flutter and webrtc
Просмотров 3,9 тыс.Год назад
Creating video streaming app using flutter and webrtc
Converting flutter design to react native
Просмотров 973Год назад
Converting flutter design to react native
Learn Apache Druid for Data Analytics part 1
Просмотров 7 тыс.Год назад
Learn Apache Druid for Data Analytics part 1
Chapter 8 SQLite with Flutter
Просмотров 300Год назад
Chapter 8 SQLite with Flutter
Chapter 6 Notifications using Firebase - II
Просмотров 134Год назад
Chapter 6 Notifications using Firebase - II
Chapter 7 Integrating Kotlin with Flutter
Просмотров 8212 года назад
Chapter 7 Integrating Kotlin with Flutter
Chapter 6 Flutter notifications using firebase
Просмотров 1742 года назад
Chapter 6 Flutter notifications using firebase
Chapter 5 Flutter row and column widget
Просмотров 442 года назад
Chapter 5 Flutter row and column widget
Chapter 4 Flutter login with firebase
Просмотров 492 года назад
Chapter 4 Flutter login with firebase
Chapter 3 flutter login screen and validation
Просмотров 3662 года назад
Chapter 3 flutter login screen and validation
Chapter 2 Flutter basics
Просмотров 622 года назад
Chapter 2 Flutter basics
Chapter 1 flutter installation
Просмотров 1282 года назад
Chapter 1 flutter installation
Learn authorization roles and impersonate in sql server
Просмотров 1,6 тыс.2 года назад
Learn authorization roles and impersonate in sql server
Complete Extruded Cut feature in Solidworks
Просмотров 6 тыс.2 года назад
Complete Extruded Cut feature in Solidworks
Basic modelling in solidworks for beginners
Просмотров 542 года назад
Basic modelling in solidworks for beginners
Simple animation video in Blender for beginners
Просмотров 1112 года назад
Simple animation video in Blender for beginners
Programmer or IT employee should not invest in stocks
Просмотров 1802 года назад
Programmer or IT employee should not invest in stocks
Web Automation Testing Using Selenium Python part 6 Handling Auto suggestion
Просмотров 3972 года назад
Web Automation Testing Using Selenium Python part 6 Handling Auto suggestion
Web Automation Testing Using Selenium Python part 5 Handling Dropdown
Просмотров 4482 года назад
Web Automation Testing Using Selenium Python part 5 Handling Dropdown
Web Automation Testing Using Selenium Python part 4 Date Picker
Просмотров 8 тыс.2 года назад
Web Automation Testing Using Selenium Python part 4 Date Picker

Комментарии

  • @MyWorld-u2o
    @MyWorld-u2o 8 дней назад

    Thank you very much, you saved my time!!!!

  • @simbeyedaudi
    @simbeyedaudi 11 дней назад

    Thank you for wonderful guidance. Can you please share the script.

  • @dipeshdighe189
    @dipeshdighe189 14 дней назад

    best explanation. thank you

  • @j.s.tharunbalaji3131
    @j.s.tharunbalaji3131 15 дней назад

    How to write pm2 service for node red in windows 11 I m running an project on node red which should be alive but how to write pm2 service on windows

    • @techsapphire
      @techsapphire 11 дней назад

      install pm2 in administrator mode, also you can add it on auto start.

  • @blackisblack22
    @blackisblack22 Месяц назад

    I'm new in the subject and this video doesn't help me much.

    • @techsapphire
      @techsapphire Месяц назад

      Thank you for the feedback. This is not a common concept, but you can use whenever you have find similar data from database which are of big size or volume it too high. Thank you for sharing the feedback.

  • @vishnupriyaarora
    @vishnupriyaarora Месяц назад

    Hey, what's the best way to reach you?

    • @techsapphire
      @techsapphire Месяц назад

      yogesh.mehla@gmail.com or +91-9023262520

  • @piyushjadiya4636
    @piyushjadiya4636 Месяц назад

    I have one naive doubt, I have a pyhton project, and have a virtual env for that, also I have the file that I want to run in my dag in that project, how to use the same venev for airflow? Or is there any other way using two different envs?

  • @videomarket9241
    @videomarket9241 Месяц назад

    Hi, I need help, I need to convert flutter app to react native

  • @bipinmishra1445
    @bipinmishra1445 Месяц назад

    Can I buy your script

    • @techsapphire
      @techsapphire Месяц назад

      Yes reach me at yogesh.mehla@gmail.com

  • @BaqarMCA
    @BaqarMCA Месяц назад

    But only tables are migrated, my views and store procedures are left out

    • @techsapphire
      @techsapphire Месяц назад

      check this ruclips.net/video/LSOef0FkjI4/видео.html

  • @srinidhiramesh4725
    @srinidhiramesh4725 2 месяца назад

    Thanks Yogesh bhai. Looks super interesting and gives a great starting point for further research and implementation.

  • @AbdulAminKhan
    @AbdulAminKhan 2 месяца назад

    How it will work global website. It is not possible. It is just only for window machine

    • @techsapphire
      @techsapphire 2 месяца назад

      We have commercial solution for each platform. Kindly reach me at yogesh.mehla@gmail.com .

  • @blessiousphiri3109
    @blessiousphiri3109 2 месяца назад

    Hello Yogesh i need these utility please

    • @techsapphire
      @techsapphire 2 месяца назад

      Check video description. Also check ruclips.net/video/8z5bvF22iOA/видео.html

  • @etlpro4940
    @etlpro4940 2 месяца назад

    Awesome, just below excellent,

  • @user-jd1nz3li3m
    @user-jd1nz3li3m 2 месяца назад

    💯

  • @itsNukePlayz
    @itsNukePlayz 2 месяца назад

    Is there any way I can do this on my entire computer? I have failed uploads/downloads in games such as VRChat and also with my web browser, such as what was covered in this video. This did fix my problems I had downloading items off of my browser so Thank you very much :)

    • @techsapphire
      @techsapphire 2 месяца назад

      yes you can configure speed on router it self.

  • @treydugas806
    @treydugas806 2 месяца назад

    Still so useful after all these years, thank you!

  • @jtech8959
    @jtech8959 2 месяца назад

    poor teaching sorry, your explaining is all over the place. slow down when you talk and cover individual topics before moving on.

    • @techsapphire
      @techsapphire 2 месяца назад

      Noted. I will soon release an updated and better version. I will try to improve.

  • @FrenchStudentDance
    @FrenchStudentDance 2 месяца назад

    Please share scripts

    • @techsapphire
      @techsapphire 2 месяца назад

      drive.google.com/file/d/1RUNgWj8BjQktVVVgklLITsoRV2j8KW1l/view

  • @MuhammadRizwan-tc3zp
    @MuhammadRizwan-tc3zp 2 месяца назад

    superset db upgrade is giving error for me!! plz help

  • @dharmanshah1239
    @dharmanshah1239 2 месяца назад

    not able to implement it for return

  • @SaurabhSharma-nx7fn
    @SaurabhSharma-nx7fn 2 месяца назад

    It's Awesome 👍..

  • @khadidjabouidia969
    @khadidjabouidia969 2 месяца назад

    please can i get the source code

  • @blessiousphiri3109
    @blessiousphiri3109 2 месяца назад

    Hello Brother. Yes Kindly share me the scripts I will need them they will help me

    • @techsapphire
      @techsapphire 2 месяца назад

      kindly check video description. Also check latest video on migration using trino. ruclips.net/video/8z5bvF22iOA/видео.html

  • @nettion
    @nettion 2 месяца назад

    Can the app print stuff when running in background automatically? Almost like a print server ?

    • @techsapphire
      @techsapphire 2 месяца назад

      we have commercial for it.

  • @eknathsonawane5775
    @eknathsonawane5775 2 месяца назад

    can you please script to me

  • @adilkhann
    @adilkhann 2 месяца назад

    I was trying to reach you and send you mail, let me know your availability.

  • @iAbdulMusawir
    @iAbdulMusawir 2 месяца назад

    What is username or password of Airflow?

  • @amzaropanget
    @amzaropanget 2 месяца назад

    Good day, After deploying a Windows Form Application the printer gives error "tmpPrint.print is denied". Thank you

  • @jankimarandi7482
    @jankimarandi7482 3 месяца назад

    Could you please do the same using react.js

    • @techsapphire
      @techsapphire Месяц назад

      yes kindly reach me at yogesh.mehla@gmail.com for commercial solution

  • @010_it_daithiyasudanks3
    @010_it_daithiyasudanks3 3 месяца назад

    I am trying to reproduce the same steps in my machine. I am not able to find Student table under Northwind database. Can you please where I can find the scripts for that? This video is starting to be very useful for me.

  • @aljithva2109
    @aljithva2109 3 месяца назад

    Will it support Ipad does this have app for I pad

    • @techsapphire
      @techsapphire 2 месяца назад

      yes but only network printer are supported.

  • @mohittomar4417
    @mohittomar4417 3 месяца назад

    what is the TCP custom protocall ? Please share the full info.

    • @techsapphire
      @techsapphire 2 месяца назад

      we are using custom protocol

  • @tratkotratkov126
    @tratkotratkov126 3 месяца назад

    The demonstrated platform responsiveness for ingesting just a few dummy records is absolutely disappointing. Also don’t really get what multiple comments like “wait for couple of minutes” has to do while you are presenting streaming solution claiming sub second operational processing !

    • @techsapphire
      @techsapphire 2 месяца назад

      Let me check where I can improve. But I will be doing a druid tutorial soon. Any suggestion will be appreciated and will consider them.

  • @celular18tas
    @celular18tas 3 месяца назад

    Hi, can I have source code?

  • @benboualimedbenyoucef1047
    @benboualimedbenyoucef1047 3 месяца назад

    Thanks a lot Mister Techsapphire

  • @gfellay
    @gfellay 4 месяца назад

    Good video, but the code is not clear. It would be nice if the code was uploaded to github or another sharing site.

  • @radha040
    @radha040 4 месяца назад

    Very informative and core knowledge for every level of SQL developer. Thank you

  • @VUAcademy1
    @VUAcademy1 4 месяца назад

    Thanku for video. can you share code. will be very thankufull

    • @techsapphire
      @techsapphire 2 месяца назад

      kindly check video description.

  • @ajitmelepat4813
    @ajitmelepat4813 4 месяца назад

    when I execute copy comments , I got this error "ERROR: invalid byte sequence for encoding "WIN1251": 0xff CONTEXT: COPY paymentmastervisa, line 1 " Can you help me ?

  • @inaciosumbane9542
    @inaciosumbane9542 4 месяца назад

    How to get the source code

    • @techsapphire
      @techsapphire 2 месяца назад

      kindly check video description.

  • @ogbonnafranklyn8170
    @ogbonnafranklyn8170 4 месяца назад

    Great! Can I access the code?

  • @devranseker9108
    @devranseker9108 4 месяца назад

    Hello, first of all, I would like to congratulate you. I couldn't open your codes.

    • @techsapphire
      @techsapphire Месяц назад

      check this and you don't need this tool ruclips.net/video/8z5bvF22iOA/видео.html

  • @Sajidhussain-pc7pl
    @Sajidhussain-pc7pl 4 месяца назад

    I need this script

  • @momennasr1637
    @momennasr1637 4 месяца назад

    SIMILAR CODE FROM CHATGPT Certainly! Here's an example code that demonstrates how to achieve inter-process communication using memory mapped files and event handlers in C#. This code assumes you have two Windows Forms projects: a sender project and a receiver project. Sender Project (Windows Forms): csharp Copy using System; using System.IO.MemoryMappedFiles; using System.Text; using System.Threading; using System.Windows.Forms; namespace SenderProject { public partial class SenderForm : Form { private MemoryMappedFile memoryMappedFile; private EventWaitHandle eventWaitHandle; public SenderForm() { InitializeComponent(); InitializeMemoryMappedFile(); } private void InitializeMemoryMappedFile() { memoryMappedFile = MemoryMappedFile.CreateOrOpen("MyMemoryMappedFile", 1000); eventWaitHandle = new EventWaitHandle(false, EventResetMode.AutoReset, "MyEvent"); } private void SendMessage(string message) { using (var accessor = memoryMappedFile.CreateViewAccessor()) { byte[] buffer = Encoding.ASCII.GetBytes(message); accessor.WriteArray(0, buffer, 0, buffer.Length); } eventWaitHandle.Set(); // Signal the event to notify the receiver } private void textBoxMessage_TextChanged(object sender, EventArgs e) { string message = textBoxMessage.Text; SendMessage(message); } } } Receiver Project (Windows Forms): csharp Copy using System; using System.IO.MemoryMappedFiles; using System.Text; using System.Threading; using System.Windows.Forms; namespace ReceiverProject { public partial class ReceiverForm : Form { private MemoryMappedFile memoryMappedFile; private EventWaitHandle eventWaitHandle; private Thread receiveThread; public ReceiverForm() { InitializeComponent(); InitializeMemoryMappedFile(); InitializeEventHandling(); } private void InitializeMemoryMappedFile() { memoryMappedFile = MemoryMappedFile.CreateOrOpen("MyMemoryMappedFile", 1000); eventWaitHandle = EventWaitHandle.OpenExisting("MyEvent"); } private void InitializeEventHandling() { receiveThread = new Thread(ReceiveMessage); receiveThread.Start(); } private void ReceiveMessage() { while (true) { eventWaitHandle.WaitOne(); // Wait for the event to be signaled using (var accessor = memoryMappedFile.CreateViewAccessor()) { byte[] buffer = new byte[1000]; accessor.ReadArray(0, buffer, 0, buffer.Length); string message = Encoding.ASCII.GetString(buffer).Trim('\0'); HandleMessage(message); } } } private void HandleMessage(string message) { // Invoke UI update on the main UI thread textBoxReceivedMessage.Invoke((MethodInvoker)delegate { textBoxReceivedMessage.Text = message; }); } } } In the sender project, you can create a Windows Forms application and add a TextBox control named textBoxMessage. Attach the textBoxMessage_TextChanged event handler to the TextChanged event of the textBoxMessage. In the receiver project, create another Windows Forms application and add a TextBox control named textBoxReceivedMessage.

  • @muhammadsiddique1011
    @muhammadsiddique1011 4 месяца назад

    Will it be worked if pdf as blob ?

  • @prabasmessi
    @prabasmessi 4 месяца назад

    Thank you so much for sharing the knowledge. Best explanation for query optimization i have seen till now.

  • @CrownofRiddles
    @CrownofRiddles 4 месяца назад

    Can I get the code please?

  • @CrownofRiddles
    @CrownofRiddles 4 месяца назад

    Please sir i am working on a POS program but i am having issues generating a receipt.please send me the code.

  • @user-zl4vf1pk8r
    @user-zl4vf1pk8r 5 месяцев назад

    Amazing tutorial on query tuning... thanks a lot