Feb 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
Dec13

MySQL – How to Create Stored Procedure

Pinal Dave
SQL, SQL Tips and Tricks
MySQL, SQL Scripts
2 Comments
If you are beginner with MySQL, you will face this particular issue while creating Stored Procedure. When I started with MySQL I had faced the similar situation as well. In MySQL we end every statement with semicolon. However, when we try to create stored procedure we face dilemmas that how…
Read More
Dec12

SQL SERVER – Optimal Memory Settings for SQL Server – Notes from the Field #006

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Notes from the Field, SQL Backup and Restore
5 Comments
[Notes from Pinal]: Quite often we hear that my SQL Server is taking more memory or my server needs more memory as all the applications are running slow. The reality is that no matter how much memory you have it is never going to be enough. We all want more…
Read More
Dec11

SQL Reporting – How to Add Excel and Word Reporting to Your Own Application – An Innovative Approach

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Reports, SSRS
1 Comment
To experience the awesomeness of OfficeWriter, I suggest you here to download the tool and work along with this blog post. The OfficeWriter API is a .NET library by SoftArtisans that makes it easy for developers to add Excel and Word reporting and document processing to their own applications. OfficeWriter…
Read More
Dec10

SQL SERVER – Working with Business Days in SQL Server – A Different Approach

Pinal Dave
SQL
Excel, SQL Scripts, SQL Server
6 Comments

I recommend that you download XLeratorDB and try this problem along with me, this is going to be a fun exercise and something new to learn about Business Days.

Read More
Dec9

SQL SERVER – How to Allow Only Alphabets in Column – Create Check Constraint to Insert Only Alphabets

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
11 Comments
Here is the question I just received in email. “Pinal, I searched your blog at https://blog.sqlauthority.com/search-sqlauthority/ but I could not find a solution to my problem. I have a column where I only want to allow alphabets. If anyone wants to insert number or any other value in that table,…
Read More
Dec8

SQLAuthority News – Notes from SQLLive 360 – Orlando, Nov 2013 – A Great Experience

Pinal Dave
Personal, SQL, SQL Server, SQL Tips and Tricks
SQLAuthority Author Visit
No Comments
Earlier I wrote about my 3 technical session at SQL Live in the event at Orlando, Florida in Nov19-20, 2013. I had a great time presenting at the SQL Live event. I presented following three sessions at the event Presenting 3 Session at SQL Server Live, Orlando, Florida. SQT10 “What…
Read More
Dec7

Personal Technology – How to do Exercise and Stay Relaxed while in Office – Tips for Developers

Pinal Dave
Personal, SQL, SQL Server, SQL Tips and Tricks
Personal Technology
6 Comments
While the modern day worker is usually no longer subjected to 10, 12, or 20 hour shifts, and can look forward to much more pleasant working conditions, modern office life has its own fair share of health and safety concerns. For example, sitting at a desk and staring at a…
Read More
Previous 1 … 438 439 440 441 442 443 444 … 829 Next

SQL SERVER – Fix – Msg 230, Level 14, State 1 – The SELECT permission was denied on the column of the object , database , schema

SQL SERVER – How to Chang Audit Location?

SQL SERVER – Restricting Access to Contained Databases using Logon Triggers

SQL SERVER – SQLCMD to Build Comma Separated String

SQL SERVER – Is tempDB behaving like a Normal DB?

SQL SERVER - Fix : Msg 230, Level 14, State 1 - The SELECT permission was denied on the object, database, schema - Part II KevinHazzard

SQL SERVER – Common Sense Data Security – Notes from the Field #055

SQL SERVER – Fix : Msg 230, Level 14, State 1 – The SELECT permission was denied on the object, database, schema – Part II

Previous 1 … 438 439 440 441 442 443 444 … 829 Next

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.


Comprehensive Database Performance Health Check

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.


SQL Server Performance Tuning Practical Workshop

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.

  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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