Thursday, 20 January 2011

SQL Server useful system stored procedures

sp_helprotect [object_name]
Returns a report with information about user permissions for an object, or statement permissions, in the current database.

sp_helptext [view_name]
Prints the text of a rule, a default, or an unencrypted stored procedure, user-defined function, trigger, computed column, or view.

Full list of System Stored Procedures

Wednesday, 19 January 2011

How to set Microsoft IIS to 32bit on 64bit server

  • go to %systemdrive%\Inetpub\AdminScripts
  • run cscript.exe adsutil.vbs set W3SVC/AppPools/Enable32BitAppOnWin64 1
  • go to  C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727
  • run IIS installer aspnet_regiis.exe -i
  • Allow 'ASP.NET v2.0.50727 (32-bit)' under Internet Information Services/Web Service Extensions
  • Disable 'ASP.NET v2.0' if exists (this is 64bit version)
  • Restart IIS

Thursday, 13 January 2011

Model-View-ViewModel in WPF

90 Minutes Video by Jason Dolinger
DataModel-View-ViewModel pattern series by Dan Crevier