Skip to content

Microsoft

SQL Server: Attunity connectors for data transfer to Oracle

Recently, at a customer site, I discovered the Attunity connector 1.1 for Oracle. The customer uses this connector to transfer data from Oracle to SQL Server using Integration Services (SSIS) and informed me that performances are greatly improved. So I decided to post a blog about this connector and perform a benchmark between Attunity connector and Microsoft OLE DB provider

… 

SQL Server 2012: How to create a Server Role?

Recently, during my many missions, a client asked me to give access rights to the SQL Server Logs from SSMS to his application managers.

 

As you know, you must give the role “securityadmin” to have such rights but with this role you can also manage logins, CREATE DATABASEs and change passwords.

This is “too many rights” for

… 

SQL Server 2012: Feature Pack

Since the third CTP version of SQL Server 2012 codename Denali, you have some features available to provide an additional value for Microsoft® SQL Server 2012 like the other SQL Server versions. This Feature Pack or Manageability Tool Kit are available but are not the final version. I have compiled all information in this blog to find it easily.

All

… 

Forefront Endpoint Protection (FEP) 2010 and database policies

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

…