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
XQuery basics
by Mayank Dubey
XQuery basics.
New
Social Club: Sample application using WinForms, C#.NET, ADO.NET and MS Access
by john-ph
WinForms application developed using C#, ADO.NET and MS Access
New
Making OUTER and CROSS APPLY work for you
by Michiel du Toit
Explaining and demonstrating the use of the APPLY keyword for SQL Server
New
Building Your First Analysis Services Cube...
by Bhushan W. Juare
How to build you first analysis service cube
New
Using WCF REST HTTP to call Stored Procedures on SQL Server
by Tom Glick Philadelphia, US
Using WCF REST Service to call Stored Procedures and run queries on SQL Server.
New
Access to Oracle without tnsnames.ora
by fstrahberger
Access to Oracle without tnsnames.ora
New
Caching Data in WinForms DataGridView in NET 2.0
by Nikhil Contractor
An article on how to show large amounts of records using DataGridView's virtual mode in paging.
New
Dynamic Data Grouping Using Microsoft Reporting Services
by Asif Sayed
Generate multiple outputs from a single physical report template using dynamic data grouping.
New
DACBuilder – Data Access objects generation tool based on XML and XSL templates transformation
by Dan Radu
The DACBuilder application provides auto-generation features from multiple database systems in...

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 
QuestionGenerating Custom XML from multiple rows in SQL servermemberONeil Tomlinson18hrs 20mins ago 
AnswerRe: Generating Custom XML from multiple rows in SQL servermvpRichard MacCutchan16hrs 30mins ago 
QuestionHow to permanently solve (blocked because of many connection0 error?memberJassim Rahma18-Jun-13 2:25 
AnswerRe: How to permanently solve (blocked because of many connection0 error?memberjschell18-Jun-13 8:40 
AnswerRe: How to permanently solve (blocked because of many connection0 error?professionalBernhard Hiller2hrs 17mins ago 
Questionarabic character not saved in MySQLmemberJassim Rahma16-Jun-13 10:20 
AnswerRe: arabic character not saved in MySQL [modified]professionalSimon_Whale16-Jun-13 22:32 
GeneralRe: arabic character not saved in MySQLmemberJassim Rahma17-Jun-13 11:27 
QuestionDatabase Design For Multiple Product TypesmemberMember 770211015-Jun-13 0:28 
AnswerRe: Database Design For Multiple Product TypesmvpEddy Vluggen15-Jun-13 2:41 
AnswerRe: Database Design For Multiple Product TypesmemberDavid Mujica17-Jun-13 4:08 
GeneralRe: Database Design For Multiple Product TypesprofessionalJörgen Andersson17-Jun-13 7:19 
AnswerRe: Database Design For Multiple Product Typesmembermark3223hrs 9mins ago 
QuestionCreating New Database in SQL 2012 Management StudiomemberGary Heath13-Jun-13 6:41 
AnswerRe: Creating New Database in SQL 2012 Management StudiomvpEddy Vluggen13-Jun-13 9:45 
GeneralRe: Creating New Database in SQL 2012 Management StudiomemberGary Heath13-Jun-13 11:44 
GeneralRe: Creating New Database in SQL 2012 Management StudiomemberBram van Kampen14-Jun-13 14:17 
GeneralRe: Creating New Database in SQL 2012 Management StudiomvpEddy Vluggen15-Jun-13 1:54 
Questionneed recommandation for database for vs.net 2010 c# web service projectmemberneodeaths12-Jun-13 5:14 
AnswerRe: need recommandation for database for vs.net 2010 c# web service projectprofessionalRichard Deeming12-Jun-13 7:11 
AnswerRe: need recommandation for database for vs.net 2010 c# web service projectmemberjschell12-Jun-13 8:59 
QuestionConnecting to an SQL Database.memberBram van Kampen11-Jun-13 13:41 
AnswerRe: Connecting to an SQL Database.mvpEddy Vluggen11-Jun-13 22:28 
GeneralRe: Connecting to an SQL Database.memberBram van Kampen12-Jun-13 12:59 
GeneralRe: Connecting to an SQL Database.memberTim Carmichael13-Jun-13 2:03 
GeneralRe: Connecting to an SQL Database.memberjschell13-Jun-13 8:57 
GeneralRe: Connecting to an SQL Database.mvpEddy Vluggen13-Jun-13 9:44 
GeneralRe: Connecting to an SQL Database.memberBram van Kampen14-Jun-13 0:42 
GeneralRe: Connecting to an SQL Database.mvpEddy Vluggen14-Jun-13 8:56 
GeneralRe: Connecting to an SQL Database.memberBram van Kampen14-Jun-13 13:59 
GeneralRe: Connecting to an SQL Database.mvpEddy Vluggen15-Jun-13 2:35 
GeneralRe: Connecting to an SQL Database.memberBram van Kampen17-Jun-13 14:13 
GeneralRe: Connecting to an SQL Database.mvpEddy Vluggen14hrs 36mins ago 
GeneralRe: Connecting to an SQL Database.memberBram van Kampen18-Jun-13 15:42 
GeneralRe: Connecting to an SQL Database.mvpEddy Vluggen18-Jun-13 22:29 
QuestionDictionary Database Requried for Android....membermAzeem229-Jun-13 8:19 
AnswerRe: Dictionary Database Requried for Android....mvpEddy Vluggen10-Jun-13 3:36 
QuestionSQL Server table sizes. [modified]memberPHS2418-Jun-13 0:24 
AnswerRe: SQL Server table sizes.memberi.j.russell8-Jun-13 23:01 
GeneralRe: SQL Server table sizes.memberPHS2419-Jun-13 5:43 
Questiongetting common datamemberArun kumar Gautam7-Jun-13 10:58 
AnswerRe: getting common datamvpEddy Vluggen9-Jun-13 2:29 
QuestionNeed Help in SQL Server "Stored Procedure"memberdr_iton6-Jun-13 5:59 
AnswerRe: Need Help in SQL Server "Stored Procedure"memberdjj556-Jun-13 7:06 
GeneralRe: Need Help in SQL Server "Stored Procedure"memberdr_iton6-Jun-13 10:42 
QuestionRe: Need Help in SQL Server "Stored Procedure"membergvprabu12-Jun-13 4:27 
QuestionHow to Insert Error_Message() into table and return user defined MessagememberRobymon5-Jun-13 21:33 
AnswerRe: How to Insert Error_Message() into table and return user defined Messagememberdjj556-Jun-13 7:09 
Last Visit: 31-Dec-99 18:00     Last Update: 19-Jun-13 19:30Refresh1234567891011 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
Web01 | 2.6.130619.1 | Last Updated 1 Aug 2007
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid