SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

   Items 1 to 20 of 8524    Next 20 >>
 

Hierarchies in SQL

One very common structure that needs to be handled in T-SQL is the hierarchy. One of our prominent members of the community discusses how you can handle hierarchies in SQL Server.  Read more...
By GSquared 2010/12/10 (first published: 2009/01/28) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 13,191 reads

SQL Server 2005 Performance Dashboard Using SSRS

A first look at the Performance Dashboard in SQL Server 2005 by new author Robert Griffin.  Read more...
By Robert Griffin 2010/12/03 (first published: 2009/07/29) | Source: SQLServerCentral.com | Category: performance dashboard
Rating: |  Discuss |  Briefcase | 13,268 reads

An Example of Test-Driven Development, Part 5

The fifth installment of this fantastic series by MVP Andy Leonard looks at database versioning. Be sure to read this one to continue learning more about TDD.  Read more...
By Andy Leonard 2010/11/26 (first published: 2009/08/20) | Source: SQLServerCentral.com | Category: test-driven development
Rating: |  Discuss |  Briefcase | 4,750 reads

A Simple way of Automating Scripts

Deploying changes to your environments can be challenging, especially when you have multiple script files. Sadequl Hussain brings us a technique that works well and handles mutliple files.  Read more...
By Sadequl Hussain 2010/11/25 (first published: 2009/07/30) | Source: SQLServerCentral.com | Category: automation
Rating: |  Discuss |  Briefcase | 13,047 reads

An Example of Test-Driven Development, Part 4

Continuing on with his testing series for T-SQL code, MVP Andy Leonard looks at deployment here.  Read more...
By Andy Leonard 2010/11/19 (first published: 2009/07/15) | Source: SQLServerCentral.com | Category: test-driven development
Rating: |  Discuss |  Briefcase | 4,101 reads

An Example of Test-Driven Development, Part 3

Andy Leonard continues on with his series on TDD. This time he performs some refactoring on his solution.  Read more...
By Andy Leonard 2010/11/12 (first published: 2009/07/13) | Source: SQLServerCentral.com | Category: testing
Rating: |  Discuss |  Briefcase | 5,064 reads

An Example of Test-Driven Development, Part 2

In this next installment of his series on TDD, MVP Andy Leonard continues the development of his database.  Read more...
By Andy Leonard 2010/11/05 (first published: 2009/06/16) | Source: SQLServerCentral.com | Category: database design
Rating: |  Discuss |  Briefcase | 7,448 reads

An Example of Test-Driven Development

Developing a database can be an trying experience, and it's ways good to see how someone else builds a design. In this new article, MVP Andy Leonard shows us how to build a database using test-driven development for a weather database.  Read more...
By Andy Leonard 2010/10/29 (first published: 2009/04/30) | Source: SQLServerCentral.com | Category: testing
Rating: |  Discuss |  Briefcase | 13,277 reads

Sending multiple rows to the Database from an Application: Part II

In part 2 of this series, Mohd Nizamuddin looks at sending multiple rows to the database from an application using XML.  Read more...
By Mohd Nizamuddin 2010/10/22 (first published: 2009/08/25) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 8,584 reads

Sending multiple rows to the Database from an Application: Part I

New author Mohd Nizamuddin brings us the start of a series that talks abuot how you can send multiple rows to the database from an application.  Read more...
By Mohd Nizamuddin 2010/10/15 (first published: 2009/08/18) | Source: SQLServerCentral.com | Category: comma seperated
Rating: |  Discuss |  Briefcase | 13,474 reads

Add Styles to Your Reporting Services Reports

Reporting Services provides a robust reporting platform that rivals many other products. New author Adam Aspin stars a series on how you can dress up your reports and maintain good development practices.  Read more...
By Adam Aspin 2010/10/08 (first published: 2009/02/26) | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |  Briefcase | 13,517 reads

Partitioning in SQL Server 2008

This article discusses about 'Partitioning'. In this detailed article, a particular emphasis is placed on the implementation of Partitioning in SQL Server.  Read more...
By Muhammad Shujaat Siddiqi 2010/10/01 (first published: 2009/04/29) | Source: SQLServerCentral.com | Category: partition
Rating: |  Discuss |  Briefcase | 14,034 reads

Moving Database Files Detach/Attach or ALTER DATABASE?

Learn why ALTER DATABASE should be preferred over Detach/Attach for moving database files on the same SQL Server from MVP Jonathan Kehayias.  Read more...
By Jonathan Kehayias 2010/09/24 (first published: 2009/05/27) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |  Briefcase | 14,146 reads

Raw Materials - Beyond Global

There's more than one way to be green.  Read more...
By Larry Gonick 2010/09/22 | Source: SQLServerCentral.com | Category: raw materials
Rating: |  Discuss |  Briefcase | 375 reads

How to Post Performance Problems

How do you get help? You can post a question on SQLServerCentral, but to get the most help you can, read this article from MVP Gail Shaw.  Read more...
By Gail Shaw 2010/09/17 (first published: 2009/06/12) | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |  Briefcase | 14,457 reads

From Zero to SSIS! Learning SQL Server Integration Services

Learn SSIS from MVP Andy Leonard in Waltham, MA on Oct 6-8, 2010. More details inside.  Read more...
By Press Release 2010/09/16 (first published: 2010/08/19) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |  Briefcase | 6,630 reads

Raw Materials - Efficiency Unit

Leila's layoff generates an innovative workflow strategy.  Read more...
By Larry Gonick 2010/09/15 | Source: SQLServerCentral.com | Category: raw materials
Rating: |  Discuss |  Briefcase | 504 reads

SQL Saturday #52 - Colorado

A free one day training event in the Denver Tech Center on Sept 25, 2010. Come learn about SQL Server and how to further your career at this one day event.  Read more...
By Press Release 2010/09/15 (first published: 2010/09/01) | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated)  Rate this |  Briefcase | 572 reads

SQL Saturday #46 - Raleigh

A free one day training event in Raleigh, NC. Come to the first SQL Saturday in this city on Sept 18, 2010  Read more...
By Press Release 2010/09/13 (first published: 2010/09/02) | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated)  Rate this |  Briefcase | 579 reads

Performance testing and tuning for a beginner

How to test and tune a stored procedure?  Read more...
By Arup Chakraborty 2010/09/10 (first published: 2008/11/17) | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |  Briefcase | 18,265 reads
   Items 1 to 20 of 8524    Next 20 >>