8,365,335 members and growing!

The SQL Zone

The database server is the big iron in a server environment, and keeping them running smoothly is a full-time job. If you’re looking to improve your skills as a DBA or a database developer, this is the place to start.

The articles gathered in our SQL Server Zone cover everything from basic SQL syntax to advanced tuning techniques for stored procedures.

Alongside white papers and sample code, you can read articles for all levels of proficiency, and get answers for specific questions from the authors themselves. Your ongoing SQL Server learning begins here.

Red Gate Whitepapers

Resources

	SQL Compare Pro SQL Compare Pro helps you compare and deploy changes quickly, simply and with zero errors. Work with live databases, snapshots, SQL scripts in source control, or backups.
	SQL Data Compare Pro SQL Data Compare Pro lets you compare and deploy data changes quickly, simply and with zero errors. Damaged data can be restored to a single row, without the need for full database recovery.
	SQL Prompt Pro As you type, SQL Prompt Pro offers unobtrusive support, including code completion and SQL snippets. You can quickly access your schema information and reformat SQL code to your preferred style.
	SQL Source Control Source control your database without changing how you work. SQL Source Control integrates into SSMS to provide seamless change management for SQL Server.
	SQL Data Generator SQL Data Generator automatically populates databases with realistic test data. By taking table and column names and constraints into account, Data Generator produces sensible information in minutes.

Featured Article

Introducing the Boomerang Framework

by psined

Introduction to Boomerang Framework

Articles

	MVC Techniques with JQuery, JSON, Knockout and C# by Mark J. Caplin Developing a Order Entry application with MVC
	101 with the Interactive Feature of SQL Server Integration Services by Keshav Singh This demo session demonstrates a little POC as to how can you make your SSIS talk to you.
	Detailed SQL Server data audit through a .NET (CLR) trigger by David Catriel Creating a .NET trigger for SQL Server that will log (down to the field level) all changes made...
	Drag & Drop Shopping Cart Using Asp.net MVC and JQuery by Jigar Bagadai Add interactivity to Shopping Cart Using JQuery and Asp.net MVC.
	Quick prototyping with XML/XSD and T4 templates. by Shahriar Iqbal Chowdhury T4 templetes with built-in support for CRUD operations, that utilize XML/XSD for DAL/BLL generation
	Tool to script and store SQL Server objects in SourceSafe using SQL DMO and Visual SourceSafe automation by Sriram Chitturi This useful tool demonstrates the power of SQL DMO to generate scripts for tables, stored...
	Display Large Amount of Data in GridView with Search Functionality by Ravi Karia This article explains how to display large amount of data and implement search functionality in...
	Oracle to SQL Server VB.NET Utility application by hoquet A utility program that allows you to enter SQL to select data from Oracle, the program will then...
	Using .NET and PHP to create an extensible WebDAV server by Bill Seddon Shows how a .NET based WebDAV server can be created by combining two Open Source projects. The...