Skip to content

Denali

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

… 

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

… 

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

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

…