Sunday, March 11, 2012
chinese localization of english software suite
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
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
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
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