{"id":145,"date":"2005-07-29T11:02:00","date_gmt":"2005-07-29T11:02:00","guid":{"rendered":"http:\/\/markwilson.me.uk\/blog\/2005\/07\/new-tools-for-managing-and.htm"},"modified":"2007-07-16T23:19:00","modified_gmt":"2007-07-16T22:19:00","slug":"new-tools-for-managing-and","status":"publish","type":"post","link":"https:\/\/www.markwilson.co.uk\/blog\/2005\/07\/new-tools-for-managing-and.htm","title":{"rendered":"New tools for managing and administering SQL Server 2005"},"content":{"rendered":"<p><!--112263703060786437--><\/p>\n<p>I haven&#8217;t looked at <a href=\"http:\/\/en.wikipedia.org\/wiki\/Sql\">structured query language<\/a> (SQL) since I was at Uni&#8217;, back in the early 1990s, and don&#8217;t intended to start now; but with a major new <a href=\"http:\/\/www.microsoft.com\/sql\/\">SQL Server<\/a> release due from Microsoft in November, I&#8217;ve been building up my knowledge of the product from an infrastructure perspective. Yesterday evening, I was at a <a href=\"http:\/\/www.microsoft.com\/uk\/technet\/training\/events.mspx\">Microsoft TechNet UK event<\/a>, where <a href=\"http:\/\/blogs.technet.com\/mat_stephen\/\">Matthew Stephen<\/a> (one of Microsoft UK&#8217;s IT Pro Evangelists) presented the tools for managing and administrating SQL Server 2005 (codenamed Yukon) along with a few of the new features for administrators. <\/p>\n<p>At the centre of SQL Server 2005 administration is the new SQL Management Studio, which replaces SQL Enterprise Manager and uses a Visual Studio project metaphor, featuring a much improved user interface showing registered servers, an object explorer (with a tree view of the databases &#8211; similar to Enterprise Manager) and a summary pane. New features include:<\/p>\n<ul>\n<li>An integrated SQLCMD mode, allowing SQLCMD queries to be run from within SQL management Studio (as long as they are preceded with <span style=\"font-family:Courier New;\">!!<\/span>).<\/li>\n<li>Online database restoration and fast recovery, with only the data currently being overwritten being unavailable.<\/li>\n<li>Online indexing (so that queries can still be performed whilst indexes are rebuilding).<\/li>\n<li>Integration with Visual Studio 2005 and the Microsoft .NET Framework v2.0, allowing the use of user-defined functions, data types and procedures, using any common language runtime (CLR)-compliant language.<\/li>\n<li>A dedicated connection for administrative access (allowing an administrator to connect to a server and diagnose problems even if access is generally being prevented by, for example, blocking).<\/li>\n<\/ul>\n<p>In common with all new Microsoft products, SQL Server 2005 will be delivered &#8220;secure by default&#8221;, meaning that some configuration changes may be required in order to administer some legacy services. Now, when connecting to a server using the SQL Management Studio, the default connection method is using TCP\/IP, and Windows authentication is the preferred authentication model.<\/p>\n<p>The <a href=\"http:\/\/www.microsoft.com\/downloads\/details.aspx?FamilyID=C039A798-C57A-419E-ACBC-2A332CB7F959&amp;displaylang=en\">SQL Server Web Data Administrator<\/a> is available today for administering SQL Server databases where no management tools are available. It runs on either <a href=\"http:\/\/www.microsoft.com\/iis\/\">Microsoft Internet Information Services<\/a> (IIS) or the lightweight <a href=\"http:\/\/asp.net\/projects\/cassini\/download\/\">Cassini portable web server<\/a> and allows either Windows or SQL-based authentication to connect to a server for management purposes, import and export (queries, stored procedures, etc.) and a T-SQL query editor. Because it is lightweight, the Web Data Administrator is ideal for use over slow network links.<\/p>\n<p><a href=\"https:\/\/blogs.conchango.com\/markwilson\/archive\/2005\/02\/01\/911.aspx\">SQL Server 2005 Express Edition<\/a> replaces the <a href=\"http:\/\/www.microsoft.com\/sql\/msde\/\">Microsoft SQL Server 2000 Desktop Engine<\/a> (MSDE) &#8211; Microsoft&#8217;s free (but functionally limited) version of SQL Server 2000. SQL Server Express 2005 is still limited, but the constraints are different to MSDE, now allowing use of a single CPU (although it can make use of multiple logical CPUs &#8211; i.e. with a multi-core CPU), 1Gb of RAM and a 4Gb database size, with no limit on the number of concurrent sessions, making it ideal as a database to support a web site.<\/p>\n<p>The SQL Server Express Manager can be used to administer SQL Server Express or MSDE databases and is based on the Microsoft.NET Framework v2.0. With a tree view of database objects and wizards for common tasks, SQL Express Manager can be used to administer either local or remote databases and includes a T-SQL query editor.<\/p>\n<p>SQLCMD uses the OLEDB interface and replaces ISQL (DB-Library) and OSQL (ODBC) tools (although OSQL still exists and SQLCMD parameters are backwards compatible with OSQL). Offering batch functionality (including command line variables and nested scripts) and script chaining, SQLCMD is a powerful command line tool for SQL Server administration and queries.<\/p>\n<p>SQLiMail is a replacement for the former MAPI32-based SQLMail. Including its own SMTP client, SQLiMail makes use of the new SQL Broker provided with SQL Server 2005 and because it is no longer MAPI-based, has no reliance on Outlook. Multiple profiles can be attached to an SMTP account along with multiple host databases. SQLiMail also supports clusters and 64-bit SQL Server installations.<\/p>\n<p>One of the new features of SQL Management Studio is the creation of maintenance plans (each one made up of sub-plans). The maintenance plan designer has a similar appearance to SQL Server Integration Services (SSIS) (a subject on which <a href=\"http:\/\/blogs.conchango.com\/jamiethomson\/\">Jamie Thomson<\/a> frequently blogs) featuring a drag and drop visual design workspace which allows tasks to be joined to build up a complex workflow. It is also possible to view the resulting T-SQL statements.<\/p>\n<p>SQL Profiler also has a host of new features, not least the ability to grant trace access to developers (without requiring SA access). Also featuring a new selection user interface, SQL Profiler includes a host of new events (so that pretty much every activity can be audited), assisting with the compliance issues faced by many organisations today. SQL Service Broker activity can also be traced and traced can be redirected to an XML file for programmatic analysis. Working in real-time, SQL Profiler includes templates to assist in profiling and results can be filtered (e.g. by SQL Server internal process identifier). One particularly impressive feature (which Mat didn&#8217;t show last night but which I&#8217;ve seen him demonstrate before) is that ability to overlay SQL Profiler data on top of a performance monitor graph, allowing analysis of the effect of a SQL operation on server performance.<\/p>\n<p>Finally, the features for monitoring SQL Server 2005 are enhanced with a new log file viewer (allowing SQL logs to be viewed in combination with Windows event logs), activity monitor (e.g. allowing locks to be viewed in real-time, by process, etc.) and an updated SQL Server Agent which can be used to set alerts, now with multiple proxies (so different logins can be used for different services) and new agent user roles.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I haven&#8217;t looked at structured query language (SQL) since I was at Uni&#8217;, back in the early 1990s, and don&#8217;t intended to start now; but with a major new SQL Server release due from Microsoft in November, I&#8217;ve been building up my knowledge of the product from an infrastructure perspective. Yesterday evening, I was at &hellip; <a href=\"https:\/\/www.markwilson.co.uk\/blog\/2005\/07\/new-tools-for-managing-and.htm\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">New tools for managing and administering SQL Server 2005<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[],"tags":[83],"class_list":["post-145","post","type-post","status-publish","format-standard","hentry","tag-sql-server"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>New tools for managing and administering SQL Server 2005 - markwilson.it<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.markwilson.co.uk\/blog\/2005\/07\/new-tools-for-managing-and.htm\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"New tools for managing and administering SQL Server 2005 - markwilson.it\" \/>\n<meta property=\"og:description\" content=\"I haven&#8217;t looked at structured query language (SQL) since I was at Uni&#8217;, back in the early 1990s, and don&#8217;t intended to start now; but with a major new SQL Server release due from Microsoft in November, I&#8217;ve been building up my knowledge of the product from an infrastructure perspective. Yesterday evening, I was at &hellip; Continue reading New tools for managing and administering SQL Server 2005\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.markwilson.co.uk\/blog\/2005\/07\/new-tools-for-managing-and.htm\" \/>\n<meta property=\"og:site_name\" content=\"markwilson.it\" \/>\n<meta property=\"article:published_time\" content=\"2005-07-29T11:02:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2007-07-16T22:19:00+00:00\" \/>\n<meta name=\"author\" content=\"Mark Wilson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@markwilsonit\" \/>\n<meta name=\"twitter:site\" content=\"@markwilsonit\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mark Wilson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2005\\\/07\\\/new-tools-for-managing-and.htm#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2005\\\/07\\\/new-tools-for-managing-and.htm\"},\"author\":{\"name\":\"Mark Wilson\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/98f61365e7c39d6be942174b8c4de468\"},\"headline\":\"New tools for managing and administering SQL Server 2005\",\"datePublished\":\"2005-07-29T11:02:00+00:00\",\"dateModified\":\"2007-07-16T22:19:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2005\\\/07\\\/new-tools-for-managing-and.htm\"},\"wordCount\":949,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/98f61365e7c39d6be942174b8c4de468\"},\"keywords\":[\"Microsoft SQL Server\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2005\\\/07\\\/new-tools-for-managing-and.htm#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2005\\\/07\\\/new-tools-for-managing-and.htm\",\"url\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2005\\\/07\\\/new-tools-for-managing-and.htm\",\"name\":\"New tools for managing and administering SQL Server 2005 - markwilson.it\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#website\"},\"datePublished\":\"2005-07-29T11:02:00+00:00\",\"dateModified\":\"2007-07-16T22:19:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2005\\\/07\\\/new-tools-for-managing-and.htm#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2005\\\/07\\\/new-tools-for-managing-and.htm\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2005\\\/07\\\/new-tools-for-managing-and.htm#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"New tools for managing and administering SQL Server 2005\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/\",\"name\":\"markwilson.it\",\"description\":\"get-info -class technology | write-output &gt; \\\/dev\\\/web\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/98f61365e7c39d6be942174b8c4de468\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/98f61365e7c39d6be942174b8c4de468\",\"name\":\"Mark Wilson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/i0.wp.com\\\/www.markwilson.co.uk\\\/blog\\\/uploads\\\/image-4.png?fit=800%2C800&ssl=1\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/www.markwilson.co.uk\\\/blog\\\/uploads\\\/image-4.png?fit=800%2C800&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/www.markwilson.co.uk\\\/blog\\\/uploads\\\/image-4.png?fit=800%2C800&ssl=1\",\"width\":800,\"height\":800,\"caption\":\"Mark Wilson\"},\"logo\":{\"@id\":\"https:\\\/\\\/i0.wp.com\\\/www.markwilson.co.uk\\\/blog\\\/uploads\\\/image-4.png?fit=800%2C800&ssl=1\"},\"description\":\"A Chartered IT Professional, with recent experience in technology leadership, IT strategy and practice management roles, Mark Wilson is an Enterprise Architect in the Advisory and Management Group at risual. During a career spanning more than two decades, Mark has gained widespread recognition as an expert in his field including both industry and national press exposure. In addition to certifications from Microsoft, VMware, Red Hat, The Open Group and Axelos, Mark held a Microsoft Most Valuable Professional (MVP) award for three years and is now part of the MVP Reconnect programme. Mark is also well-known on social media and maintains an award-winning blog.\",\"sameAs\":[\"http:\\\/\\\/www.markwilson.co.uk\\\/\",\"https:\\\/\\\/www.instagram.com\\\/markwilsonuk\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/markawilson\\\/\",\"https:\\\/\\\/x.com\\\/markwilsonit\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCWHlZCoHRTocdvtrOJ2IL4A\"],\"url\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/author\\\/mark-wilson\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"New tools for managing and administering SQL Server 2005 - markwilson.it","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.markwilson.co.uk\/blog\/2005\/07\/new-tools-for-managing-and.htm","og_locale":"en_GB","og_type":"article","og_title":"New tools for managing and administering SQL Server 2005 - markwilson.it","og_description":"I haven&#8217;t looked at structured query language (SQL) since I was at Uni&#8217;, back in the early 1990s, and don&#8217;t intended to start now; but with a major new SQL Server release due from Microsoft in November, I&#8217;ve been building up my knowledge of the product from an infrastructure perspective. Yesterday evening, I was at &hellip; Continue reading New tools for managing and administering SQL Server 2005","og_url":"https:\/\/www.markwilson.co.uk\/blog\/2005\/07\/new-tools-for-managing-and.htm","og_site_name":"markwilson.it","article_published_time":"2005-07-29T11:02:00+00:00","article_modified_time":"2007-07-16T22:19:00+00:00","author":"Mark Wilson","twitter_card":"summary_large_image","twitter_creator":"@markwilsonit","twitter_site":"@markwilsonit","twitter_misc":{"Written by":"Mark Wilson","Estimated reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.markwilson.co.uk\/blog\/2005\/07\/new-tools-for-managing-and.htm#article","isPartOf":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2005\/07\/new-tools-for-managing-and.htm"},"author":{"name":"Mark Wilson","@id":"https:\/\/www.markwilson.co.uk\/blog\/#\/schema\/person\/98f61365e7c39d6be942174b8c4de468"},"headline":"New tools for managing and administering SQL Server 2005","datePublished":"2005-07-29T11:02:00+00:00","dateModified":"2007-07-16T22:19:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2005\/07\/new-tools-for-managing-and.htm"},"wordCount":949,"commentCount":0,"publisher":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/#\/schema\/person\/98f61365e7c39d6be942174b8c4de468"},"keywords":["Microsoft SQL Server"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.markwilson.co.uk\/blog\/2005\/07\/new-tools-for-managing-and.htm#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.markwilson.co.uk\/blog\/2005\/07\/new-tools-for-managing-and.htm","url":"https:\/\/www.markwilson.co.uk\/blog\/2005\/07\/new-tools-for-managing-and.htm","name":"New tools for managing and administering SQL Server 2005 - markwilson.it","isPartOf":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/#website"},"datePublished":"2005-07-29T11:02:00+00:00","dateModified":"2007-07-16T22:19:00+00:00","breadcrumb":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2005\/07\/new-tools-for-managing-and.htm#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.markwilson.co.uk\/blog\/2005\/07\/new-tools-for-managing-and.htm"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.markwilson.co.uk\/blog\/2005\/07\/new-tools-for-managing-and.htm#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.markwilson.co.uk\/blog"},{"@type":"ListItem","position":2,"name":"New tools for managing and administering SQL Server 2005"}]},{"@type":"WebSite","@id":"https:\/\/www.markwilson.co.uk\/blog\/#website","url":"https:\/\/www.markwilson.co.uk\/blog\/","name":"markwilson.it","description":"get-info -class technology | write-output &gt; \/dev\/web","publisher":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/#\/schema\/person\/98f61365e7c39d6be942174b8c4de468"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.markwilson.co.uk\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":["Person","Organization"],"@id":"https:\/\/www.markwilson.co.uk\/blog\/#\/schema\/person\/98f61365e7c39d6be942174b8c4de468","name":"Mark Wilson","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/image-4.png?fit=800%2C800&ssl=1","url":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/image-4.png?fit=800%2C800&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/image-4.png?fit=800%2C800&ssl=1","width":800,"height":800,"caption":"Mark Wilson"},"logo":{"@id":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/image-4.png?fit=800%2C800&ssl=1"},"description":"A Chartered IT Professional, with recent experience in technology leadership, IT strategy and practice management roles, Mark Wilson is an Enterprise Architect in the Advisory and Management Group at risual. During a career spanning more than two decades, Mark has gained widespread recognition as an expert in his field including both industry and national press exposure. In addition to certifications from Microsoft, VMware, Red Hat, The Open Group and Axelos, Mark held a Microsoft Most Valuable Professional (MVP) award for three years and is now part of the MVP Reconnect programme. Mark is also well-known on social media and maintains an award-winning blog.","sameAs":["http:\/\/www.markwilson.co.uk\/","https:\/\/www.instagram.com\/markwilsonuk\/","https:\/\/www.linkedin.com\/in\/markawilson\/","https:\/\/x.com\/markwilsonit","https:\/\/www.youtube.com\/channel\/UCWHlZCoHRTocdvtrOJ2IL4A"],"url":"https:\/\/www.markwilson.co.uk\/blog\/author\/mark-wilson"}]}},"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":94,"url":"https:\/\/www.markwilson.co.uk\/blog\/2005\/02\/sql-server-2005-express-edition.htm","url_meta":{"origin":145,"position":0},"title":"SQL Server 2005 Express Edition","author":"Mark Wilson","date":"Tuesday 1 February 2005","format":false,"excerpt":"According to Microsoft \"SQL Server Express is a version of SQL Server 2005 designed to helps developers build robust and reliable applications by providing a powerful database that is also free and easy to use.\"I know nothing about SQL Server, except that there is a free cut-down version called the\u2026","rel":"","context":"In \"Microsoft SQL Server\"","block_context":{"text":"Microsoft SQL Server","link":"https:\/\/www.markwilson.co.uk\/blog\/tag\/sql-server"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":191,"url":"https:\/\/www.markwilson.co.uk\/blog\/2005\/11\/sql-server-2005-express-edition-2.htm","url_meta":{"origin":145,"position":1},"title":"SQL Server 2005 Express Edition: now available for download","author":"Mark Wilson","date":"Wednesday 9 November 2005","format":false,"excerpt":"Back in February, I blogged about SQL Server 2005 Express Edition - the successor to the Microsoft SQL Server Desktop Engine (MSDE). Now that SQL Server 2005 has been launched, SQL Server 2005 Express Edition is available for download from the Microsoft website. For further reading, check out my SQL\u2026","rel":"","context":"In \"Microsoft SQL Server\"","block_context":{"text":"Microsoft SQL Server","link":"https:\/\/www.markwilson.co.uk\/blog\/tag\/sql-server"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":452,"url":"https:\/\/www.markwilson.co.uk\/blog\/2005\/08\/sql-server-2005-overview.htm","url_meta":{"origin":145,"position":2},"title":"SQL Server 2005 overview","author":"Mark Wilson","date":"Wednesday 3 August 2005","format":false,"excerpt":"As part of my recent quest to learn about SQL Server from an infrastructure perspective, I've been attending a number of events, one of which was Michael Platt's keynote at the May 2005 Microsoft Technical Roadshow - SQL Server 2005 for IT Pros.In my opinion, SQL Server 2005 (codenamed Yukon)\u2026","rel":"","context":"In \"Microsoft SQL Server\"","block_context":{"text":"Microsoft SQL Server","link":"https:\/\/www.markwilson.co.uk\/blog\/tag\/sql-server"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":144,"url":"https:\/\/www.markwilson.co.uk\/blog\/2005\/07\/10-steps-to-help-secure-sql-server.htm","url_meta":{"origin":145,"position":3},"title":"10 steps to help secure SQL Server 2000","author":"Mark Wilson","date":"Friday 29 July 2005","format":false,"excerpt":"I just stumbled across this 10-step plan to help secure SQL Server 2000 and thought it might be useful to note...","rel":"","context":"In \"Microsoft SQL Server\"","block_context":{"text":"Microsoft SQL Server","link":"https:\/\/www.markwilson.co.uk\/blog\/tag\/sql-server"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":385,"url":"https:\/\/www.markwilson.co.uk\/blog\/2005\/11\/microsoft-developer-road-trip-cd.htm","url_meta":{"origin":145,"position":4},"title":"Microsoft developer road trip CD","author":"Mark Wilson","date":"Friday 4 November 2005","format":false,"excerpt":"In a few days time, Microsoft are launching a whole host of products including Visual Studio 2005 and SQL Server 2005. To complement the launch events and associated webcasts, Microsoft have produced the Microsoft developer road trip CD - a 45 minute audio download featuring information on Visual Studio 2005,\u2026","rel":"","context":"In \"Microsoft\"","block_context":{"text":"Microsoft","link":"https:\/\/www.markwilson.co.uk\/blog\/tag\/microsoft"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":7352,"url":"https:\/\/www.markwilson.co.uk\/blog\/2017\/12\/7352.htm","url_meta":{"origin":145,"position":5},"title":"Microsoft SQL Server overview","author":"Mark Wilson","date":"Tuesday 19 December 2017","format":false,"excerpt":"I wrote this post a few months ago... and it crashed my blog. Gone. Needed to be restored from backup... ...hopefully this time I'll have more luck! One of the advantages of being in the MVP Reconnect programme is that I occasionally get invited to webcasts that open my eyes\u2026","rel":"","context":"In &quot;Technology&quot;","block_context":{"text":"Technology","link":"https:\/\/www.markwilson.co.uk\/blog\/topic\/technology"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/posts\/145","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/comments?post=145"}],"version-history":[{"count":0,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/posts\/145\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/media?parent=145"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/categories?post=145"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/tags?post=145"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}