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

SQL SERVER – Root Cause to Performance Problems – Notes from the Field #002

November 14, 2013

Notes from the Field, SQL Backup and Restore

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

SQL SERVER – Backup SQL databases to Box or SkyDrive

November 13, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

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…

MySQL – How to Write Loop in MySQL

November 12, 2013

Pinal Dave

SQL, SQL Tips and Tricks

MySQL, SQL Scripts

Since, I have written courses on MySQL, I quite often get emails about MySQL courses. Here is the question, which I have received quite often. “How do I loop queries in MySQL?” Well, currently MySQL does not allow to write loops with the help of ad-hoc SQL. You have to…

Personal Technology – Laptop Screen Blank – No Post – No BIOS – No Boot

November 10, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Humor

If your laptop Screen is Blank and there is no POST, BIOS or boot, you can follow the steps mentioned here and there are chances that it will work if there is no hardware failure inside. Step 1: Remove the power cord from the laptop Step 2: Remove the battery from…

MYSQL – Identifying Current Version of MySQL Server Installation – Part 2

November 9, 2013

Pinal Dave

SQL, SQL Tips and Tricks

MySQL, SQL Scripts

Earlier I wrote an article about Detecting Current Version of MySQL Server Installation. After the post quite a few emails I received where various users suggested that there are many more ways to figure out the version of MySQL. Here are few of the methods which I received in the…

MySQL – How to Find mysqld.exe with Command Prompt – Fix: ‘mysql’ is not recognized as an internal or external command, operable program or batch file

November 8, 2013

Pinal Dave

SQL, SQL Tips and Tricks

MySQL

One of the most popular question I get after watching my MySQL courses on Pluralsight is that beginning users are not able to find where they have installed MySQL Server. The error they receive is as follows when they type mysqld command on their default command line. ‘mysql‘ is not recognized as…

SQL SERVER – Transaction Log Full – Transaction Log Larger than Data File – Notes from the Field #001

November 7, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Backup and Restore

I am very excited to announce a new series on this blog – Notes from the Fields. I have been blogging for almost 7 years on this blog and it has been a wonderful experience. Though, I have extensive experience with SQL and Databases, it is always a good idea…