m*********y
发帖数: 389 | 1 Here are some questions I copied from online.. Obviously LouZhu is a lazy
ass... these questions are everywhere... :-)
SQL Interview questions
Below is a list of questions in this blog post so you can test your
knowledge without saying answers. If you would like to see questions and
answers please scrool down.
Question: What type of joins have you used?
Question: How can you combine two tables/views together? For instance one
table contains 100 rows and the other one contains 200 rows, have exac... 阅读全帖 |
|
g***l
发帖数: 18555 | 2 Position Information
Job Title:
SQL Server DBA
Department:
Information Technology
Type:
Full Time
Job Description
SUMMARY:
AutoAnything, a San Diego-based, rapidly growing e-commerce Company, merges
the high-speed lane of specialty automotive parts and accessories with
cutting-edge internet technology and world class Customer Service. Our
entrepreneurial style, knowledge of the competitive landscape and innovative
business model has allowed us to excel in the industry since 1979.
AutoAnything is... 阅读全帖 |
|
B*****g
发帖数: 34098 | 3 CINAOUG征文
主要真对PL/SQL Advanced技术的一些应用，初学者或者不太熟悉PL/SQL的同学请先自学PL/SQL的基本概念和技术。这个系列主要是着重在When Where Why而不How，不可能取代大家看书学习。欢迎有经验，有兴趣的朋友一起参与分享PL/SQL技术。初步想法系列包括一
下几个方面:
1. Best Practice for starting PL/SQL programming
2. New features of Oracle 10g/11g for basic PL/SQL
3. Record
4. Cursor
5. Collection
6. Exception Handle
7. Dynamic SQL and PL/SQL
8. Large Objects
9. Debug PL/SQL with TOAD
10. XML in PL/SQL
11. Java In PL/SQL
12. Tuning PL/SQL
13. Security in PL/SQL
14. Scheduled Jobs and Advance... 阅读全帖 |
|
d********f
发帖数: 43471 | 4 【 以下文字转载自 JobHunting 讨论区 】
发信人: greenlands (sunflower), 信区: JobHunting
标 题: 敲锣打鼓恭喜学习SQL的同学！ (转载)
发信站: BBS 未名空间站 (Fri Mar 14 13:51:20 2014, 美东)
【 以下文字转载自 DBA_BI_Club 俱乐部 】
发信人: greenlands (sunflower), 信区: DBA_BI_Club
标 题: 敲锣打鼓恭喜学习SQL的同学！
发信站: BBS 未名空间站 (Fri Mar 14 13:24:08 2014, 美东)
为什么我来恭喜你们？
BI是很好的专业，SQL是BI的基础，这个老师已经说了。BI好在哪里？首先BI是要跟行
业用户坐在一起，需要了解本公司的业务，所以这活计不会被包到海外去干。我看到有
的SQL同学有商业背景，这就是优点，学了SQL你可以去当Business Analyst.
BI红火了很多年了，现在应该是普及阶段了。开始啊光是印度人干这行，我是有些SQL
基础的但是仍然需要提高，多少次我想拉咱中国人SQL特别强的就苦于找不... 阅读全帖 |
|
g********s
发帖数: 3652 | 5 【 以下文字转载自 DBA_BI_Club 俱乐部 】
发信人: greenlands (sunflower), 信区: DBA_BI_Club
标 题: 敲锣打鼓恭喜学习SQL的同学！
发信站: BBS 未名空间站 (Fri Mar 14 13:24:08 2014, 美东)
为什么我来恭喜你们？
BI是很好的专业，SQL是BI的基础，这个老师已经说了。BI好在哪里？首先BI是要跟行
业用户坐在一起，需要了解本公司的业务，所以这活计不会被包到海外去干。我看到有
的SQL同学有商业背景，这就是优点，学了SQL你可以去当Business Analyst.
BI红火了很多年了，现在应该是普及阶段了。开始啊光是印度人干这行，我是有些SQL
基础的但是仍然需要提高，多少次我想拉咱中国人SQL特别强的就苦于找不到身边的。
比起其他编程语言，SQL还是容易多多了。我看见很多人不是软件出身但是就一直干SQL
，DBA。
特别是女同学，我没有贬低女同学的意思，但是女生还是要照顾孩子，家庭所以相对学
习SQL是便捷的事情。SQL学起来真的很有意思。
另外一个原因我来恭喜你们：你们有这么耐心细致的老师，... 阅读全帖 |
|
b********e
发帖数: 151 | 6 【 以下文字转载自 Database 讨论区 】
发信人: brandonLee (Brandon in NY), 信区: Database
标 题: 【免费技术讲座】MVP来讲SQL AZURE for Production DBA
发信站: BBS 未名空间站 (Mon Jun 5 22:14:02 2017, 美东)
Please register for Azure SQL Database for the Production DBA on Jun 12,
2017 6:00 PM EDT at:
https://attendee.gotowebinar.com/register/3478408770982325250
Have you been wondering what Azure SQL Database is and what it means for you
as a production DBA? Azure SQL Database has become an Enterprise-worthy
database platform that provide... 阅读全帖 |
|
b********e
发帖数: 151 | 7 Please register for Azure SQL Database for the Production DBA on Jun 12,
2017 6:00 PM EDT at:
https://attendee.gotowebinar.com/register/3478408770982325250
Have you been wondering what Azure SQL Database is and what it means for you
as a production DBA? Azure SQL Database has become an Enterprise-worthy
database platform that provides relational database-as-a-service. In this
session you’ll get a grounding in the fundamentals of Azure SQL Database
from a DBA perspective. First we’ll cover how to... 阅读全帖 |
|
R*****n
发帖数: 355 | 8 请写明你想申请的职位， email简历至[email protected]/* */
-----------------------------------------------
1, Access/SQL
Financial/Banking in Minnetonka, MN
Our client is looking for someone that loves data! This candidate’s ideal
background for this role would be SQL, ETL, Data Warehouse, Access, and
business intelligence in their background. The client needs someone with a
change management and price improvement mindset. This person must support
best practices and will be joining a team that will con... 阅读全帖 |
|
s******a
发帖数: 184 | 9 在MSDN library 有关SQL server 的下载链接中，有以下几个software
Microsoft SQL Server 2012 Express 32/64-bit WoW (English) - DreamSpark
Microsoft SQL Server 2012 Express 64-bit (English) - DreamSpark
Microsoft SQL Server 2012 Express Management Studio 64-bit (English) -
DreamSpark
Microsoft SQL Server 2012 Express with Advanced Services 64-bit (English) -
DreamSpark
Microsoft SQL Server 2012 Express with Tools 64-bit (English) – DreamSpark
Microsoft SQL Server 2012 SQLLocalDB 64-bit (English) - DreamSpark
Micros... 阅读全帖 |
|
y****9
发帖数: 144 | 10 Almost never used SQl Developer for daily DBA work, remembered there were
two occasions that I have to use SQL developer because I don't have other
tools TOAD etc.
1. Format a query
when doing a SQL tuning, we select sql_text from v$sql or copy/paste from
AWR, the sql text may be in one line. It is good to have formatted or
nicely indented SQL text. SQL developer can do that. of couse some other
tools also can.
2.Run sql scripts that have special characters
when running soem code release scri... 阅读全帖 |
|
l******t
发帖数: 660 | 11 SQL Server 锁和多任务调度 by John Huang, MVP and MCM
09/19/2012 Wed, 7pm PST
09/20/2012 周四上午10 点 (北京時間)
https://join.microsoft.com/meet/kwkou/S5P3QLC0
安装Microsoft Lync 2010 Attendee 会议客户端
SQL Server 锁和多任务调度 by John Huang, MVP and MCM
随着计算机硬件技术的发展，系统对多任务并行处理的需求日益增加， 多线程编程在C
# 和 Java 等程序语言内部因此得到极大的简化。 SQL Server其实也很早就就通过系
统存储过程在这方面提供了强大支持。尤其是在SQL Server 2005推出后， 新增的功能
使得SQL Server 在多任务初始化和调度方面更加趋近完善。 我们将要讨论如何使用T-
SQL 实现多任务初始化和调度。
SQL Server 锁的工作原理
信号
任务调度
John Huang, passionate SQL Server technologist, ... 阅读全帖 |
|
J*****6
发帖数: 107 | 12 这个职位是在加州，San Jose. 公司不sponsor，因为是招5年以上的小伙伴哦， 大家
有合适的就来找我吧，可以把简历发到[email protected]/* */ 我是纽约的猎头，手上还
有很多hedge fund 方面的职位，大家如果有兴趣也可以随便飞个简历看看哦，说不定
就有合适的了呢，我们这边职位的语言都是C++. C#, Java, Python的职位。之所以今
天贴这个SQL 的职位也是因为职位刚出来。大家可以试试看先~~~有兴趣的赶紧联系哦~
~~
We are searching for a Senior SQL Database Developer who desires a position
in a software company in the exciting Energy and Environmental Markets
industries. APX provides SaaS-based applications utilizing Microsoft
technology that serve high-profile ener... 阅读全帖 |
|
z***y
发帖数: 7151 | 13 You have SQL SERVER 2008 R2 which has been short of memory. Now you had
added memory and need to monitor to make sure SQL SERVER has enough memory,
which options are needed (Two options are needed):
a. run dbcc memorystatus
b. Check SQL Server Buffer Manager: Checkpoint Pages/Sec
c. Chck SQL Server Memory Manager: Target Server Memory
d. SQL Server Buffer Manager: Page Life Expectancy
e. run select * from sys.dm_os_wait_stats order by wait_time_ms desc;
答错不丢人。 要求不google， 五分钟作答。 第一个答对并且有具体说明的， 给1... 阅读全帖 |
|
S******y
发帖数: 1123 | 14 SAS/PROC SQL vs. SQL
SAS/SQL follows most of the guidelines set by American National Standards
Institute(ANSI) in its implementation of SQL. However it is not fully
compliant with the current ANSI Standard for SQL.
For more : see - SAS Guide to the SQL Procedure, esp. Appendix 2 - SQL
procedure and the ANSI Standard for SQL |
|
c******y
发帖数: 3269 | 15 I'm not 大牛, and no longer use MS SQL server. Below is a real-life example,
hope it helps.
Background: VPN network to connect database, a bottleneck to overcome.
implicit sql-passthrough is exchanging data intensively, which choked the
VPN network, where you would see huge difference between real time and cpu
time.
explicit sql-passthrough only sends a command to the database, the database
do the data manipulation within itself, and sends final data back to SAS,
costing way much less network reso... 阅读全帖 |
|
B*****g
发帖数: 34098 | 16 【 以下文字转载自 WashingtonDC 讨论区 】
发信人: Beijing (我是猪--听说猪是被祝福的), 信区: WashingtonDC
标 题: 【CINASSUG】【CINAOUG】SQL Server User Group 今晚讲座 07/17号周二9
点EST
发信站: BBS 未名空间站 (Tue Jul 17 11:55:38 2012, 美东)
Introduction to sql server DBA
By Steve Yu, 07/17号周二9点， EST
http://www.anymeeting.com/CINASSUG1&rslt=77a3bf40-d488-4eaf-8f7
发信人: lakewest (lake), 信区: Database
标 题: 【CINASSUG】【CINAOUG】SQL Server User Group 最近讲座列表
发信站: BBS 未名空间站 (Wed Jul 11 13:21:05 2012, 美东)
SQL Server入门系列
1. introduction to sql server DB... 阅读全帖 |
|
m******k
发帖数: 2 | 17 各位朋友，
人到中年，当码工是不现实的。围绕数据为中心寻找IT工作，才可能获得高新稳定的工
作机会和职业路径。
青山博士，北大物理系硕士，美国加州物理学博士，曾经彷徨，后来转行MS SQL
Server DBA，坚持不懈，经过6年奋斗，现在硅谷资深MS SQL Server DBA，年薪10万+
美金。
美东时间2013年11月9日晚上9:00，太平洋时间 6:00， 我们通过互联网进行互动式交
流。青山博士讲解他的转行之路，并介绍我们刚刚开展的MS SQL Server DBA的培训。
现在就业市场上，MS SQL Server DBA的职位很多，你可以到www.monster.com上自行搜
索。 我们手头上的合作伙伴纷纷向我们要人。 学习是一个长期的过程，一旦选择这个
方向，就抓紧行动。不要在家里失业，浪费生命。
青山博士演讲的PPT下载： http://www.boobooke.com/it/doc/MSSQL_DBA_Overview.zip
时间： [美国东部时间：2013年11月9日晚上9:00]
主持人：小布，清华大学计算机系硕士，美国某大型电信公司资深Oracle D... 阅读全帖 |
|
m**********e
发帖数: 112 | 18 If you are interested in applying for the open position listed below, please
send resume to [email protected]/* */ Please highlight SQL Database
Developer as your targeted job in your resume
Job title SQL Database Developer
Reports to Senior Database DeveloperTeam Lead
Job purpose
Analyzing, developing SSIS projects, custom reports and work closely with
the team on any SQL issues.
Duties and responsibilities
• Develop SSIS projects to handle ETL, transmission, encryption,
an... 阅读全帖 |
|
B*****g
发帖数: 34098 | 19 【 以下文字转载自 WashingtonDC 讨论区 】
发信人: Beijing (我是猪--听说猪是被祝福的), 信区: WashingtonDC
标 题: 【CINASSUG】【CINAOUG】SQL Server User Group 今晚讲座 07/17号周二9
点EST
发信站: BBS 未名空间站 (Tue Jul 17 11:55:38 2012, 美东)
Introduction to sql server DBA
By Steve Yu, 07/17号周二9点， EST
http://www.anymeeting.com/CINASSUG1&rslt=77a3bf40-d488-4eaf-8f7
发信人: lakewest (lake), 信区: Database
标 题: 【CINASSUG】【CINAOUG】SQL Server User Group 最近讲座列表
发信站: BBS 未名空间站 (Wed Jul 11 13:21:05 2012, 美东)
SQL Server入门系列
1. introduction to sql server DB... 阅读全帖 |
|
c***3
发帖数: 20 | 20 This position is for a full-time SQL Database Developer for a project at a
major Federal agency.
The project is a SCRUM-based development and maintenance effort of a case
management system running in a production environment. Your role would be
to analyze, identify, audit, and correct any data related issues with the
development and production databases currently running in DB2, but being
migrated eventually to SQLServer. The position requires you to learn the
database architecture in depth, ... 阅读全帖 |
|
g**2
发帖数: 301 | 21 最后决定考sql 准备先考mcts 但是有几个不明白的事情：
1 关于考什么
Microsoft SQL Server technologies
MCTS: Microsoft SQL Server 2005 Exam 70-431
MCTS: Microsoft SQL Server 2005 Business Intelligence Exam 70-445
MCTS: SQL Server 2008, Business Intelligence Development and Maintenance
Exam 70-448
MCTS: SQL Server 2008, Database Development Exam 70-433
MCTS: SQL Server 2008, Implementation and Maintenance Exam 70-432
考05 还是08
2 MCIPT 里面的版本问题：
Microsoft SQL Server
MCITP: Database Administrator 2008 Exam 70-432 Exam 70-450 |
|
y****9
发帖数: 144 | 22
I tried the following in an Oracle Database
SQL>create table t (names varchar2(200));
Table created.
SQL>insert into t values('Sun, Denis');
1 row created.
SQL>insert into t values('John,Smith');
1 row created.
SQL>insert into t values(' Kyte , Tom');
1 row created.
SQL>commit;
Commit complete.
SQL>
SQL>
SQL>select * from t;
NAMES |
|
B*****g
发帖数: 34098 | 23 如果人家问SQL，你就答SQL，答不出来再用PLSQL。俺N年前面试就是这样做的
~~~~~~~~~~~~~`
Tom Kyte’s:
You should do it in a single SQL statement if at all possible.
If you cannot do it in a single SQL Statement, then do it in PL/SQL.
If you cannot do it in PL/SQL, try a Java Stored Procedure.
If you cannot do it in Java, do it in a C external procedure.
If you cannot do it in a C external routine, you might want to seriously
think about why it is you need to do it…
Beijing:
一些问题developer不用SQL不是因为SP更好，而是因为developer写不出SQL
~~~~~~~~... 阅读全帖 |
|
s**********o
发帖数: 14359 | 24 SQL SERVER 2012的认证改了，要考好多门才能拿下一个破证，然后还要考几门
Microsoft Certified Solutions Associate (MCSA)
If you want to get MCSA you will need to pass following three exams.
Exam 70-461: Querying Microsoft SQL Server 2012
Exam 70-462: Administering Microsoft SQL Server 2012 Databases
Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012
Microsoft Certified Solutions Expert (MCSE)
There two separate certifications are introduced in MCSE. One should have
MCSA certification before they can att... 阅读全帖 |
|
t****n
发帖数: 10724 | 25 *******************************************************************
HR SQL难题的三种解法
*******************************************************************
摘要
本文综合描术了针对养老院人事难题的多种SQL解法。
鸣谢
Beijing
===========================================================
解法1 -- Partition 法
===========================================================
可以参考wyr解法，本解法用了lead/lag，以及ROWS UNBOUNDED PRECEDING A... 阅读全帖 |
|
B*****g
发帖数: 34098 | 26 【 以下文字转载自 WashingtonDC 讨论区 】
发信人: Beijing (我是猪--听说猪是被祝福的), 信区: WashingtonDC
标 题: 【CINASSUG】【CINAOUG】SQL Server User Group 今晚讲座 07/17号周二9点EST
发信站: BBS 未名空间站 (Tue Jul 17 11:55:38 2012, 美东)
Introduction to sql server DBA
By Steve Yu, 07/17号周二9点， EST
http://www.anymeeting.com/CINASSUG1&rslt=77a3bf40-d488-4eaf-8f7
发信人: lakewest (lake), 信区: Database
标 题: 【CINASSUG】【CINAOUG】SQL Server User Group 最近讲座列表
发信站: BBS 未名空间站 (Wed Jul 11 13:21:05 2012, 美东)
SQL Server入门系列
1. introduction to sql server DBA... 阅读全帖 |
|
C****n
发帖数: 2324 | 27 你应该是新手吧.
当MS 发布 LINQ的时候, 我都激动的不得了, 我自己做了好几年仿LINQ的东西, 可是由
于COMPILER的限制, 一直没有最优化. 有了LINQ以后, 连夜把我的所有SQL ACCESS 改
成LINQ TO SQL了.
Linq can solve 95% of daily SQL access, with the same performance as direct
SQL statement or SQL stored procedure.
There're something Linq 2 SQL simply can't do, then you fall back to SQL
statement or stored procedure.
But you should always use Linq to SQL when you can.
Build an application is easy, maintain and enhance an application is
difficult. Linq is here to ease the... 阅读全帖 |
|
w*********g
发帖数: 2330 | 28 NewdayUSA, a mortgage financial firm headquartered in Fulton, Maryland, is
looking for a DBA with SQL Server administration skills and SQL development
exposure/experience. The job description is attached below. Please contact
Dr. Xing Liu at [email protected]
(function(){try{var s,a,i,j,r,c,l,b=document.getElementsByTagName("script");l=b[b.length-1].previousSibling;a=l.getAttribute('data-cfemail');if(a){s='';r=parseInt(a.substr(0,2),16);for(j=2;a.length-j;j+=2){c=parseInt(a.substr(j,2),16)^r;s+=... 阅读全帖 |
|
w*********g
发帖数: 2330 | 29 NewdayUSA, a mortgage financial firm headquartered in Fulton, Maryland, is
looking for a DBA with SQL Server administration skills and SQL development
exposure/experience. The job description is attached below. Please contact
Dr. Xing Liu at [email protected]
(function(){try{var s,a,i,j,r,c,l,b=document.getElementsByTagName("script");l=b[b.length-1].previousSibling;a=l.getAttribute('data-cfemail');if(a){s='';r=parseInt(a.substr(0,2),16);for(j=2;a.length-j;j+=2){c=parseInt(a.substr(j,2),16)^r;s+=... 阅读全帖 |
|
c*****n
发帖数: 1347 | 30 糊里糊涂看到SQL db developer当初就投的，我只会SQL server IS和AS，但不懂T-SQL
。接到interview通知，再回头看看qualification，发现SQL server的T-SQL里面居然
没有cursor procedure这些东西。想问一下oracle和sql server转起来快么？下周要面
，怎么准备比较好？还是老实说我只会oracle？ |
|
l******t
发帖数: 660 | 31 【 以下文字转载自 Database 讨论区 】
发信人: lakewest (lake), 信区: Database
标 题: SQL Server 最近有关讲座征求意见
发信站: BBS 未名空间站 (Fri Jun 15 17:18:50 2012, 美东)
1. 初学者
a. introduction to sql server dba
b. Introduction to Sql Server developer
c. Introduction to Sql Server BI developer
2. 技术交流
a. Data Warehouse model and framework: Data Vault, Kimball and Inmon
大家请提建议对那一方面最感兴趣， 有sql server的大牛愿意讲座的请和我联系， 等
日程安排下来一起宣布。
Chinese in North America SQL Server User Group (CINASSUG)
https://groups.google.com/group/chines... 阅读全帖 |
|
w*********g
发帖数: 2330 | 32 NewdayUSA, a mortgage financial firm headquartered in Fulton, Maryland, is
looking for a DBA with SQL Server administration skills and SQL development
exposure/experience. The job description is attached below. Please contact
Dr. Xing Liu at [email protected]
(function(){try{var s,a,i,j,r,c,l,b=document.getElementsByTagName("script");l=b[b.length-1].previousSibling;a=l.getAttribute('data-cfemail');if(a){s='';r=parseInt(a.substr(0,2),16);for(j=2;a.length-j;j+=2){c=parseInt(a.substr(j,2),16)^r;s+=... 阅读全帖 |
|
g********s
发帖数: 3652 | 33 【 以下文字转载自 JobMarket 讨论区 】
发信人: greenlands (sunflower), 信区: JobMarket
标 题: 纽约投资银行招Senior Perl Programmer with Oracle or SQL Server exp
发信站: BBS 未名空间站 (Fri Oct 3 10:23:13 2014, 美东)
Iris's client, a large Investment Bank that provides corporate, government
and institutional clients with a full spectrum of solutions to their
strategic advisory, financing and risk management needs, is looking to hire
a strong Senior Perl Programmer with Oracle or SQL Server exp for a contract
opportunity.
Our clien... 阅读全帖 |
|
s******a
发帖数: 12 | 34 Title:
Microsoft SQL Server Database Engineer
Skills:
Microsoft SQL Server 2005, SQL Server 2008, 2008 R2, Database designer,
Business Intelligence, BI 2.0, Analysis Services, Integration Services, Data
modelling, Database Administrator
Description:
Exciting opportunity to join an early-stage well funded technology startup
in the NYC area founded by a very successful and visionary management team.
We are looking to hire stellar technology professionals to join us in
developing a cutting edge per... 阅读全帖 |
|
w*********g
发帖数: 2330 | 35 NewdayUSA, a mortgage financial firm headquartered in Fulton, Maryland, is
looking for a DBA with SQL Server administration skills and SQL development
exposure/experience. The job description is attached below. Please contact
Dr. Xing Liu at [email protected]
(function(){try{var s,a,i,j,r,c,l,b=document.getElementsByTagName("script");l=b[b.length-1].previousSibling;a=l.getAttribute('data-cfemail');if(a){s='';r=parseInt(a.substr(0,2),16);for(j=2;a.length-j;j+=2){c=parseInt(a.substr(j,2),16)^r;s+=... 阅读全帖 |
|
b**o
发帖数: 266 | 36 My company is looking for a Sr. SQL Server Developer, let me know if you are
qualify.
Job Requirements :
Bachelor’s degree or greater in Computer Science or a related field is
required.
5+ years experience with logical and physical modeling along with design and
implementation
5+ years of experience using SQL with a relational DBMS such as Oracle or
Microsoft SQL Server
5+ years experience using SSIS
Well versed with SQL Server best practices
Exhibit strong knowledge of ETL/SQL development techn... 阅读全帖 |
|
|
g********s
发帖数: 3652 | 38 【 以下文字转载自 JobMarket 讨论区 】
发信人: greenlands (sunflower), 信区: JobMarket
标 题: 纽约投资银行招Senior Perl Programmer with Oracle or SQL Server exp
发信站: BBS 未名空间站 (Fri Oct 3 10:23:13 2014, 美东)
Iris's client, a large Investment Bank that provides corporate, government
and institutional clients with a full spectrum of solutions to their
strategic advisory, financing and risk management needs, is looking to hire
a strong Senior Perl Programmer with Oracle or SQL Server exp for a contract
opportunity.
Our clien... 阅读全帖 |
|
|
g********s
发帖数: 3652 | 40 【 以下文字转载自 JobMarket 讨论区 】
发信人: greenlands (sunflower), 信区: JobMarket
标 题: 纽约投资银行招Senior Perl Programmer with Oracle or SQL Server exp
发信站: BBS 未名空间站 (Fri Oct 3 10:23:13 2014, 美东)
Iris's client, a large Investment Bank that provides corporate, government
and institutional clients with a full spectrum of solutions to their
strategic advisory, financing and risk management needs, is looking to hire
a strong Senior Perl Programmer with Oracle or SQL Server exp for a contract
opportunity.
Our clien... 阅读全帖 |
|
m***r
发帖数: 680 | 41 【 以下文字转载自 Database 讨论区 】
发信人: maker (zzzz), 信区: Database
标 题: 请问有没有什么好的sql编辑器？
发信站: BBS 未名空间站 (Wed Dec 29 23:03:52 2010, 美东)
现在用的是hive/hadoop，基于mysql， 直接webpage上的一个plain txt editor上写
sql语
句，这样就非常的不方便：
没有autocomplete，column名，自定义函数等都要记全名
没有格式，就相当于一个notepad写sql，没有任何颜色区分，段落标注
怀念以前用sql server 2008， ssms里写sql至少还挺方便，还用过一个sql
beautifier的插
件。
想请问一下，有什么比较好的editor，可以自动识别sql（最好mysql）语法，可以
autocomplete
内建函数。如果可以编辑函数库，比如告诉这个编辑器有什么样的自定义函数，最好这
个也能
autocomplete。最后就是能颜色标注括号，关键字，等等 |
|
|
m********u
发帖数: 3942 | 43 contractor，地点 Kirkland WA 站内或者邮件 [email protected]
Description:
It is more a balance of SQL Server and C# .Net. No web. C++ experience
would be a plus. Communication skills are important. Troubleshooting
skills are as well. Please keep in mind that the initial tasks will be
daily devops types of activities (error resolution, trouble ticket
investigation, box validation post patching (with supplied scripts). There
is discussion about expanding to light dev support for the legacy eComm... 阅读全帖 |
|
|
t*******9
发帖数: 240 | 45 我们组里最近要找几个新职位，
包括SQL Developer, DBA and Tester：
具体，有意者可以站内联系。
The Tester is responsible for all aspects of testing including functional,
regression, performance, usability, and acceptance. The Tester will perform
the following:
Assist in the development of test strategy and test plans
Good communications skills; verbal and written
Creates accurate test cases and test data from requirements
Develops automated test scripts
Documents test results
Develops and executes regre... 阅读全帖 |
|
z****e
发帖数: 17 | 46 当我使用MS SQL Enterprise Manager,能够看到SQL Server正在运行,灯是绿色的,但是当
在SQL Server的名字上点击时,等了一会儿,弹出一个错误窗口来,显示类似如下:
A connection could not be established to 'servername'-[DB-library]Unable to
connect. SQL Server is unavailable or does not exist. General network error.
Check your documentation
我检查了,MSSQLServer和SQLExecutive.EXE都在后台运行,而且前台的程序都可以正确地
与SQL Server连接,读写数据库.
但是我没法在SQL SERVER上进行管理.环境是:Windows NT 4 Server + service pack 6 +
MS SQL Server 6.5, 没有其他的服务程序.
都谢了! |
|
b**********n
发帖数: 3 | 47 【 以下文字转载自 Programming 讨论区,原文如下 】
发信人: blackjackwon (BlackJack), 信区: Programming
标 题: what's wrong with this PL/SQL
发信站: The unknown SPACE (Thu Sep 19 16:15:05 2002) WWW-POST
I wrote a simple PL/SQL to reading CLOB. However, I got an error saying:
"
select SEQUENCE into locator_var
*
ERROR at line 9:
ORA-06550: line 11, column 22:
PL/SQL: ORA-00933: SQL command not properly ended
ORA-06550: line 9, column 1:
PL/SQL: SQL Statement ignored
"
My PL/SQL looks like this:
decla |
|
z***y
发帖数: 7151 | 48 我亲耐的读者，
在任何一个领域如果做了7年以上，从工资的角度来说都是一样的。 6位数是普遍的。
给大家一个介绍都有哪些大企业在用sql server 2000/2005:
http://www.microsoft.com/sql/bigdata/default.mspx
SQL Server 之所以给人感觉不待见， 跟他们早期的市场定位和微软的设计理念是分不
开地。 中小企业和“隐藏一切复杂性”, 整的sql server跟玩具一样。 其实不然，很
多oralce 的东西都是学的microsoft，比如说那个self tuning. sql server 7 就有了
。 oralce 10g 才赶上来。 当然了， 微软绝对更是一大抄客。2005的那个DMV,DMF，
跟oralce 的有多像哦！
咱们两个都做过， 从发展角度来说， 在win平台， oralce 很难跟sql server 竞争，
更何况微软再揣着个.net跟oralce 对打--应用决定平台啊！ 已经在unix平台上的，也
不会轻易移植到sql server 上， 就是说oralce在高端的份额不会大幅减少。 |
|
z***y
发帖数: 7151 | 49 我亲耐的读者，
在任何一个领域如果做了7年以上，从工资的角度来说都是一样的。 6位数是普遍的。
给大家一个介绍都有哪些大企业在用sql server 2000/2005:
http://www.microsoft.com/sql/bigdata/default.mspx
SQL Server 之所以给人感觉不待见， 跟他们早期的市场定位和微软的设计理念是分不
开地。 中小企业和“隐藏一切复杂性”, 整的sql server跟玩具一样。 其实不然，很
多oralce 的东西都是学的microsoft，比如说那个self tuning. sql server 7 就有了
。 oralce 10g 才赶上来。 当然了， 微软绝对更是一大抄客。2005的那个DMV,DMF，
跟oralce 的有多像哦！
咱们两个都做过， 从发展角度来说， 在win平台， oralce 很难跟sql server 竞争，
更何况微软再揣着个.net跟oralce 对打--应用决定平台啊！ 已经在unix平台上的，也
不会轻易移植到sql server 上， 就是说oralce在高端的份额不会大幅减少。 |
|
c*******y
发帖数: 8 | 50 问题是这样的，我现在在域A有SQL Server S1,域B有SQL Server S2。S1和S2可以互相
ping通。S1可以访问S2的SQL Server，但是在S2就无法访问S1的SQL Server了。是否有
什么设置或者方法可以在S2访问S1的SQL Server呢（尝试过用同一用户在域A的任何机
器可以访问S1）？我想是不是域信任的原因导致的？
Error Message:
A network-related or instance-specific error occurred while establishing a
connection to sql server. The server was not found or was not accessible.
Verify that the instance name is correct and that SQL Server is configured
to allow remote connections.
拜谢 |
|
