Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Development, SQL Server 2005 Rss

<< Newer    Items 21 to 40 of 77    Older >>
 

Stop SQL Injection Attacks Before They Stop You

This article discusses: How SQL injection attacks work, Testing for vulnerabilities, Validating user input, and more.  Read more...
By Additional Articles 2007/07/09 | Source: MSDN Communities | Category: security
Rating:  Rate this |   Briefcase | 4,169 reads

Cut development time with SQL Server 2005's synonyms

A synonym is a new object to SQL Server 2005. It is a way to give an alias to an already existing object. For example, if you have a table named SalesHistoryFromArchiveF  Read more...
By Additional Articles 2007/06/08 | Source: Builder.com | Category: development
Rating:  Rate this |   Briefcase | 3,819 reads

Using Multiple Active Result Sets (MARS)

SQL Server 2005 has so many new features that in my opinion if you read only BOL for a year you'd find something new every day. One of those is Multiple Active Result Sets or MARS. Multiple Active Result Sets is a new SQL Server 2005 feature that, putting it simply, allows the user to run more than one SQL batch on an open connection at the same time.  Read more...
By Additional Articles 2007/04/09 | Source: SQLTeam.com | Category: development
Rating:  Rate this |   Briefcase | 2,464 reads

Reporting Services Makes Server Support Easier

Reporting Services is one of the most widely used subsystems in SQL Server and there have been some very creative solutions invented by DBAs around the world. New author Carolyn Richardson is one of those, bringing us a implementation that tracks uptime and disk space for her SQL Servers   Read more...
By Carolyn Richardson 2007/03/12 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 8,750 reads

Common Table Expressions in SQL Server 2005

The next evoution of T-SQL, which will be released in SQL Server 2005, contains a number of enhancements designed to allow you to write more powerful queries while keeping the code structured in a way that makes development and understanding it easier. Coming ever so closer to the SQL-99 specification with Common Table Expressions, new author Srinivas Sampath brings us an introduction to this new way of writing complex queries.   Read more...
By Srinivas Sampath 2007/03/09 (first published: 2005/03/02) | Source: SQLServerCentral.com | Category: development
Rating: |  Discuss |   Briefcase | 50,038 reads

SQL Server Error Handling Workbench

Grant Fritchey steps into the workbench arena, with an example-fuelled examination of catching and gracefully handling errors in SQL 2000 and 2005, including worked examples of the new TRY..CATCH capabilities.  Read more...
By Additional Articles 2007/03/06 | Source: SimpleTalk | Category: stored procedures
Rating:  Rate this |   Briefcase | 3,089 reads

Maximum Row Size in SQL Server 2005

What is the page size in SQL Server 2005? That's an easy question, but what is the maximum row size? They're not the same thing and ANdy Warren shows you why.   Read more...
By Andy Warren 2007/02/27 | Source: SQLServerCentral.com | Category: development
Rating: |  Discuss |   Briefcase | 24,940 reads

Automate the process of trimming table data in SQL Server 2005

Arthur Fuller recently instructed a colleague on how to automate the process of trimming table data in SQL Server 2005. Find out how he is able to turn an onerous task into a breeze.  Read more...
By Additional Articles 2007/01/22 | Source: Builder.com | Category: development
Rating:  Rate this |   Briefcase | 2,570 reads

Data partitioning in SQL Server 2005 - Part V

Learn how to merge and split existing partitions.   Read more...
By Additional Articles 2007/01/18 | Source: Database Journal | Category: development
Rating:  Rate this |   Briefcase | 2,038 reads

Using Synonyms in SQL Server 2005

It's nice to have little amenities in your development tools. They make for easier development and can save you a little time. Synonyms is one of those tools.  Read more...
By Additional Articles 2007/01/03 | Source: developer.com | Category: development
Rating:  Rate this |   Briefcase | 3,502 reads

New T-SQL Features in SQL Server 2005 Part 2

SQL Server 2005 has changed many of the ways in which we will use SQL Server in the future with a dizzying array of new features and enhancements. Sureshkumar Ramakrishnan brings us the second part in a series looking at what these changes do and how to use them.   Read more...
By Sureshkumar Ramakrishnan 2006/12/06 | Source: SQLServerCentral.com | Category: development
Rating: |  Discuss |   Briefcase | 19,989 reads

Source Control in SQL Server

One of the most requested features from SQL Server developers is the integration of source control with T-SQL code. SQL Server Management Studio brings some integration with Visual Source Safe and longtime SQL Server author Raj Vasant explains it to us.   Read more...
By Vasant Raj 2006/12/04 | Source: SQLServerCentral.com | Category: development
Rating: |  Discuss |   Briefcase | 13,720 reads

New T-SQL Features in SQL Server 2005 Part 1

SQL Server 2005 has changed many of the ways in which we will use SQL Server in the future with a dizzying array of new features and enhancements. Sureshkumar Ramakrishnan brings us the first part in a series looking at what these changes do and how to use them.   Read more...
By Sureshkumar Ramakrishnan 2006/11/29 | Source: SQLServerCentral.com | Category: development
Rating: |  Discuss |   Briefcase | 27,389 reads

Data partitioning in SQL Server 2005 - Part III

Part III of the article series illustrates how to partition an existing table with data into four different file groups.  Read more...
By Additional Articles 2006/11/20 | Source: Database Journal | Category: administration
Rating:  Rate this |   Briefcase | 2,723 reads

Toying with template parameters in SQL Server 2005

If you create functions or stored procedures from SQL Server 2005 Management Studio, you will notice that the new window is filled with a template. In general, you get a skeleton interspersed with markers. This article discusses how you can use templates.   Read more...
By Additional Articles 2006/11/02 | Source: Builder.com | Category: administration
Rating:  Rate this |   Briefcase | 2,150 reads

Data partitioning in SQL Server 2005 - Part I

Learn how to make life easier by dividing large tables and indexes into smaller parts.  Read more...
By Additional Articles 2006/10/23 | Source: Database Journal | Category: administration
Rating:  Rate this |   Briefcase | 3,288 reads

Upload multiple files to VarBinary column in SQL Server 2005

This article discusses how to upload multiple image or text files to the SQL Server database varbinary column.  Read more...
By Additional Articles 2006/09/26 | Source: Database Journal | Category: development
Rating:  Rate this |   Briefcase | 1,710 reads

Using and Monitoring SQL 2005 Query Notification

The aim of this article is to show you how to make full use of SQL 2005 query notification with ASP.NET 2.0. It tackles the implementation details largely from SQL Server's perspective and includes many DBA tips and tricks for troubleshooting query notification.   Read more...
By Additional Articles 2006/09/15 | Source: Red-Gate | Category: development
Rating:  Rate this |   Briefcase | 2,011 reads

Top 10 Enhancements in SQL 2005 Notification Services

In this article, we examine some of the best new features and characteristics available in the 2005 version.  Read more...
By Additional Articles 2006/09/04 | Source: Red-Gate | Category: development
Rating:  Rate this |   Briefcase | 1,929 reads

Using the SQL Server Surface Area Configuration

So, you’ve just installed SQL Server 2005 but don’t know how to configure it. This video will instruct you how to use the SQL Server 2005 Surface Area Configuration tool to turn on SQL Server features like CLR integration and how to enable ports. Free registration required.   Read more...
By Brian Knight 2006/07/27 | Source: Other | Category: administration
Rating:  Rate this |   Briefcase | 1,940 reads
<< Newer    Items 21 to 40 of 77    Older >>
 
Tags
t-sql (9)    
advanced querying (7)    
nums (7)    
sqlinsider scripts (7)    
table of numbers (7)    
tally (7)    
administration (6)    
counter (6)    
arrays (5)    
delimited strings (5)    
parse (5)    
string manipulation (5)    
miscellaneous (4)    
sql server 7 (3)    
.net (2)    
2-dimensional arrays (2)    
programming (2)    
security (2)    
strategies (2)    
dependencies (1)    
integration services (ssis) (1)    
prime (1)    
prime number (1)    
reporting services (ssrs) (1)    
sieve (1)    
stored procedures (1)    
table (1)    
xml (1)    
xsl (1)