Jun 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
  • Hire Me
  • Health Check
Apr18

SQL SERVER – Generate Foreign Key Scripts For Database

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Constraint and Keys
14 Comments
Regular reader of SQLAuthority.com blog Madhaiyan Seenivasan has send email with one very interesting script. This script generates all the foreign key addition script for your database. Many times there are situations where one need to drop all the foreign key and add them back. This SQL Script can be…
Read More
Apr17

SQLAuthority News – My Favorite Link of This Blog

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
1 Comment
I have written more than 500 article on this blog so far and the number is increasing. Many times I get this question, which one link do I click the most. It is very interesting for myself to read my previous articles, as I often like to read them and…
Read More
Apr16

SQL SERVER – 2008 – Row Constructors – Load Temp Tables From Stored Procedures

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Scripts, SQL Stored Procedure
7 Comments
While playing with SQL Server 2008 I found new feature of “Row Constructors”, where I can load temp table from stored procedure directly. Look at the following SQL where I have to use OpenQuery from server to itself creating loopback server and execute stored procedure and insert into temp table.…
Read More
Apr15

SQL SERVER – Surface Area Configuration Tools Reduce Exposure To Security Risks

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
Database, SQL Server Management Studio
No Comments
Read my article published at SQL Server Magazine Surface Area Configuration Tools Reduce Exposure To Security Risks [Articles are relocated so links are disabled] Reference : Pinal Dave (https://blog.sqlauthority.com)
Read More
Apr14

SQL SERVER – SQL Slammer (Computer Worm)

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Download, SQL Server Security
2 Comments
Just a day ago, while talking with my outsourcing team one of the DBA asked me question. Is there any virus associated with SQL Server? I really find this question very interesting as I did not know if there are any viruses associated with SQL Server. I searched Google for…
Read More
Apr13

SQL SERVER – 2008 – Important Resources

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Database, SQL Download
No Comments
In one of the recent public speaking event I was asked if I can list some important resources of SQL Server 2008. I promised that I will post the links on my blog. Here are Important Resources for SQL Server 2008. Learn more about data programmability http://www.microsoft.com/sql/2008/technologies/dataprogrammability.mspx Learn more about…
Read More
Apr12

SQL SERVER – 2008 – Download Presentation and Whitepapers

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Download, SQL White Papers
No Comments
SQL Server 2008 Manageability Learn about the new manageability improvements in SQL server 2008 that enables you to administer, monitor and maintain your data platform infrastructure while reducing the time and cost of management. This session provides an overview of the new manageability improvements that enables you to manage the…
Read More
Previous 1 … 751 752 753 754 755 756 757 … 831 Next

SQL SERVER – Generate Foreign Key Scripts For Database

SQLAuthority News – My Favorite Link of This Blog

SQL SERVER – 2008 – Row Constructors – Load Temp Tables From Stored Procedures

SQL SERVER – Surface Area Configuration Tools Reduce Exposure To Security Risks

SQL SERVER – SQL Slammer (Computer Worm)

SQL SERVER – 2008 – Important Resources

SQL SERVER – 2008 – Download Presentation and Whitepapers

Previous 1 … 751 752 753 754 755 756 757 … 831 Next

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.

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