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
Oct11

SQL SERVER – expressor Studio 3.4 Rules Editor – ETL Graphical Coding Tool

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Best Practices, DBA
5 Comments
New in the expressor Studio 3.4 release is the rules editor.  This graphical coding tool replaces the transform editor of earlier versions.  The rules editor works in concert with the newly introduced attribute propagation functionality to minimize the amount of data mapping and coding you need to provide.  The expressor…
Read More
Oct11

SQLAuthority News – Why I am Going to Attend PASS Summit Unite 2011 – Seattle

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL PASS
5 Comments
For the third year in a row, I am attending the SQLPASS Summit, October 11-14. Every year I have explained my reasons for attending this conference in Seattle, and this year I will state those reasons again. WHY? I have written two articles on this subject, which you can read…
Read More
Oct10

SQLAuthority News – Milestone – 1900th Post and 31 Million Views – Thank You!

Pinal Dave
SQLAuthority News
SQL Milestone, SQL Server
13 Comments

I really never thought that I would be writing this post – honestly! After 1900th post and almost 5 years, this has been a journey and lots of learning. I get to write a 100 “mile stone” post 3-4 times a year, so I am happy to be writing this one. I am eagerly looking forward to my 2000th blog post as well.

Read More
Oct9

SQLAuthority News – System Center Monitoring Pack for Microsoft SQL Server 2008 R2 Parallel Data Warehouse Appliance

Pinal Dave
SQL
Database, SQL Documentation, SQL Download
No Comments

Microsoft is continuously releasing System Center Monitoring Pack for Microsoft SQL Server 2008 R2 Parallel Data Warehouse Appliance

Read More
Oct8

SQLAuthority News – SQL Server Quiz 2011 – All was well few moments before all went wrong – Reasons and Resolutions

Pinal Dave
SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks
1 Comment
I earlier wrote about DBA Quiz at All was well few moments before all went wrong – Reasons and Resolutions. I have even announced that I will give away one print book of SQL Wait Stats book. SQL Programming Joes 2 Pros (vol 4) [Amazon] | [Flipkart]- Chapter 13 has…
Read More
Oct7

SQL SERVER – Server Side Paging in SQL Server CE (Compact Edition)

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Paging, SQL Scripts
5 Comments
SQL Server Denali is coming up with new T-SQL of Paging. I have written about the same earlier. SQL SERVER – Server Side Paging in SQL Server Denali – A Better Alternative SQL SERVER – Server Side Paging in SQL Server Denali Performance Comparison SQL SERVER – Server Side Paging…
Read More
Oct6

SQL SERVER – Detecting Database Case Sensitive Property using fn_helpcollations()

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Collation, SQL DMV, SQL Function, SQL Scripts, SQL Server
5 Comments

In my recent Office Hours, I received a question on how to determine the case sensitivity of the database. Let us learn about how we can Detecting Database Case Sensitive Property using fn_helpcollations().

Read More
Previous 1 … 555 556 557 558 559 560 561 … 829 Next
SQL SERVER - Understanding JSON NULL Value Using STRICT Keyword Sledgehammer-800x164

SQL Server – When to Use a Sledgehammer and When to use a Screwdriver

SQL SERVER - Understanding JSON NULL Value Using STRICT Keyword 3commonmistakes-800x450

GroupBy Conference – 3 Common Mistakes to Kill SQL Server Performance

SQL SERVER - Understanding JSON NULL Value Using STRICT Keyword db_stats_properties-01-800x231

SQL SERVER – Using dm_db_stats_properties With InMemory OLTP Tables

SQL SERVER - Understanding JSON NULL Value Using STRICT Keyword install-dc-02

SQL SERVER – SQL Installation fails with error code 0x851A001A – Wait on the Database Engine recovery handle failed

SQL SERVER - Understanding JSON NULL Value Using STRICT Keyword sql-repair-01-800x367

SQL SERVER – Script level upgrade for database master failed – Error: 4860, Severity: 16, State: 1 – Cannot bulk load. SqlTraceCollect.dtsx does not exist

SQL SERVER - Understanding JSON NULL Value Using STRICT Keyword Implicit-Conversion-800x390

Find All Queries with Implicit Conversion in SQL Server – Interview Question of the Week #107

SQL SERVER - Understanding JSON NULL Value Using STRICT Keyword JSON-using-strict-01-800x183

SQL SERVER – Understanding JSON NULL Value Using STRICT Keyword

Previous 1 … 555 556 557 558 559 560 561 … 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