In year 2013, I had focused on MySQL along with SQL Server in database products. As I learn more and more MySQL, I quickly realized that there is no proper course or structured information for MySQL Performance Tuning. I had decided to build a course around common MySQL Performance Problems. I have decided to build the performance tuning course in two parts. 1) MySQL Indexing for Performance and 2) MySQL Query Optimization and Performance Tuning. I had released MySQL Indexing for Performance course earlier this year and right before the end of the year 2013 the second course MySQL Query Optimization and Performance Tuning has released as well.
SQL SERVER – Tools for Proactive DBAs – Central Management Server – Notes from the Field #009
[Note from Pinal]: This is a ninth episode of Notes from the Fields series. If you are DBA and Developer there is always a situation when you want to execute the same query on multiple servers. This can work out very well if you have a servers in single digit,…
Read More
SQLAuthority News – Happy New Year 2014 – Resolution of the New Years
First of all, happy New Year to all of you – 2014 has started! Every year I make at least one resolution, some I do for the public on my blog. The reason is simple – if I declare something in front of all of you, there is a good…
Read MoreDevelopers – Top Ten Influential Movies for Developers – Add Your Favourite
Today is Dec 31st and last day of the year. I suggest everyone should go out and meet friends & family. At least everyone should spend their time with people they like and have fun with. In past many times, I have gone out to a new years party, however,…
Read More
SQL SERVER – MySQL – LIMIT and OFFSET – Skip and Return Only Next Few Rows – Paging Solution
Working with MySQL and SQL Server together has its own sets of fun. Here is one example how you can implement paging in MySQL or SQL Server. Both of them have LIMIT and OFFSET mechanism. You can Skip few rows and return few rows from the sorted result set with the help of OFFSET keywords. Let us see how we can do that quickly in the both of the database. We will use AdventureWorks sample database for SQL Server and sakila sample database for MySQL.
SQL SERVER – MySQL – PostgreSQL – How to Concat Strings?
As a regular reader, you may know that I now a days work with MySQL and SQL Server both at the same time. Working with two different products have changed quite a few things in how I write code. Here is an example of that – I changed myself about how I CONCAT strings.
Developer – 10 Phrases Developer Use Too Often
If you are working in IT industry, you must encounter software developer around every corner of the office. I am developer myself and pretty much my all friends are developers too. I have created a list of phrases which developer use often. Feel free to add one of yours as a comment as well.
MySQL – How to Change Delimiter in MySQL – Supporting GO Keyword of SQL Server in MySQL
I work with both the technologies – SQL Server and MySQL and I enjoy working with both of them. In industry you will find few people talking about how one technology is better than other but the reality is that both of them have their greater share. Sometimes when I…
Read More
SQL SERVER – Roundup Post – Notes from the Field – Year 2013 – Performance Tuning and Database Health
One of the most appreciated and loved the series on SQLAuthority.com is Notes from the Field. I often received how did I come up with the idea behind it. Here is the story for the same. Inceptions of Notes from the Field There are two aspects of any technology…
Read MoreSQL SERVER – Overall SQL Server Performance – Not Just Query Performance – Notes from the Field #008
[Note from Pinal]: This is a new episode of Notes from the Field series. When SQL Server is slow we think we can improve the performance of the server by just increasing the performance of queries. However, sometimes the queries are already doing good and there is no increase in…
Read More