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 60    Older >>
 

SSRS 2008 R2 KPIs with bullet graphs

Key Performance Indicators are typically displayed in a scorecard with stop light indicators, which are either red, amber or green light icons. The limitation for these kind of indicators is that you can see the actual and target values in two different fields as well as see the status of the KPI in red, amber or green color. If the user wants to figure out the thresholds associated with the KPI, these values are generally not visible. Further, representing the threshold values in the scorecard itself defeats the purpose of the scorecard. The scorecard should display the KPI's status in the most summarized form and use a minimal amount of space on the dashboard. In this tip we would look at how to address this issue.   Read more...
By Additional Articles 2011/06/22 | Source: MSSQLTips.com | Category: reporting services (ssrs)
Rating: (not yet rated)  Rate this |   Briefcase | 3,111 reads

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,338 reads

SQL Server 2008 R2 Build List

The list of builds for SQL Server 2008 R2 up to SP3.  Read more...
By Steve Jones 2014/09/30 (first published: 2010/05/25) | Source: SQLServerCentral.com | Category: sql server 2008 r2
Rating: |  Discuss |   Briefcase | 53,161 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,673 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,762 reads

SQL Server 2008 R2 Build List

The list of builds for SQL Server 2008 R2 up to SP3.  Read more...
By Steve Jones 2014/09/30 (first published: 2010/05/25) | Source: SQLServerCentral.com | Category: sql server 2008 r2
Rating: |  Discuss |   Briefcase | 53,161 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,318 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 | 18,061 reads

SQL Server 2008 R2 Build List

The list of builds for SQL Server 2008 R2 up to SP3.  Read more...
By Steve Jones 2014/09/30 (first published: 2010/05/25) | Source: SQLServerCentral.com | Category: sql server 2008 r2
Rating: |  Discuss |   Briefcase | 53,161 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,922 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,182 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,531 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,072 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,343 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,527 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,966 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,924 reads

SQL Server 2008 R2 Build List

The list of builds for SQL Server 2008 R2 up to SP3.  Read more...
By Steve Jones 2014/09/30 (first published: 2010/05/25) | Source: SQLServerCentral.com | Category: sql server 2008 r2
Rating: |  Discuss |   Briefcase | 53,161 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,906 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,639 reads
<< Newer    Items 21 to 40 of 60    Older >>