Profile cover photo
Profile photo
Avishkar Meshram
112 followers
112 followers
About
Avishkar's posts

Post has attachment
How to Allow MySQL Remote Access in Ubuntu Server 16.04 on AWS
Step1:  Enable MySQL Server Remote Connection in
Ubuntu 
 By default MySQL Server on Ubuntu run on the local
interface, This means remote access to the MySQL Server is not Allowed. To
enable remote connections to the MySQL Server we need to change value of ...

Post has attachment
Python to Access Web Data
What is web scraping? Web sites are written using HTML, which means that each web page is a structured document. Web sites don’t always provide their data in comfortable formats such as csv or json. This is where web scraping comes in. Web scraping is the p...

Post has attachment
Python to Access Web Data
Python to Access Web Data What is
web scraping? Web
sites are written using HTML, which means that each web page is a structured
document. Web sites don’t always provide their data in comfortable formats such
as csv or json . This is
where web scraping come...

Post has attachment
Python to Access Web Data
What is
web scraping? Web
sites are written using HTML, which means that each web page is a structured
document. Web sites don’t always provide their data in comfortable formats such
as csv or json . This is
where web scraping comes in. Web scraping is the ...

Post has attachment
Python to Access Web Data
Python to Access Web Data What is web scraping? Web sites are written using HTML, which means that each web page is a structured document. Web sites don’t always provide their data in comfortable formats such as csv or json . This is where web scraping come...

Post has attachment
Heap Table
Tables without clustered indexes are called heaps. They’re scattered on disk anywhere that SQL Server can find a spot, and they’re not stored in any order whatsoever. This can make for really fast inserts – SQL Server can just throw the data down – but slow...

Post has attachment
How do you set a default value for a MySQL Datetime column?
How do you set a default value for a MySQL Datetime column? In SQL Server, it's getdate(). What is the equivalant for MySQL? The DEFAULT value clause in a data type specification indicates a default value for a column. With one exception, the default value ...

Post has attachment
QlikView Vs Qlik Sense
QlikView Vs Qlik Sense Qlik Sense is not just a new release of QlikView. Instead it is something different. There are so many similarities and differences between the two products The two products have the same analysis engine and old scripts and old formul...

Post has attachment
Common string operations in SQL Server 2008
1. Find the last occurence of a character within a string in sql server 2008 DECLARE @StringA varchar(100), @pos int, @FindChar char(1)=',' SET @stringA = 'DirectoryA,' SET @pos = LEN(@StringA) - CHARINDEX(',',REVERSE(@StringA)) SELECT @pos 2. How to remove...

Post has attachment
Issues with MS SQL Server Standard edition in AWS
Issues with MS SQL Server Standard edition in AWS 1. Database Mirroring and index maintenance MS SQL Server Standard edition in AWS allows  synchronous mirroring only.In synchronous mirroring, the additional log being generated could overload the network li...
Wait while more posts are being loaded