Hi Partners

Hope you are doing great.
Please take a look and let me know if you can submit.


*SQL Server DBA/DeveloperLouisville KY*

DBA:

Explain SQL server architecture

Candidate should be able to explain the components involved in the
architecture(Storage engine, buffer manager,buffer pool,lock manager,query
processor,SQL OS layer and protocol layer) .

Performance tuning at OS and SQL server level.

Should be able to talk about counter that needs to be selected in profiler
trace and OS level counters.

Should tell you wait types and execution plans and statistics.

Explain transaction log architecture

Should talk about virtual log file, checkpoint,active portion\inactive
portion etc

Memory architecture

should talk about AWE,32 bit vs 64 bit machines,capping memory etc



High availability

Should be familiar with Replication, clustering and always on feature of
SQL server

Active\active cluster, differences between cluster architecture of
2005,2008 and 2012 version



Development:

What is normalization?

what is Table partitioning?

horizontal vs vertical

creating stored procedure, triggers etc,

tuning slow running queries, entity relationship, primary key and foreign
key relationship, making ER diagram

Isolation levels and their meaning.

HIPPAA

HL7

ICD




Thanks
Chetan Ghediya
CyberThink Inc
chetan.ghed...@cyberthink.com

-- 
You received this message because you are subscribed to the Google Groups 
"US_IT.Groups" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to us_itgroups+unsubscr...@googlegroups.com.
To post to this group, send email to us_itgroups@googlegroups.com.
Visit this group at https://groups.google.com/group/us_itgroups.
For more options, visit https://groups.google.com/d/optout.

Reply via email to