Feed on
Posts
Comments

Archive for the ‘DBA’ Category

MVP Open day 2008 is one of the best event happened so far. I have previously written about this event in detail on this blog.
SQLAuthority News - Author Visit - South Asia MVP Open Day 2008 - Goa - Link List
SQLAuthority News - Author Visit - South Asia MVP Open Day 2008 - Goa - [...]

Read Full Post »

I just received following screen shot from one of the regular reader of SQLAuthority.com blog. He pointed out important milestone for our blog. We have crossed 5 millions visitors. In less than 2 years SQLAuthority.com blog has been visited by 5 millions visitors. I even missed the anniversary our blog. On November 1st 2008 SQLAuthority.com [...]

Read Full Post »

Quite often it happens that SQL Server Management Studio’s Dropdown box is cluttered with many different SQL Server’s name. Sometime it contains the name of the server which does not exist or developer does not have access to it. It is very easy to clean the list and start over.

Delete mru.dat file from following location.
For [...]

Read Full Post »

Pro SQL Server 2005 Replication (Definitive Guide) (Hardcover)
by Sujoy Paul (Author)
Link to Amazon (This is not affiliate link)
Quick Review:
This is good book for any novice developer to start in the world of database replication implementation and maintenance. Replication is important part of highly availability and one book covers all the concept and methodology at [...]

Read Full Post »

It has been long time since I wrote about SQL Humor. Following is the cartoon sent to me by many (more than 10 times) so far by many users. I did not publish it till now as it has been quite popular and I believed many people has already seen it. However, recently by one [...]

Read Full Post »

Recently I came across two very interesting ‘objects’ of SQL Server 2008.
SQL Server 2008 High Resolution Wallpaper (click on image to see larger version)

SQL Server 2008 Screen Saver
Click Here to Download
Reference : Pinal Dave (http://www.SQLAuthority.com)

Read Full Post »

SQL Server 2008, the latest release of Microsoft SQL Server, provides a comprehensive data platform. Books Online is the primary documentation for SQL Server 2008.
Books Online includes the following types of information:

Setup and upgrade instructions.
Information about new features and backward compatibility.
Conceptual descriptions of the technologies and features in SQL Server 2008.
Procedural topics describing how to [...]

Read Full Post »

Very frequently I have been asked to create a page, post or article where in one page all the important concepts of SQL Server are covered. SQL Server 2008 is very large subject and can not be even covered 1000 of pages. In daily life of DBA there are few commands very frequently used and [...]

Read Full Post »

SQL SERVER - Guidelines and Coding Standards complete List Download
Coding standards and guidelines are very important for any developer on the path of successful career. A coding standard is a set of guidelines, rules and regulations on how to write code. Coding standards should be flexible enough or should take care of the situation where [...]

Read Full Post »

On September 20, 2008 was one of the best day so far for Ahmedabad SQL Server User Group Meeting. We had two very interesting sessions by two SQL Server MVPs. SQL Server MVP Jacob Sebastian had began the meeting with very interesting introduction note.
Along with many news Usergroup President Jacob Sebastian announced that SQL Server [...]

Read Full Post »

Today is third Saturday of the Month and every third Saturday we have Ahmedabad User Group Meeting. Our user group is growing and getting interesting. Everybody who attended last months User Group (UG) Meeting realized that how important it is to attend UG meetings. UG President Jacob Sebastian (SQL Server - MVP) presented excellent session [...]

Read Full Post »

It is always interested to write article when reached at milestone. I start to receive many emails and suggestions just about when this blog is reaching any milestone.
One question keep on coming to me is why do I write or what is in it for me?
Satisfaction! I enjoy writing and helping community and by writing [...]

Read Full Post »

I enjoy reading questions from blog readers and answering them. One of the another SQL enthusiastic is Imran who also regulalry answer questions of users on this community blog. Recently he has answered in detail about when to use Unique Index and when to use Unique Constraint.
Cristiano asked following questions :
i need to know how [...]

Read Full Post »

The Microsoft Student Partner Program is a worldwide initiative to sponsor students who are interested in technology. The program mainly focuses on improving students skills for employability, called Microsoft Student Partners (MSP).
I was recently (August 30, 2008) invited to present technical session at conference held in my City. I really enjoyed presenting the session with [...]

Read Full Post »

Microsoft SQL Server 2008 Reporting Services Report Builder 2.0 supports the full capabilities of SQL Server 2008 Reporting Services including flexible report layout, data visualizations and richly formatted text. The download includes the following functionality above the RC0 release of Report Builder:

Easy to use wizards for creating table, matrix and chart data regions.
Support for directly [...]

Read Full Post »

Thank you to all of my readers for supporting this blog. It has been wonderful journey all the way. I strongly encourage all my readers to actively contribute in discussion and writing article for blog. Today this blog has completed 4 Million visits and there are over 675 articles published on this blog.
I have been [...]

Read Full Post »

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 http://www.pinaldave.com contains section of the Tip of the Minute. Every time when page is refreshed it displays one new tip related to SQL Server.
Few of [...]

Read Full Post »

I am very pleased to announce my newly renovated website. I always liked my previous website as it was “Valid XHTML 1.1″ and “Valid CSS 2.0″. Since I become MVP last month I have been receiving many emails where people were expecting more from my personal website. My blog http://www.SQLAuthority.com and my personal website http://www.pinaldave.com [...]

Read Full Post »

SQL Server 2008, the latest release of Microsoft SQL Server, provides a comprehensive data platform. Books Online is the primary documentation for SQL Server 2008. The Help viewer used by Books Online requires the Microsoft .NET Framework version 2.0.
Books Online includes the following types of information:

Setup and upgrade instructions.
Information about new features and backward compatibility.
Conceptual [...]

Read Full Post »

It always suprise me how many people remember my birthday and take time from their busy life to call me, email me, wish me or send me their warm greetings. I would like to express my gratitude to them. Today is my birthday and I had decided to take a day off and does not [...]

Read Full Post »

Older Posts »