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

Articles with tag SQL Server 2008 R2 Rss

Search for any content tagged sql server 2008 r2

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

SQL Server 2008 R2 Service Pack 1 Customer Technology Preview Available

You can help test the first service pack for SQL Server 2008 R2 and ensure the highest quality possible for its release.  Read more...
By Press Release 2011/04/25 | Source: MSDN Communities | Category: sql server 2008 r2
Rating: (not yet rated)  Rate this |   Briefcase | 2,318 reads

SQL Server 2008 R2 Build List

The list of builds for SQL Server 2008 R2 up to CU14 for SP1 and CU12 for SP2.  Read more...
By Steve Jones 2013/11/05 (first published: 2010/05/25) | Source: SQLServerCentral.com | Category: sql server 2008 r2
Rating: |  Discuss |   Briefcase | 50,583 reads

SQL Server 2008 and 2008 R2 Integration Services - Managing Remote Processes Using Script Task

Marcin Policht discusses ways to launch processes for remote systems using SQL Server 2008 R2 Integration Services.  Read more...
By Additional Articles 2011/04/07 | Source: Database Journal | Category: administration
Rating: (not yet rated)  Rate this |   Briefcase | 2,649 reads

Create CNN-style Map in Reporting Services

This article demonstrates how to use US Census' TIGER/Line shapefile to display CNN-style map in Reporting Services.  Read more...
By Peichung Shih 2012/06/01 (first published: 2011/03/07) | Source: SQLServerCentral.com | Category: sql server 2008 r2
Rating: |  Discuss |   Briefcase | 115,676 reads

SQL Server 2008 R2 Build List

The list of builds for SQL Server 2008 R2 up to CU14 for SP1 and CU12 for SP2.  Read more...
By Steve Jones 2013/11/05 (first published: 2010/05/25) | Source: SQLServerCentral.com | Category: sql server 2008 r2
Rating: |  Discuss |   Briefcase | 50,583 reads

Understanding SQL Server 2008 R2 Fixed Database Level Roles

To easily manage the permissions in SQL Server databases, Microsoft has provided several roles in SQL Server which are security principals that group other principals.  Read more...
By Additional Articles 2011/02/21 | Source: MSSQLTips.com | Category: sql server 2008 r2
Rating:  Rate this |   Briefcase | 3,298 reads

Creating A SQL Server 2008\2008 R2 Failover Cluster

Details how to install a SQL Server 2008\2008R2 Failover Cluster Instance  Read more...
By Perry Whittle 2013/12/23 (first published: 2011/01/19) | Source: SQLServerCentral.com | Category: clustering
Rating: |  Discuss |   Briefcase | 17,854 reads

SQL Server 2008 R2 Build List

The list of builds for SQL Server 2008 R2 up to CU14 for SP1 and CU12 for SP2.  Read more...
By Steve Jones 2013/11/05 (first published: 2010/05/25) | Source: SQLServerCentral.com | Category: sql server 2008 r2
Rating: |  Discuss |   Briefcase | 50,583 reads

Getting Started with Data Bars in SQL Server 2008 R2 Reporting Services

I'm looking at several new visualization features in SQL Server 2008 R2 Reporting Services and the data bar looks like something that I could really use. Can you provide an example of how to use this in a report?  Read more...
By Additional Articles 2010/12/29 | Source: MSSQLTips.com | Category: sql server 2008 r2
Rating: (not yet rated)  Rate this |   Briefcase | 3,894 reads

Upgrading Data Tier Applications in SQL Server 2008 R2

Changes are inevitable and like many other things in life your application will change over time. The question is how to upgrade an already deployed Data Tier Application to a newer version; what are the different methods available for upgrade and what considerations should you take?   Read more...
By Additional Articles 2010/12/15 | Source: Database Journal | Category: sql server 2008 r2
Rating: (not yet rated)  Rate this |   Briefcase | 2,174 reads

Understanding and Controlling Parallel Query Processing in SQL Server

Data warehousing and general reporting applications tend to be CPU intensive because they need to read and process a large number of rows. To facilitate quick data processing for queries that touch a large amount of data, Microsoft SQL Server exploits the power of multiple logical processors to provide parallel query processing operations such as parallel scans. Through extensive testing, we have learned that, for most large queries that are executed in a parallel fashion, SQL Server can deliver linear or nearly linear response time speedup as the number of logical processors increases. However, some queries in high parallelism scenarios perform suboptimally. There are also some parallelism issues that can occur in a multi-user parallel query workload. This white paper describes parallel performance problems you might encounter when you run such queries and workloads, and it explains why these issues occur. In addition, it presents how data warehouse developers can detect these issues, and how they can work around them or mitigate them.  Read more...
By Additional Articles 2010/12/10 | Source: MSDN Communities | Category: data warehousing
Rating:  Rate this |   Briefcase | 3,431 reads

Getting Started with Maps in SQL Server 2008 R2 Reporting Services

I noticed a new feature in SQL Server 2008 R2 Reporting Services that allows you to render maps in your reports. Can you provide some details on this new feature and can I take advantage of it even though don't have any spatial columns in my data warehouse?  Read more...
By Additional Articles 2010/12/08 | Source: MSSQLTips.com | Category: reporting services (ssrs)
Rating: (not yet rated)  Rate this |   Briefcase | 4,001 reads

Implementing Execution Log Reports on 32-bit SQL Server 2008 R2

This article covers how to implement the SQL Server 2008 Execution Log DB and package on SQL Server 2008 R2  Read more...
Rating: |  Discuss |   Briefcase | 4,294 reads

Deploying Data-Tier Applications of SQL Server 2008 R2

SQL Server 2008 R2 Data-Tier Applications make database development, deployment and management much easier. When you create and build a Data Tier Application, it creates a single, self-contained unit of deployment called a DAC package. Arshad Ali shows you how to deploy the created DAC package and discusses the different methods of deployment.   Read more...
By Additional Articles 2010/11/24 | Source: Database Journal | Category: sql server 2008 r2
Rating:  Rate this |   Briefcase | 2,520 reads

Setting up Transactional Replication in SQL Server 2008 R2

Transactional Replication is used when DML or DDL schema changes performed on an object of a database on one server needs to be reflected on the database residing on another server. This article provides a step by step guide to setting up transactional replication on SQL Server 2008 R2.  Read more...
By Additional Articles 2010/11/15 | Source: SQL Server Performance | Category: replication
Rating:  Rate this |   Briefcase | 1,904 reads

Vote for Me for a PASS SQLRally Precon on SQL Server Security

Unless James Bond is in the picture, security is usually not a sexy topic. However, we all lament the lack...  Read more...
By 2010/10/28 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,817 reads

SQL Server 2008 R2 Build List

The list of builds for SQL Server 2008 R2 up to CU14 for SP1 and CU12 for SP2.  Read more...
By Steve Jones 2013/11/05 (first published: 2010/05/25) | Source: SQLServerCentral.com | Category: sql server 2008 r2
Rating: |  Discuss |   Briefcase | 50,583 reads

Extended Protection available in SQL Server 2008 R2

We use Internet Protocol Security (IPSec) within the trusted domains, but use the Negotiate Security Support Provider for our web applications. What other security methods can we employ with SQL Server?   Read more...
By Additional Articles 2010/09/07 | Source: MSSQLTips.com | Category: security
Rating: (not yet rated)  Rate this |   Briefcase | 1,859 reads

New Features in Reporting Services 2008 and 2008 R2

Quietly, Microsoft has been making radical improvements to Reporting Services; but precisely what was introduced, and when? We asked Bill Pearson, the well-known BI expert, to come up with a definitive survey of the more recent changes and how they help the user of Reporting Services.   Read more...
By Additional Articles 2010/07/29 | Source: SimpleTalk | Category: sql server 2008 r2
Rating:  Rate this |   Briefcase | 4,603 reads

For SQL Server 2005/2008, Consider SecurityAdmin = SysAdmin

In a recent thread here on SQL Server Central, it was pointed out that a member of the securityadmin fixed...  Read more...
By Brian Kelley 2010/07/23 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 3,944 reads
<< Newer    Items 21 to 40 of 59    Older >>