pinaldave's profile picture. I am SQL Server Performance Tuning Expert at @SQLAuthority

Pinal Dave

@pinaldave

I am SQL Server Performance Tuning Expert at @SQLAuthority

ปักหมุด

Hello! 👋 If you like: 🛢️ SQL Server 📊 Database Management 💼 Career Tips Give me a follow. ✔ I'll be using Twitter to share valuable information you won't want to miss. 🎉


Looking for the best breakfast in #Seattle. My stomach is ready, my willpower is weak. Tell me where to go before I settle for plain toast.

pinaldave's tweet image. Looking for the best breakfast in #Seattle. My stomach is ready, my willpower is weak. Tell me where to go before I settle for plain toast.

If the Mandolorian and Captain America were in to win Madame Web, it'd definitely be an interesting movie about materialism! 🤔🎬✨ I'd watch that! 🍿


Have you ever wished your SQL Server could talk back, answering questions, explaining slow queries, or summarizing reports, all without sending a single byte of data to the cloud? That wish just came true with Ollama, a local AI engine that brings large language models like Llama…


I love helping the SQL Server community. Every week, I write blogs, record videos, answer emails, and share performance tips, all completely free. It is my way of giving back to a field that has given me so much. But every now and then, someone reaches out asking for a full SQL…

pinaldave's tweet image. I love helping the SQL Server community.

Every week, I write blogs, record videos, answer emails, and share performance tips, all completely free. It is my way of giving back to a field that has given me so much.

But every now and then, someone reaches out asking for a full SQL…

Every DBA has faced that moment when SQL Server feels like a silent partner. You look at waits like CXPACKET, WRITELOG, or RESOURCE_SEMAPHORE, run a dozen DMVs, and hope the culprit reveals itself before your coffee gets cold. Let us learn more about SQL SERVER and AI – Setting…

pinaldave's tweet image. Every DBA has faced that moment when SQL Server feels like a silent partner. You look at waits like CXPACKET, WRITELOG, or RESOURCE_SEMAPHORE, run a dozen DMVs, and hope the culprit reveals itself before your coffee gets cold. Let us learn more about SQL SERVER and AI – Setting…

🚀 I’ve successfully configured the MCP (Model Context Protocol) Server and hooked it with ChatGPT for my client. Now they can query SQL Server using natural language like: “Find top queries causing high WRITELOG waits in the last hour.” Behind the scenes: 🧩 MSSQL.MCP…

pinaldave's tweet image. 🚀 I’ve successfully configured the MCP (Model Context Protocol) Server and hooked it with ChatGPT for my client.

Now they can query SQL Server using natural language like:

“Find top queries causing high WRITELOG waits in the last hour.”

Behind the scenes:
🧩 MSSQL.MCP…

⚠️ Excel says: “This workbook contains links to one or more external sources that could be unsafe. If you trust the links, update them to get the latest data. Otherwise, you can keep working with the data you have.” 💡 Quick Tip: Press Ctrl+F, search [. External links always show…

pinaldave's tweet image. ⚠️ Excel says: “This workbook contains links to one or more external sources that could be unsafe. If you trust the links, update them to get the latest data. Otherwise, you can keep working with the data you have.”
💡 Quick Tip: Press Ctrl+F, search [. External links always show…

🚀 SQL Server Performance: JSON vs XML – The Showdown During a recent consulting engagement, I benchmarked JSON vs XML in SQL Server for real-world data integration scenarios. The results were eye-opening: ✅ Small dataset (3 rows): JSON was 9.8x faster ✅ Large dataset (1,000…


When in doubt, always SELECT the right path!

pinaldave's tweet image. When in doubt, always SELECT the right path!

CXPACKET waits are not villains. In our latest tuning story we show how 5–10 percent CXPACKET waits meant healthy parallelism. Forcing MAXDOP = 1 killed performance. Discover why in the blog blog.sqlauthority.com/2025/07/25/sql… #SQLAuthority #SQLTips #Parallelism #Database

pinaldave's tweet image. CXPACKET waits are not villains. In our latest tuning story we show how 5–10 percent CXPACKET waits meant healthy parallelism. Forcing MAXDOP = 1 killed performance. Discover why in the blog
 blog.sqlauthority.com/2025/07/25/sql…
#SQLAuthority #SQLTips #Parallelism #Database
pinaldave's tweet image. CXPACKET waits are not villains. In our latest tuning story we show how 5–10 percent CXPACKET waits meant healthy parallelism. Forcing MAXDOP = 1 killed performance. Discover why in the blog
 blog.sqlauthority.com/2025/07/25/sql…
#SQLAuthority #SQLTips #Parallelism #Database

🚀 Heading to Mumbai for a SQL Server Performance Tuning Project! I’ll be traveling to Mumbai during the last week of August and first week of September for a performance tuning engagement. If you're based in Mumbai and have been considering SQL Server Performance Tuning for…

pinaldave's tweet image. 🚀 Heading to Mumbai for a SQL Server Performance Tuning Project!
I’ll be traveling to Mumbai during the last week of August and first week of September for a performance tuning engagement.

If you're based in Mumbai and have been considering SQL Server Performance Tuning for…

I find @Pluralsight to be a fun online platform for learning new technologies. I have recently discovered some advanced SQL and PostgreSQL content. What are you learning nowadays?


Loading...

Something went wrong.


Something went wrong.