This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
SQL SERVER - Order of Hotfix and Service Pack

SQL SERVER – Order of Hotfix and Service Pack

June 6, 2009
Pinal Dave
SQL Tips and Tricks
SQL Download, SQL Service Pack

What is the right order of hotfix and service pack installs? You do not need every older service pack. Install the latest service pack and hotfix and you are done.

Read More
A red kettle whistling on the stove while someone in the next room turns to it

Sending a Microsoft Teams Alert From a SQL Server Agent Job

June 5, 2009
Pinal Dave
SQL Tips and Tricks
Database Mail, DBA, PowerShell, SQL Server Agent

Send a Teams alert from a failed SQL Server Agent job with a Workflows webhook, PowerShell, SQL Server 2025 REST calls, and mail fallback.

Read More
Table in SQL Server Management Studio.

SQL SERVER – What is Interim Table – Simple Definition of Interim Table

June 4, 2009
Pinal Dave
SQL Interview Questions and Answers
SQL Scripts

What is an interim table? A simple question started a long debate on a call with developers. Here is my simple definition of interim table.

Read More
SQL SERVER - Connect Item - Vote for Feature Request Function TRIM

SQL SERVER – Connect Item – Vote for Feature Request Function TRIM

June 3, 2009
Pinal Dave
SQL Tips and Tricks
SQL Function

SQL Server has LTRIM() and RTRIM() but no function TRIM. I asked the product team for it twice, and here is the Connect item where you can vote for it.

Read More
SQLAuthority News - Summary of TechEd India 2009 - A Grand Event

SQLAuthority News – Summary of TechEd India 2009 – A Grand Event

June 2, 2009
Pinal Dave
SQLAuthority News
MVP, TechEd

My summary of TechEd India 2009: Steve Ballmer’s keynote, a talk by the Oscar winning sound designer of Slumdog Millionaire, tech sessions and great community spirit.

Read More
SQL server filegroups query.

SQL SERVER – List All Objects Created on All Filegroups in Database

June 1, 2009
Pinal Dave
SQL Tips and Tricks
SQL Index, SQL Scripts, SQL System Table

A reader asked which object belongs to which filegroup. Here is how to list all objects created on all filegroups in a database, with a sample database.

Read More
SQL Server database properties settings.

SQL SERVER – Create Multiple Filegroup For Single Database

May 31, 2009
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server Management Studio

How to create multiple filegroup for a single database, both for a new database and an existing one, using T-SQL as well as SSMS.

Read More
Previous 1 … 28 29 30 31 32 33 34 … 55 Next
  • Books
  • Testimonials
  • Privacy Policy

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