SQL Server 2008 R2 Service Pack 1 Released

Today SQL Server 2008 R2 Service Pack 1 is released today.
Get it here.

  • Dynamic Management Views for increased supportability.
  • ForceSeek for improved querying performance.
  • Data-tier Application Component Framework (DAC Fx) for improved database upgrades. 
  • Disk space control in PowerPivot for SharePoint.
  • Support for 512e Drives.
  • Fixed various issues.

SQL Server Encryption

Recently I had to show that data can be encrypted in SQL Server 2008 database. The purpose was to not store the raw value in a table where anyone with access could see the sensitive data. The original process truncated the destination table and then populated the destination table with data pulled from the source table. Seeing that as an issue, I made a change to the process in addition to adding encryption. Continue reading SQL Server Encryption

SQL Server 2008 (and 2008 R2) Auditing

A person with a small amount of SQL Server DBA experience came to me and asked if there was an automatic job deletes users or changes user permissions. I told them there was no default job that does that. I then suggested they look at the audits to see if there was any activity. Come to find out, there were no audits on the installations. I decided to implement some audits so the question I was originally asked could be answered by viewing the audits.

This led to explaining how to use audits. In SQL Server 2008 (and 2008 R2), hereinafter referenced as SQL 2008, auditing is so easy, there is no reason not to do it. Basic process for creating an audit is to create audit and then define the specification for the audit. Continue reading SQL Server 2008 (and 2008 R2) Auditing

SQL Reporting Services: HTTP Error 503

I recently was playing around with SQL Server 2008 Reporting Services and switching between Native and SharePoint integrated mode.  In the last change, I switched from SharePoint Integrated to Native but came across an error when opening the Report Manager, specifically HTTP Error 503: Service is Unavailable. As usual, I over analyzed it but did find the solution. Continue reading SQL Reporting Services: HTTP Error 503

Team Foundation Server, Reporting Services, SharePoint; Almost but not Enough

In a previous entry, I stated I was using SharePoint and Reporting Services with Integrated mode. After that was finally successful, I wanted to connect Team Foundation 2010 (TFS) with this SharePoint installation. Continue reading Team Foundation Server, Reporting Services, SharePoint; Almost but not Enough

Unable to Access SQL Reporting Services using Server Name

A recent installation of SQL Reporting Services installed successfully but then when testing the site, no matter how the Reporting Services Configuration Manager was configured, the Reporting Manager could not be access using the server name. I couldn’t even connect to the database engine using the server name in Management Studio. Then I remembered something. Continue reading Unable to Access SQL Reporting Services using Server Name