Blog Home Page - Page 445 of 829 - SQL Authority with Pinal Dave

Nov15

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…

Nov14

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

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

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…

Nov13

SQL SERVER – Backup SQL databases to Box or SkyDrive

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

No Comments

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…

Nov12

MySQL – How to Write Loop in MySQL

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…

Nov11

SQL – Biggest Concerns in a Data Driven World

Pinal Dave

Big Data

SQL Server, SQL Training

No Comments

The ongoing chaos over Government Agency’s snooping has ignited a heated debate on privacy of personal data and its use by government and/or other institutions. It has created a feeling of disapproval and distrust among users. This incident proves to be a lesson for companies that are looking to leverage their business using a data driven approach. According to analysts, the goal of gathering personal information should be to deliver benefits to both the parties – the user as well as the data collector(government or business).

Nov10

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

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…

Nov9

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

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…

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 14 SQL Server database books and 100 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. If you need help with any SQL Server Performance Tuning Issues, please feel free to reach out at pinal@sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).

Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future.

Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Essentially I share my business secrets to optimize SQL Server performance.

Feb 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

SQL SERVER – SQLPASS 2013, Charlotte Memories – Friends and Technology – Part 1

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

SQL SERVER – Backup SQL databases to Box or SkyDrive

MySQL – How to Write Loop in MySQL

SQL – Biggest Concerns in a Data Driven World

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

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

SQL SERVER – Monitoring SQL Server Never Got This Easy

SQL SERVER – Download RML Utilities for SQL Server

SQL SERVER – Can Database Primary File Have Any Other Extention Than MDF

SQL SERVER – Reverse String Word By Word – Part 2

SQL SERVER – Proving that the Source of the Problems aren’t Tied to the Database

SQL SERVER – Reverse String Word By Word – Part 3

SQL SERVER – Creating the SSIS Catalog – Notes from the Field #058