Wednesday, October 20, 2010

Server(instance), Databases, Table columns collation in SQL Server

Script that returns all available collations

select * from fn_helpcollations()

Script that returns all your databases' collations

select name, collation_name

from sys.databases

SELECT DATABASEPROPERTYEX('timetableuws', 'Collation')

Query that returns your sql server instance's collation

select SERVERPROPERTY('collation')

Query table columns collation:

SELECT name, collation_name
FROM sys.columns
FROM sys.objects
WHERE type = 'U'
AND name = 'reg2003AU')

Change database collation

alter database collationtest collate Cyrillic_General_CI_AS

How to change database or server collation in SQL Server

Apple Stuff

Change the String in SystemInfo.plist to 10.5.7
/System/Library/Core Services/SystemVersion.plist

[Mac OSx86] How To Change Resolution (VMware)


How to increase the resolution of OSx86 in VMware without VMware Tools


There are 2 ways you can do this.

Method 1: Temporary

When OSX is booting, tap F8 to get to the boot prompt
Type in "Graphics Mode"="1280x1024x32" (with quotations, replacing the resolution with the resolution you want)

Method 2: Permanent

Boot OS X
Open the TextEdit program in the Applications folder
With TextEdit, open the file: /Library/Preferences/SystemConfiguration/
Open the file, and add these two lines (right after the Yes line if you are on Tiger or line if you are on Leopard)

Graphics Mode

Replace the 1280x1024x32 with the resolution you want
Then, in go to File >> Save As..
Save the file as on the Desktop (make sure the .plist part is there!)
Navigate the the /Library/Preferences/SystemConfiguration/ folder
Drag your file on the Desktop into the folder window
When a messages appears, click Authenticate and Replace and enter your password
You're done! Reboot OS X to see the changes

Here is an example of what the com.Apple.boot.plist file looks like with Leopard:

Tuesday, October 19, 2010

DPM 2010

DPM 2010 Qucic Start Guide:
DPM requires a supported 64-bit or 32-bit version of SQL Server 2008 SP1, Enterprise or Standard Edition, for the DPM database. This guide assumes that you will install a dedicated instance of SQL Server from DPM Setup

Continuous data protection of Windows application and file servers to seamlessly integrated disk, tape, and cloud — with support for a growing list of Microsoft technologies, such as:

Windows Server from 2003 through 2008 R2

SQL Server 2000 through 2008 R2

Exchange Server 2003 through 2010

SharePoint Server 2003 through 2010

Dynamics AX 2009

Cool Stuff


Updated SQL 2008 MCM Pre-reading list

Clone user Table with collation in SQL Server 2005

Checking collation of Cloumns

SELECT name, collation_name
FROM sys.columns
FROM sys.objects
WHERE type = 'U'
AND name = 'reg2003AU')

Clone table structure from existing one with collation.

select reg2003AU.*
into reg2003AUabccd
from reg2003AU
where 1=2