http://www.sqlservercentral.com/Content tagged SQL Server 2005, Development posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Part 2 of new T-SQL enhancements from Srinivas Sampath. 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. Building on his first look at Common Table Expressions, Srinivas now looks at recursive queries with CTEs. http://www.sqlservercentral.com/articles/Development/recursivequeriesinsqlserver2005/1760/2008/04/18http://www.sqlservercentral.com/articles/Development/recursivequeriesinsqlserver2005/1760/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 http://www.sqlservercentral.com/articles/Administration/2898/2008/03/04http://www.sqlservercentral.com/articles/Administration/2898/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. http://www.sqlservercentral.com/articles/Development/2862/2008/02/12http://www.sqlservercentral.com/articles/Development/2862/One of the more interesting new features in SQL Server 2005 is the Service Broker. It's not something to help you manage your financial future, nor is it some new program that handles all the instances and their accounts. It's a message queue and SQL Server MVP Srinivas Sampath brings us a look at this new feature with some code to get you going. http://www.sqlservercentral.com/articles/Development/anintroductiontotheservicebroker/1957/2007/12/14http://www.sqlservercentral.com/articles/Development/anintroductiontotheservicebroker/1957/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. http://www.sqlservercentral.com/articles/Development/2743/2007/11/30http://www.sqlservercentral.com/articles/Development/2743/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. http://www.sqlservercentral.com/articles/Development/2738/2007/11/28http://www.sqlservercentral.com/articles/Development/2738/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. http://www.sqlservercentral.com/articles/Development/2734/2007/11/27http://www.sqlservercentral.com/articles/Development/2734/Isolation levels are used to prioritize the acccess to a resource. SQL Server 2005 extends upon the support for isolation levels in 2000 with several new features including an additional level.http://www.sqlservercentral.com/redirect/articles/3234/2007/09/28http://www.sqlservercentral.com/redirect/articles/3234/Auditing is something that almost every DBA needs to tackle at some point in his or her career. David McKinney brings a new twist on the solution by using XML and XSL to help implement auditing in your SQL Server application. http://www.sqlservercentral.com/articles/Security/3179/2007/08/20http://www.sqlservercentral.com/articles/Security/3179/One of the nice new features in SQL Server 2005 is the ability to partition a table based on some sort of range in the data. New author Irfan Baig brings us a short article that explains exactly how you can get started using this new feature. http://www.sqlservercentral.com/articles/Development/3144/2007/08/14http://www.sqlservercentral.com/articles/Development/3144/One of the techniques that you can use for increasing performance, especially in large SQL Server tables, is partitioning. Andy Warren brings us an overview of what this is and how you can use it in your SQL Server 2005 applications. http://www.sqlservercentral.com/articles/Development/3135/2007/08/09http://www.sqlservercentral.com/articles/Development/3135/Concurrency and transaction isolation are a prickly subject, difficult to explain with any kind of clarity without boring the reader and leaving their poor brain in a complete muddle. Therefore, it is often ignored in the vain hope it won't affect us and we can forget all about it. Well you can't ignore it any more and with SQL Server 2005 there's a whole new isolation level added to the four that already exist.http://www.sqlservercentral.com/redirect/articles/3101/2007/07/19http://www.sqlservercentral.com/redirect/articles/3101/This article discusses: How SQL injection attacks work, Testing for vulnerabilities, Validating user input, and more.http://www.sqlservercentral.com/redirect/articles/3073/2007/07/09http://www.sqlservercentral.com/redirect/articles/3073/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 SalesHistoryFromArchiveFhttp://www.sqlservercentral.com/redirect/articles/3020/2007/06/08http://www.sqlservercentral.com/redirect/articles/3020/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.http://www.sqlservercentral.com/redirect/articles/2951/2007/04/09http://www.sqlservercentral.com/redirect/articles/2951/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 http://www.sqlservercentral.com/articles/Administration/2898/2008/03/04http://www.sqlservercentral.com/articles/Administration/2898/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. http://www.sqlservercentral.com/articles/Development/commontableexpressionsinsqlserver2005/1758/2007/03/09http://www.sqlservercentral.com/articles/Development/commontableexpressionsinsqlserver2005/1758/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.http://www.sqlservercentral.com/redirect/articles/2883/2007/03/06http://www.sqlservercentral.com/redirect/articles/2883/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. http://www.sqlservercentral.com/articles/Development/2862/2008/02/12http://www.sqlservercentral.com/articles/Development/2862/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.http://www.sqlservercentral.com/redirect/articles/2810/2007/01/22http://www.sqlservercentral.com/redirect/articles/2810/Learn how to merge and split existing partitions. http://www.sqlservercentral.com/redirect/articles/2790/2007/01/18http://www.sqlservercentral.com/redirect/articles/2790/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.http://www.sqlservercentral.com/redirect/articles/2714/2007/01/03http://www.sqlservercentral.com/redirect/articles/2714/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. http://www.sqlservercentral.com/articles/Development/2738/2007/11/28http://www.sqlservercentral.com/articles/Development/2738/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. http://www.sqlservercentral.com/articles/Development/2743/2007/11/30http://www.sqlservercentral.com/articles/Development/2743/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. http://www.sqlservercentral.com/articles/Development/2734/2007/11/27http://www.sqlservercentral.com/articles/Development/2734/Part III of the article series illustrates how to partition an existing table with data into four different file groups.http://www.sqlservercentral.com/redirect/articles/2697/2006/11/20http://www.sqlservercentral.com/redirect/articles/2697/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. http://www.sqlservercentral.com/redirect/articles/2623/2006/11/02http://www.sqlservercentral.com/redirect/articles/2623/Learn how to make life easier by dividing large tables and indexes into smaller parts.http://www.sqlservercentral.com/redirect/articles/2659/2006/10/23http://www.sqlservercentral.com/redirect/articles/2659/This article discusses how to upload multiple image or text files to the SQL Server database varbinary column.http://www.sqlservercentral.com/redirect/articles/2607/2006/09/26http://www.sqlservercentral.com/redirect/articles/2607/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. http://www.sqlservercentral.com/redirect/articles/2569/2006/09/15http://www.sqlservercentral.com/redirect/articles/2569/