Pinal Dave - SQL Server Performance Tuning Expert

SQLAuthority New – Best Practices for Speeding Up Your Web Site

January 3, 2008

Steve Souders, Chief Performance Yahoo! Best Practices for Speeding Up Your Web Site. I suggest everybody should read this basic guidelines. They are extremely important for high performance websites. 1. Make Fewer HTTP Requests 2. Use a Content Delivery Network 3. Add an Expires Header 4. Gzip Components 5. Put…

SQL SERVER – Fix : Error 15281 SQL Server blocked access to STATEMENT OpenRowset/OpenDatasource of

January 2, 2008

Pinal Dave

SQL

SQL Error Messages, SQL Server, SQL Server Security

Error 15281
Msg 15281, Level 16, State 1, Line 3
SQL Server blocked access to STATEMENT ‘OpenRowset/OpenDatasource’ of component ‘Ad Hoc Distributed Queries’ because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of ‘Ad Hoc Distributed Queries’ by using sp_configure. For more information about enabling ‘Ad Hoc Distributed Queries’, see “Surface Area Configuration” in SQL Server Books Online.

SQLAuthority New – Happy New Year 2008

January 1, 2008

Pinal Dave

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

Database, DBA, SQL Humor

Today is New Year and I wish you all Best for Year 2008. Let us all start our new year with motivational new year quote. We will open the book. Its pages are blank. We are going to put words on them ourselves. The book is called “Opportunity” and its…

SQLAuthority News – Thank You to Blog Readers

December 31, 2007

Pinal Dave

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

Database, DBA

Thank You very much for reading SQLAuthority.com for entire 2007 year. Wish you the BEST for year 2008. Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL SERVER – Remove Duplicate Characters From a String

December 30, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts, SQL String

Follow up of my previous article of Remove Duplicate Chars From String here is another great article written by Madhivanan where similar solution is suggested with alternate method of Number table approach. Check out Remove duplicate characters from a string Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL SERVER – Change Password of SA Login Using Management Studio

December 29, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Security

Login into SQL Server using Windows Authentication. In Object Explorer, open Security folder, open Logins folder. Right Click on SA account and go to Properties. Change SA password, and confirm it. Click OK. Make sure to restart the SQL Server and all its services and test new password by log…

SQL SERVER – Difference Between Quality Assurance and Quality Control – QA vs QC

December 28, 2007

Pinal Dave

SQL

Developer, Software Development, SQL Server

Regular readers of this blog are aware of my current outsourcing assignment. I am managing very large outsourcing project in India. One thing is very special in all Indian offices are “Tea Time.” Everybody wants to attend Tea Time not only for tea or coffee but for the interesting discussion occurs at that time. This is the time when all the department employees are together and discussing whatever they wish.Today there was an interesting discussion about Quality Assurance (QA) and Quality Control (QC).