SQL Tips and Tricks Archives - Page 202 of 536 - SQL Authority with Pinal Dave

SQL SERVER – Backup SQL databases to Box or SkyDrive

November 13, 2013

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…

Big Data – ClustrixDB – Extreme Scale SQL Database with Real-time Analytics, Releases Software Download – NewSQL

November 6, 2013

Pinal Dave

Big Data, SQL, SQL Server, SQL Tips and Tricks

MySQL

There are so many things to learn and there is so little time we all have. As we have little time we need to be selective to learn whatever we learn. I believe I know quite a lot of things in SQL but I still do not know what is…