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
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
MONGO is as SWEET as a MANGO
by K K Kodoth
Developing .Net application with Mongo Db as Back end
New
Performance and the Entity Framework
by Perry Marchant
An article describing the best practices for Entity Framework performance
New
A LINQ Tutorial: Adding/Updating/Deleting Data
by Abby Fichtner (Hacker Chick)
A tutorial that walks through adding/updating/deleting data in your database with LINQ to SQL...
New
SQL Statement Generator
by Chris Hambleton
A utility that generates INSERT, UPDATE, or DELETE SQL statements.
New
ATL OLE DB Consumer Template Schemas
by Joao Paulo Figueira
Exploring SQL CE 2.0 schema information with the ATL OLE DB Consumer Templates.

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 
FirstPrevNext
GeneralRe: Database Design For Multiple Product TypesprofessionalJörgen Andersson17-Jun-13 7:19 
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 Kampen22hrs 21mins ago 
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 
Last Visit: 31-Dec-99 18:00     Last Update: 18-Jun-13 8:34Refresh1234567891011 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
Web04 | 2.6.130617.1 | Last Updated 1 Aug 2007
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid