The SQL Workbench

(Steve's Site)

The SQL Workbench - (Steve's Site)

SQL Development Tips and Tricks to become a more efficient DBA/Developer

This the landing page for my SQL Development Tips and Tricks to become a more efficient DBA/Developer Presentation.

Abstract:

We’ve all learned a few best practices and even some “worse” practices.  I’ll try to cover some of the best productivity and coding practices I have come across and maybe even share some of the bad habits I’ve managed to kick.  We will look at what SSMS Projects, shortcuts keys, SQLCMD, PowerShell, and Version Control Systems can do to make you a better DBA, a better developer and all around more productive SQL Server professional.  (It will be fun I promise!)
Internal Links:
1.) Shortcut Keys
2.) PowerShell Search
3.) PowerShell Profile for DBAs
4.) SSMS Projects
5.)Naming Conventions and Documentation Standards (More why than how, but with examples)
6.) SSMS SQLCMD and SQLCMD.exe
7.) SSMS Shortcut keys (Built in)
8.)SQL docs…think Java docs
9.)TFS and Subversion
10.)Community Tools!

 

 

 

External Links:
1.) The Mythical Man Month
2.) The Pragmatic Programmer