All Articles - SQL Authority with Pinal Dave

SQL SERVER – Poll – What would you love to see in SQL in Sixty Seconds?

May 26, 2014

SQL, SQL Server, SQL Tips and Tricks, SQL Video

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…

SQLAuthority News – Download Whitepaper – A Case Study on “Hekaton” against RPM – SQL Server 2014 CTP1

May 25, 2014

Pinal Dave

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

SQL White Papers

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…

SQLAuthority News – Presented Soft Skill Session on Presentation Skills at SQL Bangalore on May 3, 2014

May 24, 2014

Pinal Dave

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

SQLAuthority Author Visit

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…

SQL SERVER – Fix: Error: Compatibility Level Drop Down is Empty

May 23, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Server

I currently have SQL Server 2012 and SQL Server 2014 both installed on the same machine. My job requires me to travel a lot and I like to travel light. Hence, I have only one computer with all the software installed on it. I can install Virtual Machines but as I was able to install SQL Server 2012 and SQL Server 2014 side by side, I just went ahead with that option. Now one day when I opened up my SQL Server 2014 and went to the properties of my database, I realized that the dropdown box for Compatibility level is empty.

Now one day when I opened up my SQL Server 2014 and went to the properties of the my database, I realized that the dropdown box for Compatibility level is empty.

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

May 22, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

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…