In this blog post we are going to fix the error which is related to Named Pipes Provider.
SQL SERVER – 2008 Katmai – Your Data, Any Place, Any Time
I was following up on the news of first Microsoft Business Intelligence (BI) Conference held at Seattle. Good news is – SQL Server 2008 code name ‘Katmai’ is announced. I went to the official website I like the catchy line “Your Data, Any Place, Any Time“. As per my opinion…
Read MoreSQL SERVER – Fix : Error 2501 : Cannot find a table or object with the name . Check the system catalog.
Error 2501 : Cannot find a table or object with the name . Check the system catalog. This is very generic error beginner DBAs or Developers faces. The solution is very simple and easy. Follow the direction below in order. Fix/Workaround/Solution: Make sure that correct Database is selected. If not…
Read MoreSQLAuthority News – Author Visit – MIS2007 Part II – Database Raid Discussion
MIS2007 is really going good. There are many things going on. As I mentioned in my previous article, It is really pleasure to meet industry leaders. There was discussion about what is good for database RAID 5 configuration or RAID 10. This subject is always very interesting. We were discussing…
Read More
SQL SERVER – Index Optimization CheckList
Index optimization is always interesting subject to me. Every time I receive requests to help optimize query or query on any specific table. I always ask Jr.DBA to go over following list first before I take a look at it. Most of the time the Query Speed is optimized just following basic rules mentioned below. Once following checklist applied interesting optimization part begins which only experiment and experience can resolve.
SQLAuthority News – Author Visit – The 2007 Marketing Innovation Summit, Las Vegas
I am attending The 2007 Marketing Innovation Summit“, Las Vegas. It started on 5/6/2007 and will continue till 5/9/2007. Unica Corporation has arranged this conference. The MIS 2007 Agenda includes: Case studies and best practices Sessions focused on Relationship Marketing, Internet Marketing and Marketing Operations Hands on “how to” sessions…
Read MoreSQL SERVER – Top 10 Hidden Gems in SQL Server 2005
Top 10 Hidden Gems in SQL Server 2005 By Cihan Biyikoglu SQL Server 2005 has hundreds of new and improved components. Some of these improvements get a lot of the spotlight. However there is another set that are the hidden gems that help us improve performance, availability or greatly simplify…
Read More