Infrastructure at your Service

All Posts By

Stéphane Savorgnano

Stéphane Savorgnano

Monitoring SQL Server with Oracle OEM Grid Control 11g

By | Database management | One Comment

Recently, I had the chance to install the SQL Server Plug-in for Oracle Entreprise Management Grid Control 11g to monitor a SQL Server instance based on a windows host. Our client, who monitors these Oracle databases via OEM Grid Control 11g, wanted to use the same tool to also monitor SQL Server databases. In this blog posting, I will describe how to install the 11g agent on a Windows host and how to import as…

Read More
Stéphane Savorgnano

SQL Server 2012: Create & replay a trace with Distributed Replay

By | Database management | One Comment

My last blog was about installing and configuring Microsoft SQL Server 2012 Distributed Replay. This time, I will show you how you can create a trace and replay it with Distributed Replay Clients on a specific SQL Server target. This is my Distributed Replay configuration:   Creation of the trace I will use the two Distributed Replay clients to generate a workload against the target server with two PowerShell Windows which will execute diverse SQL…

Read More
Stéphane Savorgnano

SQL Server 2012 SP 1: Third Cumulative Update (CU3) available

By | Technology Survey | No Comments

Three weeks ago, Microsoft published the third Cumulative Update (CU3) for Microsoft SQL Server 2012 Service Pack one. As usual, if this Cumulative Update solves an issue you are facing, install it quickly – otherwise, do not install it. Which issues are covered by this CU3? It contains 38 Hotfixes: 27 for the Engine 8 for SSAS 3 for SSRS To have more details or information about these hotfixes, click here. Historic of SQL Server 2012…

Read More
Stéphane Savorgnano

SQL Server 2012: Installing and configuring Distributed Replay

By | Database management | No Comments

Distributed Replay is a new fonctionality of Microsoft SQL Server 2012. It helps you assess the impact of future upgrades (SQL Server, hardware, OS) or SQL Server tunings by replaying a trace captured from a productive SQL Server environment to a new SQL Server test environment. This new functionality is similar to SQL Server Profiler, but with more possibilities: e. g. replaying the trace from multiple clients (up to sixteen), use a stress or  synchronization…

Read More
Stéphane Savorgnano

SQL Server 2012 SP1: Second Cumulative Update available (CU2)

By | Technology Survey | No Comments

A couple of days ago, Microsoft published the second Cumulative Update (CU2) for Microsoft SQL Server 2012 SP1. If this CU covers an issue you are experiencing, you should install it quickly. Otherwise, it is not mandatory. Which issues are covered by this CU2? This CU2 contains 51 Hotfixes: 35 for the Engine 6 for SSAS 3 for SSIS 7 for SSRS If you need more information and/or details on these hotfixes, click here. Historic of…

Read More
Stéphane Savorgnano

SQL Server View problem in LightSwitch 2012

By | Application integration & Middleware | One Comment

I recently faced a problem in Visual Studio LightSwitch 2012 with SQL Server views. I attached an external datasource to my project and when I tried to import my view (which is very simple) I experienced some issues. Here is my View in SQL Server 2012: During the import process a warning says  my view doesn’t have any primary key (apparently it’s mandatory in LightSwitch) and that a key has been inferred… When I check…

Read More
Stéphane Savorgnano

SQL Server 2012 SP1: First Cumulative Update (CU1) now available

By | Technology Survey | No Comments

A couple of days ago (20 November 2012), Microsoft rolled out the first cumulative update (CU1) for SQL Server 2012 Service Pack 1 (SP1). It’s just two weeks after the release of the first Service Pack (SP1) we are talking about here. What this first CU for SQL Server 2012 SP1 features: This CU1 contains 44 hotfixes: 33 for the Engine 3 for SSAS 4 for SSRS 4 for SSIS If you want to have…

Read More
Stéphane Savorgnano

Risk and Health Assessment Program for Microsoft SQL Server

By | Database management | One Comment

I recently had the chance to go through a so called Risk and Health Assessment Program for Microsoft SQL Server (SQLRAP) at one of our clients. The SQLRAP assesses your SQL Server implementations to ensure proper productive use. It is an excellent opportunity to review the best practices and perform a validation of your client environment by a Microsoft SQL Server Engineer. The SQLRAP program will collect data from the SQL Servers, perform a very thorough analysis,…

Read More
Stéphane Savorgnano

SQL Server 2012: Service Pack 1 (SP1) now available

By | Technology Survey | No Comments

Some days ago, the 6th of November, the first Service Pack for SQL Server 2012 was made available on the Microsoft website. SQL Server 2012 Service Pack 1 includes SQL Server 2012 Cumulative Update 1 (CU1) and SQL Server 2012 Cumulative Update 2 (CU2) and therefore all hotfixes that they were included. Which issues are fixed in the SP1: There are 13 issues fixed: 2 for Availability Group 1 for SSIS 1 for Data Quality Client…

Read More
Stéphane Savorgnano

Overview of Microsoft Visual LightSwitch

By | Application integration & Middleware | No Comments

Microsoft Visual Studio LightSwitch is a new application development tool wich allows to create fast and nice web and desktop applications. The development environment is the same as the other .NET development tools and creating a new application with LightSwitch works, at the beginning, exactly like with other .NET application: create a new project and choose your programmation’s language between Visual Basic and C#. The following will change our habits. In fact instead of creating…

Read More