<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:blogger='http://schemas.google.com/blogger/2008' xmlns:georss='http://www.georss.org/georss' xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-6070680432155434668</id><updated>2024-09-13T18:36:22.430+05:00</updated><title type='text'>My Computer sciences</title><subtitle type='html'></subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://mycomputersciences.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default?redirect=false'/><link rel='alternate' type='text/html' href='http://mycomputersciences.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><link rel='next' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default?start-index=26&amp;max-results=25&amp;redirect=false'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>48</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-6070680432155434668.post-431874887442566336</id><published>2011-06-24T14:30:00.002+05:00</published><updated>2011-06-24T14:34:59.557+05:00</updated><title type='text'>Computer</title><content type='html'>&lt;b&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;**********************&lt;/span&gt;&lt;/b&gt;&lt;div&gt;&lt;div style=&quot;text-align: left;&quot;&gt;&lt;b&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;History of Computer&lt;/span&gt;&lt;/b&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left;&quot;&gt;&lt;b&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;**********************&lt;/span&gt;&lt;/b&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left;&quot;&gt; &lt;a href=&quot;http://mycomputersciences.blogspot.com/2010/06/brief-history-of-computer-bc-1993ad.html&quot;&gt;&lt;img src=&quot;http://t3.gstatic.com/images?q=tbn:ANd9GcQTUsr-SwS9nKUh2LCTanab7p0qQPBLBN1LK6VPuubwSohokK8-cg&quot; /&gt;&lt;/a&gt;  &lt;/div&gt;&lt;div style=&quot;text-align: left;&quot;&gt;&lt;/div&gt;&lt;div&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot;  style=&quot;font-size:130%;&quot;&gt;&lt;b&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;*******************************&lt;br /&gt;Part 2&lt;/span&gt;&lt;/b&gt;: &lt;span class=&quot;Apple-style-span&quot; style=&quot;color: rgb(51, 51, 51); line-height: 15px; font-weight: bold;font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;&quot; &gt;&lt;span style=&quot;text-decoration: none; color: rgb(204, 51, 0);&quot;&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2010/06/history-of-computer.html&quot;&gt;The history of computer&lt;/a&gt;&lt;br /&gt;*****************************************&lt;br /&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: rgb(51, 51, 51); line-height: 15px;font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;&quot; &gt;&lt;b style=&quot;text-decoration: none; color: rgb(204, 51, 0);&quot;&gt;&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;*********************************&lt;/span&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left;&quot;&gt;&lt;b&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;(I&lt;/span&gt;&lt;/b&gt;&lt;b&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;nstallation of &lt;/span&gt;&lt;/b&gt;&lt;b&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;Windows 98 )&lt;/span&gt;&lt;/b&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left;&quot;&gt;&lt;b&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;******************************&lt;/span&gt;&lt;/b&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left;&quot;&gt; &lt;img src=&quot;http://t0.gstatic.com/images?q=tbn:ANd9GcR4ECT-yHkK5p0yu3BdQ0EmjvVDZSVm1-sqCb2FwN1abA8z6jj-&quot; /&gt;     &lt;/div&gt;&lt;div style=&quot;text-align: left;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;*******************************&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;b&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;Installation of Windows Xp&lt;/span&gt;&lt;/b&gt;&lt;/div&gt;&lt;div&gt;&lt;b&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;****************************&lt;/span&gt;&lt;/b&gt;&lt;/div&gt;&lt;div&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2010/08/install-winxp-part1.html&quot;&gt;&lt;img src=&quot;http://t0.gstatic.com/images?q=tbn:ANd9GcQ2I-ixYIdp5Hq7R3mFJ-0Tf9aIr5CI7Sban0FYxeQQXLKyUT0r&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;div&gt;&lt;/div&gt;&lt;div&gt;&lt;/div&gt;&lt;div&gt;&lt;b&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;***********************&lt;/span&gt;&lt;/b&gt;&lt;/div&gt;&lt;div&gt;&lt;div&gt;&lt;div&gt;&lt;h2 class=&quot;title&quot;   style=&quot;margin: 0px 0px 0.5em; position: relative; font-style: normal; font-variant: normal; font-weight: normal; font-size-adjust: none; font-stretch: normal; line-height: 18px;font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;font-size:20px;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;b&gt;(&lt;span class=&quot;Apple-style-span&quot;&gt;Best Tutorials in Urdu&lt;/span&gt; &amp;amp; ENGLISH)&lt;/b&gt;&lt;/span&gt;&lt;/h2&gt;&lt;div  style=&quot;line-height: 18px;font-family:Arial,Tahoma,Helvetica,FreeSans,sans-serif;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;b&gt;*******************************&lt;br /&gt;&lt;/b&gt;&lt;/span&gt;&lt;img style=&quot;font-weight: bold;&quot; src=&quot;file:///C:/DOCUME%7E1/XPPRESP3/LOCALS%7E1/Temp/moz-screenshot.jpg&quot; alt=&quot;&quot; /&gt;&lt;img style=&quot;font-weight: bold;&quot; src=&quot;file:///C:/DOCUME%7E1/XPPRESP3/LOCALS%7E1/Temp/moz-screenshot-1.jpg&quot; alt=&quot;&quot; /&gt;&lt;img style=&quot;font-weight: bold;&quot; src=&quot;file:///C:/DOCUME%7E1/XPPRESP3/LOCALS%7E1/Temp/moz-screenshot-12.jpg&quot; alt=&quot;&quot; /&gt;&lt;img style=&quot;font-weight: bold;&quot; src=&quot;file:///C:/DOCUME%7E1/XPPRESP3/LOCALS%7E1/Temp/moz-screenshot-13.jpg&quot; alt=&quot;&quot; /&gt;&lt;img style=&quot;font-weight: bold;&quot; src=&quot;file:///C:/DOCUME%7E1/XPPRESP3/LOCALS%7E1/Temp/moz-screenshot-14.jpg&quot; alt=&quot;&quot; /&gt;&lt;img style=&quot;font-weight: bold;&quot; src=&quot;file:///C:/DOCUME%7E1/XPPRESP3/LOCALS%7E1/Temp/moz-screenshot-15.jpg&quot; alt=&quot;&quot; /&gt;&lt;img style=&quot;font-weight: bold;&quot; src=&quot;file:///C:/DOCUME%7E1/XPPRESP3/LOCALS%7E1/Temp/moz-screenshot-16.jpg&quot; alt=&quot;&quot; /&gt;&lt;img style=&quot;font-weight: bold;&quot; src=&quot;file:///C:/DOCUME%7E1/XPPRESP3/LOCALS%7E1/Temp/moz-screenshot-17.jpg&quot; alt=&quot;&quot; /&gt;&lt;img style=&quot;font-weight: bold;&quot; src=&quot;file:///C:/DOCUME%7E1/XPPRESP3/LOCALS%7E1/Temp/moz-screenshot-18.jpg&quot; alt=&quot;&quot; /&gt;&lt;img style=&quot;font-weight: bold;&quot; src=&quot;file:///C:/DOCUME%7E1/XPPRESP3/LOCALS%7E1/Temp/moz-screenshot-19.jpg&quot; alt=&quot;&quot; /&gt;&lt;a onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot; href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server.html&quot;&gt;&lt;img style=&quot;cursor: pointer; width: 100px; height: 100px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-i6rb2ZI3lBUPjSHVXe7PTKchsx9P3YDylfDNvQwCsfpQs6hY3HnX6W4moHz4Hdb5pHG47KOJcqZXRQG3aeb9gqASo4g9tmLj9_ZucqtQWVEtLdfTZbpBGrwTRxVypHcGpqYNED_pMXWl/s400/sql.jpeg&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5621715491707134898&quot; border=&quot;0&quot; /&gt;&lt;/a&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server.html&quot;&gt;&lt;br /&gt;&lt;span style=&quot;font-weight: bold;font-size:100%;&quot; &gt;SQL Tutorials&lt;/span&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;b&gt;&lt;br /&gt;&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;&lt;/div&gt;&lt;div&gt;&lt;b&gt;&lt;/b&gt;&lt;/div&gt;&lt;div&gt;&lt;/div&gt;&lt;div&gt;&lt;b&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/ms-excel-tutorial-in-urdu.html&quot;&gt;&lt;img src=&quot;http://t3.gstatic.com/images?q=tbn:ANd9GcRwajGdL-DADA_dIaRQnVj3fuyhgY3SC34Zf6uFD44m0CGiOmdJ8w&quot; /&gt;&lt;/a&gt;&lt;br /&gt;MS EXCEL&lt;br /&gt;&lt;/b&gt;&lt;img src=&quot;file:///C:/DOCUME%7E1/XPPRESP3/LOCALS%7E1/Temp/moz-screenshot-2.jpg&quot; alt=&quot;&quot; /&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;&lt;/div&gt;&lt;div&gt;&lt;/div&gt;&lt;div&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/corel-draw-12-tutorial-in-urdu.html&quot;&gt;&lt;img src=&quot;http://t1.gstatic.com/images?q=tbn:ANd9GcQYAYCPs-zPQ8If57Q6TEsYgxEC24K-VvMIVv6tK7Ufly5Ggy8o&quot; /&gt;&lt;/a&gt;&lt;br /&gt;&lt;span style=&quot;font-weight: bold; color: rgb(0, 0, 0);&quot;&gt;COREL DRAW12&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;div&gt;&lt;/div&gt;&lt;div&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;b&gt;***********************&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;b&gt;( computer Hardware)&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;b&gt;***********************&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;b&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2010/06/pc-hardware.html&quot;&gt;&lt;img src=&quot;http://t1.gstatic.com/images?q=tbn:ANd9GcRyXmincUrgORFCZe7-RH_i5CNP10DOne9Iqs4x-J-epvW9FniF&quot; /&gt;&lt;/a&gt;&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;b&gt;&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;b&gt;************************&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;&lt;div style=&quot;color: rgb(0, 0, 0);&quot;&gt;&lt;span class=&quot;Apple-style-span&quot;  style=&quot;font-size:130%;&quot;&gt;&lt;b&gt;( Computer Repairing )&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;b&gt;************************&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;b&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/computer-repairing.html&quot;&gt;&lt;img src=&quot;http://t3.gstatic.com/images?q=tbn:ANd9GcQQTMQZUXizwBdECbPfXVO9rw676ZjvYH7oUPt5ATpx4BoHik5k3g&quot; /&gt;&lt;/a&gt;&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;b&gt;********************&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;&lt;div style=&quot;color: rgb(0, 0, 0);&quot;&gt;&lt;span class=&quot;Apple-style-span&quot;  style=&quot;font-size:130%;&quot;&gt;&lt;b&gt;(Computer Books)&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;b&gt;********************&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;b&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2010/06/computer-books.html&quot;&gt;&lt;img src=&quot;http://t1.gstatic.com/images?q=tbn:ANd9GcSyHx_IzsOes2rYbElaqtlpy5014Um8I9H-KfUHE97vrMY0ggcQNQ&quot; /&gt;&lt;/a&gt;&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;b&gt;****************************&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;&lt;div style=&quot;font-weight: bold; color: rgb(0, 0, 0);&quot;&gt;&lt;span class=&quot;Apple-style-span&quot;  style=&quot;font-size:130%;&quot;&gt;(Computer Shortcut Keys)&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;b&gt;****************************&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;b&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2010/06/top-10-keyboard-shortcuts-everyone.html&quot;&gt;&lt;img src=&quot;http://t3.gstatic.com/images?q=tbn:ANd9GcS2SAujD1UXR_BxWSVB1BC014FBmWHuEB8781-U9aLIpKbFuGAhRg&quot; /&gt;&lt;/a&gt;&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;**********&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot;  style=&quot;font-size:180%;&quot;&gt;&lt;b&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2010/06/computer-keyboard-shortcut-keys.html&quot;&gt;Link 2&lt;/a&gt;&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;**********&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;b&gt;***************************&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;b&gt;(&lt;/b&gt;&lt;span style=&quot;color: rgb(0, 0, 0);font-size:130%;&quot; &gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;Computer Protection&lt;/span&gt;&lt;/span&gt;&lt;b&gt;)&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;b&gt;***************************&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;b&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2010/06/important-steps-to-protect-your.html&quot;&gt;&lt;img src=&quot;http://t0.gstatic.com/images?q=tbn:ANd9GcSoidpMfqfKMAuifPsMxVrKwapP1p6m1hE185Wh63BkKKHsqPVQ&quot; /&gt;&lt;/a&gt;&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;b&gt;*******************************&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;&lt;div style=&quot;font-weight: bold;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot;  style=&quot;font-size:130%;&quot;&gt;(Free Computer Programs)&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;b&gt;*******************************&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;b&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2010/06/top-10-free-pc-programs-everyone-should.html&quot;&gt;&lt;img src=&quot;http://t0.gstatic.com/images?q=tbn:ANd9GcTGzyxSPSSR-Zk7RdCW2AntNw0EdR_u42MCltdiqVwqPlT7YepVKg&quot; /&gt;&lt;/a&gt;&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;b&gt;***********************&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;&lt;div style=&quot;font-weight: bold; color: rgb(0, 0, 0);&quot;&gt;&lt;span class=&quot;Apple-style-span&quot;  style=&quot;font-size:130%;&quot;&gt;Free Computer Tips&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;b&gt;***********************&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;b&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2010/06/this-years-monthly-computer-tips.html&quot;&gt;&lt;img src=&quot;http://t2.gstatic.com/images?q=tbn:ANd9GcSrpBIlSwp96i0jEB55npdYPJRFKGwZam-w7qkJV5_MiVf_l0Ny_A&quot; /&gt;&lt;/a&gt;&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;**************************&lt;/span&gt;&lt;/div&gt;&lt;div style=&quot;font-weight: bold;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot;  style=&quot;font-size:130%;&quot;&gt;Internet Privacy at Risk&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;**************************&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2010/06/learn-how-is-your-internet-privacy-is.html&quot;&gt;&lt;img src=&quot;http://t3.gstatic.com/images?q=tbn:ANd9GcSgYq72wtxWpkQoUW6LgG3tfGinlop5Ra_awv0s4HlJZcCMqitN&quot; /&gt;&lt;/a&gt;&lt;/span&gt;&lt;/div&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://mycomputersciences.blogspot.com/feeds/431874887442566336/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/computer.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/431874887442566336'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/431874887442566336'/><link rel='alternate' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/computer.html' title='Computer'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-i6rb2ZI3lBUPjSHVXe7PTKchsx9P3YDylfDNvQwCsfpQs6hY3HnX6W4moHz4Hdb5pHG47KOJcqZXRQG3aeb9gqASo4g9tmLj9_ZucqtQWVEtLdfTZbpBGrwTRxVypHcGpqYNED_pMXWl/s72-c/sql.jpeg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6070680432155434668.post-3194470729267361473</id><published>2011-06-24T12:52:00.002+05:00</published><updated>2011-06-24T14:10:45.325+05:00</updated><title type='text'>SQL Server - Summary</title><content type='html'>&lt;p&gt;Congratulations for reaching the end of this SQL Server tutorial!&lt;/p&gt; &lt;p&gt;SQL Server is a powerful application, and this tutorial has provided an overview of the main concepts involved in administering SQL Server 2008 Express.&lt;/p&gt; &lt;p&gt;To recap briefly, we&#39;ve:&lt;/p&gt;  &lt;ul&gt;&lt;li&gt;Created databases&lt;/li&gt;&lt;li&gt;Created database tables&lt;/li&gt;&lt;li&gt;Inserted data into those tables&lt;/li&gt;&lt;li&gt;Used the SSMS to run a query&lt;/li&gt;&lt;li&gt;Created a login account&lt;/li&gt;&lt;li&gt;Looked at server roles&lt;/li&gt;&lt;li&gt;Learned about database schemas&lt;/li&gt;&lt;li&gt;Looked at linked servers&lt;/li&gt;&lt;li&gt;and more&lt;/li&gt;&lt;/ul&gt;  &lt;h2&gt;What Next?&lt;/h2&gt; &lt;p&gt;There were a couple of areas we didn&#39;t touch on during this tutorial. This is mainly due to the fact that it is aimed at the free SQL Server Express version, which has its limitations.&lt;/p&gt; &lt;p&gt;All is not lost though. My SQL Server 2000 tutorial covers some of the areas that weren&#39;t included here. For example, you can learn about the &lt;span style=&quot;font-weight: bold;&quot;&gt;SQL Server Agent&lt;/span&gt; for &lt;span style=&quot;font-weight: bold;&quot;&gt;scheduling jobs&lt;/span&gt; to run automatically. You can also read about the &lt;span style=&quot;font-weight: bold;&quot;&gt;SQL Profiler&lt;/span&gt;, which allows you to monitor events within your SQL Server.&lt;/p&gt; &lt;p&gt;The most logical next step from learning SQL Server is to&lt;span style=&quot;font-weight: bold;&quot;&gt; learn SQL&lt;/span&gt; itself (if you haven&#39;t already done this that is). SQL stands for Structured Query Language and enables you to perform database related tasks programatically. Most of the tasks in this tutorial can be done programatically using SQL.&lt;/p&gt; &lt;p&gt;Probably the most common use for SQL is to work with the data in the database. For example, to insert data, select data, update data, or to delete data. Any database driven website will have many SQL statements doing this stuff.&lt;/p&gt; &lt;p&gt;To learn more about SQL, check out the &lt;span style=&quot;font-weight: bold;&quot;&gt;SQL tutorial.&lt;/span&gt;&lt;/p&gt;&lt;h3 class=&quot;post-title entry-title&quot;&gt; SQL Server &lt;/h3&gt; &lt;div class=&quot;post-header&quot;&gt;  &lt;/div&gt;  &lt;ol style=&quot;font-weight: bold;&quot;&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/about-sql-server.html&quot;&gt;About SQL Server&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-editions.html&quot;&gt;SQL Server Editions&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-management-studio.html&quot;&gt;SQL Server - Management Studio&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-database.html&quot;&gt;SQL Server - Create a Database&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-table.html&quot;&gt;SQL Server - Create a Table&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-adding-data.html&quot;&gt;SQL Server - Adding Data&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-query-designer.html&quot;&gt;SQL Server - Query Designer&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-views.html&quot;&gt;SQL Server Views&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-stored-procedures.html&quot;&gt;SQL Server Stored Procedures&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-user-logins.html&quot;&gt;User Logins&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-server-roles.html&quot;&gt;Server Roles&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-database-schemas.html&quot;&gt;Database Schemas&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-linked-servers.html&quot;&gt;Linked Servers&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-integration-services-ssis.html&quot;&gt;Integration Services&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-summary.html&quot;&gt;Summary&lt;/a&gt;&lt;/li&gt;&lt;/ol&gt;</content><link rel='replies' type='application/atom+xml' href='http://mycomputersciences.blogspot.com/feeds/3194470729267361473/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/sql-server-summary.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/3194470729267361473'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/3194470729267361473'/><link rel='alternate' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/sql-server-summary.html' title='SQL Server - Summary'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6070680432155434668.post-3254893927469760312</id><published>2011-06-24T12:50:00.001+05:00</published><updated>2011-06-24T14:11:07.014+05:00</updated><title type='text'>SQL Server Integration Services (SSIS)</title><content type='html'>&lt;p&gt;SQL Server Integration Services (SSIS) allows you to integrate smoothly with other applications and data sources.&lt;/p&gt;  &lt;p&gt;You can use Integration Services to copy or download files, send e-mail messages in response to events, update data warehouses, clean and mine data, and manage SQL Server objects and data.&lt;/p&gt; &lt;p&gt;In SQL Server 2005 and higher, &lt;span style=&quot;font-weight: bold;&quot;&gt;Data Transformation Services&lt;/span&gt; (DTS) is no longer installed with SQL Server. All DTS related tasks are now performed with SSIS.&lt;/p&gt; &lt;h2&gt;Where Has DTS Gone?&lt;/h2&gt; &lt;p&gt;If you have been working with earlier versions of SQL Server (SQL Server 2000 and earlier), you are probably familiar with DTS. DTS allowed you to transfer data between disparate sources into one or more destinations.&lt;/p&gt; &lt;p&gt;Well, starting from SQL Server 2005, DTS has been deprecated. DTS is no longer included with your SQL Server installation.&lt;/p&gt;  &lt;p&gt;If you need DTS-type functionality in SQL Server 2008, you will need to use SQL Server Integration Services.&lt;/p&gt; &lt;h2&gt;Backwards Compatibility&lt;/h2&gt; &lt;p&gt;For backwards compatibility, Microsoft has provided installation files that provide run-time support for DTS packages. This will be useful if you have already created DTS packages in an earlier version of SQL Server. For more information see &lt;span style=&quot;font-weight: bold;&quot;&gt;Support for Data Transformation Services (DTS) in SQL Server 2008 &lt;/span&gt;on the MSDN website.&lt;/p&gt;  &lt;h2&gt;SQL Server Express &amp;amp; SSIS&lt;/h2&gt; &lt;p&gt;SQL Server Integration Services is not available in the Express or Workgroup editions of SQL Server. If you need to use Integration Services, you need at least SQL Server Standard edition. And, if you need to use advanced features (such as data mining, text mining and cleansing or fuzzy transforms), you will need SQL Server Enterprise edition.&lt;/p&gt; &lt;p&gt;For more information on SQL Server Integration Services, check out &lt;span style=&quot;font-weight: bold;&quot;&gt;SQL Server Integration Services on the MSDN website.&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;h3 class=&quot;post-title entry-title&quot;&gt; SQL Server &lt;/h3&gt; &lt;div class=&quot;post-header&quot;&gt;  &lt;/div&gt;  &lt;ol style=&quot;font-weight: bold;&quot;&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/about-sql-server.html&quot;&gt;About SQL Server&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-editions.html&quot;&gt;SQL Server Editions&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-management-studio.html&quot;&gt;SQL Server - Management Studio&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-database.html&quot;&gt;SQL Server - Create a Database&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-table.html&quot;&gt;SQL Server - Create a Table&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-adding-data.html&quot;&gt;SQL Server - Adding Data&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-query-designer.html&quot;&gt;SQL Server - Query Designer&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-views.html&quot;&gt;SQL Server Views&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-stored-procedures.html&quot;&gt;SQL Server Stored Procedures&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-user-logins.html&quot;&gt;User Logins&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-server-roles.html&quot;&gt;Server Roles&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-database-schemas.html&quot;&gt;Database Schemas&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-linked-servers.html&quot;&gt;Linked Servers&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-integration-services-ssis.html&quot;&gt;Integration Services&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-summary.html&quot;&gt;Summary&lt;/a&gt;&lt;/li&gt;&lt;/ol&gt;</content><link rel='replies' type='application/atom+xml' href='http://mycomputersciences.blogspot.com/feeds/3254893927469760312/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/sql-server-integration-services-ssis.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/3254893927469760312'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/3254893927469760312'/><link rel='alternate' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/sql-server-integration-services-ssis.html' title='SQL Server Integration Services (SSIS)'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6070680432155434668.post-5114368363073813779</id><published>2011-06-24T12:49:00.001+05:00</published><updated>2011-06-24T14:11:36.651+05:00</updated><title type='text'>SQL Server - Linked Servers</title><content type='html'>&lt;p&gt;If you&#39;ve been navigating around SQL Server Management Studio (SSMS), you may have come across the Linked Servers option.&lt;/p&gt;  &lt;p&gt;The Linked Servers option allows you to connect to another instance of SQL Server running on a different machine, perhaps remotely in a different city/country. This can be useful if you need to perform distributed queries (query a remote database). Setting up a linked server is quite straight forward in SSMS, all you need is details of the remote server, and the database that you need to query. &lt;/p&gt;  &lt;h2&gt;Creating a Linked Server&lt;/h2&gt; &lt;p&gt;To create a linked server:&lt;/p&gt; &lt;ol&gt;&lt;li&gt;Navigate to &lt;i&gt;Server Objects &amp;gt; Linked Servers&lt;/i&gt;&lt;/li&gt;&lt;li&gt;Right click on &lt;i&gt;Linked Servers&lt;/i&gt; and select &lt;i&gt;New Linked Server...&lt;/i&gt;. Like this:&lt;br /&gt;&lt;img src=&quot;http://www.quackit.com/pix/sql_server/sql_server_2008/tutorial/linked_servers_1.gif&quot; alt=&quot;Creating a linked server in SQL Server Management Studio&quot; width=&quot;289&quot; height=&quot;131&quot; /&gt; &lt;/li&gt;&lt;li&gt;Complete the details for the linked server. In this example, &lt;i&gt;Data source&lt;/i&gt; refers to the name of the SQL Server machine (&quot;Barts_database_server&quot;), &lt;i&gt;Catalogue&lt;/i&gt; refers to the name of the database (&quot;Barts_database&quot;). You can also configure options in the other two tabs depending on your requirements.&lt;br /&gt;&lt;img src=&quot;http://www.quackit.com/pix/sql_server/sql_server_2008/tutorial/linked_servers_2.gif&quot; alt=&quot;Creating a linked server in SQL Server Management Studio&quot; width=&quot;480&quot; height=&quot;433&quot; /&gt; &lt;/li&gt;&lt;/ol&gt;  &lt;h2&gt;Distributed Queries&lt;/h2&gt; &lt;p&gt;Once you have configured your linked server, you will be able to run queries etc against it. When you run a query against a linked server, it is referred to as a &lt;i&gt;distributed query&lt;/i&gt;.&lt;/p&gt;  &lt;p&gt;When you execute a distributed query against a linked server, you must include a fully qualified, four-part table name for each data source to query. This four-part name should be in the form &lt;i&gt;linked_server_name.catalog.schema.object_name&lt;/i&gt;.&lt;/p&gt; &lt;p&gt;Here&#39;s an example:&lt;/p&gt;  &lt;div class=&quot;example-code&quot;&gt; Barts_database_server.Barts_database.Person.Enemy &lt;/div&gt; &lt;p&gt;This example is based on the linked server example above. It assumes that the remote database has a schema called &quot;Person&quot; and a table called &quot;Enemy&quot;.&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;h3 class=&quot;post-title entry-title&quot;&gt; SQL Server &lt;/h3&gt; &lt;div class=&quot;post-header&quot;&gt;  &lt;/div&gt;  &lt;ol style=&quot;font-weight: bold;&quot;&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/about-sql-server.html&quot;&gt;About SQL Server&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-editions.html&quot;&gt;SQL Server Editions&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-management-studio.html&quot;&gt;SQL Server - Management Studio&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-database.html&quot;&gt;SQL Server - Create a Database&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-table.html&quot;&gt;SQL Server - Create a Table&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-adding-data.html&quot;&gt;SQL Server - Adding Data&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-query-designer.html&quot;&gt;SQL Server - Query Designer&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-views.html&quot;&gt;SQL Server Views&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-stored-procedures.html&quot;&gt;SQL Server Stored Procedures&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-user-logins.html&quot;&gt;User Logins&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-server-roles.html&quot;&gt;Server Roles&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-database-schemas.html&quot;&gt;Database Schemas&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-linked-servers.html&quot;&gt;Linked Servers&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-integration-services-ssis.html&quot;&gt;Integration Services&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-summary.html&quot;&gt;Summary&lt;/a&gt;&lt;/li&gt;&lt;/ol&gt;</content><link rel='replies' type='application/atom+xml' href='http://mycomputersciences.blogspot.com/feeds/5114368363073813779/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/sql-server-linked-servers.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/5114368363073813779'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/5114368363073813779'/><link rel='alternate' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/sql-server-linked-servers.html' title='SQL Server - Linked Servers'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6070680432155434668.post-1096382773919014305</id><published>2011-06-24T12:48:00.001+05:00</published><updated>2011-06-24T14:12:14.966+05:00</updated><title type='text'>SQL Server - Database Schemas</title><content type='html'>&lt;p&gt;Ever since SQL Server 2005 was released, each object in a database has belonged to a database schema. SQL Server 2008 has continued with database schemas, and an explanation follows.&lt;/p&gt;  &lt;h2&gt;What is a Database Schema?&lt;/h2&gt; &lt;p&gt;A database schema is a way to logically group objects such as tables, views, stored procedures etc. Think of a schema as a container of objects.&lt;/p&gt;  &lt;p&gt;You can assign a user login permissions to a single schema so that the user can only access the objects they are authorized to access.&lt;/p&gt;  &lt;p&gt;Schemas can be created and altered in a database, and users can be granted access to a schema. A schema can be owned by any user, and schema ownership is transferable.&lt;/p&gt;  &lt;h2&gt;Creating a Database Schema&lt;/h2&gt; &lt;p&gt;To create a database schema in SQL Server 2008:&lt;/p&gt; &lt;ol&gt;&lt;li&gt;Navigate to &lt;i&gt;Security &amp;gt; Schemas&lt;/i&gt;&lt;/li&gt;&lt;li&gt;Right click on &lt;i&gt;Schemas&lt;/i&gt; and select &lt;i&gt;New Schema...&lt;/i&gt;. Like this:&lt;br /&gt;&lt;img src=&quot;http://www.quackit.com/pix/sql_server/sql_server_2008/tutorial/sql_server_database_schemas_1.gif&quot; alt=&quot;Creating a database schema in SQL Server Management Studio&quot; width=&quot;242&quot; height=&quot;464&quot; /&gt; &lt;/li&gt;&lt;li&gt;Complete the details in the &lt;i&gt;General&lt;/i&gt; tab for the new schema. In this example, the schema name is &quot;person&quot; and the schema owner is &quot;Homer&quot;.&lt;br /&gt;&lt;img src=&quot;http://www.quackit.com/pix/sql_server/sql_server_2008/tutorial/sql_server_database_schemas_2.gif&quot; alt=&quot;Creating a database schema in SQL Server Management Studio&quot; width=&quot;480&quot; height=&quot;431&quot; /&gt; &lt;/li&gt;&lt;li&gt;Add users to the schema as required and set their permissions:&lt;br /&gt;&lt;img src=&quot;http://www.quackit.com/pix/sql_server/sql_server_2008/tutorial/sql_server_database_schemas_3.gif&quot; alt=&quot;Creating a database schema in SQL Server Management Studio&quot; width=&quot;480&quot; height=&quot;432&quot; /&gt; &lt;/li&gt;&lt;li&gt;Add any extended properties (via the &lt;i&gt;Extended Properties tab&lt;/i&gt;)&lt;/li&gt;&lt;li&gt;Click &lt;i&gt;OK&lt;/i&gt;.&lt;/li&gt;&lt;/ol&gt;  &lt;h2&gt;Add a Table to the New Schema&lt;/h2&gt; &lt;p&gt;Now that we have a new schema, we can add objects such as tables, views, and stored procedures to it. For example, we could transfer the table that we created in the earlier lesson to the new schema.&lt;/p&gt;  &lt;p&gt;When we created that table (called &quot;Individual&quot;), it was created in the default database schema (&quot;dbo&quot;). We know this because it appears in our object browser as &quot;dbo.Individual&quot;.&lt;/p&gt; &lt;p&gt;To transfer the &quot;Individual&quot; table to the person &quot;schema&quot;:&lt;/p&gt; &lt;ol&gt;&lt;li&gt;In Object Explorer, right click on the table name and select &quot;Design&quot;:&lt;br /&gt;&lt;img src=&quot;http://www.quackit.com/pix/sql_server/sql_server_2008/tutorial/sql_server_database_schemas_4.gif&quot; alt=&quot;Changing database schema for a table in SQL Server Management Studio&quot; width=&quot;298&quot; height=&quot;155&quot; /&gt; &lt;/li&gt;&lt;li&gt;From Design view, press F4 to display the Properties window.&lt;/li&gt;&lt;li&gt;From the Properties window, change the schema to the desired schema:&lt;br /&gt;&lt;img src=&quot;http://www.quackit.com/pix/sql_server/sql_server_2008/tutorial/sql_server_database_schemas_5.gif&quot; alt=&quot;Changing database schema for a table in SQL Server Management Studio&quot; width=&quot;177&quot; height=&quot;362&quot; /&gt; &lt;/li&gt;&lt;li&gt;Close Design View by right clicking the tab and selecting &quot;Close&quot;:&lt;br /&gt;&lt;img src=&quot;http://www.quackit.com/pix/sql_server/sql_server_2008/tutorial/sql_server_database_schemas_6.gif&quot; alt=&quot;Closing Design View&quot; width=&quot;293&quot; height=&quot;189&quot; /&gt;&lt;/li&gt;&lt;li&gt;Click &quot;OK&quot; when prompted to save&lt;/li&gt;&lt;/ol&gt; &lt;p&gt;Your table has now been transferred to the &quot;person&quot; schema.&lt;/p&gt;  &lt;h2&gt;Confirm your Change&lt;/h2&gt; &lt;p&gt;To confirm the change:&lt;/p&gt; &lt;ol&gt;&lt;li&gt;Refresh the Object Browser view:&lt;br /&gt;&lt;img src=&quot;http://www.quackit.com/pix/sql_server/sql_server_2008/tutorial/sql_server_database_schemas_7.gif&quot; alt=&quot;Refreshing the view in Object Browser&quot; width=&quot;236&quot; height=&quot;152&quot; /&gt; &lt;/li&gt;&lt;li&gt;You will now see that Object Browser displays the new schema for the table (person.Individual):&lt;br /&gt;&lt;img src=&quot;http://www.quackit.com/pix/sql_server/sql_server_2008/tutorial/sql_server_database_schemas_8.gif&quot; alt=&quot;Screenshot of the table in Object Browser&quot; width=&quot;172&quot; height=&quot;97&quot; /&gt;&lt;/li&gt;&lt;/ol&gt;&lt;br /&gt;&lt;h3 class=&quot;post-title entry-title&quot;&gt; SQL Server &lt;/h3&gt; &lt;div class=&quot;post-header&quot;&gt;  &lt;/div&gt;  &lt;ol style=&quot;font-weight: bold;&quot;&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/about-sql-server.html&quot;&gt;About SQL Server&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-editions.html&quot;&gt;SQL Server Editions&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-management-studio.html&quot;&gt;SQL Server - Management Studio&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-database.html&quot;&gt;SQL Server - Create a Database&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-table.html&quot;&gt;SQL Server - Create a Table&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-adding-data.html&quot;&gt;SQL Server - Adding Data&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-query-designer.html&quot;&gt;SQL Server - Query Designer&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-views.html&quot;&gt;SQL Server Views&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-stored-procedures.html&quot;&gt;SQL Server Stored Procedures&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-user-logins.html&quot;&gt;User Logins&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-server-roles.html&quot;&gt;Server Roles&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-database-schemas.html&quot;&gt;Database Schemas&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-linked-servers.html&quot;&gt;Linked Servers&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-integration-services-ssis.html&quot;&gt;Integration Services&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-summary.html&quot;&gt;Summary&lt;/a&gt;&lt;/li&gt;&lt;/ol&gt;</content><link rel='replies' type='application/atom+xml' href='http://mycomputersciences.blogspot.com/feeds/1096382773919014305/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/sql-server-database-schemas.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/1096382773919014305'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/1096382773919014305'/><link rel='alternate' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/sql-server-database-schemas.html' title='SQL Server - Database Schemas'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6070680432155434668.post-2111375482330366467</id><published>2011-06-24T12:46:00.002+05:00</published><updated>2011-06-24T14:12:40.537+05:00</updated><title type='text'>SQL Server - Server Roles</title><content type='html'>&lt;p&gt;When creating a new user login in SQL Server, you get the option of assigning the login one or more server roles. &lt;/p&gt;  &lt;p&gt;Server roles (not to be confused with database roles) are available for various database administration tasks. Not everyone should be assigned to a server role. In fact, only advanced users such as database administrators should be assigned a server role.&lt;/p&gt;&lt;p&gt;To access the server roles in SQL Server Management Studio, expand the Security folder:&lt;/p&gt; &lt;img src=&quot;http://www.quackit.com/pix/sql_server/sql_server_2008/tutorial/server_roles_1.gif&quot; alt=&quot;Screenshot of accessing server roles&quot; width=&quot;163&quot; height=&quot;289&quot; /&gt; &lt;p&gt;You view the properties of a server role by right clicking on it. You can then add users to the server role by clicking Add. In the screenshot below, Homer has been added to the &lt;i&gt;securityadmin&lt;/i&gt; role.&lt;/p&gt; &lt;img src=&quot;http://www.quackit.com/pix/sql_server/sql_server_2008/tutorial/server_roles_2.gif&quot; alt=&quot;Adding a user to a server role&quot; width=&quot;480&quot; height=&quot;431&quot; /&gt;   &lt;h2&gt;Explanation of Server Roles&lt;/h2&gt; &lt;p&gt;Here&#39;s an explanation of the server roles defined in SQL Server 2008 during setup:&lt;/p&gt; &lt;table class=&quot;tabular&quot; cellspacing=&quot;0&quot;&gt; &lt;tbody&gt;&lt;tr&gt;&lt;th&gt;Server Role&lt;/th&gt;&lt;th&gt;Description&lt;/th&gt;&lt;/tr&gt; &lt;tr&gt;&lt;td&gt;sysadmin&lt;/td&gt;&lt;td&gt;Can perform any task in SQL Server.&lt;/td&gt;&lt;/tr&gt; &lt;tr&gt;&lt;td&gt;serveradmin&lt;/td&gt;&lt;td&gt;Can set server-wide configuration options, can shut down the server.&lt;/td&gt;&lt;/tr&gt; &lt;tr&gt;&lt;td&gt;setupadmin&lt;/td&gt;&lt;td&gt;Can manage linked servers and startup procedures.&lt;/td&gt;&lt;/tr&gt; &lt;tr&gt;&lt;td&gt;securityadmin&lt;/td&gt;&lt;td&gt;Can manage logins and database permissions, read logs, change passwords.&lt;/td&gt;&lt;/tr&gt; &lt;tr&gt;&lt;td&gt;processadmin&lt;/td&gt;&lt;td&gt;Can manage processes running in SQL Server.&lt;/td&gt;&lt;/tr&gt; &lt;tr&gt;&lt;td&gt;dbcreator&lt;/td&gt;&lt;td&gt;Can create, alter, and drop databases.&lt;/td&gt;&lt;/tr&gt; &lt;tr&gt;&lt;td&gt;diskadmin&lt;/td&gt;&lt;td&gt;Can manage disk files.&lt;/td&gt;&lt;/tr&gt; &lt;tr&gt;&lt;td&gt;bulkadmin&lt;/td&gt;&lt;td&gt;Can execute BULK INSERT statements.&lt;/td&gt;&lt;/tr&gt; &lt;tr&gt;&lt;td&gt;public&lt;/td&gt;&lt;td&gt;Every SQL Server user account belongs to this server role. When a server principal has not been granted or denied specific permissions on a securable object, the user inherits the permissions granted to public on that object. Only assign public permissions on an object when you want the object to be available to all users.&lt;/td&gt;&lt;/tr&gt; &lt;/tbody&gt;&lt;/table&gt; &lt;p&gt;As you can see, some of these roles allow very specific tasks to be performed. If you don&#39;t have many technical users, it&#39;s likely that you&#39;ll only use one or two of these roles (including sysadmin).&lt;/p&gt;&lt;h3 class=&quot;post-title entry-title&quot;&gt; SQL Server &lt;/h3&gt; &lt;div class=&quot;post-header&quot;&gt;  &lt;/div&gt;  &lt;ol style=&quot;font-weight: bold;&quot;&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/about-sql-server.html&quot;&gt;About SQL Server&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-editions.html&quot;&gt;SQL Server Editions&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-management-studio.html&quot;&gt;SQL Server - Management Studio&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-database.html&quot;&gt;SQL Server - Create a Database&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-table.html&quot;&gt;SQL Server - Create a Table&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-adding-data.html&quot;&gt;SQL Server - Adding Data&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-query-designer.html&quot;&gt;SQL Server - Query Designer&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-views.html&quot;&gt;SQL Server Views&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-stored-procedures.html&quot;&gt;SQL Server Stored Procedures&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-user-logins.html&quot;&gt;User Logins&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-server-roles.html&quot;&gt;Server Roles&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-database-schemas.html&quot;&gt;Database Schemas&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-linked-servers.html&quot;&gt;Linked Servers&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-integration-services-ssis.html&quot;&gt;Integration Services&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-summary.html&quot;&gt;Summary&lt;/a&gt;&lt;/li&gt;&lt;/ol&gt;</content><link rel='replies' type='application/atom+xml' href='http://mycomputersciences.blogspot.com/feeds/2111375482330366467/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/sql-server-server-roles.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/2111375482330366467'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/2111375482330366467'/><link rel='alternate' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/sql-server-server-roles.html' title='SQL Server - Server Roles'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6070680432155434668.post-9035360018757678452</id><published>2011-06-24T12:43:00.001+05:00</published><updated>2011-06-24T14:13:09.305+05:00</updated><title type='text'>SQL Server - User Logins</title><content type='html'>&lt;p&gt;SQL Server allows for the creation of user logins. Each individual who needs access to SQL Server can be given their own user account.&lt;/p&gt; &lt;p&gt;When the administrator configures these user logins, he/she can assign them to any number of roles and schemas, depending on the access that the individual is entitled to.&lt;/p&gt; &lt;p&gt;In this lesson, we will walk through the steps in creating a user login.&lt;/p&gt;&lt;p&gt;************************************************************************&lt;br /&gt;&lt;/p&gt;&lt;h2&gt;To Create a New User Login&lt;/h2&gt; &lt;ol&gt;&lt;li&gt;Using SQL Server Management Studio, expand the &quot;Security&quot; option and right click on &quot;Logins&quot;&lt;/li&gt;&lt;li&gt;Click on &quot;New Login&quot;&lt;br /&gt;&lt;img src=&quot;http://www.quackit.com/pix/sql_server/sql_server_2008/tutorial/sql_server_users_1.gif&quot; alt=&quot;Creating a new login in SQL Server&quot; width=&quot;258&quot; height=&quot;175&quot; /&gt; &lt;/li&gt;&lt;li&gt;Complete the login properties in the &quot;General&quot; tab by providing a name for the login, choosing the Authentication method (providing a password if you choose &quot;SQL Server authentication&quot;), and selecting the database to use as a default. If you don&#39;t choose a language, it will use the default for the current installation of SQL Server. &lt;div class=&quot;info&quot;&gt; &lt;p&gt;If you get an error that reads &quot;The MUST_CHANGE option is not supported by this version of Microsoft Windows&quot;, simply uncheck the &quot;User must change password at next login&quot; option. The error occurs because your operating system doesn&#39;t support this option.&lt;/p&gt; &lt;/div&gt; &lt;br /&gt;&lt;img src=&quot;http://www.quackit.com/pix/sql_server/sql_server_2008/tutorial/sql_server_users_2.gif&quot; alt=&quot;Creating a new login in SQL Server - General tab&quot; width=&quot;480&quot; height=&quot;431&quot; /&gt; &lt;/li&gt;&lt;li&gt;Click the &quot;Server Roles&quot; tab if you need to apply any server-wide security privileges.&lt;br /&gt;&lt;img src=&quot;http://www.quackit.com/pix/sql_server/sql_server_2008/tutorial/sql_server_users_3.gif&quot; alt=&quot;Creating a new login in SQL Server - Server Roles tab&quot; width=&quot;287&quot; height=&quot;284&quot; /&gt; &lt;/li&gt;&lt;li&gt;Click the &quot;User Mapping&quot; tab to specify which databases this user account is allowed to access. By default, the login will be assigned to the &quot;Public&quot; role, which provides the login with basic access. If the login needs more access in one or more databases, it can be assigned to another role with greater privileges.&lt;p&gt;Note that these roles are &quot;Database Roles&quot; and are different to the server roles in the previous tab. Server roles are for administering the SQL Server. Database roles are created within each database and specify what the login can do within that database.&lt;/p&gt; &lt;img src=&quot;http://www.quackit.com/pix/sql_server/sql_server_2008/tutorial/sql_server_users_4.gif&quot; alt=&quot;Creating a new login in SQL Server - User Mapping tab&quot; width=&quot;480&quot; height=&quot;428&quot; /&gt;&lt;/li&gt;&lt;/ol&gt;&lt;br /&gt;&lt;h3 class=&quot;post-title entry-title&quot;&gt; SQL Server &lt;/h3&gt; &lt;div class=&quot;post-header&quot;&gt;  &lt;/div&gt;  &lt;ol style=&quot;font-weight: bold;&quot;&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/about-sql-server.html&quot;&gt;About SQL Server&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-editions.html&quot;&gt;SQL Server Editions&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-management-studio.html&quot;&gt;SQL Server - Management Studio&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-database.html&quot;&gt;SQL Server - Create a Database&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-table.html&quot;&gt;SQL Server - Create a Table&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-adding-data.html&quot;&gt;SQL Server - Adding Data&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-query-designer.html&quot;&gt;SQL Server - Query Designer&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-views.html&quot;&gt;SQL Server Views&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-stored-procedures.html&quot;&gt;SQL Server Stored Procedures&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-user-logins.html&quot;&gt;User Logins&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-server-roles.html&quot;&gt;Server Roles&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-database-schemas.html&quot;&gt;Database Schemas&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-linked-servers.html&quot;&gt;Linked Servers&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-integration-services-ssis.html&quot;&gt;Integration Services&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-summary.html&quot;&gt;Summary&lt;/a&gt;&lt;/li&gt;&lt;/ol&gt;</content><link rel='replies' type='application/atom+xml' href='http://mycomputersciences.blogspot.com/feeds/9035360018757678452/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/sql-server-user-logins.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/9035360018757678452'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/9035360018757678452'/><link rel='alternate' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/sql-server-user-logins.html' title='SQL Server - User Logins'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6070680432155434668.post-3874832222577561423</id><published>2011-06-24T12:42:00.001+05:00</published><updated>2011-06-24T14:13:31.245+05:00</updated><title type='text'>SQL Server - Stored Procedures</title><content type='html'>&lt;p&gt;Stored procedures are a powerful part of SQL Server. They can assist programmers and administrators greatly in working with the database configuration and its data.&lt;/p&gt; &lt;p&gt;A stored procedure is a precompiled group of Transact-SQL statements, and is saved to the database (under the &quot;Stored Procedures&quot; node). Programmers and administrators can execute stored procedures either from the SQL Server Management Studio or from within an application as required. &lt;/p&gt; &lt;p&gt;Transact-SQL, which is based on SQL &lt;span style=&quot;font-weight: bold;&quot;&gt;(&lt;/span&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;Structured Query Language&lt;/span&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;)&lt;/span&gt;, is the programming language used to interface between applications and their databases. Transact-SQL is a relatively easy language to learn and I highly recommend becoming familiar with it. &lt;/p&gt;  &lt;h2&gt;Benefits of Stored Procedures&lt;/h2&gt; &lt;p&gt;Here are some key benefits in using stored procedures:&lt;/p&gt;  &lt;table class=&quot;tabular&quot; cellspacing=&quot;0&quot;&gt; &lt;tbody&gt;&lt;tr&gt;&lt;th style=&quot;width: 15%;&quot;&gt;Benefit&lt;/th&gt;&lt;th&gt;Explanation of benefit&lt;/th&gt;&lt;/tr&gt; &lt;tr&gt;&lt;td&gt;Modular programming&lt;/td&gt;&lt;td&gt;You can write a stored procedure once, then call it from multiple places in your application.&lt;/td&gt;&lt;/tr&gt; &lt;tr&gt;&lt;td&gt;Performance&lt;/td&gt;&lt;td&gt;Stored procedures provide faster code execution and reduce network traffic. &lt;ul&gt;&lt;li&gt;Faster execution: Stored procedures are parsed and optimized as soon as they are created and the stored procedure is stored in memory. This means that it will execute a lot faster than sending many lines of SQL code from your application to the SQL Server. Doing that requires SQL Server to compile and optimze your SQL code every time it runs.&lt;/li&gt;&lt;li&gt;Reduced network traffic: If you send many lines of SQL code over the network to your SQL Server, this will impact on network performance. This is especially true if you have hundreds of lines of SQL code and/or you have lots of activity on your application. Running the code on the SQL Server (as a stored procedure) eliminates the need to send this code over the network. The only network traffic will be the parameters supplied and the results of any query.&lt;/li&gt;&lt;/ul&gt; &lt;/td&gt;&lt;/tr&gt; &lt;tr&gt;&lt;td&gt;Security&lt;/td&gt;&lt;td&gt;Users can execute a stored procedure without needing to execute any of the statements directly. Therefore, a stored procedure can provide advanced database functionality for users who wouldn&#39;t normally have access to these tasks, but this functionality is made available in a tightly controlled way.&lt;/td&gt;&lt;/tr&gt; &lt;/tbody&gt;&lt;/table&gt;  &lt;h2&gt;Creating a Stored Procedure&lt;/h2&gt; &lt;p&gt;You create stored procedures in the SQL Server Management Studio using the &lt;i&gt;CREATE PROCEDURE&lt;/i&gt; statement, followed by the code that makes up the stored procedure.&lt;/p&gt; &lt;div class=&quot;example-code&quot;&gt; &lt;code&gt; &lt;/code&gt;&lt;pre&gt;CREATE PROCEDURE StoredProcedureName AS&lt;br /&gt;...&lt;br /&gt;&lt;/pre&gt;  &lt;/div&gt; &lt;p&gt;The following code creates a stored procedure called &quot;MyStoredProcedure&quot;:&lt;/p&gt; &lt;div class=&quot;example-code&quot;&gt; &lt;code&gt; &lt;/code&gt;&lt;pre&gt;CREATE PROCEDURE MyStoredProcedure AS&lt;br /&gt;SET ROWCOUNT 10&lt;br /&gt;SELECT Products.ProductName AS TenMostExpensiveProducts, Products.UnitPrice&lt;br /&gt;FROM Products&lt;br /&gt;ORDER BY Products.UnitPrice DESC&lt;br /&gt;&lt;/pre&gt;  &lt;/div&gt; &lt;p&gt;Once you run this code in the SQL Server Management Studio, the stored procedure is created and appears under the &quot;Stored Procedures&quot; node.&lt;/p&gt;  &lt;h2&gt;Modifying a Stored Procedure&lt;/h2&gt; &lt;p&gt;If you need to modify an existing stored procedure, you simply replace the CREATE with ALTER.&lt;/p&gt; &lt;div class=&quot;example-code&quot;&gt; &lt;code&gt; &lt;/code&gt;&lt;pre&gt;ALTER PROCEDURE MyStoredProcedure AS&lt;br /&gt;...&lt;br /&gt;&lt;/pre&gt;  &lt;/div&gt;  &lt;h2&gt;Running a Stored Procedure&lt;/h2&gt; &lt;p&gt;You can run a stored procedure by using &lt;i&gt;EXECUTE&lt;/i&gt; or &lt;i&gt;EXEC&lt;/i&gt;. For example, to run the above stored procedure, type the following: &lt;/p&gt; &lt;div class=&quot;example-code&quot;&gt; &lt;code&gt; &lt;/code&gt;&lt;pre&gt;EXEC MyStoredProcedure&lt;br /&gt;&lt;/pre&gt;  &lt;/div&gt; &lt;p&gt;If the stored procedure has spaces in its name, enclose it between double quotes: &lt;/p&gt; &lt;div class=&quot;example-code&quot;&gt; &lt;code&gt; &lt;/code&gt;&lt;pre&gt;EXEC &quot;My Stored Procedure&quot;&lt;br /&gt;&lt;/pre&gt;  &lt;/div&gt;  &lt;p&gt;If your stored procedure accepts any parameters, they are placed after the procedure name:&lt;/p&gt; &lt;div class=&quot;example-code&quot;&gt; &lt;code&gt; &lt;/code&gt;&lt;pre&gt;EXEC MyStoredProcedure @ParameterName=&quot;MyParameter&quot;&lt;br /&gt;&lt;/pre&gt;  &lt;/div&gt;  &lt;p&gt;So, here&#39;s an example:&lt;/p&gt; &lt;div class=&quot;example-code&quot;&gt; &lt;code&gt; &lt;/code&gt;&lt;pre&gt;EXEC SalesByCategory @CategoryName =&quot;Beverages&quot;&lt;br /&gt;&lt;/pre&gt;  &lt;/div&gt;  &lt;h2&gt;Using The GUI&lt;/h2&gt; &lt;p&gt;You can also use the graphical user interface to initiate the execution of a stored procedure. &lt;/p&gt; &lt;p&gt;To initiate a stored procedure this way:&lt;/p&gt;  &lt;ol&gt;&lt;li&gt;Navigate to the stored procedure&lt;/li&gt;&lt;li&gt;Right click on the stored procedure and select &quot;Execute Stored Procedure...&quot;:&lt;br /&gt;&lt;img src=&quot;http://www.quackit.com/pix/sql_server/sql_server_2008/tutorial/stored_procedures_1.gif&quot; alt=&quot;Initiating the execution of a stored procedure&quot; width=&quot;420&quot; height=&quot;247&quot; /&gt; &lt;/li&gt;&lt;li&gt;A dialog will appear. Enter your chosen parameter values etc:&lt;br /&gt;&lt;img src=&quot;http://www.quackit.com/pix/sql_server/sql_server_2008/tutorial/stored_procedures_2.gif&quot; alt=&quot;Initiating the execution of a stored procedure&quot; width=&quot;463&quot; height=&quot;165&quot; /&gt; &lt;/li&gt;&lt;li&gt;Click &quot;OK&quot;&lt;/li&gt;&lt;li&gt;SQL Server will now generate the SQL code and execute the stored procedure:&lt;br /&gt;&lt;img src=&quot;http://www.quackit.com/pix/sql_server/sql_server_2008/tutorial/stored_procedures_3.gif&quot; alt=&quot;Executing a stored procedure&quot; width=&quot;422&quot; height=&quot;396&quot; /&gt; &lt;/li&gt;&lt;/ol&gt;  &lt;h2&gt;Parameters&lt;/h2&gt; &lt;p&gt;A parameter is a value that your stored procedure uses in order to perform it&#39;s task. When you write a stored procedure, you can specify the parameters that need to be supplied from the user. For example, if you write a stored procedure to select the address details about an individual, your stored procedure needs to know which individual to select. In this case, the user can provide an IndividualId or UserId to tell the stored procedure which individual to look up.&lt;/p&gt;   &lt;h2&gt;System Stored Procedures&lt;/h2&gt; &lt;p&gt;SQL Server includes a large number of system stored procedures to assist in database administration tasks. Many of the tasks you can perform via SQL Server Management Studio can be done via a system stored procedure. For example, some of the things you can do with system stored procedures include:&lt;/p&gt; &lt;ul&gt;&lt;li&gt;configure security accounts&lt;/li&gt;&lt;li&gt;set up linked servers&lt;/li&gt;&lt;li&gt;create a database maintenance plan&lt;/li&gt;&lt;li&gt;create full text search catalogs&lt;/li&gt;&lt;li&gt;configure replication&lt;/li&gt;&lt;li&gt;set up scheduled jobs&lt;/li&gt;&lt;li&gt;and much more.&lt;/li&gt;&lt;/ul&gt;&lt;br /&gt;&lt;h3 class=&quot;post-title entry-title&quot;&gt; SQL Server &lt;/h3&gt; &lt;div class=&quot;post-header&quot;&gt;  &lt;/div&gt;  &lt;ol style=&quot;font-weight: bold;&quot;&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/about-sql-server.html&quot;&gt;About SQL Server&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-editions.html&quot;&gt;SQL Server Editions&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-management-studio.html&quot;&gt;SQL Server - Management Studio&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-database.html&quot;&gt;SQL Server - Create a Database&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-table.html&quot;&gt;SQL Server - Create a Table&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-adding-data.html&quot;&gt;SQL Server - Adding Data&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-query-designer.html&quot;&gt;SQL Server - Query Designer&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-views.html&quot;&gt;SQL Server Views&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-stored-procedures.html&quot;&gt;SQL Server Stored Procedures&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-user-logins.html&quot;&gt;User Logins&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-server-roles.html&quot;&gt;Server Roles&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-database-schemas.html&quot;&gt;Database Schemas&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-linked-servers.html&quot;&gt;Linked Servers&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-integration-services-ssis.html&quot;&gt;Integration Services&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-summary.html&quot;&gt;Summary&lt;/a&gt;&lt;/li&gt;&lt;/ol&gt;</content><link rel='replies' type='application/atom+xml' href='http://mycomputersciences.blogspot.com/feeds/3874832222577561423/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/sql-server-stored-procedures.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/3874832222577561423'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/3874832222577561423'/><link rel='alternate' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/sql-server-stored-procedures.html' title='SQL Server - Stored Procedures'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6070680432155434668.post-4500788763867135388</id><published>2011-06-24T12:41:00.002+05:00</published><updated>2011-06-24T14:13:54.930+05:00</updated><title type='text'>SQL Server - Views</title><content type='html'>&lt;h2&gt;Benefits of Views&lt;/h2&gt; &lt;p&gt;A view can be useful when there are multiple users with different levels of access, who all need to see portions of the data in the database (but not necessarily all of the data). Views can do the following:&lt;/p&gt; &lt;ul&gt;&lt;li&gt;Restrict access to specific rows in a table&lt;/li&gt;&lt;li&gt;Restrict access to specific columns in a table&lt;/li&gt;&lt;li&gt;Join columns from multiple tables and present them as though they are part of a single table&lt;/li&gt;&lt;li&gt;Present aggregate information (such as the results of the COUNT function)&lt;/li&gt;&lt;/ul&gt;  &lt;h2&gt;Accessing Views&lt;/h2&gt; &lt;p&gt;Any view that you create ends up being located under the &quot;Views&quot; folder of your database.&lt;/p&gt;  &lt;p&gt;The following screenshot shows a number of views that are located within the &quot;AdventureWorks2008&quot; database:&lt;/p&gt; &lt;img src=&quot;http://www.quackit.com/pix/sql_server/sql_server_2008/tutorial/sql_server_views_1.gif&quot; alt=&quot;Accessing a view&quot; width=&quot;339&quot; height=&quot;421&quot; /&gt;  &lt;h2&gt;Creating a View&lt;/h2&gt; &lt;p&gt;You create a view by using the CREATE VIEW statement, followed by the SELECT statement.&lt;/p&gt; &lt;div class=&quot;example-code&quot;&gt; &lt;code&gt; &lt;/code&gt;&lt;pre&gt;CREATE VIEW ViewName AS&lt;br /&gt;SELECT ...&lt;br /&gt;&lt;/pre&gt;  &lt;/div&gt;  &lt;p&gt;Example:&lt;/p&gt; &lt;div class=&quot;example-code&quot;&gt; &lt;code&gt; &lt;/code&gt;&lt;pre&gt;CREATE VIEW &quot;Alphabetical list of products&quot; AS&lt;br /&gt;SELECT Products.*, Categories.CategoryName&lt;br /&gt;FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID&lt;br /&gt;WHERE (((Products.Discontinued)=0))&lt;br /&gt;&lt;/pre&gt;  &lt;/div&gt;  &lt;h2&gt;Modifing a View&lt;/h2&gt; &lt;p&gt;You can modify an existing view by using using ALTER instead or CREATE.&lt;/p&gt; &lt;p&gt;Example:&lt;/p&gt; &lt;div class=&quot;example-code&quot;&gt; &lt;code&gt; &lt;/code&gt;&lt;pre&gt;ALTER VIEW &quot;Alphabetical list of products&quot; AS&lt;br /&gt;SELECT Products.*, Categories.CategoryName&lt;br /&gt;FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID&lt;br /&gt;WHERE (((Products.Discontinued)=0))&lt;br /&gt;&lt;/pre&gt;  &lt;/div&gt; &lt;div class=&quot;tip&quot;&gt; &lt;p&gt;You can also right click on the view and select &quot;Design&quot;.&lt;/p&gt; &lt;/div&gt;  &lt;h2&gt;Running a View&lt;/h2&gt; &lt;p&gt;You run a view by using a SELECT statement. &lt;/p&gt; &lt;div class=&quot;example-code&quot;&gt; &lt;code&gt; &lt;/code&gt;&lt;pre&gt;SELECT TOP 1000 *&lt;br /&gt;FROM [AdventureWorks2008].[Sales].[vIndividualCustomer]&lt;br /&gt;&lt;/pre&gt;  &lt;/div&gt; &lt;div class=&quot;tip&quot;&gt; &lt;p&gt;You can also right-click on the view and select &quot;Select Top 1000 Rows&quot;.&lt;/p&gt; &lt;/div&gt;  &lt;p&gt;Running the above view results in this:&lt;/p&gt; &lt;img src=&quot;http://www.quackit.com/pix/sql_server/sql_server_2008/tutorial/sql_server_views_2.gif&quot; alt=&quot;Results of a view&quot; width=&quot;480&quot; height=&quot;325&quot; /&gt; &lt;p&gt;As you can see, it looks just like you&#39;ve selected rows from a table. The difference is that, each column could potentially be coming from a different table.&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;h3 class=&quot;post-title entry-title&quot;&gt; SQL Server &lt;/h3&gt; &lt;div class=&quot;post-header&quot;&gt;  &lt;/div&gt;  &lt;ol style=&quot;font-weight: bold;&quot;&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/about-sql-server.html&quot;&gt;About SQL Server&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-editions.html&quot;&gt;SQL Server Editions&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-management-studio.html&quot;&gt;SQL Server - Management Studio&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-database.html&quot;&gt;SQL Server - Create a Database&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-table.html&quot;&gt;SQL Server - Create a Table&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-adding-data.html&quot;&gt;SQL Server - Adding Data&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-query-designer.html&quot;&gt;SQL Server - Query Designer&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-views.html&quot;&gt;SQL Server Views&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-stored-procedures.html&quot;&gt;SQL Server Stored Procedures&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-user-logins.html&quot;&gt;User Logins&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-server-roles.html&quot;&gt;Server Roles&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-database-schemas.html&quot;&gt;Database Schemas&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-linked-servers.html&quot;&gt;Linked Servers&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-integration-services-ssis.html&quot;&gt;Integration Services&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-summary.html&quot;&gt;Summary&lt;/a&gt;&lt;/li&gt;&lt;/ol&gt;</content><link rel='replies' type='application/atom+xml' href='http://mycomputersciences.blogspot.com/feeds/4500788763867135388/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/sql-server-views.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/4500788763867135388'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/4500788763867135388'/><link rel='alternate' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/sql-server-views.html' title='SQL Server - Views'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6070680432155434668.post-7790005970342922003</id><published>2011-06-24T12:39:00.002+05:00</published><updated>2011-06-24T14:14:22.590+05:00</updated><title type='text'>SQL Server - Query Designer</title><content type='html'>&lt;h2&gt;About The Query Designer&lt;/h2&gt; &lt;p&gt;The graphical query designer is a graphical user interface that allows you to build queries to run against your SQL Server database. This can be particularly useful when building complex queries that involves many tables, views etc.&lt;/p&gt; &lt;p&gt;The query designer can also be beneficial for those who are learning how to write SQL. This is because you don&#39;t need to remember the SQL syntax in order to write queries against your database - the query designer generates the SQL for you.&lt;/p&gt; &lt;h2&gt;Building Your Queries&lt;/h2&gt; &lt;p&gt;To build a query with the query gesigner:&lt;/p&gt;  &lt;ol&gt;&lt;li&gt;Select &lt;i&gt;Query &amp;gt; Design Query in Editor...&lt;/i&gt;:&lt;br /&gt;&lt;img src=&quot;http://www.quackit.com/pix/sql_server/sql_server_2008/tutorial/query_designer_1.gif&quot; alt=&quot;Accessing the Query Designer&quot; width=&quot;369&quot; height=&quot;322&quot; /&gt; &lt;/li&gt;&lt;li&gt;Add the tables you want to run the query against. In this case, we only have one table to choose from.&lt;br /&gt;&lt;img src=&quot;http://www.quackit.com/pix/sql_server/sql_server_2008/tutorial/query_designer_2.gif&quot; alt=&quot;Accessing the Query Designer&quot; width=&quot;400&quot; height=&quot;417&quot; /&gt; &lt;/li&gt;&lt;li&gt;Select the column/s you want to display in your query:&lt;br /&gt;&lt;img src=&quot;http://www.quackit.com/pix/sql_server/sql_server_2008/tutorial/query_designer_3.gif&quot; alt=&quot;Query Designer&quot; width=&quot;432&quot; height=&quot;417&quot; /&gt; &lt;/li&gt;&lt;li&gt;Click &quot;OK&quot;&lt;/li&gt;&lt;/ol&gt; &lt;p&gt;Once you&#39;ve clicked OK, you will find the query has been added to your workspace. You can then run it as you would any other query.&lt;/p&gt;&lt;h3 class=&quot;post-title entry-title&quot;&gt; SQL Server &lt;/h3&gt; &lt;div class=&quot;post-header&quot;&gt;  &lt;/div&gt;  &lt;ol style=&quot;font-weight: bold;&quot;&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/about-sql-server.html&quot;&gt;About SQL Server&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-editions.html&quot;&gt;SQL Server Editions&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-management-studio.html&quot;&gt;SQL Server - Management Studio&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-database.html&quot;&gt;SQL Server - Create a Database&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-table.html&quot;&gt;SQL Server - Create a Table&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-adding-data.html&quot;&gt;SQL Server - Adding Data&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-query-designer.html&quot;&gt;SQL Server - Query Designer&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-views.html&quot;&gt;SQL Server Views&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-stored-procedures.html&quot;&gt;SQL Server Stored Procedures&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-user-logins.html&quot;&gt;User Logins&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-server-roles.html&quot;&gt;Server Roles&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-database-schemas.html&quot;&gt;Database Schemas&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-linked-servers.html&quot;&gt;Linked Servers&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-integration-services-ssis.html&quot;&gt;Integration Services&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-summary.html&quot;&gt;Summary&lt;/a&gt;&lt;/li&gt;&lt;/ol&gt;</content><link rel='replies' type='application/atom+xml' href='http://mycomputersciences.blogspot.com/feeds/7790005970342922003/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/sql-server-query-designer.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/7790005970342922003'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/7790005970342922003'/><link rel='alternate' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/sql-server-query-designer.html' title='SQL Server - Query Designer'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6070680432155434668.post-8903154652502539977</id><published>2011-06-24T12:38:00.001+05:00</published><updated>2011-06-24T14:14:50.599+05:00</updated><title type='text'>SQL Server - Adding Data</title><content type='html'>&lt;h2&gt;Editing Table Rows&lt;/h2&gt;&lt;p&gt;We can use the &quot;Edit Top 200 Rows&quot; option to add data to our table.&lt;/p&gt;  &lt;ol&gt;&lt;li&gt;To use this option, right click on the table you wish to open, and select &quot;Edit Top 200 Rows&quot;:&lt;br /&gt;&lt;img src=&quot;http://www.quackit.com/pix/sql_server/sql_server_2008/tutorial/adding_data_1.gif&quot; alt=&quot;Screenshot of editing the top 200 rows of a table in SSMS&quot; width=&quot;280&quot; height=&quot;332&quot; /&gt; &lt;/li&gt;&lt;li&gt;You can now start entering the data directly into your table.&lt;br /&gt;&lt;div class=&quot;info&quot;&gt; &lt;p&gt;Note that you don&#39;t need to enter data into the IndividualId and DateCreated columns. This is because the they will be populated automatically (remember, we set IndividualId to &quot;Is Identity&quot; and DateCreated to &quot;GetDate()&quot;))&lt;/p&gt; &lt;/div&gt; &lt;img src=&quot;http://www.quackit.com/pix/sql_server/sql_server_2008/tutorial/adding_data_2.gif&quot; alt=&quot;Screenshot of editing the top 200 rows of a table in SSMS&quot; width=&quot;440&quot; height=&quot;124&quot; /&gt; &lt;/li&gt;&lt;/ol&gt;  &lt;h2&gt;Disadvantages of Entering Data Directly to your Table&lt;/h2&gt; &lt;p&gt;The above method is fine if you only have a small amount of data to enter or update. If you have a lot of data to enter, this could become very tedious. Also, if you have multiple environments (for example, a development environment, staging environment, and production environment), with duplicate databases configured in each environment, you will need to re-enter the same data into each environment.&lt;/p&gt; &lt;p&gt;When you&#39;re first learning SQL Server, this may not be a major concern. However, in an environment such as described, entering data directly into the table becomes quite inefficient.&lt;/p&gt;  &lt;h2&gt;A Better Method - SQL Scripts&lt;/h2&gt; &lt;p&gt;In most cases, you will probably find it more efficient to write a &lt;i&gt;SQL script&lt;/i&gt;. Using a script enables you to re-enter the data as many times as you like. If you need to rebuild your database for any reason, you can simply run your script to enter the data. If you have multiple environments, once again you can run your script against each environment.&lt;/p&gt; &lt;p&gt;Once you get used to writing and running scripts, you will probably find it quicker than entering data directly into the table.&lt;/p&gt;  &lt;h2&gt;Database Driven Websites&lt;/h2&gt; &lt;p&gt;When you create a database driven website, you actually write SQL scripts to insert data into the database. You also use SQL scripts to read data, update data, and delete data. These SQL scripts can be placed directly into your website code (PHP, ColdFusion etc), or they can be stored in the database as &lt;i&gt;Stored Procedures&lt;/i&gt; or &lt;i&gt;Views&lt;/i&gt;.&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;h3 class=&quot;post-title entry-title&quot;&gt; SQL Server &lt;/h3&gt; &lt;div class=&quot;post-header&quot;&gt;  &lt;/div&gt;  &lt;ol style=&quot;font-weight: bold;&quot;&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/about-sql-server.html&quot;&gt;About SQL Server&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-editions.html&quot;&gt;SQL Server Editions&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-management-studio.html&quot;&gt;SQL Server - Management Studio&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-database.html&quot;&gt;SQL Server - Create a Database&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-table.html&quot;&gt;SQL Server - Create a Table&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-adding-data.html&quot;&gt;SQL Server - Adding Data&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-query-designer.html&quot;&gt;SQL Server - Query Designer&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-views.html&quot;&gt;SQL Server Views&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-stored-procedures.html&quot;&gt;SQL Server Stored Procedures&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-user-logins.html&quot;&gt;User Logins&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-server-roles.html&quot;&gt;Server Roles&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-database-schemas.html&quot;&gt;Database Schemas&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-linked-servers.html&quot;&gt;Linked Servers&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-integration-services-ssis.html&quot;&gt;Integration Services&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-summary.html&quot;&gt;Summary&lt;/a&gt;&lt;/li&gt;&lt;/ol&gt;</content><link rel='replies' type='application/atom+xml' href='http://mycomputersciences.blogspot.com/feeds/8903154652502539977/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/sql-server-adding-data.html#comment-form' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/8903154652502539977'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/8903154652502539977'/><link rel='alternate' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/sql-server-adding-data.html' title='SQL Server - Adding Data'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6070680432155434668.post-3347243308638890086</id><published>2011-06-24T12:37:00.003+05:00</published><updated>2011-06-24T14:15:12.094+05:00</updated><title type='text'>SQL Server - Create a Table</title><content type='html'>&lt;p&gt;This lesson demonstrates how to create a table in a SQL Server database using SQL Server Management Studio (SSMS).&lt;/p&gt;  &lt;ol&gt;&lt;li&gt;Ensuring you have the right database expanded, right click on the &quot;Tables&quot; icon and select &quot;New Table...&quot;:&lt;br /&gt;&lt;img src=&quot;http://www.quackit.com/pix/sql_server/sql_server_2008/tutorial/create_a_table_1.gif&quot; alt=&quot;Creating a table in SQL Server - step 1&quot; width=&quot;442&quot; height=&quot;446&quot; /&gt; &lt;/li&gt;&lt;li&gt;While you have this screen open, do the following:  &lt;ol type=&quot;a&quot;&gt;&lt;li&gt;Using the values in the screenshot, complete the details in the &quot;Column Name&quot; column, the &quot;Data Type&quot; column, &quot;Length&quot; column, and &quot;Allow Nulls&quot; column.&lt;/li&gt;&lt;li&gt;Make the IndividualId column an &quot;identity column&quot;, by setting &quot;Is Identity&quot; to &quot;Yes&quot; (this option is under the &quot;Identity Specification&quot; section in the bottom pane). Note that to set values in the bottom pane, you need to select the column name in the top pane first). This column is going to be an auto-number column - it will contain an incrementing number for each record that is created.&lt;/li&gt;&lt;li&gt;Set the &quot;Default Value&quot; of the DateCreated column to &lt;i&gt;(getdate())&lt;/i&gt;. (This will automatically insert the current date into that field for each new record).&lt;/li&gt;&lt;/ol&gt; &lt;img src=&quot;http://www.quackit.com/pix/sql_server/sql_server_2008/tutorial/create_a_table_2.gif&quot; alt=&quot;Creating a table in SQL Server - step 2&quot; width=&quot;489&quot; height=&quot;489&quot; /&gt; &lt;p&gt;What we are doing at this stage, is creating the column names, specifying the type of data that can be entered into them, and setting default values. Restricting the data type for each column is very important and helps maintain data integrity. For example, it can prevent us from accidentally entering an email address into a field for storing the current date.&lt;/p&gt;  &lt;/li&gt;&lt;li&gt;Save the table by selecting &lt;i&gt;File &amp;gt; Save Table_1&lt;/i&gt;:&lt;br /&gt;&lt;img src=&quot;http://www.quackit.com/pix/sql_server/sql_server_2008/tutorial/create_a_table_3a.gif&quot; alt=&quot;Save table as...&quot; width=&quot;198&quot; height=&quot;311&quot; /&gt;&lt;/li&gt;&lt;li&gt;When prompted, name your table:&lt;br /&gt;&lt;img src=&quot;http://www.quackit.com/pix/sql_server/sql_server_2008/tutorial/create_a_table_3b.gif&quot; alt=&quot;Creating a table in SQL Server - step 3&quot; width=&quot;333&quot; height=&quot;124&quot; /&gt; &lt;/li&gt;&lt;/ol&gt;  &lt;h2&gt;Your New Table&lt;/h2&gt; &lt;p&gt;Now that you&#39;ve created a new table, it will appear under your database in the &quot;Tables&quot; section. &lt;/p&gt; &lt;img src=&quot;http://www.quackit.com/pix/sql_server/sql_server_2008/tutorial/create_a_table_4.gif&quot; alt=&quot;Viewing the contents of your table&quot; width=&quot;248&quot; height=&quot;489&quot; /&gt;&lt;br /&gt;&lt;br /&gt;&lt;h3 class=&quot;post-title entry-title&quot;&gt; SQL Server &lt;/h3&gt; &lt;div class=&quot;post-header&quot;&gt;  &lt;/div&gt;  &lt;ol style=&quot;font-weight: bold;&quot;&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/about-sql-server.html&quot;&gt;About SQL Server&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-editions.html&quot;&gt;SQL Server Editions&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-management-studio.html&quot;&gt;SQL Server - Management Studio&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-database.html&quot;&gt;SQL Server - Create a Database&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-table.html&quot;&gt;SQL Server - Create a Table&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-adding-data.html&quot;&gt;SQL Server - Adding Data&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-query-designer.html&quot;&gt;SQL Server - Query Designer&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-views.html&quot;&gt;SQL Server Views&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-stored-procedures.html&quot;&gt;SQL Server Stored Procedures&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-user-logins.html&quot;&gt;User Logins&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-server-roles.html&quot;&gt;Server Roles&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-database-schemas.html&quot;&gt;Database Schemas&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-linked-servers.html&quot;&gt;Linked Servers&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-integration-services-ssis.html&quot;&gt;Integration Services&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-summary.html&quot;&gt;Summary&lt;/a&gt;&lt;/li&gt;&lt;/ol&gt;&lt;br /&gt;&lt;p&gt; &lt;/p&gt;</content><link rel='replies' type='application/atom+xml' href='http://mycomputersciences.blogspot.com/feeds/3347243308638890086/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/sql-server-create-table.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/3347243308638890086'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/3347243308638890086'/><link rel='alternate' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/sql-server-create-table.html' title='SQL Server - Create a Table'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6070680432155434668.post-2302886323921234106</id><published>2011-06-24T12:33:00.002+05:00</published><updated>2011-06-24T14:15:35.310+05:00</updated><title type='text'>SQL Server - Create a Database</title><content type='html'>&lt;h2 style=&quot;font-weight: normal;&quot;&gt;&lt;span style=&quot;font-size:85%;&quot;&gt;One of the first things we should look at with SQL Server/Management Studio is how to create a database. After all, most of the tasks you perform with SQL Server will evolve around one or more databases.&lt;/span&gt;&lt;/h2&gt;&lt;h2&gt;System Databases&lt;/h2&gt; &lt;p&gt;If you&#39;ve only just installed SQL Server, you might notice that some databases have already been created. These are system databases.&lt;/p&gt;  &lt;table class=&quot;tabular&quot; cellspacing=&quot;0&quot;&gt; &lt;tbody&gt;&lt;tr&gt;&lt;th&gt;Database&lt;/th&gt;&lt;th&gt;Type&lt;/th&gt;&lt;th&gt;Description&lt;/th&gt;&lt;/tr&gt; &lt;tr&gt;&lt;td&gt;master&lt;/td&gt;&lt;td&gt;System database&lt;/td&gt;&lt;td&gt;Stores system level information such as user accounts, configuration settings, and info on all other databases.&lt;/td&gt;&lt;/tr&gt; &lt;tr&gt;&lt;td&gt;model&lt;/td&gt;&lt;td&gt;System database&lt;/td&gt;&lt;td&gt;This database is used as a template for all other databases that are created.&lt;/td&gt;&lt;/tr&gt; &lt;tr&gt;&lt;td&gt;msdb&lt;/td&gt;&lt;td&gt;System database&lt;/td&gt;&lt;td&gt;Used by the SQL Server Agent for configuring alerts and scheduled jobs etc&lt;/td&gt;&lt;/tr&gt; &lt;tr&gt;&lt;td&gt;tempdb&lt;/td&gt;&lt;td&gt;System database&lt;/td&gt;&lt;td&gt;Holds all temporary tables, temporary stored procedures, and any other temporary storage requirements generated by SQL Server.&lt;/td&gt;&lt;/tr&gt; &lt;/tbody&gt;&lt;/table&gt; &lt;p&gt;We will now create another database for our own use.&lt;/p&gt;  &lt;h2&gt;Creating a New Database&lt;/h2&gt; &lt;p&gt;The following steps demonstrate how to create a database in SQL Server using SQL Server Management Studio.&lt;/p&gt; &lt;ol&gt;&lt;li&gt;Right click on the &quot;Databases&quot; icon and select &quot;New Database...&quot;:&lt;br /&gt;&lt;img src=&quot;http://www.quackit.com/pix/sql_server/sql_server_2008/tutorial/create_a_database_1.gif&quot; alt=&quot;Creating a new database in SQL Server - step 1&quot; width=&quot;472&quot; height=&quot;463&quot; /&gt; &lt;/li&gt;&lt;li&gt;Name your database and click &quot;OK&quot;:&lt;br /&gt;&lt;img src=&quot;http://www.quackit.com/pix/sql_server/sql_server_2008/tutorial/create_a_database_2.gif&quot; alt=&quot;Creating a new database in SQL Server - step 2&quot; width=&quot;480&quot; height=&quot;431&quot; /&gt; &lt;/li&gt;&lt;/ol&gt;  &lt;h2&gt;Your New Database&lt;/h2&gt; &lt;p&gt;You will now notice your new database appears under the &quot;Databases&quot; section of SQL Server Management Studio.&lt;/p&gt; &lt;p&gt;Your new database is based on the &quot;Model&quot; database. The Model database is a system database which is used as a template whenever a new database is created. If you use the left pane to navigate to your database and expand the tree, you will notice that your database already contains a number of objects. For example, it already contains system functions, system views, system stored procedures, and (hidden) system tables. These are system objects which provide information about the database.&lt;/p&gt;  &lt;img src=&quot;http://www.quackit.com/pix/sql_server/sql_server_2008/tutorial/create_a_database_3.gif&quot; alt=&quot;Creating a new database in SQL Server - step 3&quot; width=&quot;464&quot; height=&quot;458&quot; /&gt;  &lt;h2&gt;Other Options&lt;/h2&gt; &lt;p&gt;We have just created a database using the default options. When we created the database, a &quot;Data File&quot; and a &quot;Transaction Log&quot; were created. They were created in the default location for our server.&lt;/p&gt; &lt;p&gt;If we&#39;d wanted to, we could have specified a different location for these files. We also could have changed specifications on whether to allow the file to grow automatically (as it stores more and more data), and if so, how that growth should be managed. We could have done that at step 2. But all is not lost. We can still do it now that we&#39;ve created the database. We can do it via the Properties dialog box.&lt;/p&gt; &lt;p&gt;To view or change the database properties, simply right click on the database and select &quot;Properties&quot;:&lt;/p&gt; &lt;img src=&quot;http://www.quackit.com/pix/sql_server/sql_server_2008/tutorial/create_a_database_4.gif&quot; alt=&quot;Creating a new database in SQL Server - step 4&quot; width=&quot;365&quot; height=&quot;486&quot; /&gt; &lt;p&gt;The Properties dialog contains a large number of options for changing the configuration of your database. For now, we can leave everything at its default setting.&lt;/p&gt; &lt;img src=&quot;http://www.quackit.com/pix/sql_server/sql_server_2008/tutorial/create_a_database_5.gif&quot; alt=&quot;Creating a new database in SQL Server - step 5&quot; width=&quot;480&quot; height=&quot;431&quot; /&gt;&lt;br /&gt;&lt;br /&gt;&lt;h3 class=&quot;post-title entry-title&quot;&gt; SQL Server &lt;/h3&gt; &lt;div class=&quot;post-header&quot;&gt;  &lt;/div&gt;  &lt;ol style=&quot;font-weight: bold;&quot;&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/about-sql-server.html&quot;&gt;About SQL Server&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-editions.html&quot;&gt;SQL Server Editions&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-management-studio.html&quot;&gt;SQL Server - Management Studio&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-database.html&quot;&gt;SQL Server - Create a Database&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-table.html&quot;&gt;SQL Server - Create a Table&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-adding-data.html&quot;&gt;SQL Server - Adding Data&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-query-designer.html&quot;&gt;SQL Server - Query Designer&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-views.html&quot;&gt;SQL Server Views&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-stored-procedures.html&quot;&gt;SQL Server Stored Procedures&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-user-logins.html&quot;&gt;User Logins&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-server-roles.html&quot;&gt;Server Roles&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-database-schemas.html&quot;&gt;Database Schemas&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-linked-servers.html&quot;&gt;Linked Servers&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-integration-services-ssis.html&quot;&gt;Integration Services&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-summary.html&quot;&gt;Summary&lt;/a&gt;&lt;/li&gt;&lt;/ol&gt;&lt;br /&gt;  &lt;p&gt; &lt;/p&gt;</content><link rel='replies' type='application/atom+xml' href='http://mycomputersciences.blogspot.com/feeds/2302886323921234106/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/sql-server-create-database.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/2302886323921234106'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/2302886323921234106'/><link rel='alternate' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/sql-server-create-database.html' title='SQL Server - Create a Database'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6070680432155434668.post-2391117342568315055</id><published>2011-06-24T12:32:00.001+05:00</published><updated>2011-06-24T14:15:56.530+05:00</updated><title type='text'>SQL Server - Management Studio</title><content type='html'>&lt;h1&gt;SQL Server Management Studio (SSMS)&lt;/h1&gt;&lt;br /&gt;&lt;p&gt;SQL Server Management Studio (SSMS) is the main administration console for SQL Server. &lt;/p&gt; &lt;p&gt;SSMS enables you to create database objects (such as databases, tables, views etc), view the data within your database, you can configure user accounts, transfer data between databases, and more.&lt;/p&gt; &lt;p&gt;Here&#39;s what SQL Server Management Studio looks like when you first open it up:&lt;/p&gt; &lt;img src=&quot;http://www.quackit.com/pix/sql_server/sql_server_2008/tutorial/sql_server_management_studio.gif&quot; alt=&quot;Screenshot of SQL Server Management Studio&quot; width=&quot;467&quot; height=&quot;458&quot; /&gt; &lt;p&gt;The left pane contains the Object Explorer. The Object Explorer provides navigation to databases, server objects (such as triggers), log files, and more.&lt;/p&gt;  &lt;p&gt;The right pane allows you to write queries against the database and view the results. In this screenshot I have opened a blank query by clicking the &quot;New Query&quot; button. You can also bring up other windows, such as the Properties window. &lt;/p&gt; &lt;p&gt;Note that I have minimized the size of the window for this screenshot. Once maximized, you have much more room to play with.&lt;/p&gt;   &lt;p&gt;You can use SQL Server Management Studio to create as many databases as you like. You can also connect to as many databases on as many servers as you like. &lt;/p&gt; &lt;p&gt;Most of the tasks performed with SQL Server Management Studio are initiated either from the top menu, or by right-clicking on an icon/object.&lt;/p&gt; &lt;p&gt;Throughout most of this tutorial, we&#39;ll be looking at the various things you can do via SQL Server Management Studio.&lt;/p&gt;&lt;br /&gt;&lt;h3 class=&quot;post-title entry-title&quot;&gt; SQL Server &lt;/h3&gt; &lt;div class=&quot;post-header&quot;&gt;  &lt;/div&gt;  &lt;ol style=&quot;font-weight: bold;&quot;&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/about-sql-server.html&quot;&gt;About SQL Server&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-editions.html&quot;&gt;SQL Server Editions&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-management-studio.html&quot;&gt;SQL Server - Management Studio&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-database.html&quot;&gt;SQL Server - Create a Database&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-table.html&quot;&gt;SQL Server - Create a Table&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-adding-data.html&quot;&gt;SQL Server - Adding Data&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-query-designer.html&quot;&gt;SQL Server - Query Designer&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-views.html&quot;&gt;SQL Server Views&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-stored-procedures.html&quot;&gt;SQL Server Stored Procedures&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-user-logins.html&quot;&gt;User Logins&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-server-roles.html&quot;&gt;Server Roles&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-database-schemas.html&quot;&gt;Database Schemas&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-linked-servers.html&quot;&gt;Linked Servers&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-integration-services-ssis.html&quot;&gt;Integration Services&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-summary.html&quot;&gt;Summary&lt;/a&gt;&lt;/li&gt;&lt;/ol&gt;</content><link rel='replies' type='application/atom+xml' href='http://mycomputersciences.blogspot.com/feeds/2391117342568315055/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/sql-server-management-studio.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/2391117342568315055'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/2391117342568315055'/><link rel='alternate' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/sql-server-management-studio.html' title='SQL Server - Management Studio'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6070680432155434668.post-5493719436536501252</id><published>2011-06-24T12:29:00.003+05:00</published><updated>2011-06-24T14:16:18.877+05:00</updated><title type='text'>SQL Server Editions</title><content type='html'>&lt;p&gt;If you are serious about installing (or upgrading) SQL Server, this page provides a quick overview of your options.&lt;/p&gt; &lt;p&gt;SQL Server 2008 comes in many different editions. The edition you choose will depend on your requirements. If you are looking for a free database management system, you will need to choose one of the &lt;i&gt;Express&lt;/i&gt; editions or the &lt;i&gt;Compact&lt;/i&gt; edition. You could also try the &lt;i&gt;Evaluation&lt;/i&gt; edition, which allows you to trial SQL Server 2008 for 180 days.&lt;/p&gt;  &lt;h2&gt;The Editions&lt;/h2&gt; &lt;p&gt;Here are the different editions available for SQL Server 2008.&lt;/p&gt; &lt;ul&gt;&lt;li&gt;&lt;b&gt;Enterprise Edition&lt;/b&gt;&lt;br /&gt;Data management and business intelligence platform providing enterprise class scalability, high availability, and security for running business-critical applications&lt;/li&gt;&lt;li&gt;&lt;b&gt;Standard Edition&lt;/b&gt;&lt;br /&gt;Data management and business intelligence platform providing ease of use and manageability for running departmental applications&lt;/li&gt;&lt;li&gt;&lt;b&gt;Workgroup Edition&lt;/b&gt;&lt;br /&gt;Data management and reporting platform providing secure, remote synchronization, and management capabilities for running branch applications&lt;/li&gt;&lt;li&gt;&lt;b&gt;Developer Edition&lt;/b&gt;&lt;br /&gt;May be installed and used by one user to design, develop, test, and demonstrate your programs on as many systems as needed&lt;/li&gt;&lt;li&gt;&lt;b&gt;Web Edition&lt;/b&gt;&lt;br /&gt;A low-TCO, scalable, and manageable database option for web hosters and end customers looking to deploy publicly facing web applications and services&lt;/li&gt;&lt;li&gt;&lt;b&gt;Express Edition&lt;/b&gt;&lt;br /&gt;A free edition of SQL Server ideal for learning and building desktop and small server applications and for redistribution by ISVs&lt;/li&gt;&lt;li&gt;&lt;b&gt;Compact Edition&lt;/b&gt;&lt;br /&gt;A free, SQL Server embedded database ideal for building stand-alone and occasionally connected applications for mobile devices, desktops, and web clients&lt;/li&gt;&lt;li&gt;&lt;b&gt;Evaluation Edition&lt;/b&gt;&lt;br /&gt;This edition may be installed for demonstration and evaluation purposes until an expiration period of 180 days.&lt;/li&gt;&lt;/ul&gt;  &lt;h2&gt;SQL Server Edition in this Tutorial&lt;/h2&gt; &lt;p&gt;The examples in this tutorial were made using the (free) Express edition of SQL Server 2008. To be more precise, it is &lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/microsoft-sql-server-2008-express-with.html&quot;&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;SQL Server 2008 Express with Advanced Services&lt;/span&gt;.&lt;/a&gt;&lt;/p&gt;  &lt;p&gt;SQL Server 2008 Express with Advanced Services includes the following features:&lt;/p&gt; &lt;ul&gt;&lt;li&gt;SQL Server database engine - create, store, update and retrieve your data&lt;/li&gt;&lt;li&gt;SQL Server Management Studio Basic - visual database management tool for creating, editing and managing databases&lt;/li&gt;&lt;li&gt;Full-text Search - powerful, high-speed engine for searching text-intensive data&lt;/li&gt;&lt;li&gt;Reporting Services - integrated report creation and design environment to create reports&lt;/li&gt;&lt;/ul&gt; &lt;p&gt;The Express edition also comes as &lt;i&gt;SQL Server 2008 Express with Tools&lt;/i&gt;, which only includes the SQL Server database engine and the SQL Server Management Studio Basic, and &lt;i&gt;SQL Server 2008 Express (Runtime Only)&lt;/i&gt; which doesn&#39;t include the SQL Server Management Studio.&lt;/p&gt;  &lt;p&gt;While the free version of SQL Server does have its limitations, it is a good start for those starting out with SQL Server.&lt;/p&gt;&lt;h3 class=&quot;post-title entry-title&quot;&gt; SQL Server &lt;/h3&gt; &lt;div class=&quot;post-header&quot;&gt;  &lt;/div&gt;  &lt;ol style=&quot;font-weight: bold;&quot;&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/about-sql-server.html&quot;&gt;About SQL Server&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-editions.html&quot;&gt;SQL Server Editions&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-management-studio.html&quot;&gt;SQL Server - Management Studio&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-database.html&quot;&gt;SQL Server - Create a Database&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-table.html&quot;&gt;SQL Server - Create a Table&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-adding-data.html&quot;&gt;SQL Server - Adding Data&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-query-designer.html&quot;&gt;SQL Server - Query Designer&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-views.html&quot;&gt;SQL Server Views&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-stored-procedures.html&quot;&gt;SQL Server Stored Procedures&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-user-logins.html&quot;&gt;User Logins&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-server-roles.html&quot;&gt;Server Roles&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-database-schemas.html&quot;&gt;Database Schemas&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-linked-servers.html&quot;&gt;Linked Servers&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-integration-services-ssis.html&quot;&gt;Integration Services&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-summary.html&quot;&gt;Summary&lt;/a&gt;&lt;/li&gt;&lt;/ol&gt;</content><link rel='replies' type='application/atom+xml' href='http://mycomputersciences.blogspot.com/feeds/5493719436536501252/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/sql-server-editions.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/5493719436536501252'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/5493719436536501252'/><link rel='alternate' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/sql-server-editions.html' title='SQL Server Editions'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6070680432155434668.post-3024432383942369508</id><published>2011-06-24T12:23:00.003+05:00</published><updated>2011-06-24T14:16:43.326+05:00</updated><title type='text'>soft Visual Studio 2005 Service Pack 1 Update for Microsoft SQL Server 2008 Support</title><content type='html'>&lt;h1 title=&quot;item&quot; id=&quot;top&quot;&gt;soft Visual Studio 2005 Service Pack 1 Update for Microsoft SQL Server 2008 Support&lt;/h1&gt;                    &lt;h4 id=&quot;ctl00_ctl18_ColumnRepeater_ctl00_RowRepeater_ctl01_CellRepeater_ctl00_ctl01_Description&quot; class=&quot;description&quot;&gt;This update enables developers to use Microsoft Visual Studio 2005 Service Pack 1 with Microsoft SQL Server 2008.&lt;/h4&gt;                 &lt;div class=&quot;qdtl&quot;&gt;            &lt;div class=&quot;qdtl-inner&quot;&gt;                &lt;h2 titleflag=&quot;item&quot; title=&quot;item&quot;&gt;Quick details&lt;/h2&gt;                &lt;div class=&quot;qdtl-info&quot; parenttitle=&quot;item&quot;&gt;                    &lt;table class=&quot;properties&quot;&gt;                        &lt;colgroup&gt;                            &lt;col class=&quot;col1&quot;&gt;                            &lt;col class=&quot;col2&quot;&gt;                            &lt;col class=&quot;col3&quot;&gt;                            &lt;col class=&quot;col4&quot;&gt;                        &lt;/colgroup&gt;                        &lt;tbody&gt;&lt;tr&gt;                                                        &lt;td class=&quot;col2&quot;&gt;&lt;span&gt;Version=8.0&lt;/span&gt;&lt;/td&gt;                            &lt;td class=&quot;col3&quot;&gt;&lt;strong&gt;Date Published:&lt;/strong&gt;&lt;/td&gt;                            &lt;td class=&quot;col4&quot;&gt;&lt;span&gt;11/5/2008&lt;/span&gt;&lt;/td&gt;                        &lt;/tr&gt;                        &lt;tr&gt;                                                                                    &lt;td class=&quot;col234&quot; colspan=&quot;3&quot; parenttitle=&quot;item&quot;&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;:English&lt;/span&gt;&lt;br /&gt;&lt;/td&gt;                                                    &lt;/tr&gt;                    &lt;/tbody&gt;&lt;/table&gt;                &lt;/div&gt;                                  &lt;div class=&quot;qdtl-articles&quot; parenttitle=&quot;item&quot;&gt;                    &lt;table class=&quot;articles&quot;&gt;                        &lt;colgroup&gt;                            &lt;col class=&quot;col1&quot;&gt;                            &lt;col class=&quot;col234&quot;&gt;                        &lt;/colgroup&gt;                                                &lt;tbody&gt;&lt;tr&gt;                            &lt;td class=&quot;col1&quot; titleflag=&quot;item&quot; title=&quot;item&quot;&gt;&lt;strong&gt;KB Articles:&lt;/strong&gt;&lt;/td&gt;                            &lt;td style=&quot;font-weight: bold;&quot; class=&quot;col234&quot; parenttitle=&quot;item&quot;&gt;KB954961&lt;/td&gt;                        &lt;/tr&gt;                                            &lt;/tbody&gt;&lt;/table&gt;                &lt;/div&gt;                                     &lt;table class=&quot;files&quot;&gt;                    &lt;colgroup&gt;                        &lt;col class=&quot;file-name&quot;&gt;                        &lt;col class=&quot;size&quot;&gt;                        &lt;col class=&quot;download&quot;&gt;                    &lt;/colgroup&gt;                    &lt;tbody&gt;&lt;tr&gt;                        &lt;th&gt;File Name&lt;/th&gt;                        &lt;th&gt;Size&lt;/th&gt;                        &lt;th&gt;&lt;br /&gt;&lt;/th&gt;                    &lt;/tr&gt;                                                                   &lt;tr&gt;                        &lt;td class=&quot;file-name&quot; titleflag=&quot;item&quot; title=&quot;item&quot;&gt;&lt;span&gt;VS80sp1-KB954961-X86-INTL.exe&lt;/span&gt;&lt;/td&gt;                        &lt;td class=&quot;size&quot;&gt;&lt;span&gt;12.0 MB&lt;/span&gt;&lt;/td&gt;                        &lt;td class=&quot;download&quot; parenttitle=&quot;item&quot;&gt;                            &lt;a class=&quot;download&quot; href=&quot;http://www.microsoft.com/download/en/confirmation.aspx?id=15680&quot; fileurl=&quot;http://download.microsoft.com/download/4/6/3/463f3ed1-1483-4300-a4a3-2954a1cff869/VS80sp1-KB954961-X86-INTL.exe&quot; track=&quot;false&quot;&gt;&lt;span&gt;Download&lt;/span&gt;&lt;/a&gt;                        &lt;/td&gt;                    &lt;/tr&gt;                                    &lt;/tbody&gt;&lt;/table&gt;                      &lt;div class=&quot;feature-items&quot; parenttitle=&quot;item&quot;&gt;                                    &lt;/div&gt;            &lt;/div&gt;        &lt;/div&gt;                            &lt;h2 id=&quot;overview&quot; titleflag=&quot;item1&quot; title=&quot;item1&quot;&gt;Overview&lt;/h2&gt;            &lt;p&gt;This update resolves the following error that when you try to use Microsoft Visual Studio 2005 Service Pack 1 design tools to open a database connection to Microsoft SQL Server 2008 :&lt;br /&gt;&lt;br /&gt;“This server version is not supported. Only servers up to Microsoft SQL Server 2005 are supported.”&lt;br /&gt;&lt;br /&gt;This update addresses this issue and enables the following Visual Studio functionality for SQL Server 2008:&lt;br /&gt;&lt;/p&gt;&lt;ul&gt;&lt;li&gt;Server Explorer successfully connects to SQL Server 2008, and database objects such as stored procedures and table data can be viewed and edited. Note that table schemas cannot be viewed or edited in this release.&lt;/li&gt;&lt;li&gt;SQL CLR projects that target SQL Server 2008 can be created and deployed to the server. &lt;/li&gt;&lt;li&gt;T-SQL and SQL CLR debugging are now enabled for SQL Server 2008.&lt;/li&gt;&lt;li&gt;Data binding features in Client and Web Projects are enabled. &lt;/li&gt;&lt;/ul&gt;&lt;br /&gt;This update does not support the following features for SQL Server 2008:&lt;br /&gt;&lt;ul&gt;&lt;li&gt;Creating and editing table schemas in Table Designer or Database Diagrams. As a workaround you may use the table designer feature in SQL Server Management Studio 2008 to edit table schemas in SQL Server 2008. &lt;/li&gt;&lt;/ul&gt;            &lt;a href=&quot;http://www.microsoft.com/download/en/details.aspx?displaylang=en&amp;amp;id=15680#top&quot; class=&quot;to-top&quot; parenttitle=&quot;item1&quot;&gt;&lt;span&gt;&lt;br /&gt;&lt;/span&gt;&lt;/a&gt;                    &lt;h2 id=&quot;system-requirements&quot; titleflag=&quot;item2&quot; title=&quot;item2&quot;&gt;System requirements&lt;/h2&gt;                            &lt;p&gt;&lt;strong&gt;Supported Operating Systems:&lt;/strong&gt; Windows 2000 Service Pack 4, Windows Server 2003 R2 (32-Bit x86), Windows Server 2003 R2 x64 editions, Windows Server 2003 Service Pack 1, Windows Server 2003 Service Pack 2, Windows Server 2003 x64 editions, Windows Vista, Windows XP Professional x64 Edition , Windows XP Service Pack 2&lt;/p&gt;                            &lt;p&gt;&lt;br /&gt;&lt;/p&gt;                        &lt;a href=&quot;http://www.microsoft.com/download/en/details.aspx?displaylang=en&amp;amp;id=15680#top&quot; class=&quot;to-top&quot; parenttitle=&quot;item2&quot;&gt;&lt;span&gt;&lt;/span&gt;&lt;/a&gt;                    &lt;h2 id=&quot;instructions&quot; titleflag=&quot;item3&quot; title=&quot;item3&quot;&gt;Instructions&lt;/h2&gt;            &lt;ol&gt;&lt;li&gt;Click the &lt;b&gt;Download&lt;/b&gt; button on this page to start the download, or select a different language from the &lt;b&gt;Change language&lt;/b&gt; drop-down list and click &lt;b&gt;Change&lt;/b&gt;.&lt;/li&gt;&lt;li&gt;Do one of the following:&lt;/li&gt;&lt;ul&gt;&lt;li&gt;To start the installation immediately, click &lt;b&gt;Run&lt;/b&gt;.&lt;/li&gt;&lt;li&gt;To save the download to your computer for installation at a later time, click &lt;b&gt;Save&lt;/b&gt;.&lt;/li&gt;&lt;li&gt;To cancel the installation, click &lt;b&gt;Cancel&lt;/b&gt;.&lt;/li&gt;&lt;/ul&gt;&lt;/ol&gt;&lt;br /&gt;&lt;h3 class=&quot;post-title entry-title&quot;&gt; SQL Server &lt;/h3&gt; &lt;div class=&quot;post-header&quot;&gt;  &lt;/div&gt;  &lt;ol style=&quot;font-weight: bold;&quot;&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/about-sql-server.html&quot;&gt;About SQL Server&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-editions.html&quot;&gt;SQL Server Editions&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-management-studio.html&quot;&gt;SQL Server - Management Studio&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-database.html&quot;&gt;SQL Server - Create a Database&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-table.html&quot;&gt;SQL Server - Create a Table&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-adding-data.html&quot;&gt;SQL Server - Adding Data&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-query-designer.html&quot;&gt;SQL Server - Query Designer&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-views.html&quot;&gt;SQL Server Views&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-stored-procedures.html&quot;&gt;SQL Server Stored Procedures&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-user-logins.html&quot;&gt;User Logins&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-server-roles.html&quot;&gt;Server Roles&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-database-schemas.html&quot;&gt;Database Schemas&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-linked-servers.html&quot;&gt;Linked Servers&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-integration-services-ssis.html&quot;&gt;Integration Services&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-summary.html&quot;&gt;Summary&lt;/a&gt;&lt;/li&gt;&lt;/ol&gt;</content><link rel='replies' type='application/atom+xml' href='http://mycomputersciences.blogspot.com/feeds/3024432383942369508/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/soft-visual-studio-2005-service-pack-1.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/3024432383942369508'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/3024432383942369508'/><link rel='alternate' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/soft-visual-studio-2005-service-pack-1.html' title='soft Visual Studio 2005 Service Pack 1 Update for Microsoft SQL Server 2008 Support'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6070680432155434668.post-759417591462192942</id><published>2011-06-24T12:14:00.004+05:00</published><updated>2011-06-24T14:17:09.227+05:00</updated><title type='text'>Microsoft® SQL Server® 2008 Express with Advanced Services</title><content type='html'>&lt;div rowheight=&quot;0&quot; id=&quot;ctl00_ctl18_ColumnRepeater_ctl00_RowRepeater_ctl00_Row&quot; class=&quot;hpGrd_Row hpGrd_RowNoMargin&quot; gridindex=&quot;0&quot; gridtype=&quot;row&quot;&gt;                                                                                &lt;/div&gt;                                                                                                                                                    &lt;div style=&quot;display: none; visibility: hidden;&quot;&gt;    &lt;object classid=&quot;clsid:17492023-C23A-453E-A040-C7C580BBF700&quot; id=&quot;LegitCheck&quot; codebase=&quot;#version=1,9,0042,0&quot; viewastext=&quot;&quot;&gt;&lt;/object&gt;&lt;/div&gt;&lt;input id=&quot;gaflag&quot; name=&quot;gaflag&quot; value=&quot;&quot; type=&quot;hidden&quot;&gt;&lt;input id=&quot;blobhash&quot; name=&quot;blobhash&quot; value=&quot;&quot; type=&quot;hidden&quot;&gt;&lt;script type=&quot;text/javascript&quot;&gt;    var g_DateCode = &#39;6db0ad0c-2567-0081-13f8-654789bbbb28&#39;;    var g_IEValidationPage = &#39;genuine-validation.aspx&#39;;    var g_ExeValidationPage = &#39;exe-validation.aspx&#39;;    var g_autocheck = false;        function isIE() {        return $.browser.msie;    }    function submitBlob() {        var blob = getBlob();        if (blob != null) {            var elm = document.getElementById(&#39;blobhash&#39;);            elm.value = blob;            var frm = document.getElementById(&#39;aspnetForm&#39;);            var flag = document.getElementById(&#39;gaflag&#39;);            flag.value = &#39;true&#39;;            frm.submit();            return true;        }        return false;    }    function DoWGA(pid) {          if (!submitBlob()) {            return goToValidationPage(pid);        }        return false;    }    function getBlob() {        if (isIE()) {            try {                var LegitCheck = document.getElementById(&#39;LegitCheck&#39;);                LegitCheck.HashCode = g_DateCode;                return LegitCheck.GetBlob(g_DateCode);            }            catch (e) {                return null;            }        }    }    function goToValidationPage(pid){        var frm = $(&#39;#aspnetForm&#39;);        frm.submit(function(e) {            stopEvent(e);        });                if(isIE()){            window.location.href = g_IEValidationPage + &quot;?id=&quot; + pid;        }        else{            window.location.href = g_ExeValidationPage + &quot;?id=&quot; + pid;        }        return false;    }    function stopEvent(e) {        if (e.stopPropagation) e.stopPropagation();        else e.cancelBubble = true;                if (e.preventDefault) e.preventDefault();        else e.returnValue = false;    }    &lt;/script&gt;&lt;script type=&quot;text/javascript&quot;&gt;    $().ready(function () {        if (g_autocheck) {            if (isIE()) {                submitBlob();            }            else {                goToValidationPage(&#39;1842&#39;);            }        }    });&lt;/script&gt;        &lt;div class=&quot;details-nav&quot;&gt;&lt;h1 title=&quot;item&quot; id=&quot;top&quot;&gt;Microsoft® SQL Server® 2008 Express with Advanced Services&lt;/h1&gt;&lt;/div&gt;            &lt;h4 id=&quot;ctl00_ctl18_ColumnRepeater_ctl00_RowRepeater_ctl01_CellRepeater_ctl00_ctl01_Description&quot; class=&quot;description&quot;&gt;Microsoft SQL Server 2008 Express with Advanced Services is a free, easy-to use version of the SQL Server Express data platform. This edition includes an advanced graphical management tool and powerful reporting features to make it easier than ever to start developing powerful data-driven applications for the Web or local desktop.&lt;/h4&gt;                 &lt;div class=&quot;qdtl&quot;&gt;            &lt;div class=&quot;qdtl-inner&quot;&gt;                &lt;h4&gt;Files in this download&lt;/h4&gt;                &lt;p&gt;The links in this section correspond to files available for this download. Download the files appropriate for you.&lt;/p&gt;                                     &lt;table class=&quot;files&quot;&gt;                    &lt;colgroup&gt;                        &lt;col class=&quot;file-name&quot;&gt;                        &lt;col class=&quot;size&quot;&gt;                        &lt;col class=&quot;download&quot;&gt;                    &lt;/colgroup&gt;                    &lt;tbody&gt;&lt;tr&gt;                        &lt;th&gt;File Name&lt;/th&gt;                        &lt;th&gt;Size&lt;/th&gt;                        &lt;th&gt;&lt;br /&gt;&lt;/th&gt;                    &lt;/tr&gt;                                                                   &lt;tr&gt;                        &lt;td class=&quot;file-name&quot; titleflag=&quot;item&quot; title=&quot;item&quot;&gt;&lt;span&gt;SQLEXPRADV_x86_ENU.exe&lt;/span&gt;&lt;/td&gt;                        &lt;td class=&quot;size&quot;&gt;&lt;span&gt;502.0 MB&lt;/span&gt;&lt;/td&gt;                        &lt;td class=&quot;download&quot; parenttitle=&quot;item&quot;&gt;                            &lt;a class=&quot;download&quot; href=&quot;http://www.microsoft.com/downloads/info.aspx?na=41&amp;amp;srcfamilyid=b5d1b8c3-fda5-4508-b0d0-1311d670e336&amp;amp;srcdisplaylang=en&amp;amp;u=http%3a%2f%2fdownload.microsoft.com%2fdownload%2fe%2f9%2fb%2fe9bcf5d7-2421-464f-94dc-0c694ba1b5a4%2fSQLEXPRADV_x86_ENU.exe&quot; index=&quot;0&quot; fileurl=&quot;http://download.microsoft.com/download/e/9/b/e9bcf5d7-2421-464f-94dc-0c694ba1b5a4/SQLEXPRADV_x86_ENU.exe&quot; track=&quot;false&quot;&gt;&lt;span&gt;Download&lt;/span&gt;&lt;/a&gt;                        &lt;/td&gt;                    &lt;/tr&gt;                                        &lt;tr&gt;                        &lt;td class=&quot;file-name&quot; titleflag=&quot;item&quot; title=&quot;item&quot;&gt;&lt;span&gt;SQLEXPRADV_x64_ENU.exe&lt;/span&gt;&lt;/td&gt;                        &lt;td class=&quot;size&quot;&gt;&lt;span&gt;546.0 MB&lt;/span&gt;&lt;/td&gt;                        &lt;td class=&quot;download&quot; parenttitle=&quot;item&quot;&gt;                                                        &lt;a class=&quot;download&quot; href=&quot;http://www.microsoft.com/downloads/info.aspx?na=41&amp;amp;srcfamilyid=b5d1b8c3-fda5-4508-b0d0-1311d670e336&amp;amp;srcdisplaylang=en&amp;amp;u=http%3a%2f%2fdownload.microsoft.com%2fdownload%2fe%2f9%2fb%2fe9bcf5d7-2421-464f-94dc-0c694ba1b5a4%2fSQLEXPRADV_x64_ENU.exe&quot; index=&quot;1&quot; fileurl=&quot;http://download.microsoft.com/download/e/9/b/e9bcf5d7-2421-464f-94dc-0c694ba1b5a4/SQLEXPRADV_x64_ENU.exe&quot; track=&quot;false&quot;&gt;&lt;span&gt;Download&lt;/span&gt;&lt;/a&gt;                                                    &lt;/td&gt;                    &lt;/tr&gt;                                    &lt;/tbody&gt;&lt;/table&gt;                      &lt;div class=&quot;feature-items&quot; parenttitle=&quot;item&quot;&gt;                                    &lt;/div&gt;            &lt;/div&gt;        &lt;/div&gt;                            &lt;h2 id=&quot;overview&quot; titleflag=&quot;item1&quot; title=&quot;item1&quot;&gt;Overview&lt;/h2&gt;            &lt;p&gt;Microsoft SQL Server 2008 Express with Advanced Services is a free, easy-to-use version of the SQL Server Express data platform that includes an advanced graphical management tool and powerful features for reporting and advanced text-based searches. This edition provides powerful and reliable data management tools and rich features, data protection, and fast performance. It is ideal for small server applications and local data stores.&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;Free to download, free to deploy, and free to redistribute as an embedded part of an application, SQL Server 2008 Express with Advanced Services is the fast and easy way to develop and manage data-driven applications with powerful built-in reporting and full-text search functionality.&lt;br /&gt;&lt;br /&gt;For more information about SQL Server 2008 Express with Advanced Services, including other versions and downloadable components now available, see &lt;a href=&quot;http://go.microsoft.com/fwlink/?LinkID=123082&quot;&gt;Microsoft SQL Server Express&lt;/a&gt;.&lt;br /&gt;&lt;br /&gt;For information about the different editions of SQL Server 2008, see the Editions page.&lt;/p&gt;            &lt;span class=&quot;to-top&quot;&gt;&lt;span&gt;Top of page&lt;/span&gt;&lt;/span&gt;                    &lt;h2 id=&quot;system-requirements&quot; titleflag=&quot;item2&quot; title=&quot;item2&quot;&gt;System requirements&lt;/h2&gt;                            &lt;p&gt;&lt;strong&gt;Supported Operating Systems:&lt;/strong&gt; Windows Server 2003 Service Pack 2, Windows Server 2008, Windows Vista, Windows Vista Service Pack 1, Windows XP Service Pack 2, Windows XP Service Pack 3&lt;/p&gt;                            &lt;ul&gt;&lt;li&gt;32-Bit Systems: Computer with Intel or compatible 1GHz or faster processor (2 GHz or faster is recommended. Only a single processor is supported)&lt;/li&gt;&lt;li&gt;64-Bit Systems: 1.4 GHz or higher processor (2 GHz or faster is recommended. Only a single processor is supported)&lt;/li&gt;&lt;li&gt;Minimum of 512 MB of RAM (1 GB or more is recommended)&lt;/li&gt;&lt;li&gt; 1 GB of free hard disk space&lt;/li&gt;&lt;/ul&gt;&lt;br /&gt;&lt;b&gt;Note:&lt;/b&gt; There is no support in this release for Windows XP Embedded Edition.&lt;br /&gt;&lt;br /&gt;&lt;b&gt; Connecting to Visual Studio 2005 requires downloading and installing &lt;/b&gt;&lt;span style=&quot;font-weight: bold; color: rgb(51, 102, 255);&quot;&gt;Visual Studio 2005 Support for SQL Server 2008, Community Technology Preview. &lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;b&gt; Please read important information in the &lt;a href=&quot;http://go.microsoft.com/fwlink/?LinkID=120421&quot;&gt;Release Notes&lt;/a&gt; before installing SQL Server 2008 with Visual Studio 2008. &lt;/b&gt;&lt;br /&gt;&lt;br /&gt;To learn more about what is required to run SQL Server 2008 Express with Advanced Services, see the &lt;a href=&quot;http://go.microsoft.com/fwlink/?LinkID=123030&quot;&gt;system requirements&lt;/a&gt;&lt;a href=&quot;http://www.microsoft.com/download/en/details.aspx?displaylang=en&amp;amp;id=1842#top&quot; class=&quot;to-top&quot; parenttitle=&quot;item2&quot;&gt;&lt;span&gt;&lt;/span&gt;&lt;/a&gt;                    &lt;h2 id=&quot;instructions&quot; titleflag=&quot;item3&quot; title=&quot;item3&quot;&gt;Instructions&lt;/h2&gt;            &lt;p&gt;&lt;b&gt;Note: &lt;/b&gt; You must have administrative rights on the computer to install SQL Server Express.&lt;br /&gt;&lt;br /&gt;We recommended that you read the &lt;span style=&quot;font-weight: bold;&quot;&gt;Release Notes &lt;/span&gt;and Readme before installing SQL Server Express with Advance Services.&lt;br /&gt;&lt;br /&gt;&lt;b&gt;Step 1:&lt;/b&gt; Download and install &lt;a href=&quot;http://go.microsoft.com/fwlink/?LinkId=120550&quot;&gt;Microsoft .Net Framework 3.5 SP1&lt;/a&gt;.&lt;br /&gt;&lt;br /&gt;&lt;b&gt;Step 2&lt;/b&gt; Download and install &lt;a href=&quot;http://go.microsoft.com/fwlink/?LinkId=123422&quot;&gt; Windows Installer 4.5&lt;/a&gt;.&lt;br /&gt;.&lt;br /&gt;&lt;b&gt;Step 3&lt;/b&gt; Download and install &lt;a href=&quot;http://go.microsoft.com/fwlink/?LinkId=120552&quot;&gt; Windows PowerShell 1.0&lt;/a&gt;.&lt;br /&gt;&lt;br /&gt;&lt;b&gt; Note: For help on installing Windows Powershell 1.0 see the following KB articles:&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;           &lt;/p&gt;&lt;div class=&quot;details-article&quot;&gt;&lt;li&gt; &lt;a href=&quot;http://go.microsoft.com/fwlink/?LinkId=120645&quot;&gt; &lt;/a&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;926139&lt;/span&gt;: English Language PowerShell 1.0 for Windows XP ans Windows Server 2003&lt;/li&gt;&lt;br /&gt;    &lt;li&gt; &lt;a href=&quot;http://go.microsoft.com/fwlink/?LinkId=120646&quot;&gt; &lt;/a&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;926140&lt;/span&gt;: Localized PowerShell 1.0 for Windows XP and Windows Server 2003&lt;/li&gt;&lt;br /&gt;    &lt;li&gt; &lt;a href=&quot;http://go.microsoft.com/fwlink/?LinkId=120647&quot;&gt; &lt;/a&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;926141: &lt;/span&gt;Multilanguage User Interface for PowerShell 1.0 for Windows XP and Windows Server 2003&lt;/li&gt;&lt;br /&gt;  &lt;li&gt; &lt;a href=&quot;http://go.microsoft.com/fwlink/?LinkId=120648&quot;&gt; &lt;/a&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;928439&lt;/span&gt;: PowerShell 1.0 for Vista (includes all languages)&lt;/li&gt;&lt;/div&gt;&lt;br /&gt;&lt;h3 class=&quot;post-title entry-title&quot;&gt; SQL Server &lt;/h3&gt; &lt;div class=&quot;post-header&quot;&gt;  &lt;/div&gt;  &lt;ol style=&quot;font-weight: bold;&quot;&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/about-sql-server.html&quot;&gt;About SQL Server&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-editions.html&quot;&gt;SQL Server Editions&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-management-studio.html&quot;&gt;SQL Server - Management Studio&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-database.html&quot;&gt;SQL Server - Create a Database&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-table.html&quot;&gt;SQL Server - Create a Table&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-adding-data.html&quot;&gt;SQL Server - Adding Data&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-query-designer.html&quot;&gt;SQL Server - Query Designer&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-views.html&quot;&gt;SQL Server Views&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-stored-procedures.html&quot;&gt;SQL Server Stored Procedures&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-user-logins.html&quot;&gt;User Logins&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-server-roles.html&quot;&gt;Server Roles&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-database-schemas.html&quot;&gt;Database Schemas&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-linked-servers.html&quot;&gt;Linked Servers&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-integration-services-ssis.html&quot;&gt;Integration Services&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-summary.html&quot;&gt;Summary&lt;/a&gt;&lt;/li&gt;&lt;/ol&gt;</content><link rel='replies' type='application/atom+xml' href='http://mycomputersciences.blogspot.com/feeds/759417591462192942/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/microsoft-sql-server-2008-express-with.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/759417591462192942'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/759417591462192942'/><link rel='alternate' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/microsoft-sql-server-2008-express-with.html' title='Microsoft® SQL Server® 2008 Express with Advanced Services'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6070680432155434668.post-4867863005939585522</id><published>2011-06-24T12:09:00.002+05:00</published><updated>2011-06-24T14:17:34.603+05:00</updated><title type='text'>SQL Server 2008 Editions</title><content type='html'>&lt;p&gt;If you are serious about installing (or upgrading) SQL Server, this page provides a quick overview of your options.&lt;/p&gt; &lt;p&gt;SQL Server 2008 comes in many different editions. The edition you choose will depend on your requirements. If you are looking for a free database management system, you will need to choose one of the &lt;i&gt;Express&lt;/i&gt; editions or the &lt;i&gt;Compact&lt;/i&gt; edition. You could also try the &lt;i&gt;Evaluation&lt;/i&gt; edition, which allows you to trial SQL Server 2008 for 180 days.&lt;/p&gt;  &lt;h2&gt;The Editions&lt;/h2&gt; &lt;p&gt;Here are the different editions available for SQL Server 2008.&lt;/p&gt; &lt;ul&gt;&lt;li&gt;&lt;b&gt;Enterprise Edition&lt;/b&gt;&lt;br /&gt;Data management and business intelligence platform providing enterprise class scalability, high availability, and security for running business-critical applications&lt;/li&gt;&lt;li&gt;&lt;b&gt;Standard Edition&lt;/b&gt;&lt;br /&gt;Data management and business intelligence platform providing ease of use and manageability for running departmental applications&lt;/li&gt;&lt;li&gt;&lt;b&gt;Workgroup Edition&lt;/b&gt;&lt;br /&gt;Data management and reporting platform providing secure, remote synchronization, and management capabilities for running branch applications&lt;/li&gt;&lt;li&gt;&lt;b&gt;Developer Edition&lt;/b&gt;&lt;br /&gt;May be installed and used by one user to design, develop, test, and demonstrate your programs on as many systems as needed&lt;/li&gt;&lt;li&gt;&lt;b&gt;Web Edition&lt;/b&gt;&lt;br /&gt;A low-TCO, scalable, and manageable database option for web hosters and end customers looking to deploy publicly facing web applications and services&lt;/li&gt;&lt;li&gt;&lt;b&gt;Express Edition&lt;/b&gt;&lt;br /&gt;A free edition of SQL Server ideal for learning and building desktop and small server applications and for redistribution by ISVs&lt;/li&gt;&lt;li&gt;&lt;b&gt;Compact Edition&lt;/b&gt;&lt;br /&gt;A free, SQL Server embedded database ideal for building stand-alone and occasionally connected applications for mobile devices, desktops, and web clients&lt;/li&gt;&lt;li&gt;&lt;b&gt;Evaluation Edition&lt;/b&gt;&lt;br /&gt;This edition may be installed for demonstration and evaluation purposes until an expiration period of 180 days.&lt;/li&gt;&lt;/ul&gt;  &lt;h2&gt;SQL Server Edition in this Tutorial&lt;/h2&gt; &lt;p&gt;The examples in this tutorial were made using the (free) Express edition of SQL Server 2008. To be more precise, it is &lt;span style=&quot;font-weight: bold;&quot;&gt;SQL Server 2008 Express with Advanced Services&lt;/span&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;.&lt;/span&gt;&lt;/p&gt;  &lt;p&gt;SQL Server 2008 Express with Advanced Services includes the following features:&lt;/p&gt; &lt;ul&gt;&lt;li&gt;SQL Server database engine - create, store, update and retrieve your data&lt;/li&gt;&lt;li&gt;SQL Server Management Studio Basic - visual database management tool for creating, editing and managing databases&lt;/li&gt;&lt;li&gt;Full-text Search - powerful, high-speed engine for searching text-intensive data&lt;/li&gt;&lt;li&gt;Reporting Services - integrated report creation and design environment to create reports&lt;/li&gt;&lt;/ul&gt; &lt;p&gt;The Express edition also comes as &lt;i&gt;SQL Server 2008 Express with Tools&lt;/i&gt;, which only includes the SQL Server database engine and the SQL Server Management Studio Basic, and &lt;i&gt;SQL Server 2008 Express (Runtime Only)&lt;/i&gt; which doesn&#39;t include the SQL Server Management Studio.&lt;/p&gt;  &lt;p&gt;While the free version of SQL Server does have its limitations, it is a good start for those starting out with SQL Server.&lt;/p&gt; &lt;p&gt;You can&lt;span style=&quot;font-weight: bold;&quot;&gt; &lt;/span&gt;&lt;a style=&quot;font-weight: bold;&quot; href=&quot;http://www.microsoft.com/express/sql/download/&quot;&gt;download SQL Server 2008 Express&lt;/a&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt; &lt;/span&gt;from Microsoft&#39;s website.&lt;/p&gt;&lt;h3 class=&quot;post-title entry-title&quot;&gt; SQL Server &lt;/h3&gt; &lt;div class=&quot;post-header&quot;&gt;  &lt;/div&gt;  &lt;ol style=&quot;font-weight: bold;&quot;&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/about-sql-server.html&quot;&gt;About SQL Server&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-editions.html&quot;&gt;SQL Server Editions&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-management-studio.html&quot;&gt;SQL Server - Management Studio&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-database.html&quot;&gt;SQL Server - Create a Database&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-table.html&quot;&gt;SQL Server - Create a Table&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-adding-data.html&quot;&gt;SQL Server - Adding Data&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-query-designer.html&quot;&gt;SQL Server - Query Designer&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-views.html&quot;&gt;SQL Server Views&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-stored-procedures.html&quot;&gt;SQL Server Stored Procedures&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-user-logins.html&quot;&gt;User Logins&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-server-roles.html&quot;&gt;Server Roles&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-database-schemas.html&quot;&gt;Database Schemas&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-linked-servers.html&quot;&gt;Linked Servers&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-integration-services-ssis.html&quot;&gt;Integration Services&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-summary.html&quot;&gt;Summary&lt;/a&gt;&lt;/li&gt;&lt;/ol&gt;</content><link rel='replies' type='application/atom+xml' href='http://mycomputersciences.blogspot.com/feeds/4867863005939585522/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/sql-server-2008-editions.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/4867863005939585522'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/4867863005939585522'/><link rel='alternate' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/sql-server-2008-editions.html' title='SQL Server 2008 Editions'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6070680432155434668.post-1350359097785617572</id><published>2011-06-24T12:07:00.001+05:00</published><updated>2011-06-24T14:17:56.280+05:00</updated><title type='text'>Database Management Systems</title><content type='html'>&lt;p&gt;A &lt;dfn&gt;Database Management System&lt;/dfn&gt; (DBMS), is a software program that enables the creation and management of databases. Generally, these databases will be more complex than the text file/spreadsheet example in the previous lesson. In fact, most of today&#39;s database systems are referred to as a &lt;dfn&gt;Relational Database Management System (RDBMS)&lt;/dfn&gt;, because of their ability to store related data across multiple tables.&lt;/p&gt;  &lt;p&gt;Some of the more popular relational database management systems include:&lt;/p&gt; &lt;ul&gt;&lt;li&gt;Microsoft Access&lt;/li&gt;&lt;li&gt;Filemaker&lt;/li&gt;&lt;li&gt;Microsoft SQL Server&lt;/li&gt;&lt;li&gt;MySQL&lt;/li&gt;&lt;li&gt;Oracle&lt;/li&gt;&lt;/ul&gt;  &lt;p&gt;Throughout this tutorial, you will become familiar with some of the key concepts of database management systems. These include:&lt;/p&gt;  &lt;ul&gt;&lt;li&gt;Database creation&lt;/li&gt;&lt;li&gt;Tables&lt;/li&gt;&lt;li&gt;Adding data to your database&lt;/li&gt;&lt;li&gt;Querying a database&lt;/li&gt;&lt;li&gt;Relational database design&lt;/li&gt;&lt;/ul&gt;   &lt;h2&gt;What Does a Database Management System Look Like?&lt;/h2&gt; &lt;p&gt;Different database management systems look different, but generally, there are a number of common features that you&#39;ll usually see across most of them.&lt;/p&gt;  &lt;h3&gt;Microsoft Access&lt;/h3&gt; &lt;img src=&quot;http://www.quackit.com/pix/database/tutorial/relational_databases_1.gif&quot; alt=&quot;Microsoft Access Database Management System&quot; width=&quot;475&quot; height=&quot;380&quot; /&gt;  &lt;p&gt;This is the main screen you&#39;ll see when opening up Access to view an existing database. The outer part is the database management system and it&#39;s menu, the middle part is the actual database. In this example, the database is called &quot;dateSite&quot; and has 20 tables. If you were to open a different database, the name of the database would be different and you would see different tables, but the available options would be the same (i.e. Tables, Queries, Forms, Reports, Macros, Modules, Open, Design, New). &lt;/p&gt;  &lt;p&gt;Some of these options are common across all database management systems. All database systems allow you to create &lt;i&gt;tables&lt;/i&gt;, build &lt;i&gt;queries&lt;/i&gt;, design a new database, and open an existing database.&lt;/p&gt;  &lt;h3&gt;Microsoft SQL Server&lt;/h3&gt; &lt;img style=&quot;width: 503px; height: 416px;&quot; src=&quot;http://www.quackit.com/pix/database/tutorial/dbms_sql_server.gif&quot; alt=&quot;Microsoft SQL Server - Enterprise Manager&quot; /&gt; &lt;p&gt;Microsoft SQL Server is a more robust database management system than Access. While Access is better suited to home and small office use, SQL Server is more suited to enterprise applications such as corporate CRMs and websites etc.&lt;/p&gt; &lt;p&gt;The above screen is what you see when you open SQL Server through Enterprise Manager. Enterprise Manager is a built-in tool for managing SQL Server and its databases. In this example, there are 6 databases. Each database is represented down the left pane, and also in the main pane (with a &quot;database&quot; icon).&lt;/p&gt;  &lt;h2&gt;Which Database System to Use?&lt;/h2&gt; &lt;p&gt;If you are using a database for home or small office use, Microsoft Access or Filemaker should be fine. If you need to create a database driven website, then you&#39;re better off using a more robust system such as SQL Server, Oracle, or MySQL.&lt;/p&gt; &lt;p&gt;The examples in this tutorial use Microsoft Access. If you don&#39;t have Microsoft Access, you should still be able to follow the examples. The tasks we perform are the same tasks you would need to perform regardless of which database management system you use. The key goal with this tutorial is to provide you with an overview of what is involved in creating and maintaining a database.&lt;br /&gt;&lt;/p&gt;&lt;h3 class=&quot;post-title entry-title&quot;&gt; SQL Server &lt;/h3&gt; &lt;div class=&quot;post-header&quot;&gt;  &lt;/div&gt;  &lt;ol style=&quot;font-weight: bold;&quot;&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/about-sql-server.html&quot;&gt;About SQL Server&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-editions.html&quot;&gt;SQL Server Editions&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-management-studio.html&quot;&gt;SQL Server - Management Studio&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-database.html&quot;&gt;SQL Server - Create a Database&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-table.html&quot;&gt;SQL Server - Create a Table&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-adding-data.html&quot;&gt;SQL Server - Adding Data&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-query-designer.html&quot;&gt;SQL Server - Query Designer&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-views.html&quot;&gt;SQL Server Views&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-stored-procedures.html&quot;&gt;SQL Server Stored Procedures&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-user-logins.html&quot;&gt;User Logins&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-server-roles.html&quot;&gt;Server Roles&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-database-schemas.html&quot;&gt;Database Schemas&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-linked-servers.html&quot;&gt;Linked Servers&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-integration-services-ssis.html&quot;&gt;Integration Services&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-summary.html&quot;&gt;Summary&lt;/a&gt;&lt;/li&gt;&lt;/ol&gt;</content><link rel='replies' type='application/atom+xml' href='http://mycomputersciences.blogspot.com/feeds/1350359097785617572/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/database-management-systems.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/1350359097785617572'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/1350359097785617572'/><link rel='alternate' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/database-management-systems.html' title='Database Management Systems'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6070680432155434668.post-1435911849532163915</id><published>2011-06-24T12:05:00.002+05:00</published><updated>2011-06-24T14:18:17.825+05:00</updated><title type='text'>About SQL Server</title><content type='html'>&lt;p&gt;Microsoft SQL Server is a &lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/database-management-systems.html&quot;&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;Relational Database Management System&lt;/span&gt;&lt;/a&gt; (RDBMS) designed to run on platforms ranging from laptops to large multiprocessor servers. SQL Server is commonly used as the backend system for websites and corporate CRMs and can support thousands of concurrent users.&lt;/p&gt; &lt;p&gt;SQL Server comes with a number of tools to help you with your database administration and programming tasks. &lt;/p&gt;  &lt;p&gt;SQL Server is much more robust and scalable than a desktop database management system such as Microsoft Access. Anyone who has ever tried using Access as a backend to a website will probably be familiar with the errors that were generated when too many users tried to access the database!&lt;/p&gt;  &lt;p&gt;Although SQL Server can also be run as a desktop database system, it is most commonly used as a server database system.&lt;/p&gt; &lt;h2&gt;Server Database Systems&lt;/h2&gt; &lt;p&gt;Server based database systems are designed to run on a central server, so that multiple users can access the same data simultaneously. The users normally access the database through an application.&lt;/p&gt; &lt;p&gt;For example, a website could store all its content in a database. Whenever a visitor views an article, they are retrieving data from the database. As you know, websites aren&#39;t normally limited to just one user. So, at any given moment, a website could be serving up hundreds, or even thousands of articles to its website visitors. At the same time, other users could be updating their personal profile in the members&#39; area, or subscribing to a newsletter, or anything else that website users do. &lt;/p&gt; &lt;p&gt;Generally, it&#39;s the application that provides the functionality to these visitors. It is the database that stores the data and makes it available. Having said that, SQL Server does include some useful features that can assist the application in providing its functionality.&lt;/p&gt;  &lt;h2&gt;SQL Server Editions&lt;/h2&gt; &lt;p&gt;SQL Server comes in many editions. Some are paid versions others are free. The examples in this tutorial were done using the free Express version of SQL Server.&lt;/p&gt; &lt;p&gt;The   discusses the various editions of SQL Server 2008.&lt;/p&gt;&lt;h3 class=&quot;post-title entry-title&quot;&gt; SQL Server &lt;/h3&gt; &lt;div class=&quot;post-header&quot;&gt;  &lt;/div&gt;  &lt;ol style=&quot;font-weight: bold;&quot;&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/about-sql-server.html&quot;&gt;About SQL Server&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-editions.html&quot;&gt;SQL Server Editions&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-management-studio.html&quot;&gt;SQL Server - Management Studio&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-database.html&quot;&gt;SQL Server - Create a Database&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-table.html&quot;&gt;SQL Server - Create a Table&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-adding-data.html&quot;&gt;SQL Server - Adding Data&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-query-designer.html&quot;&gt;SQL Server - Query Designer&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-views.html&quot;&gt;SQL Server Views&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-stored-procedures.html&quot;&gt;SQL Server Stored Procedures&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-user-logins.html&quot;&gt;User Logins&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-server-roles.html&quot;&gt;Server Roles&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-database-schemas.html&quot;&gt;Database Schemas&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-linked-servers.html&quot;&gt;Linked Servers&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-integration-services-ssis.html&quot;&gt;Integration Services&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-summary.html&quot;&gt;Summary&lt;/a&gt;&lt;/li&gt;&lt;/ol&gt;</content><link rel='replies' type='application/atom+xml' href='http://mycomputersciences.blogspot.com/feeds/1435911849532163915/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/about-sql-server.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/1435911849532163915'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/1435911849532163915'/><link rel='alternate' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/about-sql-server.html' title='About SQL Server'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6070680432155434668.post-8651470419688638810</id><published>2011-06-24T11:56:00.004+05:00</published><updated>2011-06-24T14:49:45.278+05:00</updated><title type='text'>SQL Server</title><content type='html'>&lt;ol style=&quot;font-weight: bold;&quot;&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/about-sql-server.html&quot;&gt;About SQL Server&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-editions.html&quot;&gt;SQL Server Editions&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-management-studio.html&quot;&gt;SQL Server - Management Studio&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-database.html&quot;&gt;SQL Server - Create a Database&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-table.html&quot;&gt;SQL Server - Create a Table&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-adding-data.html&quot;&gt;SQL Server - Adding Data&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-query-designer.html&quot;&gt;SQL Server - Query Designer&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-views.html&quot;&gt;SQL Server Views&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-stored-procedures.html&quot;&gt;SQL Server Stored Procedures&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-user-logins.html&quot;&gt;User Logins&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-server-roles.html&quot;&gt;Server Roles&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-database-schemas.html&quot;&gt;Database Schemas&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-linked-servers.html&quot;&gt;Linked Servers&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-integration-services-ssis.html&quot;&gt;Integration Services&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-summary.html&quot;&gt;Summary&lt;/a&gt;&lt;/li&gt;&lt;/ol&gt;&lt;span style=&quot;color: rgb(255, 0, 0); font-weight: bold;font-size:180%;&quot; &gt;[More Information Links about SQL]&lt;/span&gt;&lt;br /&gt;&lt;ul class=&quot;posts&quot;&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-summary.html&quot;&gt;SQL Server - Summary&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-integration-services-ssis.html&quot;&gt;SQL Server Integration Services (SSIS)&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-linked-servers.html&quot;&gt;SQL Server - Linked Servers&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-database-schemas.html&quot;&gt;SQL Server - Database Schemas&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-server-roles.html&quot;&gt;SQL Server - Server Roles&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-user-logins.html&quot;&gt;SQL Server - User Logins&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-stored-procedures.html&quot;&gt;SQL Server - Stored Procedures&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-views.html&quot;&gt;SQL Server - Views&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-query-designer.html&quot;&gt;SQL Server - Query Designer&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-adding-data.html&quot;&gt;SQL Server - Adding Data&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-table.html&quot;&gt;SQL Server - Create a Table&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-create-database.html&quot;&gt;SQL Server - Create a Database&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-management-studio.html&quot;&gt;SQL Server - Management Studio&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-editions.html&quot;&gt;SQL Server Editions&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/soft-visual-studio-2005-service-pack-1.html&quot;&gt;soft Visual Studio 2005 Service Pack 1 Update for ...&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/microsoft-sql-server-2008-express-with.html&quot;&gt;Microsoft® SQL Server® 2008 Express with Advanced ...&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/sql-server-2008-editions.html&quot;&gt;SQL Server 2008 Editions&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/database-management-systems.html&quot;&gt;Database Management Systems&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/about-sql-server.html&quot;&gt;About SQL Server&lt;/a&gt;&lt;/li&gt;&lt;/ul&gt;</content><link rel='replies' type='application/atom+xml' href='http://mycomputersciences.blogspot.com/feeds/8651470419688638810/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/sql-server.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/8651470419688638810'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/8651470419688638810'/><link rel='alternate' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/sql-server.html' title='SQL Server'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6070680432155434668.post-7017136897755550394</id><published>2011-06-18T21:51:00.005+05:00</published><updated>2011-06-18T22:04:10.748+05:00</updated><title type='text'>MS Excel Tutorial in Urdu</title><content type='html'>&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: rgb(51, 51, 51); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; line-height: 15px; &quot;&gt;&lt;ol&gt;&lt;span class=&quot;Apple-style-span&quot; &gt;&lt;li style=&quot;padding-top: 0.35em; padding-right: 0px; padding-bottom: 0.35em; padding-left: 1.3em; margin-top: 0.25em; margin-right: 0px; margin-bottom: 0.25em; margin-left: 0px; text-indent: -15px; border-top-style: dashed; border-top-width: 0px; border-top-color: rgb(119, 119, 119); background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; list-style-type: none; list-style-image: none; list-style-position: outside; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; background-image: none; &quot;&gt;&lt;br /&gt;&lt;/li&gt;&lt;li style=&quot;padding-top: 0.35em; padding-right: 0px; padding-bottom: 0.35em; padding-left: 1.3em; margin-top: 0.25em; margin-right: 0px; margin-bottom: 0.25em; margin-left: 0px; text-indent: -15px; border-top-style: dashed; border-top-width: 0px; border-top-color: rgb(119, 119, 119); background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; list-style-type: none; list-style-image: none; list-style-position: outside; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; background-image: none; &quot;&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/ms-excel-tutorial-urdu-1_18.html&quot; style=&quot;text-decoration: none; color: rgb(204, 51, 0); &quot;&gt;MS Excel Tutorial Urdu 1&lt;/a&gt;&lt;/li&gt;&lt;li style=&quot;padding-top: 0.35em; padding-right: 0px; padding-bottom: 0.35em; padding-left: 1.3em; margin-top: 0.25em; margin-right: 0px; margin-bottom: 0.25em; margin-left: 0px; text-indent: -15px; border-top-style: dashed; border-top-width: 0px; border-top-color: rgb(119, 119, 119); background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; list-style-type: none; list-style-image: none; list-style-position: outside; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; background-image: none; &quot;&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/ms-excel-tutorial-urdu-2_18.html&quot; style=&quot;text-decoration: none; color: rgb(204, 51, 0); &quot;&gt;MS Excel Tutorial Urdu 2&lt;/a&gt;&lt;/li&gt;&lt;li style=&quot;padding-top: 0.35em; padding-right: 0px; padding-bottom: 0.35em; padding-left: 1.3em; margin-top: 0.25em; margin-right: 0px; margin-bottom: 0.25em; margin-left: 0px; text-indent: -15px; border-top-style: dashed; border-top-width: 0px; border-top-color: rgb(119, 119, 119); background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; list-style-type: none; list-style-image: none; list-style-position: outside; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; background-image: none; &quot;&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/ms-excel-tutorial-urdu-3_18.html&quot; style=&quot;text-decoration: underline; color: rgb(255, 51, 0); &quot;&gt;MS Excel Tutorial Urdu 3&lt;/a&gt;&lt;/li&gt;&lt;li style=&quot;padding-top: 0.35em; padding-right: 0px; padding-bottom: 0.35em; padding-left: 1.3em; margin-top: 0.25em; margin-right: 0px; margin-bottom: 0.25em; margin-left: 0px; text-indent: -15px; border-top-style: dashed; border-top-width: 0px; border-top-color: rgb(119, 119, 119); background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; list-style-type: none; list-style-image: none; list-style-position: outside; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; background-image: none; &quot;&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/ms-excel-tutorial-urdu-4_18.html&quot; style=&quot;text-decoration: none; color: rgb(204, 51, 0); &quot;&gt;MS Excel Tutorial Urdu 4&lt;/a&gt;&lt;/li&gt;&lt;/span&gt;&lt;/ol&gt;&lt;/span&gt;</content><link rel='replies' type='application/atom+xml' href='http://mycomputersciences.blogspot.com/feeds/7017136897755550394/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/ms-excel-tutorial-in-urdu.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/7017136897755550394'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/7017136897755550394'/><link rel='alternate' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/ms-excel-tutorial-in-urdu.html' title='MS Excel Tutorial in Urdu'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6070680432155434668.post-3037466421370221217</id><published>2011-06-18T21:51:00.001+05:00</published><updated>2011-06-18T21:51:38.691+05:00</updated><title type='text'>Corel Draw 12 Tutorial in Urdu</title><content type='html'>&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: rgb(51, 51, 51); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 15px; &quot;&gt;&lt;ul class=&quot;posts&quot; style=&quot;padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; line-height: 1.2; list-style-type: none; list-style-position: initial; list-style-image: none; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; &quot;&gt;&lt;li style=&quot;padding-top: 0.35em; padding-right: 0px; padding-bottom: 0.35em; padding-left: 1.3em; margin-top: 0.25em; margin-right: 0px; margin-bottom: 0.25em; margin-left: 0px; text-indent: -15px; border-top-style: none; border-top-width: 0px; border-top-color: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; list-style-type: none; list-style-image: none; list-style-position: outside; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; background-image: none; background-position: initial initial; background-repeat: initial initial; &quot;&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/corel-draw-12-tutorial-urdu-1_18.html&quot; style=&quot;text-decoration: none; color: rgb(204, 51, 0); &quot;&gt;Corel Draw 12 Tutorial Urdu 1&lt;/a&gt;&lt;/li&gt;&lt;li style=&quot;padding-top: 0.35em; padding-right: 0px; padding-bottom: 0.35em; padding-left: 1.3em; margin-top: 0.25em; margin-right: 0px; margin-bottom: 0.25em; margin-left: 0px; text-indent: -15px; border-top-style: dashed; border-top-width: 0px; border-top-color: rgb(119, 119, 119); background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; list-style-type: none; list-style-image: none; list-style-position: outside; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; background-image: none; background-position: initial initial; background-repeat: initial initial; &quot;&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/corel-draw-12-tutorial-urdu-2_18.html&quot; style=&quot;text-decoration: none; color: rgb(204, 51, 0); &quot;&gt;Corel Draw 12 Tutorial Urdu 2&lt;/a&gt;&lt;/li&gt;&lt;/ul&gt;&lt;/span&gt;</content><link rel='replies' type='application/atom+xml' href='http://mycomputersciences.blogspot.com/feeds/3037466421370221217/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/corel-draw-12-tutorial-in-urdu.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/3037466421370221217'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/3037466421370221217'/><link rel='alternate' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/corel-draw-12-tutorial-in-urdu.html' title='Corel Draw 12 Tutorial in Urdu'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6070680432155434668.post-1228163478310348195</id><published>2011-06-18T21:33:00.002+05:00</published><updated>2011-06-18T21:36:08.179+05:00</updated><title type='text'>Computer Repairing</title><content type='html'>&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: rgb(51, 51, 51); font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; &quot;&gt;&lt;ul&gt;&lt;li style=&quot;padding-top: 0.35em; padding-right: 0px; padding-bottom: 0.35em; padding-left: 1.3em; margin-top: 0.25em; margin-right: 0px; margin-bottom: 0.25em; margin-left: 0px; text-indent: -15px; border-top-style: none; border-top-width: 0px; border-top-color: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; list-style-type: none; list-style-image: none; list-style-position: outside; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; background-image: none; &quot;&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2010/08/computer-repair-course-chapter-1_04.html&quot; style=&quot;text-decoration: none; color: rgb(204, 51, 0); &quot;&gt;&lt;span class=&quot;Apple-style-span&quot; &gt;A+ Computer Repair Course Chapter 1&lt;/span&gt;&lt;/a&gt;&lt;/li&gt;&lt;li style=&quot;padding-top: 0.35em; padding-right: 0px; padding-bottom: 0.35em; padding-left: 1.3em; margin-top: 0.25em; margin-right: 0px; margin-bottom: 0.25em; margin-left: 0px; text-indent: -15px; border-top-style: dashed; border-top-width: 0px; border-top-color: rgb(119, 119, 119); background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; list-style-type: none; list-style-image: none; list-style-position: outside; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; background-image: none; &quot;&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2010/08/computer-repair-course-chapter-2_04.html&quot; style=&quot;text-decoration: none; color: rgb(204, 51, 0); &quot;&gt;&lt;span class=&quot;Apple-style-span&quot; &gt;A+ Computer Repair Course Chapter 2&lt;/span&gt;&lt;/a&gt;&lt;/li&gt;&lt;li style=&quot;padding-top: 0.35em; padding-right: 0px; padding-bottom: 0.35em; padding-left: 1.3em; margin-top: 0.25em; margin-right: 0px; margin-bottom: 0.25em; margin-left: 0px; text-indent: -15px; border-top-style: dashed; border-top-width: 0px; border-top-color: rgb(119, 119, 119); background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; list-style-type: none; list-style-image: none; list-style-position: outside; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; background-image: none; &quot;&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2010/08/computer-repair-course-chapter-3_04.html&quot; style=&quot;text-decoration: none; color: rgb(204, 51, 0); &quot;&gt;&lt;span class=&quot;Apple-style-span&quot; &gt;A+ Computer Repair Course Chapter 3 Troubleshooting&lt;/span&gt;&lt;/a&gt;&lt;/li&gt;&lt;li style=&quot;padding-top: 0.35em; padding-right: 0px; padding-bottom: 0.35em; padding-left: 1.3em; margin-top: 0.25em; margin-right: 0px; margin-bottom: 0.25em; margin-left: 0px; text-indent: -15px; border-top-style: dashed; border-top-width: 0px; border-top-color: rgb(119, 119, 119); background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; list-style-type: none; list-style-image: none; list-style-position: outside; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; background-image: none; &quot;&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2010/08/computer-repair-course-chapter-4_04.html&quot; style=&quot;text-decoration: none; color: rgb(204, 51, 0); &quot;&gt;&lt;span class=&quot;Apple-style-span&quot; &gt;A+ Computer Repair Course Chapter 4&lt;/span&gt;&lt;/a&gt;&lt;/li&gt;&lt;li style=&quot;padding-top: 0.35em; padding-right: 0px; padding-bottom: 0.35em; padding-left: 1.3em; margin-top: 0.25em; margin-right: 0px; margin-bottom: 0.25em; margin-left: 0px; text-indent: -15px; border-top-style: dashed; border-top-width: 0px; border-top-color: rgb(119, 119, 119); background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; list-style-type: none; list-style-image: none; list-style-position: outside; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; background-image: none; &quot;&gt;&lt;a href=&quot;http://mycomputersciences.blogspot.com/2010/08/computer-repair-course-chapter-5-part_04.html&quot; style=&quot;text-decoration: none; color: rgb(204, 51, 0); &quot;&gt;&lt;span class=&quot;Apple-style-span&quot; &gt;A+ Computer Repair Course Chapter 5 part - CPUs&lt;/span&gt;&lt;/a&gt;&lt;/li&gt;&lt;/ul&gt;&lt;/span&gt;</content><link rel='replies' type='application/atom+xml' href='http://mycomputersciences.blogspot.com/feeds/1228163478310348195/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/computer-repairing.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/1228163478310348195'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/1228163478310348195'/><link rel='alternate' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/computer-repairing.html' title='Computer Repairing'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-6070680432155434668.post-7208445046245676420</id><published>2011-06-18T19:45:00.002+05:00</published><updated>2011-06-18T19:47:44.219+05:00</updated><title type='text'>Corel Draw 12 Tutorial Urdu 1</title><content type='html'>&lt;div&gt;&lt;h1 id=&quot;watch-headline-title&quot; style=&quot;text-align: right; margin-top: 0px; margin-right: 0px; margin-bottom: 5px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; font-size: 1.8333em; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; height: 1.1363em; max-height: 1.1363em; line-height: 1.1363em; color: rgb(51, 51, 51); overflow-x: hidden; overflow-y: hidden; font-family: arial, sans-serif; &quot;&gt;&lt;span id=&quot;eow-title&quot; class=&quot;long-title&quot; dir=&quot;ltr&quot; title=&quot;Corel Draw 12 Tutorial Urdu Part 1 By Irfan Wazir Ali&quot; style=&quot;margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; font-size: 0.9166em; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; letter-spacing: -0.5px; &quot;&gt;Page &lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/corel-draw-12-tutorial-urdu-1_18.html&quot;&gt;1&lt;/a&gt; &lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/corel-draw-12-tutorial-urdu-2_18.html&quot;&gt;2&lt;/a&gt;&lt;/span&gt;&lt;/h1&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: arial, sans-serif; font-size: 12px; &quot;&gt;&lt;h1 id=&quot;watch-headline-title&quot; style=&quot;margin-top: 0px; margin-right: 0px; margin-bottom: 5px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; font-size: 1.8333em; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; font-weight: bold; height: 1.1363em; max-height: 1.1363em; line-height: 1.1363em; color: rgb(51, 51, 51); overflow-x: hidden; overflow-y: hidden; background-position: initial initial; background-repeat: initial initial; &quot;&gt;&lt;span id=&quot;eow-title&quot; class=&quot;long-title&quot; dir=&quot;ltr&quot; title=&quot;Corel Draw 12 Tutorial Urdu Part 1 By Irfan Wazir Ali&quot; style=&quot;margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; font-size: 0.9166em; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; letter-spacing: -0.5px; background-position: initial initial; background-repeat: initial initial; &quot;&gt;Corel Draw 12 Tutorial Urdu Part 1&lt;/span&gt;&lt;/h1&gt;&lt;/span&gt;&lt;/div&gt;&lt;iframe width=&quot;425&quot; height=&quot;349&quot; src=&quot;http://www.youtube.com/embed/iJeFWSjFdbc&quot; frameborder=&quot;0&quot; allowfullscreen=&quot;&quot;&gt;&lt;/iframe&gt;&lt;div&gt;&lt;h1 id=&quot;watch-headline-title&quot; style=&quot;font-family: arial, sans-serif; margin-top: 0px; margin-right: 0px; margin-bottom: 5px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; font-size: 1.8333em; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; font-weight: bold; height: 1.1363em; max-height: 1.1363em; line-height: 1.1363em; color: rgb(51, 51, 51); overflow-x: hidden; overflow-y: hidden; &quot;&gt;&lt;span id=&quot;eow-title&quot; class=&quot;long-title&quot; dir=&quot;ltr&quot; title=&quot;Corel Draw 12 Tutorial Urdu Part 1 By Irfan Wazir Ali&quot; style=&quot;margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; font-size: 0.9166em; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; letter-spacing: -0.5px; background-position: initial initial; background-repeat: initial initial; &quot;&gt;Corel Draw 12 Tutorial Urdu Part 2&lt;/span&gt;&lt;/h1&gt;&lt;div&gt;&lt;span id=&quot;eow-title&quot; class=&quot;long-title&quot; dir=&quot;ltr&quot; title=&quot;Corel Draw 12 Tutorial Urdu Part 1 By Irfan Wazir Ali&quot; style=&quot;margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; font-size: 11px;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;iframe width=&quot;425&quot; height=&quot;349&quot; src=&quot;http://www.youtube.com/embed/SeT5Ki-wYyc&quot; frameborder=&quot;0&quot; allowfullscreen=&quot;&quot;&gt;&lt;/iframe&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;&lt;h1 id=&quot;watch-headline-title&quot; style=&quot;margin-top: 0px; margin-right: 0px; margin-bottom: 5px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; font-size: 1.8333em; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; font-weight: bold; height: 1.1363em; max-height: 1.1363em; line-height: 1.1363em; color: rgb(51, 51, 51); overflow-x: hidden; overflow-y: hidden; font-family: arial, sans-serif; &quot;&gt;&lt;span id=&quot;eow-title&quot; class=&quot;long-title&quot; dir=&quot;ltr&quot; title=&quot;Corel Draw 12 Tutorial Urdu Part 1 By Irfan Wazir Ali&quot; style=&quot;margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; font-size: 0.9166em; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; letter-spacing: -0.5px; background-position: initial initial; background-repeat: initial initial; &quot;&gt;Corel Draw 12 Tutorial Urdu Part 3&lt;/span&gt;&lt;/h1&gt;&lt;div&gt;&lt;span id=&quot;eow-title&quot; class=&quot;long-title&quot; dir=&quot;ltr&quot; title=&quot;Corel Draw 12 Tutorial Urdu Part 1 By Irfan Wazir Ali&quot; style=&quot;margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; font-size: 11px;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;iframe width=&quot;425&quot; height=&quot;349&quot; src=&quot;http://www.youtube.com/embed/XzbTprPUF_E&quot; frameborder=&quot;0&quot; allowfullscreen=&quot;&quot;&gt;&lt;/iframe&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;&lt;h1 id=&quot;watch-headline-title&quot; style=&quot;margin-top: 0px; margin-right: 0px; margin-bottom: 5px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; font-size: 1.8333em; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; font-weight: bold; height: 1.1363em; max-height: 1.1363em; line-height: 1.1363em; color: rgb(51, 51, 51); overflow-x: hidden; overflow-y: hidden; font-family: arial, sans-serif; &quot;&gt;&lt;span id=&quot;eow-title&quot; class=&quot;long-title&quot; dir=&quot;ltr&quot; title=&quot;Corel Draw 12 Tutorial Urdu Part 1 By Irfan Wazir Ali&quot; style=&quot;margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; font-size: 0.9166em; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; letter-spacing: -0.5px; background-position: initial initial; background-repeat: initial initial; &quot;&gt;Corel Draw 12 Tutorial Urdu Part 4&lt;/span&gt;&lt;/h1&gt;&lt;div&gt;&lt;span id=&quot;eow-title&quot; class=&quot;long-title&quot; dir=&quot;ltr&quot; title=&quot;Corel Draw 12 Tutorial Urdu Part 1 By Irfan Wazir Ali&quot; style=&quot;margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; font-size: 11px;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;iframe width=&quot;425&quot; height=&quot;349&quot; src=&quot;http://www.youtube.com/embed/77Fuh2DonmM&quot; frameborder=&quot;0&quot; allowfullscreen=&quot;&quot;&gt;&lt;/iframe&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;&lt;h1 id=&quot;watch-headline-title&quot; style=&quot;margin-top: 0px; margin-right: 0px; margin-bottom: 5px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; font-size: 1.8333em; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; font-weight: bold; height: 1.1363em; max-height: 1.1363em; line-height: 1.1363em; color: rgb(51, 51, 51); overflow-x: hidden; overflow-y: hidden; font-family: arial, sans-serif; &quot;&gt;&lt;span id=&quot;eow-title&quot; class=&quot;long-title&quot; dir=&quot;ltr&quot; title=&quot;Corel Draw 12 Tutorial Urdu Part 1 By Irfan Wazir Ali&quot; style=&quot;margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; font-size: 0.9166em; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; letter-spacing: -0.5px; background-position: initial initial; background-repeat: initial initial; &quot;&gt;Corel Draw 12 Tutorial Urdu Part 5&lt;/span&gt;&lt;/h1&gt;&lt;div&gt;&lt;span id=&quot;eow-title&quot; class=&quot;long-title&quot; dir=&quot;ltr&quot; title=&quot;Corel Draw 12 Tutorial Urdu Part 1 By Irfan Wazir Ali&quot; style=&quot;margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; font-size: 11px;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;iframe width=&quot;425&quot; height=&quot;349&quot; src=&quot;http://www.youtube.com/embed/ZnklEmHl9ZE&quot; frameborder=&quot;0&quot; allowfullscreen=&quot;&quot;&gt;&lt;/iframe&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;&lt;h1 id=&quot;watch-headline-title&quot; style=&quot;margin-top: 0px; margin-right: 0px; margin-bottom: 5px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; font-size: 1.8333em; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; font-weight: bold; height: 1.1363em; max-height: 1.1363em; line-height: 1.1363em; color: rgb(51, 51, 51); overflow-x: hidden; overflow-y: hidden; font-family: arial, sans-serif; &quot;&gt;&lt;span id=&quot;eow-title&quot; class=&quot;long-title&quot; dir=&quot;ltr&quot; title=&quot;Corel Draw 12 Tutorial Urdu Part 1 By Irfan Wazir Ali&quot; style=&quot;margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; font-size: 0.9166em; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; letter-spacing: -0.5px; background-position: initial initial; background-repeat: initial initial; &quot;&gt;Corel Draw 12 Tutorial Urdu Part 6&lt;/span&gt;&lt;/h1&gt;&lt;div&gt;&lt;span id=&quot;eow-title&quot; class=&quot;long-title&quot; dir=&quot;ltr&quot; title=&quot;Corel Draw 12 Tutorial Urdu Part 1 By Irfan Wazir Ali&quot; style=&quot;margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; font-size: 11px;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;&lt;iframe width=&quot;425&quot; height=&quot;349&quot; src=&quot;http://www.youtube.com/embed/lQif8n-J5NA&quot; frameborder=&quot;0&quot; allowfullscreen=&quot;&quot;&gt;&lt;/iframe&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;&lt;h1 id=&quot;watch-headline-title&quot; style=&quot;margin-top: 0px; margin-right: 0px; margin-bottom: 5px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; font-size: 1.8333em; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; height: 1.1363em; max-height: 1.1363em; line-height: 1.1363em; color: rgb(51, 51, 51); overflow-x: hidden; overflow-y: hidden; font-family: arial, sans-serif; &quot;&gt;&lt;span id=&quot;eow-title&quot; class=&quot;long-title&quot; dir=&quot;ltr&quot; title=&quot;Corel Draw 12 Tutorial Urdu Part 1 By Irfan Wazir Ali&quot; style=&quot;margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; font-size: 0.9166em; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; letter-spacing: -0.5px; &quot;&gt;Corel Draw 12 Tutorial Urdu Part 7&lt;/span&gt;&lt;/h1&gt;&lt;div&gt;&lt;span id=&quot;eow-title&quot; class=&quot;long-title&quot; dir=&quot;ltr&quot; title=&quot;Corel Draw 12 Tutorial Urdu Part 1 By Irfan Wazir Ali&quot; style=&quot;margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; font-size: 15px;&quot;&gt;&lt;iframe width=&quot;425&quot; height=&quot;349&quot; src=&quot;http://www.youtube.com/embed/KtZ0EBYQ8Zc&quot; frameborder=&quot;0&quot; allowfullscreen=&quot;&quot;&gt;&lt;/iframe&gt;&lt;/span&gt;&lt;/div&gt;&lt;div style=&quot;font-family: arial, sans-serif; &quot;&gt;&lt;span id=&quot;eow-title&quot; class=&quot;long-title&quot; dir=&quot;ltr&quot; title=&quot;Corel Draw 12 Tutorial Urdu Part 1 By Irfan Wazir Ali&quot; style=&quot;margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; letter-spacing: -0.5px; &quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Georgia, serif; &quot;&gt;&lt;h1 id=&quot;watch-headline-title&quot; style=&quot;text-align: right; margin-top: 0px; margin-right: 0px; margin-bottom: 5px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; font-size: 1.8333em; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; height: 1.1363em; max-height: 1.1363em; line-height: 1.1363em; color: rgb(51, 51, 51); overflow-x: hidden; overflow-y: hidden; font-family: arial, sans-serif; &quot;&gt;&lt;span id=&quot;eow-title&quot; class=&quot;long-title&quot; dir=&quot;ltr&quot; title=&quot;Corel Draw 12 Tutorial Urdu Part 1 By Irfan Wazir Ali&quot; style=&quot;margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; font-size: 0.9166em; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; letter-spacing: -0.5px; &quot;&gt;Page &lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/corel-draw-12-tutorial-urdu-1_18.html&quot;&gt;1&lt;/a&gt; &lt;a href=&quot;http://mycomputersciences.blogspot.com/2011/06/corel-draw-12-tutorial-urdu-2_18.html&quot;&gt;2&lt;/a&gt;&lt;/span&gt;&lt;/h1&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://mycomputersciences.blogspot.com/feeds/7208445046245676420/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/corel-draw-12-tutorial-urdu-1_18.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/7208445046245676420'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/6070680432155434668/posts/default/7208445046245676420'/><link rel='alternate' type='text/html' href='http://mycomputersciences.blogspot.com/2011/06/corel-draw-12-tutorial-urdu-1_18.html' title='Corel Draw 12 Tutorial Urdu 1'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://img.youtube.com/vi/iJeFWSjFdbc/default.jpg" height="72" width="72"/><thr:total>0</thr:total></entry></feed>