Infosys Microsoft Alliance and Solutions blog

Main

September 17, 2012

SQL Server 2012: Distributed Replay

Distributed Replay is a new feature in SQL Server which focuses on tuning the database environments after upgrade or any major change. Similar to SQL Profiler it is used for replaying the workloads for testing on databases but with one major improvement, it can used to simulate workload in a distributed environment (multiple systems can be involved). So it can be used to accurately simulate a real workload with requests coming from multiple client systems and considered as a scale out solution.
The setup for Distributed Replay is available along with the SQL Server installation. The steps for installing and configuration for the Distributed Replay feature is available here.

September 5, 2012

SQL 2012 Performance Dashboard Reports

SQL Server performance dashboard reports are a set of custom reports which sit on top of SQL Server and can be executed directly through SQL Management Studio. These reports are meant for DBAs as well as developers. The goal of these reports is to help users identify and troubleshoot performance related issues.

Continue reading "SQL 2012 Performance Dashboard Reports" »

August 9, 2012

SQL Server 2012: Timeline feature

SQL Server 2012 provides improved point-in-time recovery options with the new Timeline feature available during restore operations. For point-in-time recovery both database and transaction log backups would be required, hence this feature will only be possible in Full or Bulk Logged Recovery modes.

Continue reading "SQL Server 2012: Timeline feature" »

July 26, 2012

SQL Server 2012: SSIS Deployment Models

With SQL Server 2012, even Integration Services (SSIS) has started to support server deployment methodology similar to Analysis Services and Reporting Services. This new technique is called the project deployment model. This option will be available with the traditional deployment technique by using the Package Deployment utility. The advantage here would be to have all the configuration information related to deployed package available on the SSIS at a central location.

Continue reading "SQL Server 2012: SSIS Deployment Models" »

July 18, 2012

SQL Server Data Tools (SSDT)

SQL Server Data Tools (SSDT) is a new SQL Server development tool released by Microsoft as an Add on to SQL 2012. SSDT is an integrated development tool available through Visual Studio, and provides the developer with the familiar Visual Studio tools development environment integrated with standard database features like Intellisense, T-SQL Editor, DB designer etc.

Continue reading "SQL Server Data Tools (SSDT)" »

Subscribe to this blog's feed

Follow us on

Blogger Profiles

Infosys on Twitter