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

Articles with tag SQL Server 2008 Rss

Refine your search with one of the following additional tags (with number of items):

T-SQL (18)     Editorial (2)     Data Compression (1)     Product Reviews (1)    
SQL Server 2005 (15)     Encryption (2)     Database Developer (1)     Programming (1)    
Integration Services (SSIS) (13)     Filtered Indexes (2)     Database Development (1)     proxy accounts (1)    
Spatial Data (10)     GIS (2)     Database Mail (1)     Query Optimization (1)    
Change Data Capture (CDC) (9)     Installation (2)     database security (1)     Report Builder (1)    
Data Warehousing (9)     MERGE (2)     deadlock (1)     Reporting Services (1)    
Data Types (8)     peer-to-peer (2)     Declarative Management Framework (DMF) (1)     Sample Chapters (1)    
FILESTREAM (8)     Performance Monitoring (2)     Dependencies (1)     Sample databases (1)    
Performance Tuning (8)     Profiler (2)     Designing Database Solutions (1)     SAP (1)    
Auditing (7)     Scalability (2)     Dimensions (1)     Schema (1)    
News (7)     Sparse Columns (2)     DMV (1)     Service Broker (1)    
Security (7)     SQL Server (2)     Editorial - iPod (1)     sponsored article (1)    
Upgrade (6)     SQL Server 7, 2000 (2)     Editorial - MP3 (1)     SQL Agent (1)    
Backup and Recovery (5)     Table Valued Parameters (2)     Editorial - WMV (1)     SQL Sentry (1)    
Blogs (5)     Visualizations (2)     Enterprise Policy Management Framework (EPM) (1)     SQL Server 2000 (1)    
Clustering (5)     Windows 2008 (2)     Exams (1)     SQL Server Architecture (1)    
Management Studio (5)     XEvents (2)     Fast Track Data Warehouse (1)     SQL Server security (1)    
Replication (5)     Administration (1)     File Exists (1)     SQL Trace (1)    
Reporting Services (SSRS) (5)     ADO.NET (1)     File System Task (1)     SQL University (1)    
Resource Governor (5)     Adventureworks (1)     Fragmentation (1)     SQLSaturday (1)    
Service Packs (5)     AMO (1)     FTP Task (1)     SSIS (1)    
TDE (5)     Analysis Services (1)     Full-Text Search (2008) (1)     SSRS (1)    
Compression (4)     Analysis Services (SSAS) (1)     geo-replication (1)     Star Schemas (1)    
Data Collector (4)     Application Programming (1)     IEnumerable (1)     statistics (1)    
Database Weekly (4)     attach (1)     Indexed Views (1)     Streaming (1)    
Datetime Manipulation (4)     Backup (1)     Jobs (1)     Studying (1)    
Extended Events (4)     Backup compression (1)     Large UDT (1)     Surface Area Configuration tool (1)    
Extract, Transform, Load (ETL) (4)     Best Practices (1)     loading data (1)     System Monitor (1)    
MDW (4)     Brad's Sure Guides (1)     MCITP (1)     Teradata (1)    
Policy Based Management (4)     Bulk import (1)     MCTS (1)     Time Range (1)    
SQL Server Management Studio (SSMS) (4)     Business case (1)     Miscellaneous (1)     trace (1)    
Video (4)     Business Intelligence (1)     Monitoring (1)     Transparent Data Encryption (1)    
books (3)     Certifications (1)     Netweaver (1)     Troubleshooting (1)    
grouping sets (3)     Command Prompt (1)     Oracle (1)     TVP (1)    
HierarchyID (3)     Common Language Runtime (CLR) (1)     paging (1)     upgrade advisor (1)    
High Availability (3)     compare database (1)     Partitioned Tables (1)     VBScript (1)    
Indexing (3)     Compliance (1)     Performance Advisor (1)     visual studio (1)    
PBM (3)     copy_only (1)     Performance testing (1)     web service (1)    
.Net (2)     Cryptography (1)     Permissions (1)     XML (1)    
Data Profiling (2)     data (1)     PHP (1)     XMLA (1)    
Database Mirroring (2)     Data access (1)     powershell (1)     xp_sendmail (1)    
Debugger (2)    

Search for any content tagged SQL Server 2008

   Items 1 to 20 of 217    Next 20 >>
 

SQL University: Multiple Paths and Ownership Chaining

Welcome back to our last class this term on security in SQL Server here at SQL University. According to the syllabus,...  Read more...
By 2009/11/03 | Source: SQLServerCentral.com | Category: Blogs
Rating: (not yet rated)  Rate this |  Briefcase | 480 reads

Using SQL Server 2008 Reporting Services with SAP NetWeaver Business Intelligence

This paper discusses the integration of SAP NetWeaver BI ® with Microsoft ® SQL Server ® 2008 Reporting Services (SSRS). The paper provides an overview of using the Reporting Services SAP Netweaver BI data provider and related query designer, to build high quality reports against SAP NetWeaver BI sources. For Reporting Services users who are new to working with SAP NetWeaver BI, this paper will help you connect and build datasets. For users already familiar with SAP NetWeaver, the paper will show how some of that system’s notable features can be leveraged in Reporting Services reports. It also presents some tips and tricks that can help you make the most of the integration between the two products.  Read more...
By Additional Articles 2009/11/02 | Source: Microsoft MSDN | Category: SQL Server 2008
Rating: (not yet rated)  Rate this |  Briefcase | 863 reads

Using SQL Server 2008 Change Data Capture

An introduction to this new feature in SQL Server 2008.  Read more...
By Additional Articles 2009/10/19 | Source: developer.com | Category: SQL Server 2008
Rating: (not yet rated)  Rate this |  Briefcase | 2,205 reads

Open DBDiff for SQL Server 2008

The DBDiff utility compares two databases and generates a script to synchronize the two databases. In this article, MAK illustrates the various uses of the Open Diff utility.  Read more...
By Additional Articles 2009/10/14 | Source: Database Journal | Category: compare database
Rating:  Rate this |  Briefcase | 2,973 reads

Using new location-aware data types in SQL Server 2008

With SQL Server 2008, you will have new built-in support for location based data types and supporting geospatial features. Next you will learn how these new data types work.  Read more...
By Additional Articles 2009/10/13 | Source: developer.com | Category: SQL Server 2008
Rating:  Rate this |  Briefcase | 1,492 reads

SQL Server 2008 Failover Clustering

This white paper complements the existing documentation on planning, implementation, and administration of a SQL Server 2008 failover cluster, which can be found in Microsoft SQL Server 2008 Books Online. There are links to relevant existing content throughout the paper, which is intended primarily for a technical audience. This white paper covers failover cluster architecture and concepts for Windows Server (2003 and 2008) and SQL Server 2008; installation of a SQL Server 2008 failover cluster; upgrades and updates to SQL Server 2008 failover clustering; and maintenance and administration of SQL Server 2008.  Read more...
By Additional Articles 2009/10/02 | Source: SQLCAT | Category: Clustering
Rating: (not yet rated)  Rate this |  Briefcase | 2,650 reads

Setting up Change Data Capture in SQL Server 2008

Change Data Capture (CDC) is a new native feature in SQL Server 2008 Enterprise Edition. This article shows how to use CDC to easily set up data auditing on your SQL Server system  Read more...
By Additional Articles 2009/09/30 | Source: Builder.com | Category: Change Data Capture (CDC)
Rating: (not yet rated)  Rate this |  Briefcase | 2,467 reads

SQL Server 2008 Build List

The list of builds for SQL Server 2008 updated with Cumulative Update 2 for SP1.  Read more...
By Steve Jones 2009/09/25 (first published: 2008/09/26) | Source: SQLServerCentral.com | Category: SQL Server 2008
Rating: |  Discuss |  Briefcase | 14,198 reads

Using SQL Server 2008 Reporting Services with the.NET Framework Data Provider for Teradata

This article discusses the connectivity and usage of Teradata database servers and the .NET Framework Data Provider for Teradata with Microsoft SQL Server 2008 Reporting Services (SSRS).  Read more...
By Additional Articles 2009/09/18 | Source: Microsoft MSDN | Category: Teradata
Rating: (not yet rated)  Rate this |  Briefcase | 1,686 reads

Tuning the Performance of Change Data Capture in SQL Server 2008

Change data capture is a new feature in SQL Server 2008 that provides an easy way to capture changes to data in a set of database tables so these changes can be transferred to a second system like a data warehouse. This document provides guidance on how to configure change data capture parameters to maximize data capture performance while minimizing the performance impact on the production workload. The scope of this document is limited to the capture of change data and the cleanup process. Querying the changed data is out of scope for this white paper.  Read more...
Rating:  Rate this |  Briefcase | 1,570 reads

Service Broker: Performance and Scalability Techniques

SQL Server Service Broker provides support for building asynchronous messaging and queuing applications with the SQL Server Database Engine. This paper describes a large scale customer scenario and the techniques employed in scaling Service Broker to process tens of thousands of messages per second on one server.  Read more...
By Additional Articles 2009/09/11 | Source: Microsoft MSDN | Category: Service Broker
Rating: (not yet rated)  Rate this |  Briefcase | 1,985 reads

Using Star Join and Few-Outer-Row Optimizations to Improve Data Warehousing Queries

In this white paper we discuss two of the new features in SQL Server 2008, Star Join and Few-Outer-Row optimizations. We test the performance of SQL Server 2008 on a set of complex data warehouse queries designed to highlight the effect of these two features and observed a significant performance gain over SQL Server 2005 (without these two features).  Read more...
By Additional Articles 2009/09/10 | Source: Microsoft MSDN | Category: SQL Server 2008
Rating: (not yet rated)  Rate this |  Briefcase | 3,180 reads

Implementing a SQL Server Fast Track Data Warehouse

This paper defines a reference configuration model (known as SQL Server Fast Track Data Warehouse) and a CPU core-balanced approach to implementing a symmetric multiprocessor (SMP)-based SQL Server data warehouse with proven performance and scalability expectations for sequential I/O data workloads.  Read more...
By Additional Articles 2009/09/04 | Source: Microsoft MSDN | Category: Data Warehousing
Rating: (not yet rated)  Rate this |  Briefcase | 3,053 reads

Decompressing on Compression in SQL Server 2008....

Compression is one of the major features introduced in SQL Server 2008, and one that can significantly reduce disk storage. ...  Read more...
By Robert Pearl 2009/09/02 | Source: SQLServerCentral.com | Category: Blogs
Rating:  Rate this |  Briefcase | 964 reads

Analysis Services Memory Limits

I attended a presentation recently from Steven Wright of SQL Sentry on Analysis Services (SSAS) memory management and it was...  Read more...
By Steve Jones 2009/09/01 | Source: SQLServerCentral.com | Category: Blogs
Rating: (not yet rated)  Rate this |  Briefcase | 768 reads

SQL Server 2008 T-SQL Enhancements Part - V

The fifth installment of Arshad Ali's series examines the spatial data types in SQL Server 2008. These new types allow the use of geospatial data in SQL Server applications.  Read more...
By Arshad Ali 2009/08/31 | Source: SQLServerCentral.com | Category: SQL Server 2008
Rating: |  Discuss |  Briefcase | 5,668 reads

SQL Server 2008 T-SQL Enhancements Part - IV

In the fourth installment that looks at T-SQL changes for SQL Server 2008, Ashad Ali examines how the Filestream data type works.  Read more...
By Arshad Ali 2009/08/28 | Source: SQLServerCentral.com | Category: SQL Server 2008
Rating: |  Discuss |  Briefcase | 7,223 reads

Enterprise Policy Management Framework with SQL Server 2008

The Enterprise Policy Management (EPM) Framework leverages and extends the new Microsoft SQL Server 2008 Policy-Based Management feature across an entire SQL Server enterprise, including down-level instances of SQL Server such as SQL Server 2000 and SQL Server 2005.  Read more...
By Additional Articles 2009/08/28 | Source: Microsoft MSDN | Category: SQL Server 2008
Rating: (not yet rated)  Rate this |  Briefcase | 1,557 reads

SQL Server 2008 T-SQL Enhancements Part - III

Continuing with his series on T-SQL enhancements in SQL Server 2008, Arshad Ali brings us a look at the HierarchyID and Large UDTs.  Read more...
By Arshad Ali 2009/08/27 | Source: SQLServerCentral.com | Category: SQL Server 2008
Rating: |  Discuss |  Briefcase | 9,923 reads

Attaching a database in Microsoft SQL Server 2008

Various methods of using the "For Attach" clause exist to overcome the limitations that face us when using sp_attach_db and sp_attach_single_file_db. The first installment illustrates the use of the "Create Database" statement for the "For Attach" and "for ATTACH_REBUILD_LOG" arguments, for a single .MDF file and single .LDF file.  Read more...
By Additional Articles 2009/08/24 | Source: Database Journal | Category: SQL Server 2008
Rating: (not yet rated)  Rate this |  Briefcase | 1,962 reads
   Items 1 to 20 of 217    Next 20 >>
 
Most popular

SQL Server 2008 T-SQL Enhancements Part - III

Continuing with his series on T-SQL enhancements in SQL Server 2008, Arshad Ali brings us a look at the HierarchyID and Large UDTs.  Read more...
By Arshad Ali 2009/08/27 | Source: SQLServerCentral.com | Category: SQL Server 2008
Rating: |  Discuss |  Briefcase | 9,923 reads

SQL Server 2008 T-SQL Enhancements Part - I

SQL Server 2008 has a number of enhancements over 2005 that make it a more capable platform. New author Arshad Ali brings us an overview and some code about a few T-SQL changes.  Read more...
By Arshad Ali 2009/01/22 | Source: SQLServerCentral.com | Category: SQL Server 2008
Rating: |  Discuss |  Briefcase | 19,734 reads

SQL Server 2008 T-SQL Enhancements Part - IV

In the fourth installment that looks at T-SQL changes for SQL Server 2008, Ashad Ali examines how the Filestream data type works.  Read more...
By Arshad Ali 2009/08/28 | Source: SQLServerCentral.com | Category: SQL Server 2008
Rating: |  Discuss |  Briefcase | 7,223 reads