January « 2009 « SQL Server Journey with SQL Authority

Archive for January, 2009

SQLAuthority News – Milestone of 6 Million Visits – 60 Lak Visits – Search and Job

Posted in About Me, Database, DBA, Pinal Dave, Readers Contribution, SQL, SQL Authority, SQL Milestone, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology on January 22, 2009 | 4 Comments »

Today SQLAuthority.com has completed 6 Million Visits. In 2 years 3 months miles stone of 6 million visits has been crossed. I want to thank all of my readers for their continuous support and help. On milestone of 6 million visits I want to announce small gratitude towards my readers who are continuously participating on [...]

Read Full Post »

SQLAuthority News – SQLAuthority News – Ahmedabad User Group Meeting January 17 2009 – Review

Posted in MVP, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQL User Group, SQLAuthority Author Visit, SQLAuthority News, T SQL, Technology on January 21, 2009 | 5 Comments »

User Group Meeting is the the event I always wait during whole month. User Group meetings are the place where we can meet various people from all around the city and expand our networking. Meeting new people and exchanging new tips and tricks is always interesting. For year 2009 we had our first User Group [...]

Read Full Post »

SQL SERVER – Rules for Optimizining Any Query – Best Practices for Query Optimization

Posted in Best Practices, Pinal Dave, SQL, SQL Authority, SQL Optimization, SQL Performance, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on January 20, 2009 | 31 Comments »

This subject is very deep subject but today we will see it very quickly and most important points. May be following up on few of the points of this point will help users to right away improve the performance of query. In this article I am not focusing on in depth analysis of database but [...]

Read Full Post »

SQLAuthority News – CWE/SANS TOP 25 Most Dangerous Programming Errors

Posted in SQL, SQL Authority, SQL Documentation, SQL Error Messages, SQL Performance, SQL Query, SQL Security, SQL Server, SQL Tips and Tricks, SQLAuthority News, SQLAuthority Website Review, T SQL, Technology on January 19, 2009 | 3 Comments »

I just came across very interesting article from SANS Institute. Experts from more than 30 US and international cyber security organizations have released list of 25 most dangerous programming errors and their resolution. It may be possible that many of the programmers may not understand what this errors are and how to implement their solution. [...]

Read Full Post »

SQL SERVER – Difference Between Index Scan and Index Seek

Posted in Pinal Dave, SQL, SQL Authority, SQL Index, SQL Performance, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on January 18, 2009 | 30 Comments »

I have explained the concept of Index Scan and Index Seek earlier but I keep on receiving the same question again and again. Let us today look into it with little more depth. Before we go over the concept of scan and seek we need to understand what SQL Server does before applying any kind [...]

Read Full Post »

« Newer Posts - Older Posts »