Pinal Dave - SQL Server Performance Tuning Expert

MySQL – Scalability on Amazon RDS: Scale out to multiple RDS instances

May 21, 2014

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Today, I’d like to discuss getting better MySQL scalability on Amazon RDS.
The question of the day: “What can you do when a MySQL database needs to scale write-intensive workloads beyond the capabilities of the largest available machine on Amazon RDS?”

SQL SERVER – Reset SA Password – SQL in Sixty Seconds #066

May 21, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video, SQLAuthority News

Joes 2 Pros, SQLAuthority Book Review

It has been quite a long time since I posted SQL in Sixty Seconds Video. Here we are back with the new video. One of the most popular question, I often receive is very similar to following: “How do I reset the password for SA username?” “I have forgotten the…

SQL SERVER – 3 Challenges for DBA and Smart Solutions

May 20, 2014

Pinal Dave

SQL

Devart, MySQL, SQL Utility

Developer’s life is never easy. DBA’s life is even crazier. Let us see in this blog post 3 Challenges for DBA and Smart Solutions.

SQL SERVER – CTE can be Updated

May 19, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

CTE, SQL Scripts, SQL View

Today I have received a fantastic email from Matthew Spieth. SQL Server expert from Ohio. He recently had a great conversation with his colleagues in the office and wanted to make sure that everybody who reads this blog knows about this little feature which is commonly confused. Here is his…

SQL SERVER – Migration Assistant Upgraded to Support SQL Server 2014

May 18, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MySQL, SQL Documentation, SQL Download

We all start somewhere when it is about database. There are different reasons, why we go for one database over another database. Usually the reason is cost and convenience. After a period of time when business is successful and traffic is growing, the same two reasons of cost and convenience…

Developer’s Life – Every Developer is a Spiderman

May 17, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Developer, Superhero

I have to admit, Spiderman is my favorite superhero. The most recent movie recently was released in theaters, so it has been at the front of my mind for some time. Spiderman was my favorite superhero even before the latest movie came out, but of course I took my whole…

MySQL – Beginning Temporary Tables in MySQL

May 16, 2014

Pinal Dave

SQL, SQL Tips and Tricks

MySQL

MySQL supports Temporary tables to store the resultsets temporarily for a given connection. Temporary tables are created with the keyword TEMPORARY along with the CREATE TABLE statement. Let us create the temporary table named Temp CREATE TEMPORARY TABLE TEMP (id INT); Now you can find out the column names using…