由买买提看人间百态

topics

全部话题 - 话题: sql
1 2 3 4 5 6 7 8 9 10 下页 末页 (共10页)
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
来自主题: Database版 - 招人SQL SERVER DBA
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... 阅读全帖
w********m
发帖数: 1137
3
来自主题: Programming版 - 大妈谈SQL
我来科普一下SQL吧,看不下去了
https://forums.huaren.us/showtopic.html?topicid=2562330&fid=398
以前回帖科普过,看到最近帖子很多人有误解,把好多想学习的大妈都吓退了
SQL本身是一种语言,structure query language,严格的说不算编程语言。在学校也
就是database这门课一学期课程里面的一节课的内容,有的老师干脆不讲直接带过。
编程语言大致分两种,一种是需要编译的,比如Java,要先把人写的代码编译成机器码
然后执行,还有一种不需要编译的叫做解释语言,比如很多脚本语言常见的Javascript
,这些,都是直接执行的。
而SQL连脚本语言都算不上,就是用词造句,或者叫做填空题?
所有的语句通常细分为4/5类
DDL – Data Definition Language,包括create,rename,alter,drop,truncate和
comment
DQl – Data Query Language 就是select语句
DML – Data Manipulation Language包括... 阅读全帖
B*****g
发帖数: 34098
4
来自主题: Database版 - 【征文】Oracle Advanced PL/SQL 系列
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
5
【 以下文字转载自 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
6
【 以下文字转载自 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
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... 阅读全帖
b********e
发帖数: 151
8
【 以下文字转载自 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... 阅读全帖
R*****n
发帖数: 355
9
来自主题: JobMarket版 - 【内推】计算机H1B职位SQL/ETL/BI
请写明你想申请的职位, 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
10
在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... 阅读全帖
j******r
发帖数: 855
11
来自主题: JobMarket版 - Bethesda MD (招Microsoft SQL Server DBA)
Job Description
Nira, Inc. is looking for a Microsoft SQL Server DBA to support a federal
agency’s IT modernization program. US Citizenship or green card is required.
Responsibilities include:
- Operation, maintenance, administration of Microsoft SQL Server, including
SQL Server Master Data Service (MDS) and Service Broker. Monitor the system
performance and SQL jobs.
- Participate in full life-cycle development of Business Process Management
System based applications, including requirement anal... 阅读全帖
y****9
发帖数: 144
12
来自主题: Database版 - 比较sqlplus和sql developer
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
13
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******r
发帖数: 855
14
Responsibilities include:
- Operation, maintenance, administration of Microsoft SQL Server, including
SQL Server Master Data Service (MDS) and Service Broker. Monitor the system
performance and SQL jobs.
- Participate in full life-cycle development of Business Process Management
System based applications, including requirement analysis, designing data
schemas, data migration,developing data access components and system testing.
- Analyze data related issues and performance issues from back-end f... 阅读全帖

发帖数: 1
15
Recent Graduates are welcome to apply! CPT/OPT accepted
We provide free on-boarding training for entry-level employees.
Job Responsibilities:
Design and create Data Model based on various business requirement.
Create ERD to the proposed database.
Create database objects such as tables, views, UDFs and UDPs etc
Design packages related to the extraction, transformation and loading (ETL)
process using Microsoft SQL Server 2012 or later
Responsible for data profiling as well as SQL and database tuni... 阅读全帖
J*****6
发帖数: 107
16
来自主题: JobHunting版 - SQL Database developer 看过来!!
这个职位是在加州,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... 阅读全帖

发帖数: 1
17
Recent Graduates are welcome to apply! CPT/OPT accepted
We provide free on-boarding training for entry-level employees.
Job Responsibilities:
Design and create Data Model based on various business requirement.
Create ERD to the proposed database.
Create database objects such as tables, views, UDFs and UDPs etc
Design packages related to the extraction, transformation and loading (ETL)
process using Microsoft SQL Server 2012 or later
Responsible for data profiling as well as SQL and database tuni... 阅读全帖
z***y
发帖数: 7151
18
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... 阅读全帖
d*******r
发帖数: 3299
19
来自主题: Programming版 - Which No-Sql is closed to mysql ?
1.对CS出生的来说, SQL, 特别是复杂 SQL 真心恶心. 不然就不会有 DBA 这种职业.
2.对你说的非技术部门来说, 在 GUI 上填写 filter, 或者填关键词, 比写 SQL 容易
多了.
3.把2中那些复杂的 filters 结构化, 写成查询语句, 用普通编程函数比SQL容易多了,
即使不了解底层 array/hash/btree.
其实之前 NoSQL 火的一大原因就是, 写普通编程句子比写 SQL 容易,
不只是对 CS 的人来说. 你不见一大堆非CS转行的, 只写前端的萌新,
只用会用简单的 NoSQL (e.g. MongoDB), 不会用 SQL (MySQL, PostgreSQL),
然后他们都很开心的叫自己 full stack 么? 为啥, SQL 真的不好用啊?
SQL 咋一看像是英文, 其实表现力特弱, 写复杂了就是一堆浆糊.
SQL 能一直活着, 就是历史原因. 很多东西活着都是历史原因而已.
S******y
发帖数: 1123
20
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
21
来自主题: Statistics版 - PROC SQL运行速度问题.
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
22
【 以下文字转载自 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
23
各位朋友,
人到中年,当码工是不现实的。围绕数据为中心寻找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
24
来自主题: JobHunting版 - SQL Database Developer Opening Central NJ
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
25
【 以下文字转载自 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
26
来自主题: WashingtonDC版 - Look for SQL Database Developer
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
27
来自主题: Database版 - SQL证书考试求助
最后决定考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
28
来自主题: Database版 - SQL的一个愚蠢小问题

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
29
来自主题: Database版 - SQL 题目,包子有谢!
如果人家问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
30
来自主题: Database版 - SQL SERVER 2012的认证改了
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
31
*******************************************************************
HR SQL难题的三种解法
*******************************************************************
摘要
本文综合描术了针对养老院人事难题的多种SQL解法。
鸣谢
Beijing
===========================================================
解法1 -- Partition 法
===========================================================
可以参考wyr解法,本解法用了lead/lag,以及ROWS UNBOUNDED PRECEDING A... 阅读全帖
B*****g
发帖数: 34098
32
【 以下文字转载自 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
33
你应该是新手吧.
当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
34
来自主题: Classified版 - SQL server DBA Job opening - Maryland
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
35
来自主题: Classified版 - SQL server DBA Job opening - Maryland.
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
36
糊里糊涂看到SQL db developer当初就投的,我只会SQL server IS和AS,但不懂T-SQL
。接到interview通知,再回头看看qualification,发现SQL server的T-SQL里面居然
没有cursor procedure这些东西。想问一下oracle和sql server转起来快么?下周要面
,怎么准备比较好?还是老实说我只会oracle?
l******t
发帖数: 660
37
【 以下文字转载自 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
38
来自主题: JobHunting版 - SQL server DBA Job opening - Maryland
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
39
【 以下文字转载自 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... 阅读全帖
r**********d
发帖数: 510
40
Pm me ur email. I will send you some stuff end of month. I am overseas.
Dont need to buy books.
Allitbooks has everything u need.
Some features are sql server specific and not used very often.
Practice more than once to male sure you know joins, group by win functions
.
U need to know everythin mg in that book.
Other books are t sql fundamental.
Sql server devel. ....
Murish guide to sql server
Again all depending in your goal. This is part of MSDA cert. so it takes
months to get thru ... 阅读全帖
s******a
发帖数: 12
41
来自主题: JobMarket版 - Microsoft SQL Server Database Engineer
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
42
来自主题: JobMarket版 - SQL server DBA Job opening - Maryland.
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
43
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
44
来自主题: Arizona版 - 中国人打个SQL翻身仗! (转载)
【 以下文字转载自 NewJersey 讨论区 】
发信人: greenlands (sunflower), 信区: NewJersey
标 题: 中国人打个SQL翻身仗!
发信站: BBS 未名空间站 (Fri Mar 14 14:14:38 2014, 美东)
为啥我们中国人应该大学特学SQL?
1. 印度人SQL起步早特别强,
2. SQL很容易学,
3. 凡是数据库必用SQL
4. BI 很火很好找工,这行又不累,相对容易,何乐不为?
我们要想保住IT阵地,就要武装我们自己,不学SQL就等于缴枪投降,乖乖地把BI 把
SQL阵地拱手送给印度人!
http://www.mitbbs.com/clubarticle_t/DBA_BI_Club/31188201.html
http://www.mitbbs.com/clubarticle_t/DBA_BI_Club/31188213.html
http://www.mitbbs.com/clubarticle_t/DBA_BI_Club/31186337.html
http://www.mitbbs.com/clubarticle... 阅读全帖
g********s
发帖数: 3652
45
【 以下文字转载自 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
46
来自主题: NewYork版 - 中国人打个SQL翻身仗! (转载)
【 以下文字转载自 NewJersey 讨论区 】
发信人: greenlands (sunflower), 信区: NewJersey
标 题: 中国人打个SQL翻身仗!
发信站: BBS 未名空间站 (Fri Mar 14 14:14:38 2014, 美东)
为啥我们中国人应该大学特学SQL?
1. 印度人SQL起步早特别强,
2. SQL很容易学,
3. 凡是数据库必用SQL
4. BI 很火很好找工,这行又不累,相对容易,何乐不为?
我们要想保住IT阵地,就要武装我们自己,不学SQL就等于缴枪投降,乖乖地把BI 把
SQL阵地拱手送给印度人!
http://www.mitbbs.com/clubarticle_t/DBA_BI_Club/31188201.html
http://www.mitbbs.com/clubarticle_t/DBA_BI_Club/31188213.html
http://www.mitbbs.com/clubarticle_t/DBA_BI_Club/31186337.html
http://www.mitbbs.com/clubarticle... 阅读全帖
g********s
发帖数: 3652
47
【 以下文字转载自 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
48
【 以下文字转载自 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。最后就是能颜色标注括号,关键字,等等
g********s
发帖数: 3652
49
来自主题: Seattle版 - 中国人打个SQL翻身仗! (转载)
【 以下文字转载自 NewJersey 讨论区 】
发信人: greenlands (sunflower), 信区: NewJersey
标 题: 中国人打个SQL翻身仗!
发信站: BBS 未名空间站 (Fri Mar 14 14:14:38 2014, 美东)
为啥我们中国人应该大学特学SQL?
1. 印度人SQL起步早特别强
2. SQL很容易学
3. 凡是数据库必用SQL
4. BI 很火很好找工,这行又不累,相对容易,何乐不为?
我们要想保住IT阵地,就要武装我们自己,不学SQL就等于缴枪投降,乖乖地把BI 把
SQL阵地拱手送给印度人!
http://www.mitbbs.com/clubarticle_t/DBA_BI_Club/31188201.html
http://www.mitbbs.com/clubarticle_t/DBA_BI_Club/31188213.html
http://www.mitbbs.com/clubarticle_t/DBA_BI_Club/31186337.html
http://www.mitbbs.com/clubarticle_t... 阅读全帖
m********u
发帖数: 3942
50
来自主题: Seattle版 - SQL developer with strong C#
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... 阅读全帖
1 2 3 4 5 6 7 8 9 10 下页 末页 (共10页)