All Articles - SQL Authority with Pinal Dave

SQLAuthority Author Visit – Ahmedabad SQL Server User Group Meeting – July 19 2008

July 21, 2008

Best Practices, MVP, SQL Download, SQL User Group, SQLAuthority Author Visit

Ahmedabad SQL Server User Group is just 2 months old chapter but it is getting extremely popular among enthusiastic IT professionals. I have joined this group and suggest all the developers of Ahmedabad and surrounding areas to join this group. It does not matter which application you are using but…

SQL SERVER – Change the Port of Service Broker Configuration

July 20, 2008

Pinal Dave

SQL Tips and Tricks

Service Broker, SQL Scripts, SQL Server

Just two days ago, I wrote a small note about SQL SERVER – Introduction to Service Broker.

SQL Server – Fix – Error : 9692 The _MSG protocol transport cannot listen on port because it is in use by another process.

July 19, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Service Broker, SQL Error Messages, SQL Scripts

If you face following error the solution of this is very simple. Error : 9692 The _MSG protocol transport cannot listen on port because it is in use by another process. Above error comes up with Service Broker. Service Broker is used to send Database Emails. Read more about SQL…

SQL SERVER – Introduction to Service Broker

July 18, 2008

Pinal Dave

SQL

Database Mail, Service Broker, SQL Server

Service Broker is message queuing for SQL Server. It is used for sending emails and through Database Mails. You can read about SQL SERVER – Difference Between Database Mail and SQLMail here. Service Broker is feature which provides facility to SQL Server to send an asynchronous, transactional message.

SQLAuthority News – Updated My Personal Book Mark Pages

July 18, 2008

Pinal Dave

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

Database, DBA

It has been long time since I have updated my personal book mark list. I have just refreshed it. You are all welcome to checkout my personally picked articles. SQLAuthority Best Articles SQLAuthority Favorite Articles I often visit above two links to read my selected articles. If you have any…

SQLAuthority News – Ahmedabad SQL Server Usergroup Meeting

July 17, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MVP, SQL User Group, SQLAuthority Author Visit

I will be attending Ahmedabad SQL Server Usergroup Meeting on July 19, 2008. I will be taking session about “SQL Server Best Practices“. I invite all of the SQL enthusiastic to stop by User Group Meeting and meet all the fellow developers, DBAs and members. Location : 401, TIME SQUARE,…

SQL SERVER – Readers Contribution to Site – Simple Example of Cursor

July 16, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Cursor, SQL Scripts

eaders are very important to me. Without their active participation this site would not be the community helping web site. I encourage readers participation and request that you help other users with your knowledge. I recently come across very good communication between two of blog readers. I want to thank…

SQL SERVER – Deferred Name Resolution

July 15, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Scripts

One of my Jr. Developer always wondered when she creates any Stored Procedure (SP) and if there is incorrect table name in the SP it creates the SP fine but while executing it gives run time error. However, if there is any valid table from database is referenced in SP…

SQL SERVER – 2008 – Introduction to SPARSE Columns – Part 2

July 14, 2008

Pinal Dave

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

SPARSE Columns, SQL Data Storage

Previously I wrote about SQL SERVER – 2008 – Introduction to SPARSE Columns. Let us understand the concept of SPARSE column in more detail. I suggest you read the first part before continuing reading this article. All SPARSE columns are stored as one XML column in database. Let us see…

SQL SERVER – SP_CONFIGURE – Displays or Changes Global Configuration Settings

July 13, 2008

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server, SQL Server Configuration, SQL Server Security

It is very good to know our server and its feature which are available for configurations. SQL Server always has many features which can be enabled or disabled. One should at least know what are the options SQL Server provides. This blog post we will learn how to display or change global configuration settings.