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

MySQL – Export the Resultset to CSV file

August 2, 2014

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

Developer – Cross-Platform: Fact or Fiction?

July 29, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

This is a guest blog post by Jeff McVeigh. Jeff McVeigh is the general manager of Performance Client and Visual Computing within Intel’s Developer Products Division. His team is responsible for the development and delivery of leading software products for performance-centric application developers spanning Android*, Windows*, and OS* X operating…

SQL SERVER – SSMS: Top Queries by CPU and IO

July 29, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Reports, SQL Server Management Studio

Let me start this blog post with a personal story. Personal Story – Dad and I My fascination for computers started way back when I was about to get into highschool. My father once took me to his office (was for some family day if I remember correctly) and it…

SQL SERVER – SSMS: Top Transaction Reports

July 28, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Reports, SQL Server, SQL Server Management Studio

Let us start with a personal story. Personal Story – My Daughter and I My day has its own part of long meetings and my daughter tries to pull a string here and there to get my attention almost every other day. And recently I was made to watch one…