Blog Home Page - Page 422 of 831 - SQL Authority with Pinal Dave

May2

MySQL supports Stored Procedures which can execute set of codes by applying relevant business logics. In this post we will see how to create a stored procedure and execute it. Let us create the following tables CREATE TABLE items(item_id INT, item_description VARCHAR(100)); CREATE TABLE sales(sales_id INT auto_increment KEY,item_id INT, sales_date…

May1

SQL SERVER – Good Value for Page Life Expectancy – Notes from the Field #026

Pinal Dave

SQL Tips and Tricks

Notes from the Field, SQL Memory, SQL Server

[Notes from Pinal]: In the past, I have been wrong many times, but I was man enough to accept my mistakes and correct myself. Page Life Expectancy is a very similar subject for me. In the past when I had written a blog post based on Microsoft’s white paper, I was corrected by SQL Experts immediately for my error in judgment and incorrect information. I accepted my mistakes and corrected it. I just shared this story with my good friend Tim Radney and he was very kind to give me guidance on this subject. I asked him if he can write further on this topic and help people understand this complex subject in simple words.

May1

SQL SERVER – Synchronize Data Exclusively with T-SQL

Pinal Dave

SQL

Devart

Database developers often face the task to synchronize users’ data. Currently, to solve this task, there was developed quite a big number of various utilities. In this article, we will review the process of creating the new functionality to synchronize data exclusively with T-SQL.

Apr30

SQL SERVER – Faster Application Performance with In-Memory OLTP

Pinal Dave

SQL

Safepeak, SQL Server

Today, I’d like to examine how in-memory OLTP engines to vastly improve performance and scalability of SQL Server databases and to accelerate applications. A very large part of this article focuses specifically on SQL Server 2014 and its new In-Memory OLTP capabilities.

Apr29

SQL SERVER – Optimizing Three Important Resources – CPU, Memory and Disk

Pinal Dave

SQL Video

Dell, SQL Server

For any DBA there are three most important resources – CPU, Memory and Disk. Here is a real life story just happened recently which discusses CPU, Memory & Disk along with a new manager and frustrated employee. Well, thanks to Dell Software’s Spotlight on SQL Server Enteprise, the story has a happy ending. Trust me, you will enjoy this mini story, so continue reading.

Apr28

SQLAuthority News – An Amazing Event – Presented at North India’s Largest Conference C Sharp Corner

Pinal Dave

SQL Tips and Tricks

C Sharp Corner, SQL User Group, SQLAuthority Author Visit

There are few feelings which are hard to describe in words as this note is about an amazing event on the C Sharp Corner.

Apr27

SQLAuthority News – Two Microsoft Whitepaper on In-Memory OLTP

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Earlier this week, I was presenting at Great Indian Developer Summit in Bangalore. Lots of people were interested in the subject of In-Memory OLTP database. Everybody wanted to know how to do, use the new features of In-Memory OLTP feature. Microsoft has recently released two white paper which discusses about…

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 24 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 109 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.

Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.

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.

Jun 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

MySQL – How to Create Stored Procedure in MySQL

SQL SERVER – Good Value for Page Life Expectancy – Notes from the Field #026

SQL SERVER – Synchronize Data Exclusively with T-SQL

SQL SERVER – Faster Application Performance with In-Memory OLTP

SQL SERVER – Optimizing Three Important Resources – CPU, Memory and Disk

SQLAuthority News – An Amazing Event – Presented at North India’s Largest Conference C Sharp Corner

SQLAuthority News – Two Microsoft Whitepaper on In-Memory OLTP

MySQL – How to Create Stored Procedure in MySQL

SQL SERVER – Good Value for Page Life Expectancy – Notes from the Field #026

SQL SERVER – Synchronize Data Exclusively with T-SQL

SQL SERVER – Faster Application Performance with In-Memory OLTP

SQL SERVER – Optimizing Three Important Resources – CPU, Memory and Disk

SQLAuthority News – An Amazing Event – Presented at North India’s Largest Conference C Sharp Corner

SQLAuthority News – Two Microsoft Whitepaper on In-Memory OLTP