Day 6: MySQL Programs
On day 5 we understand how to install MySQL or upgrade to latest version. Today we will discuss once installation...
2018-05-06
204 reads
Vinay Thakur
Day 5: Install MySQL and Upgrade
There are multiple ways you can install MySQL, MySQL is compatible for almost all the Operating System. it would be...
2018-05-05
280 reads
Day 4: MySQL Architecture Continue…
MySQL is an open source and configuration of MySQL is very simple and can be customized per the requirement. MySQL...
2018-05-04
267 reads
Day 3: MySQL Architecture
Like other RDBMS MySQL also has similar architecture: Connection Layer/Application Layer Logical Layer (Processing) Storage Engine Layer (Physical) – special Connection...
2018-05-03
298 reads
Day 2: Introduction to MySQL
Story of MySQL is very interesting and involved emotions in it. This is my understanding and my though on Journey...
2018-05-02
295 reads
Day 1: MySQL History
Swedish Company: MySQL AB by – Michael Widenius (Monty), David Axmark and Allan Larsson Name Combination: Michael’s Daughter name –“My” and...
2018-05-01
209 reads
HA between Windows and Linux
If you ask before couple of years about Microsoft and Linux can be compatible was a dream. now Microsoft has...
2018-02-02
253 reads
Count_Big() function
Learned new function for count while going through the channel 9 video for salva. where for a very big table...
2018-01-22
602 reads
Happy New Year… Late:)
Yeah I know its new year and i am back from quite some time. during these days i was learning...
2018-01-13
308 reads
Azure support MySQL & PostgreSQL
After SQL Server support on Linux Microsoft is not have another great enhancement where now Azure supports MySQL and PostgreSQL...
2017-08-27
489 reads
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Compare rows within the same table
I have a table. Structure in script below. I have to compare and see...
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers