Print media is gradually fading out as we are moving to the new exciting world of digital gadgets. I have seen quite a lot of friends who used to tell me that they will never buy kindle or ebook reader as they do not like reading electronically. However, the same set of people I have seen now a days sporting kindle or flipping electronics magazine in their smart phones.
SQL SERVER – vCPUs – How Many Are Too Many CPU for SQL Server Virtualization ? – Notes from the Field #003
[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…
Read MoreSQL SERVER – How to export data from SQL Server to Excel or any other Format?
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…
Read MoreSQL SERVER – 3 Quick Videos on Careers, Certifications and Information
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…
Read MoreSQLAuthority News – Presenting 3 Session at SQL Server Live, Orlando, Florida
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…
Read MorePersonal Technology – From Floppy to CD, DVD to USB Drive – Quick Note on Evolution of Personal Storage Device
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…
Read MoreSQL SERVER – SQLPASS 2013, Charlotte Memories – Book and Book Signing – Part 2
Yesterday I wrote about my SQLPASS 2013, Charlotte Memories Friends. This is second and last part of the same series. As you know I have so far written 10 different books on SQL Server and I am very much proud of that fact. Every time at SQLPASS, our books are…
Read MoreSQL SERVER – SQLPASS 2013, Charlotte Memories – Friends and Technology – Part 1
I have been visiting SQLPASS for last 5 years and I always have a great time attending this event. For the last few years, I have been attending this event in Seattle, Washington. This year this event was at Charlotte, North Carolina. This was a new place for me as…
Read MoreSQL SERVER – Root Cause to Performance Problems – Notes from the Field #002
[Note from Pinal]: This is a second episode of Notes from the Fields series. When there is a performance problem we all relentlessly work to fix the issue, however, we hardly spend time to find what has created the issues in the first place. For example, it is easy to…
Read MoreSQL SERVER – Backup SQL databases to Box or SkyDrive
To ensure your SQL Server or Azure databases remain safe, you should backup your databases periodically. And it is important to store the backups in a reliable location. Microsoft SkyDrive currently offers 7GB free, Box offers 5GB free – both are reliable and it is simple to send your backups…
Read More