http://www.sqlservercentral.com/Articles tagged SQL Server 2008 posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)This article provides an overview of the use of Column Sets with Spare Columns in SQL Server 2008http://www.sqlservercentral.com/redirect/articles/63704/2008/07/14http://www.sqlservercentral.com/redirect/articles/63704/SQL Server 2008 introduces the Database Backup Compression feature. This article describes how to take advantage of this new featurehttp://www.sqlservercentral.com/redirect/articles/63702/2008/07/14http://www.sqlservercentral.com/redirect/articles/63702/SQL Server 2008 is coming in August, with the same pricing as SQL Server 2005.http://www.sqlservercentral.com/articles/SQL+Server+2008/63640/2008/07/10http://www.sqlservercentral.com/articles/SQL+Server+2008/63640/If you use the new data types in SQL Server 2008, and your front-end application uses .NET 2, you may hit difficulties. András explains why and how...http://www.sqlservercentral.com/redirect/articles/63522/2008/07/10http://www.sqlservercentral.com/redirect/articles/63522/Enhanced variable declaration, one of the many enhancements that Microsoft added to SQL Server 2008 allows you to declare and initialize a value at the same time. This article shows you how to do it.http://www.sqlservercentral.com/redirect/articles/63525/2008/07/09http://www.sqlservercentral.com/redirect/articles/63525/Microsoft SQL Server has steadily gained ground on other database systems and now surpasses the competition in terms of performance, scalability, security, developer productivity, business intelligence (BI), and compatibility with the 2007 Microsoft Office System. It achieves this at a considerably lower cost than does Oracle Database 11g.http://www.sqlservercentral.com/redirect/articles/63340/2008/06/19http://www.sqlservercentral.com/redirect/articles/63340/While reviewing the new features in SQL Server 2008, we noticed Transparent Data Encryption. This sounds very interesting. Could you provide us with an explanation and the details to implement it?http://www.sqlservercentral.com/redirect/articles/63387/2008/06/17http://www.sqlservercentral.com/redirect/articles/63387/SQL Server 2008 February CTP introduces a new feature, SQL Server Audit. This feature facilitates auditing of Database Engine events by providing simple T-SQL statements to enable, store, and view audits on server and database objects. Part 1 of this series focuses on the server level events.http://www.sqlservercentral.com/redirect/articles/63385/2008/06/16http://www.sqlservercentral.com/redirect/articles/63385/SQL Server 2008 is secure by design, default, and deployment. Microsoft is committed to communicating information about threats, countermeasures, and security enhancements as necessary to keep your data as secure as possible. This paper covers some of the most important security features in SQL Server 2008. It tells you how, as an administrator, you can install SQL Server securely and keep it that way, even as applications and users make use of the data stored within.http://www.sqlservercentral.com/redirect/articles/63339/2008/06/12http://www.sqlservercentral.com/redirect/articles/63339/People reading this post might really wonder of having read /heard about a concept on Dependency tracking in SQL Server 2008. It is nothing, but a set of built in existing SYS objects and their effective usage that help us save time & tedious efforts.http://www.sqlservercentral.com/redirect/articles/63027/2008/05/22http://www.sqlservercentral.com/redirect/articles/63027/This article illustrates different methods to insert data into a table, including the new Row Value Constructor, which simplifies the data insertion.http://www.sqlservercentral.com/redirect/articles/63015/2008/05/16http://www.sqlservercentral.com/redirect/articles/63015/As we are reviewing the new features in SQL Server 2008, we found one that looks really interesting - Policy-Based Management. Could you help us to understand how this works and provide some examples? Can you please explain each of the components and how to manage them in the interface and with commands?http://www.sqlservercentral.com/redirect/articles/63021/2008/05/16http://www.sqlservercentral.com/redirect/articles/63021/ckup compression is a new feature in SQL Server 2008 that can help provide smaller sized backups and reduce backup time. This document provides guidance related to tuning options for backup performance. All of the information and test results presented here were done specifically by using the backup compression feature of SQL Server 2008; however, they apply broadly to any backup scenario whether backup compression is used or nothttp://www.sqlservercentral.com/redirect/articles/62929/2008/05/12http://www.sqlservercentral.com/redirect/articles/62929/SQL 2008 has some key improvements over SQL 2005. This article deals with backup compression and faster backups in SQL 2008http://www.sqlservercentral.com/articles/Compression/62746/2008/05/05http://www.sqlservercentral.com/articles/Compression/62746/This article illustrates the functionality of UPSERT via the MERGE command in SQL Server 2008.http://www.sqlservercentral.com/redirect/articles/62835/2008/04/24http://www.sqlservercentral.com/redirect/articles/62835/This article examines one of the T-SQL changes coming in SQL Server 2008: The hierarchyID.http://www.sqlservercentral.com/articles/SQL+Server+2008/62204/2008/03/25http://www.sqlservercentral.com/articles/SQL+Server+2008/62204/Looking at this from a confidentiality, integrity and availability perspective – the essence of security and compliance – there are quite a few new selling points.http://www.sqlservercentral.com/redirect/articles/62548/2008/03/24http://www.sqlservercentral.com/redirect/articles/62548/Part 2 of this article illustrates how to enable Change Data Capture on a database, on a table and how SQL Server tracks the data changes of the CDC enabled table.http://www.sqlservercentral.com/redirect/articles/62294/2008/02/28http://www.sqlservercentral.com/redirect/articles/62294/In this screencast, we look at Table Valued Parameters from both the server side and client side perspectives.http://www.sqlservercentral.com/redirect/articles/62186/2008/02/27http://www.sqlservercentral.com/redirect/articles/62186/This is the third articlefrom Dinesh Asanka in the series on the new Data Types in SQL Server 2008. In this article the spatial data types are explored.http://www.sqlservercentral.com/redirect/articles/62146/2008/02/22http://www.sqlservercentral.com/redirect/articles/62146/In this article, we are going to explore the new HierarchyID data type. We are going to show how to implement hierarchies in SQL Server 2005 and than how same thing in can be achived in SQL Server 2008 using the HierarchyID data type.http://www.sqlservercentral.com/redirect/articles/62145/2008/02/20http://www.sqlservercentral.com/redirect/articles/62145/This article is going to cover the newly introduced data types in SQL Server 2008 July CTP, and will specifically discuss the DATETIME functions.http://www.sqlservercentral.com/redirect/articles/62144/2008/02/18http://www.sqlservercentral.com/redirect/articles/62144/Paul Randal of SQLskills takes a look at lock escalation in SQL Server 2008http://www.sqlservercentral.com/redirect/articles/62004/2008/01/30http://www.sqlservercentral.com/redirect/articles/62004/SQL Server 2008, Katmai, apparently won't ship in Q2. Looks like a Q3 possibility now.http://www.sqlservercentral.com/articles/SQL+Server+2008/62080/2008/01/25http://www.sqlservercentral.com/articles/SQL+Server+2008/62080/Part one of this series illustrates how to enable Change Data Capture on a database, and on a table, and how to keep track of Data Definition Language changes on a table.http://www.sqlservercentral.com/redirect/articles/61971/2008/01/25http://www.sqlservercentral.com/redirect/articles/61971/Paul Randal talks about the new spatial data types and their indexes.http://www.sqlservercentral.com/redirect/articles/62003/2008/01/23http://www.sqlservercentral.com/redirect/articles/62003/Older versions of SQL Server had only one datatype to store both the date and time values. In SQL Server 2008, Microsoft introduces a set of new datatypes that store date and time individually, and both date and time together.http://www.sqlservercentral.com/redirect/articles/61922/2008/01/21http://www.sqlservercentral.com/redirect/articles/61922/This article highlights the steps involved to install SQL Server 2008.http://www.sqlservercentral.com/redirect/articles/61726/2007/12/27http://www.sqlservercentral.com/redirect/articles/61726/In SQL Server 2008 we get a new DATE date type that allows you to store a date without a time.http://www.sqlservercentral.com/redirect/articles/61700/2007/12/18http://www.sqlservercentral.com/redirect/articles/61700/SQL Server 2008 introduces four new DATETIME datatypes as well as new DATETIME functions.http://www.sqlservercentral.com/redirect/articles/61638/2007/12/11http://www.sqlservercentral.com/redirect/articles/61638/