I don't like any programming language. The sympathy is mutual.

Windows 7 updated last night and now it won't boot!

Administrator — Sat, 22 May 2010 09:15:28 GMT

Start with F8->disable restart on failure, if the bluscreen error is 0x7b then switch your hard drives to IDE mode in BIOS, then edit these two registry keys:
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\Msahci
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\IastorV
"Start" must have a value of 0 (loaded by kernel), it is probably 3 (manual)
More details here

Install PHP as FastCGI on XP

Administrator — Wed, 21 Apr 2010 14:48:05 GMT

1. Do not use the web platform installer. If you already have, uninstall PHP and FastCGI using the Control Panel
2. Download the Non Thread Safe ZIP version from http://windows.php.net/download/, unpack it in C:\PHP5
3. Download FastCGI from http://www.iis.net/download/FastCGI (already included in Windows 7)
4. Add the .php file extension mapping using the IIS manager or
C:\WINDOWS\system32\inetsrv>cscript fcgiconfig.js -add -section:"PHP" -extension:php -path:"C:\PHP5\php-cgi.exe"
5. Download the VC9 non-thread safe FreeTDS dll from http://download.moodle.org/download.php ... B_NOTS.zip or (preferred - this one has parameterized queries) the v2 php_sqlsrv_53_nts_vc9.dll - search for the download link on http://blogs.msdn.com/sqlphp - it's in beta now.
6. In c:\php5\php.ini:
error_log = c:\devel\php-errors.log
fastcgi.impersonate = 1
extension=ext\php_sqlsrv_53_nts_vc9.dll
7. Set the application protection level to Low (IIS Process)
8. in a file.php

ini_set('error_reporting',E_ALL);
ini_set('display_errors','On');
ini_set('display_startup_errors','On');
//phpinfo();
$serverName = "(local)\sqlexpress";
$connectionOptions = array("Database"=>"aa", "UID"=>"zz", "PWD"=>"yy");
$conn = sqlsrv_connect($serverName, $connectionOptions); $s=sqlsrv_errors();
if(!$conn) echo ('cannot connect: ' .$s[0][2]);
else { echo 'Successful connection';
sqlsrv_close($conn); }
?>

Prevent Finder error -36 when copying on SMB share

Administrator — Thu, 01 Apr 2010 14:00:57 GMT

The error is caused by OS X trying to save metadata for copied files in resource forks (NT terminology) / named streams (Mac terminology). If the server (usually Samba) doesn't support this it can be disabled
1. For a Mac user, when connecting to any SMB server, write

[default]
streams=no
in ~/Library/Preferences/nsmb.conf

2. For all Mac users, when connecting to a specific share
touch "/shared dir/.com.apple.smb.streams.off"
while there, you should also do a
touch "/shared dir/.metadata_never_index"
3. Samba can also disable the forks and extended attributes for all clients, use

[global]
ea support = no
unix extensions = no

in /etc/smb.conf

Schedule a background task in ASP.Net

Administrator — Wed, 10 Mar 2010 15:31:08 GMT

private static CacheItemRemovedCallback OnCacheRemove = null;

protected void Application_Start(object sender, EventArgs e)
{
AddTask("DoStuff", 60);
}

private void AddTask(string name, int seconds)
{
OnCacheRemove = new CacheItemRemovedCallback(CacheItemRemoved);
HttpRuntime.Cache.Insert(name, seconds, null,
DateTime.Now.AddSeconds(seconds), Cache.NoSlidingExpiration,
CacheItemPriority.NotRemovable, OnCacheRemove);
}

public void CacheItemRemoved(string k, object v, CacheItemRemovedReason r)
{
// do stuff here if it matches our taskname, like WebRequest
// re-add our task so it recurs
AddTask(k, Convert.ToInt32(v));
}

restart microsoft download manager

Administrator — Sat, 30 Jan 2010 00:00:13 GMT

%windir%\Downloaded Program Files\TransferMgr.exe

Grant restricted backup and restore privileges

Administrator — Thu, 28 Jan 2010 15:20:50 GMT

Purpose: allow a specific user to backup and restore database, without giving her full access to the filesystem.
As dbo, create the proc below, create the login, grant public access to master, grant dbo access on the needed databases, grant execute on dbo.backupng and dbo.restoreng to sqluser.
As user,
exec backupng @database='somename'


exec sp_configure 'show advanced options',1
reconfigure
go
exec sp_configure 'xp_cmdshell',1
reconfigure
go
EXEC sp_xp_cmdshell_proxy_account 'domain\user', 'password' --use a restricted user for this one
go
set nocount on
go
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[backupng]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[backupng]
go
create procedure [dbo].[backupng] ( @database sysname ) as
declare @rootdir varchar(128)
--allow writes only in a specific dir
select @rootdir='d:\sites\sqlbackups\'
declare @cmd varchar(128)
declare @result varchar(128)
SELECT @cmd = 'dir ' + @rootdir
EXEC @result = master.dbo.xp_cmdshell @cmd, no_output
IF @result <> 0
 BEGIN
  SELECT @cmd = 'mkdir ' + @rootdir
  EXEC master.dbo.xp_cmdshell @cmd, NO_OUTPUT
 END
declare @db varchar(128)
select @db = replace(replace(replace(@database,':',''),'''',''),'\','')
declare @now varchar(14)
declare @filename varchar(128)
select @now = replace(replace(replace(convert(varchar(50), getdate(), 120), '-', ''), ' ', ''), ':', '')
select @filename = @rootdir + @db + '_' + @now + '.bak'
BACKUP DATABASE @db TO DISK = @filename WITH INIT
go

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[restoreng]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[restoreng]
go
create procedure [dbo].[restoreng] ( @database sysname ) as
declare @rootdir varchar(128)
select @rootdir='d:\sites\sqlbackups\'
declare @cmd varchar(128)
declare @result varchar(128)
declare @db varchar(128)
select @db = replace(replace(replace(@database,':',''),'''',''),'\','')
declare @now varchar(14)
declare @filename varchar(128)
select @filename = @rootdir + @db + '.bak'
--EXEC sp_dboption @db, 'single user', 'true'
--drop database @db
--restore DATABASE @db from disk = @filename
go

sql 2005 reduce file sizes

Administrator — Tue, 26 Jan 2010 17:48:48 GMT

use angajare
alter database angajare set recovery simple
backup log angajare with truncate_only
dbcc shrinkfile (angajare_log, 1)
dbcc shrinkfile (angajare, 1)

where's the security tab?

Administrator — Mon, 25 Jan 2010 11:54:54 GMT

Either
Tools->Folder Options->View-> uncheck Use simple file sharing
or

Hive: HKEY_CURRENT_USER
Key: Software\Microsoft\windows\CurrentVersion\Policies\Explorer
Name: Nosecuritytab
Type: REG_DWORD
Value: 0

or
convert c: /fs:ntfs

How to copy SQL users to another server

Administrator — Mon, 04 Jan 2010 13:29:12 GMT

EXEC sp_help_revlogin

USE master
GO
IF OBJECT_ID ('sp_hexadecimal') IS NOT NULL
  DROP PROCEDURE sp_hexadecimal
GO
CREATE PROCEDURE sp_hexadecimal
    @binvalue varbinary(256),
    @hexvalue varchar (514) OUTPUT
AS
DECLARE @charvalue varchar (514)
DECLARE @i int
DECLARE @length int
DECLARE @hexstring char(16)
SELECT @charvalue = '0x'
SELECT @i = 1
SELECT @length = DATALENGTH (@binvalue)
SELECT @hexstring = '0123456789ABCDEF'
WHILE (@i <= @length)
BEGIN
  DECLARE @tempint int
  DECLARE @firstint int
  DECLARE @secondint int
  SELECT @tempint = CONVERT(int, SUBSTRING(@binvalue,@i,1))
  SELECT @firstint = FLOOR(@tempint/16)
  SELECT @secondint = @tempint - (@firstint*16)
  SELECT @charvalue = @charvalue +
    SUBSTRING(@hexstring, @firstint+1, 1) +
    SUBSTRING(@hexstring, @secondint+1, 1)
  SELECT @i = @i + 1
END

SELECT @hexvalue = @charvalue
GO
 
IF OBJECT_ID ('sp_help_revlogin') IS NOT NULL
  DROP PROCEDURE sp_help_revlogin
GO
CREATE PROCEDURE sp_help_revlogin @login_name sysname = NULL AS
DECLARE @name sysname
DECLARE @type varchar (1)
DECLARE @hasaccess int
DECLARE @denylogin int
DECLARE @is_disabled int
DECLARE @PWD_varbinary  varbinary (256)
DECLARE @PWD_string  varchar (514)
DECLARE @SID_varbinary varbinary (85)
DECLARE @SID_string varchar (514)
DECLARE @tmpstr  varchar (1024)
DECLARE @is_policy_checked varchar (3)
DECLARE @is_expiration_checked varchar (3)

DECLARE @defaultdb sysname
 
IF (@login_name IS NULL)
  DECLARE login_curs CURSOR FOR

      SELECT p.sid, p.name, p.type, p.is_disabled, p.default_database_name, l.hasaccess, l.denylogin FROM 
sys.server_principals p LEFT JOIN sys.syslogins l
      ON ( l.name = p.name ) WHERE p.type IN ( 'S', 'G', 'U' ) AND p.name <> 'sa' and p.name not like '%\%'
ELSE
  DECLARE login_curs CURSOR FOR


      SELECT p.sid, p.name, p.type, p.is_disabled, p.default_database_name, l.hasaccess, l.denylogin FROM 
sys.server_principals p LEFT JOIN sys.syslogins l
      ON ( l.name = p.name ) WHERE p.type IN ( 'S', 'G', 'U' ) AND p.name = @login_name
OPEN login_curs

FETCH NEXT FROM login_curs INTO @SID_varbinary, @name, @type, @is_disabled, @defaultdb, @hasaccess, @denylogin
IF (@@fetch_status = -1)
BEGIN
  PRINT 'No login(s) found.'
  CLOSE login_curs
  DEALLOCATE login_curs
  RETURN -1
END
SET @tmpstr = '/* sp_help_revlogin script '
PRINT @tmpstr
SET @tmpstr = '** Generated ' + CONVERT (varchar, GETDATE()) + ' on ' + @@SERVERNAME + ' */'
PRINT @tmpstr
PRINT ''
WHILE (@@fetch_status <> -1)
BEGIN
  IF (@@fetch_status <> -2)
  BEGIN
    PRINT ''
    SET @tmpstr = '-- Login: ' + @name
    PRINT @tmpstr
    IF (@type IN ( 'G', 'U'))
    BEGIN -- NT authenticated account/group

      SET @tmpstr = 'CREATE LOGIN ' + QUOTENAME( @name ) + ' FROM WINDOWS WITH DEFAULT_DATABASE = [' + @defaultdb + ']'
    END
    ELSE BEGIN -- SQL Server authentication
        -- obtain password and sid
            SET @PWD_varbinary = CAST( LOGINPROPERTY( @name, 'PasswordHash' ) AS varbinary (256) )
        EXEC sp_hexadecimal @PWD_varbinary, @PWD_string OUT
        EXEC sp_hexadecimal @SID_varbinary,@SID_string OUT
 
        -- obtain password policy state
        SELECT @is_policy_checked = CASE is_policy_checked WHEN 1 THEN 'ON' WHEN 0 THEN 'OFF' ELSE NULL END FROM sys.sql_logins WHERE name = @name
        SELECT @is_expiration_checked = CASE is_expiration_checked WHEN 1 THEN 'ON' WHEN 0 THEN 'OFF' ELSE NULL END FROM sys.sql_logins WHERE name = @name
 
            SET @tmpstr = 'CREATE LOGIN ' + QUOTENAME( @name ) + ' WITH PASSWORD = ' + @PWD_string + ' HASHED, SID = ' + @SID_string + ', DEFAULT_DATABASE = [' + @defaultdb + ']'

        IF ( @is_policy_checked IS NOT NULL )
        BEGIN
          SET @tmpstr = @tmpstr + ', CHECK_POLICY = ' + @is_policy_checked
        END
        IF ( @is_expiration_checked IS NOT NULL )
        BEGIN
          SET @tmpstr = @tmpstr + ', CHECK_EXPIRATION = ' + @is_expiration_checked
        END
    END
    IF (@denylogin = 1)
    BEGIN -- login is denied access
      SET @tmpstr = @tmpstr + '; DENY CONNECT SQL TO ' + QUOTENAME( @name )
    END
    ELSE IF (@hasaccess = 0)
    BEGIN -- login exists but does not have access
      SET @tmpstr = @tmpstr + '; REVOKE CONNECT SQL TO ' + QUOTENAME( @name )
    END
    IF (@is_disabled = 1)
    BEGIN -- login is disabled
      SET @tmpstr = @tmpstr + '; ALTER LOGIN ' + QUOTENAME( @name ) + ' DISABLE'
    END
    PRINT @tmpstr
  END

  FETCH NEXT FROM login_curs INTO @SID_varbinary, @name, @type, @is_disabled, @defaultdb, @hasaccess, @denylogin
   END
CLOSE login_curs
DEALLOCATE login_curs
RETURN 0
GO

How to create / consume a .Net web service

Administrator — Sat, 19 Dec 2009 20:44:24 GMT

[WebService(Namespace = "http://server")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class myservice : WebService {
    [WebMethod]
    public string someq(string var1, string var2)
    {        
        return var1+var2;
    }

$wsdl = "http://server/service.asmx?wsdl";
$client = new SoapClient($wsdl);
var_dump($client->someq(array('var1'=>"val1", 'var2'=>"val2")));
?>

Restore Show Desktop icon to Quick Launch bar

Administrator — Fri, 11 Dec 2009 22:34:32 GMT

regsvr32 /n /i:U shell32

How to fix a database in one simple step

Administrator — Wed, 09 Dec 2009 08:58:58 GMT

DECLARE @db nvarchar(50)
set @db='my.datab.name'
--close all connections
DECLARE @SPId int
DECLARE @CMD varchar(100)
DECLARE my_cursor CURSOR FAST_FORWARD FOR
SELECT SPId FROM MASTER..SysProcesses
WHERE DBId = DB_ID(@db) AND SPId <> @@SPId
OPEN my_cursor
FETCH NEXT FROM my_cursor INTO @SPId
WHILE @@FETCH_STATUS = 0
BEGIN
SELECT @CMD = 'KILL ' + CAST(@SPId AS varchar(10))
EXEC (@CMD)
FETCH NEXT FROM my_cursor INTO @SPId
END
CLOSE my_cursor
DEALLOCATE my_cursor

exec('ALTER DATABASE ['+ @db +'] SET SINGLE_USER WITH NO_WAIT')
dbcc checkdb(@db, REPAIR_ALLOW_DATA_LOSS)
exec('ALTER DATABASE ['+ @db +'] SET MULTI_USER WITH NO_WAIT')
--try another dbcc checkdb afterwards to be sure it's fixed