This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Great Indian Developers Summit 2014 poster.

SQLAuthority News – Great Time Spent at Great Indian Developers Summit 2014

May 9, 2014
Pinal Dave
SQLAuthority News
GIDS, MySQL, SQLAuthority Author Visit

A thank you note after my four sessions at Great Indian Developers Summit 2014 in Bangalore, with standing room crowds and big interest in SQL Server.

Read More
MySQL - How to Create Stored Procedure in MySQL

MySQL – How to Create Stored Procedure in MySQL

May 2, 2014
Pinal Dave
SQL Tips and Tricks
MySQL, SQL Stored Procedure

MySQL supports stored procedures for your business logic. Here is how to create a stored procedure in MySQL and execute it, with a simple sales example.

Read More
Cartoon depicting friendship and indexes in SQL Server.

SQL SERVER – Presenting 4 Technology Sessions at Great Indian Developer 2014 – Contest

April 21, 2014
Pinal Dave
SQL Performance
GIDS, MySQL

I am presenting four very different sessions at the Great Indian Developer Conference (GIDS) in Bangalore, April 22 to 25, 2014. Here are the details.

Read More
Developers - Drive by Daniel Pink - Book Review

Developers – Drive by Daniel Pink – Book Review

April 19, 2014
Pinal Dave
Personal
MySQL, SQLAuthority Book Review

My review of Drive by Daniel Pink, a book about what really motivates us and which work suits us best, with a few favorite quotes and a book giveaway.

Read More
MySQL - Finding First day and Last day of a Month

MySQL – Finding First day and Last day of a Month

April 9, 2014
Pinal Dave
SQL Tips and Tricks
MySQL, SQL DateTime

MySQL has LAST_DAY to find the last day of a month but nothing built in for the first day. I show two simple methods to find the first day as well.

Read More
MySQL - List User Defined Tables - Two Methods

MySQL – List User Defined Tables – Two Methods

April 1, 2014
Pinal Dave
SQL Tips and Tricks
MySQL, SQL Scripts, SQL Server, SQL System Table

There are different methods to list out user defined tables in MySQL. We will see two methods in this post.

Let us create the following tables in the database named Test

Read More
MySQL - Generate Script for a Table Using SQL

MySQL – Generate Script for a Table Using SQL

March 28, 2014
Pinal Dave
SQL Tips and Tricks
MySQL

SQL Server needs SSMS to build a CREATE TABLE script, but MySQL can do it in SQL. Here is how SHOW CREATE TABLE returns the script for a table.

Read More
Previous 1 … 7 8 9 10 11 12 13 … 17 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com