Ashwani .Net

Hello Techies,   In this article i am going to introduce how you can code Python with Visual studio code and GIT Bash for Data Science. So, Please follow bellow steps for this approach. 1 . Download and install Python from : https://www.python.org/downloads/windows/   ( Add python 3.7 * should be checked) 2 . Install Git bash from given link :  https://gitforwindows.org/ 3 . Download and install Visual studio code from : https://code.visualstudio.com/ 4. Install Python Ext from VS Code Integrate GIT BASH in VS CODE  5 . Open   https://code.visualstudio.com/docs/editor/integrated-terminal  link and find bash code for VS Terminal which is given bellow. // Git Bash "terminal.integrated.shell.windows" : "C:\\Program Files\\Git\\bin\\bash.exe" 6 .Now open VS Code and update setting with given code.  7. Now press CTRL + ~ (tild) for open Terminal.    Now you can see GIT BASH has been integrated with V...

Hi Techies,   In this tutorial i am going to start basic tutorial about R-Programming. R is a dialect of S. S is a language that was developed by John Chambers and others at the old Bell Telephone Laboratories, originally part of AT&T Corp. For Download R :  https://cran.r-project.org For IDE R-Studio :  https://www.rstudio.com/products/rstudio/download/

Hi Techies, Today i am going to introduce basic introduction of  Artificial intelligence (Ai).

Dear Techies, Today i am going practice DATA partition in sql server for better performance. Please Follow the bellow steps for that. Create a table where we will store 50 lacs records.  Insert 50 lacs Sample Data using WHILE Loop Declare @i int =0 While @i<5000000 BEGIN Insert into DemoTableForPartition (Name,Address,Country,State,Education,Company) values ('Test'+CONVERT(varchar,@i),'D-2017','India','UP','Master','Test Company') SET @i=@i+1 END Create Clone table for check difference. select * into [ DemoTableForWithoutPartition ] from [ DemoTableForPartition ]

Hi Techies, In this article i am going to introduce CTE (Common Table Expression). Common Table Expression (CTE) :  It is used for create temporary named result set with calculation or conditional result within the query or tables.  This clause is a simple query and defined within the execution scope of a single statement like SELECT, INSERT, UPDATE, or DELETE.  This clause can also be used in a CREATE VIEW statement. This is referred to as a recursive common table expression in SQL Server. EX: --EXEC [TestProcedure] Create PROC TestProcedure AS  BEGIN  ------------------------------------------------------------ ;with CTE_Data as (     SELECT Top 10 * FROM Employee      union all      SELECT Top 10 * FROM Employee  ) ---------------------------------------------------------------- select * from CTE_Data  END

Hello Techies,                      In this article i am going to describe how to create Sql Job in sql server to run stored procedure. Please follow the bellow steps for the same. Step 1.  Open  SQL Server management studio  Go to  SQL Server Agent  (for this you should have Admin rights and SQL Server should be professional edition) Step 2. Enter Job Name and Description  Step 3. Click on Steps button for next process Click on image for better view.  Step 4. Click on Schedules for setup Scheduling the job when it will be execute on server.  Step 5 (For Execute Job Manually or Test) Find your Created job by Job Name in Jobs Folder in Sql Server Agent.  Right Click after select Job pop will be open In pop up click Start Job at Step.  After click on step progress Pop up window will be open. And your j...