{"id":746,"date":"2013-03-29T13:13:14","date_gmt":"2013-03-29T02:13:14","guid":{"rendered":"http:\/\/www.rjmprogramming.com.au\/wordpress\/?p=746"},"modified":"2013-03-29T13:13:14","modified_gmt":"2013-03-29T02:13:14","slug":"sql-server-primer-tutorial","status":"publish","type":"post","link":"https:\/\/www.rjmprogramming.com.au\/ITblog\/sql-server-primer-tutorial\/","title":{"rendered":"SQL Server Primer Tutorial"},"content":{"rendered":"<div style=\"width: 230px\" class=\"wp-caption alignnone\"><a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/MS-SQL\/SQLServerManagementStudioExample\/\"><img decoding=\"async\" style=\"float:left; border: 15px solid pink;\" alt=\"SQL Server Primer Tutorial ... thanks to UTS SQL Server 2008 Course Notes\" src=\"http:\/\/www.rjmprogramming.com.au\/MS-SQL\/SQLServerManagementStudioExample\/Microsoft_SQL-Server_Management_Studio_4of.JPG\" title=\"SQL Server Primer Tutorial ... thanks to UTS SQL Server 2008 Course Notes\"  \/><\/a><p class=\"wp-caption-text\">SQL Server Primer Tutorial ... thanks to UTS SQL Server 2008 Course Notes<\/p><\/div>\n<p>Welcome to the SQL Server Primer Tutorial &#8230; or SSPT for short (although by the time you explain it<a target=_blank href='http:\/\/grammar.quickanddirtytips.com\/double-is-double-has.aspx' title='The doubled word rule' id='doubleit' onclick='var xx=document.getElementById(\"doubleit\");  if (xx.innerHTML.indexOf(\",\") != (0 - 1)) { xx.innerHTML = \" \"; } else { xx.innerHTML = \",\"; }'>,<\/a> it is not so short anymore).<\/p>\n<blockquote><p>Microsoft SQL Server is a relational database management system developed by Microsoft. As a database, it is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network (including the Internet). There are at least a dozen different editions of Microsoft SQL Server aimed at different audiences and for different workloads (ranging from small applications that store and retrieve data on the same computer, to millions of users and computers that access huge amounts of data from the Internet at the same time). Its primary query languages are T-SQL and ANSI SQL.<\/p><\/blockquote>\n<p>There is no doubt that SQL Server is a great database to use and that T-SQL is an excellent tool to learn and use in conjunction with the Visual Studio suite of Visual C++,C#,VB.Net and ASP.Net products, where its integration is brilliant.   Like the hand and glove &#8230; like <a target=_blank href='https:\/\/www.youtube.com\/watch?v=YFI0rFFp8j8' title='Fred and Ginger'>Fred and Ginger<\/a>.<\/p>\n<p>In the primer tutorial you can see  <a target=_blank title='click picture' href='http:\/\/www.rjmprogramming.com.au\/MS-SQL\/SQLServerManagementStudioExample\/'>Microsoft SQL Server Management Studio<\/a> 2008 R2 after a successful install.    Installs of SQL Server can result from a variety of paths, including during installs of Visual Studio (Express) .<\/p>\n<p>Link to SQL Server more information &#8230; <a target=_blank href='http:\/\/en.wikipedia.org\/wiki\/Microsoft_SQL_Server' title='Link to SQL Server more information'>via Wikipedia, from where quote above came<\/a>.<br \/>\nLink to SQL Server &#8220;spiritual home&#8221; &#8230; <a target=_blank href='http:\/\/www.microsoft.com\/en-us\/sqlserver\/product-info.aspx' title='As the foundation of the cloud-ready information platform, SQL Server 2012 will help organizations unlock breakthrough insights across the organization as well as quickly build solutions and extend data across on-premises and public cloud backed by mission critical confidence. '>via Microsoft, includes talk about (the recent) SQL Server 2012, and about download options<\/a>.<br \/>\nLink to SQL Server jobs done &#8230; <a target=_blank href='http:\/\/www.rjmprogramming.com.au\/MS-SQL\/' title='Examples of use of SQL Server'>SQL Server jobs done<\/a> &#8230; some of personal experience.\n<\/p>\n<p>If this was interesting you may be interested in <a title='Click here to see topics in which you might be interested' href='#d746' onclick='var dv=document.getElementById(\"d746\"); dv.innerHTML = \"&lt;iframe width=670 height=600 src=\" + \"http:\/\/www.rjmprogramming.com.au\/wordpress\/?cat=47\" + \"&gt;&lt;\/iframe&gt;\"; dv.style.display = \"block\";'>this<\/a> too.<\/p>\n<div id='d746' style='display: none; border-left: 2px solid green; border-top: 2px solid green;'><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Welcome to the SQL Server Primer Tutorial &#8230; or SSPT for short (although by the time you explain it, it is not so short anymore). Microsoft SQL Server is a relational database management system developed by Microsoft. As a database, &hellip; <a href=\"https:\/\/www.rjmprogramming.com.au\/ITblog\/sql-server-primer-tutorial\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9,12,37,39],"tags":[267,299,819,1186,1187,1319,1354],"class_list":["post-746","post","type-post","status-publish","format-standard","hentry","category-database","category-elearning","category-tutorials","category-visual-studio","tag-course","tag-database-2","tag-ms-sql","tag-sql","tag-sql-server","tag-tutorial","tag-uts"],"_links":{"self":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts\/746"}],"collection":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/comments?post=746"}],"version-history":[{"count":0,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts\/746\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/media?parent=746"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/categories?post=746"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/tags?post=746"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}