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
Jul11

SQL SERVER – 2005 – Two Important Security Update

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Download, SQL Server Security
3 Comments
If you are using SQL Server 2005, following two are very important security updates not to be missed. Security Update for SQL Server 2005 Service Pack 2 (KB948108) A security issue has been identified in the SQL Server 2005 Service Pack 2 that could allow an attacker to compromise your…
Read More
Jul10

SQL SERVER – 2008 – Introduction to SPARSE Columns

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
SPARSE Columns, SQL Data Storage, SQL Scripts
27 Comments
I have been writing recently about how SQL Server 2008 is better in terms of Data Stage and Backup Management. I have received very good replies from many users and have requested to write more about it. Today we will look into another interesting concept of SPARSE column. The reason…
Read More
Jul9

SQL SERVER – 2008 – Two Convenient Features Inline Assignment – Inline Operations

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Scripts, SQL Utility
6 Comments
Sometimes things just go very convenient and we wish that how come it was not available in earlier versions. Let us see two features here. If it was SQL Server earlier versions we might have to write more lines to achieve what we can achieve in lesser lines. Following small…
Read More
Jul8

SQL SERVER – Find Space Used For Any Particular Table

Pinal Dave
SQL Tips and Tricks
SQL Data Storage, SQL Scripts, SQL Server, SQL Stored Procedure
9 Comments

We often run out of the space in our drive and that is the number 1 cause of SQL Server engine stop running on various machines. Quite often we wonder how much space if any of the objects takes in the database. It is very simple to find out the space used by any table in the database.

Read More
Jul7

SQLAuthority News – Thank You to Awarding Author SQL MVP

Pinal Dave
Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Database, DBA, MVP
8 Comments
I received award from Microsoft for SQL Server Most Valuable Professional a week ago. I have received many many congratulations messages from many readers for getting this award. I thank all of you for sending me messages and your wishes. Honestly, I think this is all of yours award and…
Read More
Jul6

SQL SERVER – 2008 – Introduction to Row Compression

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
SQL Backup and Restore, SQL Data Storage, SQL Scripts
13 Comments
In my previous article SQL SERVER – 2008 – Introduction to New Feature of Backup Compression I wrote about Row Compression and I have received many request to write in detail about Row Compression. I like when I get request about any subject to write about from my readers. Row…
Read More
Jul5

SQL SERVER – Difference Between Database Mail and SQLMail

Pinal Dave
SQL
Database Mail, Service Broker, SQL Scripts, SQL Server Security
47 Comments

In recent user group meeting in my city Ahmedabad, I have found that not every user knows difference between these two features of SQL Server. I do not blame any user for not knowing difference between Database Mail and SQLMail as this is very confusing sometime. I will try to explain this concept here.

Read More
Previous 1 … 737 738 739 740 741 742 743 … 829 Next
SQL Azure - Add IP Address to Firewall bluetooth0-800x345

Personal Technology – Solution – Bluetooth KeyBoard and Mouse Frequently Disconnecting

SQL Azure - Add IP Address to Firewall backgroundjobs-800x189

SQL SERVER – List All Active Background Jobs

SQL Azure - Add IP Address to Firewall TempDB-Data-Files-800x248

SQL SERVER – 3 Ways to Know Count of TempDB Data Files

SQL Azure - Add IP Address to Firewall 88-IndexforQuery-yt-800x450

Identify Index Used for Query – SQL in Sixty Seconds #088

SQL Azure - Add IP Address to Firewall boostsql-800x507

SQL SERVER – Boost SQL Server Priority and SSMS 18

SQL Azure - Add IP Address to Firewall generatescript0-800x197

How to Generate Script for SQL Server 2005 from SQL Server 2019? – Interview Question of the Week #285

SQL Azure - Add IP Address to Firewall ipaddress-800x450

SQL Azure – Add IP Address to Firewall

Previous 1 … 737 738 739 740 741 742 743 … 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