SQL Archives - Page 172 of 519 - SQL Authority with Pinal Dave

SQL SERVER – Windows File/Folder and Share Permissions – Notes from the Field #029

May 22, 2014

Notes from the Field, SQL Server Security

[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…

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

May 21, 2014

Pinal Dave

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

MySQL, SQL Server

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…