lunes, 28 de marzo de 2011

VisualStudio 2010 *.sql files not opening

from here

1. Load up your ISO or DVD VS2010 Installer in an explorer window
2. Go to the WCU foldler
3. Go to the DAC folder
4. Install MSI's

i. DACFramework_enu.msi
ii. DACProjectSystemSetup_enu.msi
iii. TSqlLanguageService_enu.msi

In case not working at all check uninstall Visual Studio 2010

viernes, 25 de marzo de 2011

Start and Stopping services PowerShell

open PowerShell console with admin privileges (right click->run as administrator)

display services regexp *sql*:

PS$>Get-Service -displayname *sql*

Stop/Start microsoft sql server instance:

PS$>Stop-Service -name MSSQLSERVER

PS$>Start-Service -name MSSQLSERVER

Ref: Five basic PowerShell commands Windows admins should know

miércoles, 23 de marzo de 2011

Firefox 4.0..

Yeeehaa FireFox is back,.... 4.0 feels and looks pretty faster and cute... now hope to de-chromize my cookies :D

Get Yours now!!

martes, 15 de marzo de 2011

IE9 buena presentacion, mal desempeño

IE9 funciona lento en mi win7 profesional con tarjeta de gráficos intel, tiene una interfaz mejorada pero sigue siendo mucho mas lento que chrome 10, al menos eso es lo que me parece hoy trabaje todo el día con él.

Además no se porque o como el default del zoom es 125 y no encontré como regresar a 100%, espero en lo próximos días cambiarlo.

espero que Firefox 4 en Windows se tan bueno como como chrome para poder volver a navegar en él, ya que prácticamente no lo uso más.

WSPBuilder adding link assemblies

for adding link assemblies in a wspbuilder sharepoint 2007 project/solution feature right click folder (e.g. bin) and select add existing item the follow the right down arrow

jueves, 10 de marzo de 2011

Dealing with MOSS Session State

In the code for an SharePoint application page i'm getting NULL for HttpContext.Current.Session;
so I'm looking for information related to why this is happening.
Until now only found these blogs with information related to state and SharePoint:

Enabling Session State in SharePoint 2007 I first thought this was my problem but from this book (chapter 7: Database Security for SQL Session State), found that the session state tables live in my SharePoint services provider database (default created: SharedServices1_DB) and also found this blog(it fixes other issue with session state) about how to extract the sql script from command aspnet_regsql.exe

aspnet_regsql -sstype c –d [YOUR SSP DB NAME] -sqlexportonly fix.sql –ssadd

in my case

aspnet_regsql -S vpc03 -sstype c –d SharedServices1_DB -sqlexportonly fix.sql –ssadd

Note: i added the -S paramenter to specify my server name "vpc03".

Unfortunately I'm still stuck with Session NULL :(

Here was posted how to enable the session state in web.config of SharePoint application; only need to review this tag:

page enableSessionState="true"

Recycling Pool

I need to recycle application pool every time for SharePoint 2007 application page debug, so i searched for PowerShell script out there and ended with this option:

PS > (Get-WmiObject -class "iisapplicationpool" -namespace "root\microsoftiisv2"
-filter "Name='W3SVC/AppPools/DefaultAppPool'").Recycle()

here DefaultAppPool is the name of your application pool under the tree of IIS admin, so you must change on demand

this works fine for IIS6 on windows server 2003 R2 64bits, and power shell 1.0
It should work for power shell 2.0 and Win2008R2

martes, 1 de marzo de 2011

Windows 7 short cut keys

Most useful:

Windows key shortcuts:
  • Windows logo key+E Open Windows Explorer navigated to Computer.
Windows Explorer shortcuts
  • F3 or Ctrl+F Search for a file or folder.

Datos personales