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

Personal Technology – A Quick Note on Good Elevator Etiquette

November 24, 2013

Personal, SQL, SQL Server, SQL Tips and Tricks

I have been traveling a lot for different conferences and meetings lately, and that means a lot of air flights, taxi drives, and elevator rides! There are plenty of rules out there, both written and unwritten, for air flights and taxis, and we all more or less follow these rules…

SQL SERVER – FIX : Error 3154: The backup set holds a backup of a database other than the existing database – SSMS

November 23, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Data Storage, SQL Error Messages, SQL Scripts

This is a follow up of the blog post I have posted on error 3154 few years ago. I have received quite a few emails that how we can fix the same error with the help of SQL Server Management Studio. In this blog post, I will explain how we can…

SQL SERVER – vCPUs – How Many Are Too Many CPU for SQL Server Virtualization ? – Notes from the Field #003

November 21, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Backup and Restore

[Note from Pinal]: This is a third episode of Notes from the Field series. Lots of organizations do Virtualization. The purpose of the Virtualization is often consolidation, performance or just easy to use configuration. Looking at the various advantages of the Virtualization, nowadays I find lots of organization have implemented…

SQL SERVER – How to export data from SQL Server to Excel or any other Format?

November 20, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Note: If you want to practice the code and the example along with here, you can download dbForget Studio from here. Everyone, who is involved in work with databases, eventually faces with data export/import tasks. Unlike data import tasks, data export has to be performed in various formats, depending on the business…

SQL SERVER – 3 Quick Videos on Careers, Certifications and Information

November 19, 2013

Pinal Dave

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

SQL in Sixty Seconds has been a very popular channel on YouTube. Here are three of the videos which are based on the Careers, Certifications and Information. Let me know what you think of the same. Additionally, if you like the SQL in Sixty Channel, please subscribe over here. In…

SQLAuthority News – Presenting 3 Session at SQL Server Live, Orlando, Florida

November 18, 2013

Pinal Dave

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

Performance tuning is my favorite subject and I totally enjoy presenting on this subject. I will be presenting 3 sessions at SQL Server Live at Orlando, Florida which are related to SQL Server Performance Tuning. Here is the abstract of the session. SQT10 “What Did I Do?” T-SQL Worst Practices…

Personal Technology – From Floppy to CD, DVD to USB Drive – Quick Note on Evolution of Personal Storage Device

November 17, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Software Development

Recently I was cleaning my house – clearing out old books and computer junk that I’ve been storing for a long time, when I found a box of floppy disks. I was filled with nostalgia. There was a time when I used floppy disks for everything – games, images, and…