All Articles - SQL Authority with Pinal Dave

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

August 23, 2008

Today in this article I would discuss about the Database Mail which is used to send the Email using SQL Server. Previously I had discussed about SQL SERVER – Difference Between Database Mail and SQLMail. Database mail is the replacement of the SQLMail with many enhancements. So one should stop using…

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

August 22, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

I had previously written SQL SERVER – UDF – Function to Convert Text String to Title Case – Proper Case and I had really enjoyed writing it. Above script converts first letter of each word from sentence to upper case. For example this function will convert this string to title…

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

August 21, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Scripts, SQL Server DBCC, SQL Server Security, SQL Stored Procedure

Imran Mohammed continues to help community of SQL Server with his very enthusiastic writing and deep understanding of SQL Server architecture. Let us read what Imran has to say about how Transaction Log works and Shrinking of Log works. Question from lauraV Please help me understand. I am taking a…

SQLAuthority News – Microsoft SQL Server Management Pack for Microsoft Operations Manager 2005

August 21, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Download, SQL Server Security

Note: Download Microsoft Operations Manager 2005 by Microsoft The Microsoft SQL Server Management Pack provides both proactive and reactive monitoring of SQL Server 2008, 2005 and SQL Server 2000 in an enterprise environment. Availability and configuration monitoring, performance data collection, and default thresholds are built for enterprise-level monitoring. Both local…

SQLAuthority News – Find Your IP Address – What Is My IP Address

August 20, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

While developing often my developers need to know which IP address is of local network when looked from outside. I am working in large outsourcing company and we have local intranet setup. When connecting to remote servers from local system or from remote servers to local system we always want…

SQL SERVER – Disable All the Trigger of Current Database

August 19, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Trigger

I have previously written article about SQL SERVER – Disable All Triggers on a Database – Disable All Triggers on All Servers. This is alternate method to achieve the same task. Following article is sent by Manish Kaushik. I recommend all of you to read original article along with this…

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

August 18, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Scripts, SQL Server Security, SQL Transactions

Loyal reader of this blog and “Great SQL Expert” Imran Mohammed always have good attitude towards any problem. Many times his answers very interesting to read and details are very accurate. I came across his two interesting comment on this blog and I would like to share this all of…

SQL SERVER – 2005 – Best Practices Analyzer (August 2008)

August 17, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Download, SQL Server Security, SQL Utility

The SQL Server 2005 Best Practices Analyzer (BPA) gathers data from Microsoft Windows and SQL Server configuration settings. BPA uses a predefined list of SQL Server 2005 recommendations and best practices to determine if there are potential issues in the database environment. This download is the August 2008 release of…

SQL SERVER – XML – Split a Delimited String – Generate a Delimited String

August 17, 2008

Pinal Dave

SQL Tips and Tricks

Best Practices, MVP, SQL Scripts, SQL Server, SQL Stored Procedure, SQL XML

SQL Server MVP and my very good friend Jacob Sebastian has written two wonderful articles about SQL Server and XML. I encourage to read this two articles to anybody who are interested in learning SQL and XML. Let us see how to Split a Delimited String.

SQLAuthority News – Tip of the Minute

August 16, 2008

Pinal Dave

Personal, SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Best Practices, Database, DBA

Since my new personal website is launched I have received many comments and emails regarding new section of Tip of the Minute. Right navigation bar of the my personal website https://www.pinaldave.com/ contains section of the Tip of the Minute. Every time when page is refreshed it displays one new tip…