PFE LatinAmerica & ISS - All Comments

re: Storage Area Network (SAN) for DBA's

Joe.TJ — Fri, 10 May 2013 08:36:33 GMT

"In the absence of disk alignment forces the eighth 4-KB cluster of user data to be laid across two stripe units" WHY?

128-63=65sectors=32.5kb, 4kb*8=32kb.so i think the 9th cluster will lay across two stripe units.

re: Analysis Services Tabular Mode vs Multidimensional Mode

Daniel — Thu, 11 Apr 2013 15:47:16 GMT

I think the demo is incomplete.

Did you have distinct count measures ?

This scenario is a good reason to use Tabular Modes.

re: Storage Area Network (SAN) for DBA's

SQL PFE LATAM — Wed, 03 Apr 2013 18:39:51 GMT

Glad you like it!

re: Analysis Services Tabular Mode vs Multidimensional Mode

SQL PFE LATAM — Wed, 20 Mar 2013 23:45:18 GMT

You are Welcome, We are very excited to help.

re: Analysis Services Tabular Mode vs Multidimensional Mode

Temitope — Tue, 19 Mar 2013 17:45:46 GMT

Thanks a lot I really appreciate your post. i have been evaluating the choice between tabular and cube. i tried the tabular model and it just zaps my memory. Now i know i should just stick with my cube.

thanks a lot

re: Auditoría de Seguridad en SQL Server 2008

SQL PFE LATAM — Wed, 27 Feb 2013 02:14:28 GMT

Ya que SQL Audit está basado en Extended Events usa muy pocos recursos mientras hace la recolección de datos, por tanto no produce un overhead considerable. Sin embargo la cantidad de overhead se verá ligado a: Que tipo eventos estas auditando, ocurren con una frecuencia muy elevada, es adecuado auditar solo lo necesario. Tambien donde estas almacenando el Log de Eventos, Lo más adecuado sería en un disco independiente, nunca en uno donde existan archivos de bases de datos de SQL.

re: Auditoría de Seguridad en SQL Server 2008

Mad_season — Tue, 26 Feb 2013 13:00:26 GMT

No afecta la performance del servicio ??

re: How to configure FBA (Forms-Based Authentication) in SharePoint Server 2010 using IIS 7 and ASP .NET Membership Database (SQL) like in MOSS 2007!!!

Raymundo Vale — Fri, 15 Feb 2013 14:07:09 GMT

Hi Counie,

You can create your own application to manage users on SQL Database for FBA, the easiest way to me is creating an IIS Site from IIS Manager and connect that site to the Connection String already created and add the Membership and Role Provider also already created, then you MUST set default providers to FBAMembershipProvider and FBARoleProvider respectively like in this example, these 3 steps will connect the IIS Site to the SQL database storing users and then using IIS Manager Add or Delete users as you need. Click on the IIS Site, on the main or central panel click .NET Users and over the action panel you can add or delete the users, you can also Edit accounts but I'm not really sure if you can reset a password. The role who can handle users is the Windows Administrator or any other role that can manage IIS Manager.

Greetings!!

re: How to configure FBA (Forms-Based Authentication) in SharePoint Server 2010 using IIS 7 and ASP .NET Membership Database (SQL) like in MOSS 2007!!!

Counie — Thu, 14 Feb 2013 14:44:32 GMT

Hi Raymond.

First of all Thanks for posting this article.

FBA is already configured in my environment ( by someone else) but I was curious to know how to set up the IIS site to manage FBA users.

The details on how to set up the IIS site are not clear to me.

Then it jumps straight to "go back to IIS manager..."

Is IIS manager the place to manage these FBA accounts ? OR is their a website provided whereby FBA users can manage their own accounts/passwords etc. ?

re: Auditoría de Seguridad en SQL Server 2008

SQL PFE LATAM — Tue, 11 Dec 2012 14:49:22 GMT

Muchas Gracias! Asi será :)