Exercises for Sql Server 2005 -

-

i new sql server 2005 , planning learn ssis, ssrs , ssas. before going deep want master fundamentals of sql server 2005. novice did best , installed these database

  1. adventureworks
  2. adventureworksdw

now best resource can master fundamentals? need exercises on these databases because understand sql math "the more practice more learn".

also, please recommend me other database if need install.

i not recommend w3schools learning sql. i've found examples simple beginner , think bored pretty quickly. suggestion before trying learn ssas, ssis, ssrs, learn fundamentals of sql server rdbms. end, books start learning. suggest getting can itzik ben-gan, 

mcts self-paced training kit (exam 70-433): microsoft sql server 2008 - database development: microsoft sql server 2008 database development (if anything, organizing things want learn about. think great book , served me when studying mcts exam. there sql 2005 version.)

don't forget books online (sql server's help). if want specific topic, 1 of first places to. example, might want start here: http://msdn.microsoft.com/library/ms169620.aspx , move further.

next thing might want follow blogs , sign news letters. recommend sqlservercentral.com. newsletter great , i've found plenty of great stuff there. spend time following sql server , tsql server related tags in so. questions interesting , answers more so:).

as move more advanced topics, must have kalen delaney sql server internals books.

and finally, rule, curious , inquisitive. try learn knows more you:). and, think important, if have dba can talk to, pick brain can. learn new things every day have chat our senior dba , interesting find out want happening code , database after you've shipped production.

one last thing: if new sql server, try start sql server 2008. there differences, of course, doing anyway, why not start there?.

cheers.


Comments

Post a Comment

Popular posts from this blog

android - Spacing between the stars of a rating bar? -

-
ho can set spacing beween stars? thats ratingbar: ratingbar = (ratingbar) inflater.inflate(r.layout.ratingbar, null); ratingbar.setlayoutparams(new layoutparams(layoutparams.wrap_content, layoutparams.wrap_content)); the layout: <?xml version="1.0" encoding="utf-8"?> <ratingbar xmlns:android="http://schemas.android.com/apk/res/android" style="@style/mystyle" android:layout_alignparentright="true" android:layout_height="19dp" android:layout_width="wrap_content" android:numstars="5"> </ratingbar> the style: <style name="mystyle" parent="@android:style/widget.ratingbar"> <item name="android:progressdrawable">@drawable/android_r2_ratingstar_yellow</item> <item name="android:indeterminatedrawable">@drawable/android_r2_ratingstar_grey</item> </style> thanks, cheers you have ...
Read more

html - Instapaper-like algorithm -

-
does of algorithm extracts contents webpage? instapaper ? there 2 steps instapaper does: find main content block on page (excluding headers, footers, menus etc) from content block extract , format text to find content block (typically html block element, div containing key page text content) instapaper uses algorithm 1 used readability . can @ source of readability.js see what's going on, @ core tries find area on page highest text/link ratio, although has other simple scoring metrics (e.g. off top of head, things ratio of text commas, para elements etc) go heuristics. once have identified root node element, relevant content, you'll need format it, if want can pull node element containing text out of source document , insert yours, in reality you'll want remove existing styles , apply own, standard , feel. if want output nice text-only can use jericho's renderer . update1 : should mention else instapaper - follow 'pagination' links (...
Read more

c# - How to execute a particular part of code asynchronously in a class -

-
i creating speech recognition engine that's going respond user commands.i have created button enable , disable speech recognition per user convenience.i have used dispose() of speech engine disable speech recoginition.here code private void button1_click(object sender, routedeventargs e) { engineon = !engineon; if (engineon) { speechengine = speech.createspeechengine(); //speech class creates , returns new speech engine. speechengine.audiolevelupdated += new eventhandler<audiolevelupdatedeventargs>(speechengine_audiolevelupdated); // use system's default microphone speechengine.setinputtodefaultaudiodevice(); speechengine.loadgrammar(new dictationgrammar()); // start listening speechengine.recognizeasync(recognizemode.multiple); } else { speechclass.myengine.dispose(); } } but disposal of speech obj...
Read more