招聘MsSQL DBA - 上海
有意者请联系yushan-33@hotmail.com / 18821146311
Microsoft SQL Administrator
Job Description:
A detail oriented Microsoft SQL Administratorwith excellent problem solving, analytical skills and a proven track record in managing production level environments to join our Information Technology team. The successful incumbent will be responsible for the day to day administration of current SQL Server environment. In addition He / She will be involved with designing and implementing a new scalable, highly-available global data architecture.
This position is located in Shanghai, China.
Responsibilities:
- Review and analyze database requirements; develop detailed database design specifications to meet identified requirements.
- Review and analyze user needs; determine equipment and software requirements for solutions to problems.
- Install and maintain database performance by developing tuning methodologies.
- Manage and implement database security and user accounts.
- Design and implement backup and recovery strategies.
- Assist with the design and development of data models as needed.
- Assist with the development and implementation of database/SQL standards and methodologies.
- Analyze and report on database metrics; administer and control data resources; monitor and ensure database integrity, security, an
相关问答:
说来害羞哈,呵呵……
自学编程已经两年多了,还不会查看数据库连接池啊,请大侠们说一下怎样查看呀?
比方说,我用IE和FF和Opera同时以三个用户身份打开本地网站(网站在IIS上,地址如http://127.0.0.1/M ......
假设有两张表,t1 t2
t1:id 字段1 字段2 字段3
t2:id 字段4 字段5 字段6
现用一条查询语句select t1.*,t2.* from t1,t2 where t1.id=t2.id and 条件……
将符合条件的数据从mssql数据库中导出至exce ......
mssql在另外一台电脑上恢复备份后,不能连接,使用sa帐户也不能连接,以前也遇到类似问题一直得不到解决
请高手帮忙解答?
但是选择访问数据库的时候,提示"21002用户""已经存在"错误?
......
我连接了两个数据库,mssql,access
如何在同一个按钮下操作两个数据库的表
比如,我通过复杂的sql语句从mssql数据库多个表取得了数据
然后插入access数据库某一个表中
SQL code:
SQL SER ......
mssql 判断是否是日期?
SQL code:
declare @var int
set @var= isdate('g')
if @var =0
print '不是有效日期'
else
print '是有效日期'
SQL code:
select * from tb where isdate(字段)=1 ......