In today’s article I have combined two different questions. I was fond of SQL Server Debugger feature in SQL Server 2000. To my utter disappointment, this feature was withdrawn from SQL Server 2005. However, because of loads of requests from developers it was re-introduced in SQL Server 2008. Let us learn about how to customize toolbars.
SQL SERVER – Create Multiple Filegroup For Single Database
I am elated to receive hundreds of emails every day from my readers. My tight work schedule refrains me from answering all your questions, but I do try my best to entertain them whenever I can. Today’s post revolves around a question I received a number of times last year…
Read MoreSQL SERVER – FIX : ERROR : (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: )
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…
Read MoreSQL 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
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…
Read MoreSQLAuthority News – TechEd India 2009 – Day 3 – Product Group Meeting – Final Presentations – Meeting Friends
TechEd India 2009 has ended today and I’ve already started missing it! This three-day event was one of the best events of this year so far. I got the platform to meet best of the best people in the industry today. If I have to rate my days at TechEd…
Read MoreSQLAuthority News – TechEd India 2009 – Day 1 – Authors Tech Session – SQL Server Cheat Sheet – Meeting Great People
First day of TechEd India 2009 is over and when I recall the day I can say that it was truly a blast! This immensely huge and grand event was conducted successfully. I am having a tough time trying to recapitulate the first day as there were several different activities…
Read MoreSQL SERVER – 2008 – Management Studio New Features
Pinalkumar Dave describes the top 5 features of SQL Server Management Studio 2008. This article describes the top 5 features of SQL Server Management Studio 2008. With the release of SQL Server 2008 Microsoft has upgraded SSMS with many new features as well as added tons of new functionalities requested…
Read More