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 - Size of Index Table for Each Index - Solution 3 - Powershell Index Size

SQL SERVER – Size of Index Table for Each Index – Solution 3 – Powershell Index Size

May 10, 2010
Pinal Dave
SQL Performance
PowerShell, SQL Index, SQL Scripts, SQL Server

Laerte Junior fixed my Powershell setup remotely in minutes and sent solution 3 to my puzzle on the size of each index. Here is his Powershell Index Size answer.

Read More
A pottery kiln working on its own in an empty studio at night

Installing SQL Server Silently From the Command Line

April 25, 2010
Pinal Dave
SQL Tips and Tricks
Command Line, DBA, PowerShell, SQL Server Installation, SQL Setup

Installing SQL Server silently takes a reviewed ConfigurationFile.ini, required setup switches, and a check of logs and active instance settings.

Read More
Gloved hands lifting a honeycomb frame from a stacked wooden beehive in a meadow, smoke drifting nearby

What Is Installed? Finding Every SQL Server Component

November 28, 2009
Pinal Dave
SQL Tips and Tricks
PowerShell, SQL Server, SQL Server Installation, SQL Server Services

Finding every SQL Server component starts with the Setup discovery report, then checks services, engine versions, and separate client tools.

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
Configure and reconfigure options.

SQL SERVER – Enable xp_cmdshell using sp_configure

April 26, 2007
Pinal Dave
SQL Tips and Tricks
PowerShell, SQL Scripts, SQL Server, SQL Server Configuration, SQL Server Security, SQL Stored Procedure, SQL Utility

Enable xp_cmdshell with sp_configure: turn on show advanced options, set xp_cmdshell to 1 and run RECONFIGURE. The full script is ready to run in SSMS.

Read More
Previous 1 … 6 7 8 9
  • Books
  • Testimonials
  • Privacy Policy

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