Showing posts with label dba. Show all posts
Showing posts with label dba. Show all posts

Sunday, March 11, 2012

chinese localization of english software suite

Hi,
Our company is planning a project to localise our current software suite for
chinese market. As a SQL DBA, I would like to get more information of what
is involved from database admin and development perspective. I would
appreciate any help, artical links and/or materials links etc. Thanks.
I'm interested in this too. I would guess that you need Chinese locale,
collation etc. for the specific database.
Tables would be able to store Chinese characters. Developing programs may
still use English.
"flologic" <flo@.flo.net> wrote in message
news:%23bdrZYqlEHA.1244@.TK2MSFTNGP15.phx.gbl...
> Hi,
> Our company is planning a project to localise our current software suite
for
> chinese market. As a SQL DBA, I would like to get more information of what
> is involved from database admin and development perspective. I would
> appreciate any help, artical links and/or materials links etc. Thanks.
>
|||Here are some good article you can start with
http://msdn.microsoft.com/library/de...server2000.asp
http://www.microsoft.com/globaldev/g...s/wrguide.mspx
http://msdn.microsoft.com/library/de...plications.asp
Wei Xiao [MSFT]
SQL Server Storage Engine Development
This posting is provided "AS IS" with no warranties, and confers no rights.
"Richard Ding" <rding@.acadian-asset.com> wrote in message
news:u$eSew0lEHA.2380@.TK2MSFTNGP14.phx.gbl...
> I'm interested in this too. I would guess that you need Chinese locale,
> collation etc. for the specific database.
> Tables would be able to store Chinese characters. Developing programs may
> still use English.
>
> "flologic" <flo@.flo.net> wrote in message
> news:%23bdrZYqlEHA.1244@.TK2MSFTNGP15.phx.gbl...
> for
>

chinese localization of english software suite

Hi,
Our company is planning a project to localise our current software suite for
chinese market. As a SQL DBA, I would like to get more information of what
is involved from database admin and development perspective. I would
appreciate any help, artical links and/or materials links etc. Thanks.I'm interested in this too. I would guess that you need Chinese locale,
collation etc. for the specific database.
Tables would be able to store Chinese characters. Developing programs may
still use English.
"flologic" <flo@.flo.net> wrote in message
news:%23bdrZYqlEHA.1244@.TK2MSFTNGP15.phx.gbl...
> Hi,
> Our company is planning a project to localise our current software suite
for
> chinese market. As a SQL DBA, I would like to get more information of what
> is involved from database admin and development perspective. I would
> appreciate any help, artical links and/or materials links etc. Thanks.
>|||Here are some good article you can start with
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/intlfeaturesinsqlserver2000.asp
http://www.microsoft.com/globaldev/getWR/steps/wrguide.mspx
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpcondesigningglobalapplications.asp
Wei Xiao [MSFT]
SQL Server Storage Engine Development
This posting is provided "AS IS" with no warranties, and confers no rights.
"Richard Ding" <rding@.acadian-asset.com> wrote in message
news:u$eSew0lEHA.2380@.TK2MSFTNGP14.phx.gbl...
> I'm interested in this too. I would guess that you need Chinese locale,
> collation etc. for the specific database.
> Tables would be able to store Chinese characters. Developing programs may
> still use English.
>
> "flologic" <flo@.flo.net> wrote in message
> news:%23bdrZYqlEHA.1244@.TK2MSFTNGP15.phx.gbl...
>> Hi,
>> Our company is planning a project to localise our current software suite
> for
>> chinese market. As a SQL DBA, I would like to get more information of
>> what
>> is involved from database admin and development perspective. I would
>> appreciate any help, artical links and/or materials links etc. Thanks.
>>
>

Sunday, February 19, 2012

Checking Jobs Status through Query

I am a Junior DBA and i have to checks the various jobs on different servers.Please help me with a T-SQL way by which i can check the Job status through a Query.

Thanks in Advance

Jacx

you can use opennrowset or openquery to

query other servers

job information are stored in msdb and you can invoke the

following to query job information

use msdb
select * from sysjobs
select * from sysjobhistory

|||

tually i wanted a code to find the urrent job status of a particular job which i am inerested in. Kindly help me with that.

Thanks

Jacx

|||

use msdb
select * from sysjobs sj join --<change the * to get only the columns you need
sysjobhistory sjh
on sj.job_id=sjh.job_id
where name like 'W%' <modify this for the job name

check the run status

check this link

http://msdn2.microsoft.com/en-gb/library/ms174997.aspx

Thursday, February 16, 2012

Checking for free disk space and getting mail when it falls below a certain limit

Hello

I have a script which checks the disk space and when it falls a certain size , it mails the dba mail box.

I would like to know how I can change it , as a percentage calculation.

For example when the free space is less than 20% of the total space on the drive I should be receiving a mail.

The script I have is :

declare @.MB_Free int

create table #FreeSpace(
Drive char(1),
MB_Free int)

insert into #FreeSpace exec xp_fixeddrives
-- Free Space on F drive Less than Threshold
if @.MB_Free < 4096
exec master.dbo.xp_sendmail
@.recipients ='dvaddi@.domain.edu',
@.subject ='SERVER X - Fresh Space Issue on D Drive',
@.message = 'Free space on D Drive
has dropped below 2 gig'
drop table #freespace

Thanks

Hi Vaddi -

Why not use the Alerts feature in Performance Monitor? The Logical Disk Performance Object has a Counter for % Free Space and you can select which drive letter you'd like to monitor. Once the limit is reached, you can have it email you using a WSH script.

HTH...

checking for free disk space and getting mail , when falls below a certain limit

Hello

I have a script which checks the disk space and when it falls a certain size , it mails the dba mail box.

I would like to know how I can change it , as a percentage calculation.

For example when the free space is less than 20% of the total space on the drive I should be receiving a mail.

The script I have is :

declare @.MB_Free int

create table #FreeSpace(
Drive char(1),
MB_Free int)

insert into #FreeSpace exec xp_fixeddrives
-- Free Space on F drive Less than Threshold
if @.MB_Free < 4096
exec master.dbo.xp_sendmail
@.recipients ='dvaddi@.domain.edu',
@.subject ='SERVER X - Fresh Space Issue on D Drive',
@.message = 'Free space on D Drive
has dropped below 2 gig'
drop table #freespace

ThanksHere's what I use:
set nocount on

declare @.MB_Threshold int
set @.MB_Threshold = 102400
declare @.From varchar(500)
declare @.Subject varchar(500)
declare @.Message varchar(500)

create table #FreeSpace(Drive char(1), MB_Free int)

insert into #FreeSpace exec master..xp_fixeddrives

select @.Message = isnull(@.Message + ', ', 'The following drives have dropped below ' + cast(@.MB_Threshold as varchar(10)) + ' MB free space: ') + Drive
from #FreeSpace
where MB_Free < @.MB_Threshold

set @.From = @.@.ServerName
set @.Subject = 'Drive space warning!'

if len(@.Message) > 0
begin
exec master.dbo.xp_smtp_sendmail
@.SERVER = 'exchange.foobar.corp',
@.FROM = @.From,
@.TO = N'blindman@.dbforums.com',
@.SUBJECT = @.Subject,
@.MESSAGE = @.Message

end

drop table #FreeSpace
go