The evolution of the human race is based on the fact that humans have had intelligence to reuse an already available solution to a problem to achieve solutions to even bigger problems. In software engineering, we know this as design patterns, which are general reusable solutions to commonly occurring problems. In the world of T-SQL, these are downloadable scripts, which, with a finite amount of customization can be reused within any administrator’s environment or any developer’s T-SQL code. In the world of C# or other programming languages & frameworks, these are blocks or snippets of code that help realize a business requirement.
I have often seen developers and administrators searching for hours on search engines to download scripts or code snippets which they can use for a variety of purposes:
- To learn about a particular feature
- To implement an industry-standard practice in their environments
- To compare a pre-existing solution with industry-standard best practices
- To use as reference in order to get out of “writers block”
- And many more..
The BeyondRelational.com platform has come up with a revolutionary new concept of the “Scripts” module (http://beyondrelational.com/modules/30/scripts.aspx?s=stream&tab=scripts), where one can share scripts and code snippets which demonstrate solutions to a given engineering problem, examples include:
- Scripts to retrieve queries that are most expensive/use most I/O (http://beyondrelational.com/modules/30/scripts/485/scripts/14932/script-to-retrieve-the-queries-that-are-most-expensive-use-the-most-io.aspx)
- A C# script to list all SQL Server instances on a given SQL Server instance (http://beyondrelational.com/modules/30/scripts/496/scripts/13610/c-script-to-list-all-sql-server-databases-that-exists-in-a-given-sql-server-instance.aspx)
- A script to retrieve a list of all indexes along with their filegroups (http://beyondrelational.com/modules/30/scripts/485/scripts/11418/retrieve-a-list-of-all-indexes-along-with-their-file-groups.aspx)
So, if you are a developer or administrator or an enthusiast and use a piece of code frequently to address a business problem, the “Scripts” module is the right platform for you to share your solution with the community.
So, head over to the Scripts module today – share your scripts while learning something new!
BeyondRelational.com will be celebrating a “scripts week” from July 09, 2012 – July 15, 2012. Do not forget to visit the Scripts module during this time for fresh, new and extremely useful scripts on each day of the week!
Until we meet next time,