Weekly Shaarli

All links of one week in a single page.

Week 21 (May 21, 2012)

A Pequena Grande Crise | UOL Jogos Online

Entenda sobre a crise dos EUA com "A Pequena Grande Crise", finalista do Nave Awards e Oi Futuro.

Download: EPS English - Windows Server 2008 w/ SQL Server 2005 - Microsoft Download Center - Download Details

This download comes as a pre-configured VHD. This download enables testing of application designs on the Windows Server Platform.

Default password: pass2word1

Scripting user permissions using catalog views in SQL Server 2005 : Narayana Vyas Kondreddi's home page

--Script created by Vyas
--http://vyaskn.tripod.com

SET NOCOUNT ON

DECLARE @OldUser sysname, @NewUser sysname

SET @OldUser = 'HRUser'
SET @NewUser = 'PersonnelAdmin'

SELECT 'USE' + SPACE(1) + QUOTENAME(DB_NAME()) AS '--Database Context'

SELECT '--Cloning permissions from' + SPACE(1) + QUOTENAME(@OldUser) + SPACE(1) + 'to' + SPACE(1) + QUOTENAME(@NewUser) AS '--Comment'

SELECT 'EXEC sp_addrolemember @rolename ='

  • SPACE(1) + QUOTENAME(USER_NAME(rm.role_principal_id), '''') + ', @membername =' + SPACE(1) + QUOTENAME(@NewUser, '''') AS '--Role Memberships'
    FROM sys.database_role_members AS rm
    WHERE USER_NAME(rm.member_principal_id) = @OldUser
    ORDER BY rm.role_principal_id ASC

SELECT CASE WHEN perm.state <> 'W' THEN perm.state_desc ELSE 'GRANT' END

  • SPACE(1) + perm.permission_name + SPACE(1) + 'ON ' + QUOTENAME(USER_NAME(obj.schema_id)) + '.' + QUOTENAME(obj.name)
  • CASE WHEN cl.column_id IS NULL THEN SPACE(0) ELSE '(' + QUOTENAME(cl.name) + ')' END
  • SPACE(1) + 'TO' + SPACE(1) + QUOTENAME(@NewUser) COLLATE database_default
  • CASE WHEN perm.state <> 'W' THEN SPACE(0) ELSE SPACE(1) + 'WITH GRANT OPTION' END AS '--Object Level Permissions'
    FROM sys.database_permissions AS perm
    INNER JOIN
    sys.objects AS obj
    ON perm.major_id = obj.[object_id]
    INNER JOIN
    sys.database_principals AS usr
    ON perm.grantee_principal_id = usr.principal_id
    LEFT JOIN
    sys.columns AS cl
    ON cl.column_id = perm.minor_id AND cl.[object_id] = perm.major_id
    WHERE usr.name = @OldUser
    ORDER BY perm.permission_name ASC, perm.state_desc ASC

SELECT CASE WHEN perm.state <> 'W' THEN perm.state_desc ELSE 'GRANT' END

  • SPACE(1) + perm.permission_name + SPACE(1)
  • SPACE(1) + 'TO' + SPACE(1) + QUOTENAME(@NewUser) COLLATE database_default
  • CASE WHEN perm.state <> 'W' THEN SPACE(0) ELSE SPACE(1) + 'WITH GRANT OPTION' END AS '--Database Level Permissions'
    FROM sys.database_permissions AS perm
    INNER JOIN
    sys.database_principals AS usr
    ON perm.grantee_principal_id = usr.principal_id
    WHERE usr.name = @OldUser
    AND perm.major_id = 0
    ORDER BY perm.permission_name ASC, perm.state_desc ASC
HOME | Euro NCAP - For safer cars crash test safety rating

Euro NCAP provides motoring consumers - both drivers and the automotive industry - with a realistic and independent assessment of the safety performance of some of the most popular cars sold in Europe.

Download: SQL 2008 on Windows Server 2008 - Microsoft Download Center - Download Details

VHD Test Drive Evaluation Package:

Windows Server 2008 R1 Enterprise (x64) Server Full Installation + SQL Server 2008

VHD Test Drive Overview

This image is provided through the Microsoft VHD Test Drive Program. The intent of this program is to provide customers with fully configured virtual machines for the purpose of test, evaluation, demonstration, training & education and proof of concept. VHD Test Drive images may contain software from Microsoft and Microsoft partners. This image is part of a library and program that is expanding rapidly. Partners are encouraged to write VHDINFO@microsoft.com with regard to questions, issues and desired images.

Use the following information to log on to Microsoft Windows contained within the virtual machine

· Username: Administrator
· Password: pass@word1

Password Strength | Password Strength Calculator and Strength Checker
How Secure Is My Password?
How to transfer the logins and the passwords between instances of SQL Server 2005 and SQL Server 2008
Capture web page screenshot entirely? That's easy with FireShot!

FireShot is an extension for Firefox, Internet Explorer, Chrome, Seamonkey and Thunderbird that captures, edits, annotates, organizes, exports, uploads and prints screenshots of your web pages.

Getting Real: The bestselling book by 37signals

Vous voulez construire une application web réussie ? Alors il est temps de Get Real. Getting Real est une manière de construire plus simplement, plus rapidement et mieux un logiciel.

Want to build a successful web app? Then it's time to Get Real. Getting Real is a smaller, faster, better way to build software.

eng
http://gettingreal.37signals.com/toc.php

por
http://gettingreal.37signals.com/GR_por.php

NRJ Hit music only
AJE - Al Jazeera English
Acrimed | Action Critique Médias

Née du mouvement social de 1995, dans la foulée de l’Appel à la solidarité avec les grévistes, notre association, pour remplir les fonctions d’un observatoire des médias s’est constituée, depuis sa création en 1996, comme une association-carrefour. Elle réunit des journalistes et salariés des médias, des chercheurs et universitaires, des acteurs du mouvement social et des « usagers » des médias. Elle cherche à mettre en commun savoirs professionnels, savoirs théoriques et savoirs militants au service d’une critique indépendante, radicale et intransigeante.

Password Strength Checker
Accueil | Fondation Sommeil

L'identification de ces objectifs découle des besoins fondamentaux des personnes ayant des troubles de sommeil, en complément aux traitements médicaux. Le plan d'action de 2009-2010 permettra de mettre rapidement chacun de ces objectifs sur des assises solides, et leur réalisation complète se poursuivra dans les années suivantes. C'est pourquoi votre contribution la financière ou votre adhésion à Fondation Sommeil est indispensable.