Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – SSMS: Database Consistency History Report

August 5, 2014

SQL Reports, SQL Server Management Studio

Doctor and Database The last place I like to visit is always a hospital. With the monsoon season starting, intermittent rains, it has become sort of a routine to get a cycle of fever every other year (seriously I hate it). So when I visit my doctor, it is always…

SQL SERVER – SSMS: Backup and Restore Events Report

August 4, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Reports, SQL Server Management Studio

A DBA wears multiple hats and in fact does more than what an eye can see. One of the core task of a DBA is to take backups. This looks so trivial that most developers shrug this off as the only activity a DBA might be doing. I have huge…

Developer’s Life – Every Developer is a Captain America

August 3, 2014

Pinal Dave

SQL

Developer, Superhero

Captain America was first created as a comic book character in the 1940’s as a way to boost morale during World War II. Aimed at a children’s audience, his legacy faded away when the war ended. However, he has recently has a major reboot to become a popular movie character that deals with modern issues.

MySQL – Export the Resultset to CSV file

August 2, 2014

Pinal Dave

SQL, SQL Tips and Tricks

CSV, MySQL

In SQL Server, you can use BCP command to export the result set to a csv file. In MySQL too, You can export data from a table or result set as a csv file in many methods. Here are two methods. Method 1 : Make use of Work Bench If…

SQL SERVER – SSMS: Disk Usage Report

August 1, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Reports, SQL Server Management Studio

Let us start with humor! I think we the series on various reports, we come to a logical point. We covered all the reports at server level. This means the reports we saw were targeted towards activities that are related to instance level operations. These are mostly like how a…

Developer’s Life – Disaster Lessons – Notes from the Field #039

July 31, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field

[Note from Pinal]: This is a 39th episode of Notes from the Field series. What is the best solution do you have when you encounter a disaster in your organization. Now many of you would answer that in this scenario you would have another standby machine or alternative which you…

SQL Authority News – Play by Play with Pinal Dave – A Birthday Gift

July 30, 2014

Pinal Dave

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

SQL Training

Today is my birthday. Personal Note When I was young, I was always looking forward to my birthday as on this day, I used to get gifts from everybody. Now when I am getting old on each of my birthday, I have almost same feeling but the direction is different.…