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 MoreSQLAuthority 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 MoreSQL 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.
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.