All Articles - SQL Authority with Pinal Dave

SQL SERVER – Shrinking NDF and MDF Files – A Safe Operation

January 25, 2009

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

SQL Data Storage, SQL Scripts, SQL Server DBCC, SQL Server Security

Just a day ago I have received following email from Siddhi and I found it interesting so I am sharing with all of you. Hello Pinal, I have seen many blogs from you on SQL server and i have always found them useful and easy to understand. Thanks for all…

SQLAuthority News – Download Microsoft SQL Server 2005 Data Mining Add-ins for Microsoft Office 2007

January 24, 2009

Pinal Dave

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

Database, SQL Download

Note: Download Microsoft SQL Server 2005 Data Mining Add-ins for Microsoft Office 2007 by Microsoft Microsoft SQL Server 2005 Data Mining Add-ins for Microsoft Office 2007 (Data Mining Add-ins) allow you take advantage of SQL Server 2005 predictive analytics in Office Excel 2007 and Office Visio 2007. The download includes…

SQL SERVER – 2008 – 2005 – Find Longest Running Query – TSQL – Part 2

January 23, 2009

Pinal Dave

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

Best Practices, SQL Scripts, SQL Server DBCC, SQL System Table

Just another day I was playing with my query which I posted earlier SQL SERVER – 2008 – 2005 – Find Longest Running Query – TSQL and I found that I got error devide by zero. I have fixed this error in following query as well I have updated query…

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

January 22, 2009

Pinal Dave

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

Database, DBA

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…

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

January 21, 2009

Pinal Dave

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

MVP, SQL User Group, SQLAuthority Author Visit

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…

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

January 20, 2009

Pinal Dave

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

Best Practices, SQL Scripts

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…

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

January 19, 2009

Pinal Dave

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

SQL Error Messages, SQL Server Security

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…

SQL SERVER – Difference Between Index Scan and Index Seek

January 18, 2009

Pinal Dave

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

SQL Index, SQL Scripts

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…

SQLAuthority News – Download Microsoft SQL Server Protocol Documentation

January 17, 2009

Pinal Dave

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

SQL Download

he Microsoft SQL Server protocol documentation provides detailed technical specifications for Microsoft proprietary protocols (including extensions to industry-standard or other published protocols) that are implemented and used in Microsoft SQL Server to interoperate or communicate with Microsoft products. The documentation includes a set of companion overview and reference documents that…

SQLAuthority News – Ahmedabad User Group Meeting January 17 2009

January 16, 2009

Pinal Dave

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

MVP, SQL User Group

It is my pleasure to announce that SQL Server User Group Meeting is held on January 17, 2009. This is the first meeting of year 2009 and will be one interesting meeting as we will have back to back three presentation from SQL Experts. The agenda of meeting will be…