http://sqlblog.com/blogs/paul_nielsen/archive/tags/Team+System+for+DB+Professionals/default.aspxTags: Team System for DB ProfessionalsenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/paul_nielsen/archive/2007/04/02/my-biggest-sql-server-pet-peeves.aspxMon, 02 Apr 2007 20:25:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:1075Paul Nielsen15http://sqlblog.com/blogs/paul_nielsen/comments/1075.aspxhttp://sqlblog.com/blogs/paul_nielsen/commentrss.aspx?PostID=1075<P class=MsoListParagraphCxSpFirst style="MARGIN:0in 0in 0pt 0.5in;TEXT-INDENT:-0.25in;mso-list:l0 level1 lfo1;"><SPAN style="mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin;"><SPAN style="mso-list:Ignore;"><FONT face=Calibri size=3>1)</FONT><SPAN style="FONT:7pt 'Times New Roman';">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></SPAN></SPAN><FONT face=Calibri size=3>Team System for DB Professionals runs only in Visual Studio. </FONT></P> <P class=MsoListParagraphCxSpLast style="MARGIN:0in 0in 10pt 0.5in;TEXT-INDENT:-0.25in;mso-list:l0 level1 lfo1;"><SPAN style="mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin;"><SPAN style="mso-list:Ignore;"><FONT face=Calibri size=3>2)</FONT><SPAN style="FONT:7pt 'Times New Roman';">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></SPAN></SPAN><FONT face=Calibri size=3>Stored Procedure Debugging is only available in Visual Studio</FONT></P> <P class=MsoNormal style="MARGIN:0in 0in 10pt;"><FONT face=Calibri size=3>Both of these facts bother me because together they point to a trend to move database development from the database professional to the application developer. </FONT></P> <P class=MsoNormal style="MARGIN:0in 0in 10pt;"><FONT size=3><FONT face=Calibri>The primary tool of the SQL Server database professional&nbsp;is Management Studio and the primary language of SQL Server database development is T-SQL. For these two reasons, both stored procedure debugging and Data Dude belong in Management Studio first and Visual Studio only as a secondary option. <SPAN style="mso-spacerun:yes;">&nbsp;</SPAN></FONT></FONT></P> <P class=MsoNormal style="MARGIN:0in 0in 10pt;"><FONT face=Calibri size=3>When I teach a SQL Server upgrade class, the students are shocked to learn that store procedure debugging was moved from the database tool to Visual Studio. Most SQL Server professionals I know don’t even have Visual Studio installed on their workstation. </FONT></P> <P class=MsoNormal style="MARGIN:0in 0in 10pt;"><FONT face=Calibri size=3>Microsoft, please respect the database professional and make the common sense move to place database tools inside the primary environment first.</FONT></P><img src="http://sqlblog.com/aggbug.aspx?PostID=1075" width="1" height="1">Team System for DB ProfessionalsDebugging