1 / 13

Freaky Fast Development Tips

Freaky Fast Development Tips. Rick Krueger (@ D ataOgre ). Dave Valentine (@ IngeniousSQL ). Public Service Announcement: Networking. Rick Krueger Twitter: @DataOgre Blog: www.premierapps.com Email: rick@premierapps.com Dave Valentine Twitter: @IngeniousSQL Blog: www.IngeniousSQL.com

selene
Download Presentation

Freaky Fast Development Tips

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Freaky Fast Development Tips Rick Krueger (@DataOgre) Dave Valentine (@IngeniousSQL)

  2. Public Service Announcement: Networking Rick Krueger • Twitter: @DataOgre • Blog: www.premierapps.com • Email: rick@premierapps.com Dave Valentine • Twitter: @IngeniousSQL • Blog: www.IngeniousSQL.com • Email: Dave.Valentine@ingenioussql.com

  3. Agenda • SQL Server Management Studio • Windows • Visual Studio • Business Intelligence • FREE 3rd Party Tools/Utilities • BIDS Helper • SSMS Tools • SSMS Boost • Red Gate SQL Search

  4. SQL Server Management Studio • Keyboard Shortcuts • Query Shortcuts • Standard • User Defined

  5. Windows • UDL Files • Get Connection String • Connectivity Issues • EXEC sp_change_users_login 'Auto_Fix', 'DataOgre' • Firewall

  6. Visual Studio • Custom External Tools • SQLCMD • PoSh • Batch files • Merge Scripts • Organize the chaos

  7. 3rd Party Tools – SSMS Tools • Download • http://www.ssmstoolspack.com/ • SQL Snippets • Generate Insert Statements • CRUD Procedure Generation • History

  8. 3rd Party Tools – SQL Search • Download: • http://www.red-gate.com/products/sql-development/sql-search/ • Search for Objects • Quickly Display Object Definitions

  9. Business Intelligence • Templates • Paths • SQL Server 2005 • %Program Files%\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ProjectItems\[Template Type] • SQL Server 2008 and 2008 R2 • %Program Files%\ Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\ProjectItems\[Template Type] • SQL Server 2012 • %Program Files%\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies\ProjectItems\[Template Type] • SSIS = DataTransformationProject • SSRS = ReportProject

  10. 3rd Party Tools – BIDS Helper • Download: • http://bidshelper.codeplex.com/ • Reset GUIDs • Smart Diff • Expression and Configuration Highlighter • SSIS Variables Windows Extensions

  11. 3rd Party Tools – SSMS Boost • Download • http://www.ssmsboost.com/ • Script Object • Locate Object • Format SQL

  12. Recap • Query and Keyboard shortcuts • UDL files for connection strings • External Tools in Visual Studio • Templates for Business Intelligence • Great FREE 3rd party tools and utilities • SSMS Tools • Red Gate SQL Search • BIDS Helper • SSMS Boost

  13. Questions? Rick Krueger • Twitter: @DataOgre • Blog: www.premierapps.com • Email: rick@premierapps.com Dave Valentine • Twitter: @IngeniousSQL • Blog: www.IngeniousSQL.com • Email: Dave.Valentine@ingenioussql.com

More Related