Named Pipes Provider error 40, could not open a connection to SQL Server, hit me after I rebuilt my home network. Here are the common errors and the fix.
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
SSMS says saving changes is not permitted when a table must be re-created. Learn to turn off Prevent saving changes, and why I still prefer T-SQL.
SQLAuthority News – TechEd India 2009 – Day 3 – Product Group Meeting – Final Presentations – Meeting Friends
TechEd India 2009 has ended. Day 3 was the best, with a meeting with the SQL Server product group under NDA, final presentations and time with friends.
SQLAuthority News – TechEd India 2009 – Day 1 – Authors Tech Session – SQL Server Cheat Sheet – Meeting Great People
The first day of TechEd India 2009 was a blast: Steve Ballmer’s keynote, my tech session with the SQL Server cheat sheet, and meeting great people.
SQL SERVER – IntelliSense Does Not Work – Enable IntelliSense
IntelliSense in SQL Server 2008 not showing suggestions? Four ways to Enable IntelliSense, starting with connecting to a 2008 instance and checking Tools, Options.
SQL SERVER – Start SQL Server Instance in Single User Mode
How to start a SQL Server instance in single user mode: add the -m; startup parameter in SQL Server Configuration Manager and restart the service.
SQL SERVER – 2008 – Change Color of Status Bar of SSMS Query Editor
Change the color of status bar in SSMS 2008 for each server, so a query meant for development never runs on production by mistake. Step by step with images.