Infrastructure at your Service

Tag

database Archives - Page 6 of 6 - Blog dbi services

Stéphane Haby

Forefront Endpoint Protection (FEP) 2010 and database policies

By | Database management | No Comments

I have seen at a customer that the SQL Server’s policy doesn’t follow the Microsoft’s recommendations about antivirus and databases(kb 309422), such excluding *.mdf,*.ndf and *.ldf files. In addition the policy for Oracle doesn’t exist in case of Forefront Endpoint Protection 2010 known as FEP 2010.

I have decided to create databases policies for FEP optimized by dbi services to be generic and adapted to all SQL Server and Oracle environments.

Read More
Stéphane Haby

SQL Server 2012 ‘Denali’: a new panel of DMVs

By | Database management | One Comment

Dynamic management views (DMVs) return server state information that can be used to monitor the health of a server instance, diagnose problems and tune performance.
Since few months, I test the future new version SQL Server 2012 codename Denali and I was very surprised form the news DMVs from this version.
I will just explain some DMVs very interesting for a DBA.
My article is based on msdn web site reference and you find in the end from each chapter a msdn reference for more details of the DMV.

Read More
Stéphane Haby

Changing the reference instance for SQL Server Integration Service (SSIS)

By | Database management | No Comments

In my experience, I have seen many clients do not know how to do when they have multiple databases instances and Integration Servicet for manage the end of the instance that is the reference for Integration Services.

When Integration Service is installed with the instance “TOTO” and that it is at the end of his life, we’ll see how to transfer information to the second instance “TITI”. We present you a small working method to transfer information correctly.

Only the folders transfert is presented in this article and the  transfert of the SSIS packages are explained at the end.

Read More