Click here to Skip to main content
Search within:



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


Featured Article

Featured
Introducing the Boomerang Framework
by psined
Introduction to Boomerang Framework

Articles

New
IDataReader implementation + SqlBulkCopy
by cesar_boucas
IDataReader implementation illustrated with SqlBulkCopy class usage
New
SQL Server Compact (CE) Database Maintenance Helper
by Tadeusz Kaliszewski
A small .NET class library for maintaining SQL CE database schema written in C#.
New
SQLoogle - Part 1 of 2
by dale.newman
Google your SQL.
New
A mobile salon services solution.
by Randall Smith II
A simple solution trying out the Azure platform for development and deployment.
New
SQL Server Functions that helps to convert date and time values to and from string literals and other date and time formats.
by Shemeer NS
CAST(), CONVERT(), PARSE(), TRY_PARSE(), TRY_CONVERT(), FORMAT(), SQL Server Functions, SQL...
New
Three-tier .NET Application Utilizing Three ORM Technologies
by Bryan Thomas Weikel
LINQ to SQL, Entity Framework, and NHibernate used in a parallel fashion in a three-tier...
New
Dynamically Pointing to Shared Data Sources on SQL Reporting Services using a Report Definition Customization Extension (RDCE)
by Carlos Alberto Cabrera Gonzalez
This article shows a detailed approach on how to dynamically point to a given shared data source...
New
Entity Framework in WinForms
by Bernardo Castilho
A component that makes it easy to use Entity Framework in WinForms projects, including...
New
Get DataGrid Row Value Without PostBack or AJAX
by murtaza dhari
How to get DataGrid row value without postback or AJAX.

Discussions

 
Hint: For improved responsiveness ensure Javascript is enabled and choose 'Normal' from the Layout dropdown and hit 'Update'.
You must Sign In to use this message board.
Search this forum  
    Spacing  Noise  Layout  Per page  Show 
First PrevNext
QuestionHOW TO ANSWER A QUESTIONadminChris Maunder16 Jul '09 - 3:10 
QuestionHow to get an answer to your questionadminChris Maunder10 Nov '05 - 16:30 
QuestionSelect in SP slower than non-SP ?memberSaxet12hrs 8mins ago 
QuestionRe: Select in SP slower than non-SP ?mvpEddy Vluggen11hrs 48mins ago 
AnswerRe: Select in SP slower than non-SP ?memberSaxet11hrs 21mins ago 
GeneralRe: Select in SP slower than non-SP ?mvpEddy Vluggen11hrs 4mins ago 
GeneralRe: Select in SP slower than non-SP ?professionalPIEBALDconsult4hrs 30mins ago 
QuestionData ClashesmemberBram van Kampen21 May '13 - 15:04 
AnswerRe: Data ClashesmemberDavid Mujica16hrs 58mins ago 
QuestionStored Procedures SQL Servermemberdamokk21 May '13 - 1:11 
AnswerRe: Stored Procedures SQL Servermemberscottgp21 May '13 - 2:37 
AnswerRe: Stored Procedures SQL Servermemberdjj5521 May '13 - 2:58 
GeneralRe: Stored Procedures SQL Servermemberdamokk21 May '13 - 4:14 
AnswerRe: Stored Procedures SQL ServerprofessionalMycroft Holmes21 May '13 - 3:19 
GeneralRe: Stored Procedures SQL Servermemberdamokk21 May '13 - 4:15 
QuestionImporting data using SSIS Packagememberindian14320 May '13 - 21:38 
AnswerRe: Importing data using SSIS PackageprofessionalMycroft Holmes20 May '13 - 23:54 
GeneralRe: Importing data using SSIS PackageprofessionalJörgen Andersson21 May '13 - 0:58 
AnswerRe: Importing data using SSIS PackageprofessionalMycroft Holmes21 May '13 - 3:14 
QuestionEntity FrameworkmemberN_cooL19 May '13 - 19:56 
AnswerRe: Entity FrameworkprofessionalMycroft Holmes19 May '13 - 21:52 
GeneralRe: Entity Frameworkmembermark merrens20 May '13 - 7:34 
Questionproblem in uniongroupmhd.sbt19 May '13 - 19:18 
AnswerRe: problem in unionprofessionalMycroft Holmes19 May '13 - 21:50 
GeneralRe: problem in unionmemberdjj5520 May '13 - 3:03 
Last Visit: 31 Dec '99 - 18:00     Last Update: 22 May '13 - 15:24Refresh1234567891011 Next »

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   



Red Gate Resources

Free eBooks

Product Announcements



Advertise | Privacy | Mobile
Web02 | 2.6.130516.1 | Last Updated 1 Aug 2007
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid