Data Driver

Blog archive

One-Stop Shop for SQL Server Scripts

Microsoft recently updated its All-In-One Script Framework, which features SQL Server (and other) scripts designed to address common problems reported by users in forums, support incidents and online communities.

Though primarily targeted at IT pros, the scripts are helpful for developers, too, as pointed out recently by Jialiang Ge, who works at a sister project called the All-In-One Code Framework. "Considering that many developers are writing T-SQL scripts too, we hope that the scripts could be useful to you," he wrote in a MSDN blog post.

He wrote about seven new scripts added to the All-In-One-Script Framework, including:

  • Enroll SQL Server instances on multi server into an existing SQL Server Utility
  • Check SQL Server missing KB2277078 to prevent leak of security audit entries
  • How to retrieve the top N rows for each group
  • Publish report to Reporting Services in SharePoint Integrated Mode
  • Bulk set the Timeout property of the reports that in one specified folder
  • Add one user/group to a specified Reporting Services item
  • Get properties of the objects that in multiple SQL Server instances

Meanwhile, back at the All-In-One Code Framework, targeted specifically at developers, code samples are available via a standalone sample installer or as a Visual Studio extension.

Some sample scripts of interest to data developers include:

  • Import Data from Excel to SQL Server
  • Entity Framework Sample Provider
  • Upload Files Asynchronously Using AJAX into SQL Server Database
  • Bind Image in Gridview Using C# with ASP.NET
  • ASP.NET Dynamic Data Unleashed
  • LinqToSqlExample
  • Stored Procedures
The project also has a "request code sample" service described as "a proactive way for our developer community to obtain code samples for certain programming tasks directly from Microsoft." Project documentation said developers can vote on requests and Microsoft engineers will choose the requests with the most votes and provide appropriate code samples. The two most popular requests at the time of this writing were "Code samples for Orchard Project" and "N-tier Entity Framework 4 end to end sample app."

So take a look at the one-stop shops for code samples and scripts and share your thoughts by commenting here or dropping me a line.

Posted by David Ramel on 10/24/2012 at 1:15 PM

comments powered by Disqus


  • How to Do Machine Learning Evolutionary Optimization Using C#

    Resident data scientist Dr. James McCaffrey of Microsoft Research turns his attention to evolutionary optimization, using a full code download, screenshots and graphics to explain this machine learning technique used to train many types of models by modeling the biological processes of natural selection, evolution, and mutation.

  • Old Stone Wall Graphic

    Visual Studio Code Boosts Java Dependency Viewer

    Easier management of project code dependencies and improvements to extensions for popular Java frameworks and runtimes highlight the February update to Java in Visual Studio Code functionality.

  • Blule Squares

    Visual Studio 2019 for Mac 8.5 Preview Adds ASP.NET Core Authentication

    Microsoft, after shipping Visual Studio 2019 for Mac v8.4 with support for ASP.NET Core Blazor Server applications last month, is now previewing the v8.5 series, adding new authentication templates for ASP.NET Core along with other improvements.

  • Q&A with Brice Wilson: What's New in Angular 9

    We caught up with expert web developer/trainer Brice Wilson to get his take on Angular, which always appears at or near the top of periodic rankings of the most popular JavaScript-based web development frameworks.

  • Entity Framework Core Migrations

    Eric Vogel uses code samples and screenshots to demonstrate how to use Entity Framework Core migrations in a .NET Core application through the command line and in code.

.NET Insight

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.

Upcoming Events