May « 2009 « SQL Server Journey with SQL Authority

Archive for May, 2009

SQL SERVER – FIX : ERROR : (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: )

Posted in Pinal Dave, SQL, SQL Authority, SQL Error Messages, SQL Query, SQL Scripts, SQL Server, SQL Server Management Studio, SQL Tips and Tricks, T SQL, Technology on May 21, 2009 | 353 Comments »

Regular readers of my blog are aware of the fact that I have written about this subject umpteen times earlier, and every time I have spoken about a new issue related to it. Few days ago, I had redone my local home network. I have LAN setup with wireless router connected with my four computers, [...]

Read Full Post »

SQL Server – Download PDF SQL Server Cheat Sheet

Posted in Database, DBA, MVP, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQL User Group, SQLServer, T SQL, Technology on May 20, 2009 | 11 Comments »

I had a gala time at TechEd India 2009 event! Meeting with great people is an experience of a lifetime. My session was well attended and well appreciated, which also gives me another reason to feel happy. Moreover, my SQL Server Cheat Sheet gained unpredicted popularity at the event. Let me share with you all [...]

Read Full Post »

SQLAuthority News – SQL Server Energy Event – Mark Your Calendar – May 20, 2009

Posted in Business Intelligence, MVP, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQL User Group, SQLAuthority Author Visit, SQLAuthority News, SQLServer, T SQL, Technology, tagged DigiCorp on May 19, 2009 | 3 Comments »

I am very excited to share this news with all my readers. If you all remember I had already given a hint on my blog just two days back; I mentioned that we are going to host a grand event for Gandhinagar SQL Server User Group. In the past, Gandhinagar SQL Server User Group events [...]

Read Full Post »

SQL SERVER – Fix : Management Studio Error : Saving Changes in not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can’t be re-created or enabled the option Prevent saving changes that require the table to be re-created

Posted in Database, Pinal Dave, SQL, SQL Authority, SQL Error Messages, SQL Query, SQL Scripts, SQL Server, SQL Server Management Studio, SQL Tips and Tricks, SQLServer, T SQL, Technology on May 18, 2009 | 24 Comments »

Today, we will delve into a very simple issue that one of the Jr. Developers at my organization confronted. I have a preference for T-SQL. According to me, all the developers should always use T-SQL instead of Design feature of SQL Server Management Studio (SSMS). In fact, sound knowledge of T-SQL has the potential to [...]

Read Full Post »

SQLAuthority News – Gandhinagar SQL Server User Group Meeting – International Speaker Visiting

It is my pleasure to announce Gandhinagar SQL Server User Group Meeting on May 20, 2009 Wednesday. Mark this date as we will be having international speaker Rushabh Mehta of SolidQ attending our session. Rushabh Mehta is a Mentor for Solid Quality Mentors’ global Business Intelligence division, based in USA, and is also the Managing [...]

Read Full Post »

« Newer Posts - Older Posts »