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
Mail Configuration Wizard.

SQL SERVER – 2008 – Configure Database Mail – Send Email From SQL Database

August 23, 2008
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Utility

Configure Database Mail in SQL Server 2008 in three steps: create a profile and account, configure email, then send email. Video and screenshots included.

Read More
SQL Server Management Studio query window for Adventure Works database.

SQL SERVER – UDF – Function to Convert Text String to Title Case – Proper Case – Part 2

August 22, 2008
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts

Part 2 on Proper Case in SQL Server: a quick script that makes only the first letter of a sentence upper case, and how to do it for a table column.

Read More
SQL SERVER - Behind the Scene of SQL Server Activity of - Transaction Log - Shrinking Log

SQL SERVER – Behind the Scene of SQL Server Activity of – Transaction Log – Shrinking Log

August 21, 2008
Pinal Dave
SQL Performance
SQL Backup and Restore, SQL Scripts, SQL Server DBCC, SQL Server Security, SQL Stored Procedure

Why does an LDF file keep growing even with hourly log backups? Imran Mohammed explains what goes on behind the scene of the Transaction Log and shrinking.

Read More
SQL SERVER - Disable All the Trigger of Current Database

SQL SERVER – Disable All the Trigger of Current Database

August 19, 2008
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Trigger

Another way to disable all the trigger objects in the current database: a stored procedure by Manish Kaushik that loops over each table and disables them.

Read More
SQL SERVER - Detailed Explanation of Transaction Lock, Lock Type, Avoid Locks

SQL SERVER – Detailed Explanation of Transaction Lock, Lock Type, Avoid Locks

August 18, 2008
Pinal Dave
SQL Performance
SQL Error Messages, SQL Scripts, SQL Server Security, SQL Transactions

How do you find which table has a transaction lock and what lock type it is? Imran Mohammed explains it for SQL Server 2000 and 2005, and how to avoid locks.

Read More
Seven smooth stones on a wooden tray beside a sage bowl, with one stone tied in red ribbon and a pale folded cloth.

Stable Weekday Numbers Without Changing DATEFIRST

August 17, 2008
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Scripts

Stable weekday numbers use a fixed Monday anchor and negative-safe modulo. Map Monday to one without changing DATEFIRST or session language.

Read More
A long string of bunting laid out on a village green while two hands check the last knot

Generating Backup Commands for Every Database With STRING_AGG

August 17, 2008
Pinal Dave
SQL Tips and Tricks
DBA, SQL Backup and Restore, SQL Scripts, SQL String

Use STRING_AGG for generating backup commands with copy-only backups, checksums, safe database names, and dated files for careful review.

Read More
Previous 1 … 303 304 305 306 307 308 309 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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