There are multiple reasons why a user may want to make a copy of the database. Sometimes a user wants to copy the database to the same server and sometime wants to copy the database on a different server. The important point is that DBA and Developer may want copies…
Read MoreSQL SERVER – Poll – What would you love to see in SQL in Sixty Seconds?
Last week, I had my very first SQL in Sixty Seconds Video of this year. Lots of people send me email asking for me to continue this series as it was extremely fun at times to watch the video. I am going to start the series again in the month…
Read MoreSQLAuthority News – Download Whitepaper – A Case Study on “Hekaton” against RPM – SQL Server 2014 CTP1
In this new world of social media, apps and mobile devices, we are all now getting impatient. Automatic updates have spoiled few of our habits. When a new feature is released everybody wants to immediately adopt the feature and start using it. Though this is true in the world of…
Read MoreSQLAuthority News – Presented Soft Skill Session on Presentation Skills at SQL Bangalore on May 3, 2014
I have presented on various database technologies for almost 10 years now. SQL, Database and NoSQL have been part of my life. Earlier this month, I had the opportunity to present on the topic Performing an Effective Presentation. I must say it was blast to prepare as well as present…
Read MoreSQL SERVER – Windows File/Folder and Share Permissions – Notes from the Field #029
[Note from Pinal]: This is a 29th episode of Notes from the Field series. Security is the task which we should give it to the experts. If there is a small overlook or misstep, there are good chances that security of the organization is compromised. This is very true, but…
Read MoreMySQL – Scalability on Amazon RDS: Scale out to multiple RDS instances
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
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…
Read MoreSQL SERVER – 3 Challenges for DBA and Smart Solutions
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.





