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
WHERE OBJECT_ID IN ( SELECT OBJECT_ID
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
http://www.db-staff.com/index.php/microsoft-sql-server/69-change-collation

Apple Stuff

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

http://3l3373.com/iphone-sdk-3-3-on-osx-10-5-5/



[Mac OSx86] How To Change Resolution (VMware)
http://pcwizcomputer.com/index.php?option=com_content&task=view&id=31&Itemid=32

Description:

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/com.apple.Boot.plist
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
1280x1024x32


Replace the 1280x1024x32 with the resolution you want
Then, in go to File >> Save As..
Save the file as com.apple.Boot.plist on the Desktop (make sure the .plist part is there!)
Navigate the the /Library/Preferences/SystemConfiguration/ folder
Drag your com.apple.Boot.plist 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: http://technet.microsoft.com/en-us/library/ff399378.aspx
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



http://www.microsoft.com/systemcenter/en/us/data-protection-manager/dpm-2010-overview.aspx

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

RAMdisk: http://memory.dataram.com/products-and-services/software/ramdisk#download-ramdisk

Updated SQL 2008 MCM Pre-reading list

http://blogs.technet.com/b/themasterblog/archive/2009/12/07/updated-sql-2008-mcm-pre-reading-list.aspx

https://dynamicevents.emeetingsonline.com/emeetings/dynamicevents/290/MCM_SQL2008_Pre-reading_v3.pdf

Clone user Table with collation in SQL Server 2005

Checking collation of Cloumns

SELECT name, collation_name
FROM sys.columns
WHERE OBJECT_ID IN ( SELECT OBJECT_ID
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