{"id":452,"date":"2005-08-03T16:08:00","date_gmt":"2005-08-03T16:08:00","guid":{"rendered":"http:\/\/markwilson.me.uk\/blog\/2005\/08\/sql-server-2005-overview.htm"},"modified":"2007-07-16T22:50:32","modified_gmt":"2007-07-16T21:50:32","slug":"sql-server-2005-overview","status":"publish","type":"post","link":"https:\/\/www.markwilson.co.uk\/blog\/2005\/08\/sql-server-2005-overview.htm","title":{"rendered":"SQL Server 2005 overview"},"content":{"rendered":"<p><!--112308559124305030--><\/p>\n<p>As part of my recent quest to learn about SQL Server from an infrastructure perspective, I&#8217;ve been attending a number of events, one of which was <a href=\"http:\/\/blogs.technet.com\/michael_platt\/\">Michael Platt<\/a>&#8216;s keynote at the May 2005 Microsoft Technical Roadshow &#8211; SQL Server 2005 for IT Pros.<\/p>\n<p>In my opinion, SQL Server 2005 (codenamed Yukon) is probably Microsoft&#8217;s most significant product release since Windows 2000.  Central to the data management functionality within the Microsoft platform, this new version of SQL Server, due for release in November, is a massive rewrite (around 3 million lines of C# code), including a huge number of new features with improvements in three key areas, all underpinned by new levels of security and reliability:<\/p>\n<ul>\n<li>Developer productivity:<\/li>\n<\/ul>\n<ul>\n<li>Visual Studio 2005 integration.<\/li>\n<\/ul>\n<li>Enterprise data management:<\/li>\n<ul>\n<li>SQL Server database.<\/li>\n<li>SQL Server replication services.<\/li>\n<\/ul>\n<li>Business intelligence (BI):<\/li>\n<ul>\n<li>SQL Server integration services (SSIS) &#8211; replacing data transformation services (DTS).<\/li>\n<li>SQL Server analytical services.<\/li>\n<li>SQL Server reporting services.<\/li>\n<li>SQL Server notification services.<\/li>\n<\/ul>\n<p>In terms of developer productivity, the Microsoft .NET Framework common language runtime (CLR) is now part of the SQL engine, allowing database-side coding using any Microsoft .NET language.  XML support is no longer a bolt-on component, with XML now supported natively, feeding into the web services strategy, with integrated web services features including the new <a href=\"https:\/\/www.markwilson.co.uk\/blog\/2005\/08\/microsoft-view-of-connected-systems.htm\">SQL Service Broker for messaging between SQL Server and other systems<\/a>.<\/p>\n<p>Looking at enterprise data management: availability and security is enhanced with support for database mirroring and online operations as well as data security and privacy (encryption and enhanced auditing); manageability is improved with a self-tuning database, fast recovery and restore, and a host of <a href=\"https:\/\/www.markwilson.co.uk\/blog\/2005\/07\/new-tools-for-managing-and.htm\">management tools<\/a>; and the platform scales to cover a huge range of devices from smartphones to <a href=\"https:\/\/www.markwilson.co.uk\/blog\/2005\/05\/how-about-this-for-test-system.htm\">massive 64-bit installations<\/a> using technologies such as partitioning and snapshots to allow the system to scale in line with business growth.<\/p>\n<p>For business intelligence, all of the previously separate tools are pulled together into a single front-end management interface with two components &#8211; Management Studio for management and BI Studio for design &#8211; both of which are closely integrated with Visual Studio.  SQL Server 2005 has more real-time analytical support built into the platform as well as a comprehensive extract, transform and load (ETL) capability for the entire enterprise, supporting heterogeneous databases.<\/p>\n<p>In the past, DTS used the database engine to carry out the transform whereas SSIS carries out the transform itself, with some standard transforms included, but also expandable with custom transformations.  With SQL Server 2005, the SQL Server reporting services reporting solution is supplemented with a report builder for user generated reports and an multidimensional expressions (MDX) builder for developers; providing an interactive enterprise reporting environment, integrated with Office System applications .  Analysis Services allows the integration of relational databases and <a href=\"http:\/\/en.wikipedia.org\/wiki\/OLAP\">OLAP<\/a> cubes to cache the OLAP data in synchronisation with relational updates and perform analysis on real time data.  Finally, data mining capabilities (previously the domain of expensive high-end technologies) become available for general purpose use in SQL Server 2005 offering exploration, pattern discovery and pattern description.<\/p>\n<p><img data-recalc-dims=\"1\" decoding=\"async\" alt=\"SQL Server 2005 Platform\" src=\"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/images\/sqlserver2005platform.png?w=700&#038;ssl=1\" border=\"0\" \/><\/p>\n<p>In line with the Microsoft policy of using its new products internally (a process which they refer to, somewhat delightfully, as &#8220;dogfooding&#8221;), Microsoft is already using SQL Server 2005 heavily for its enterprise applications (e.g. their SAP R\/3 1.7Tb database, the staging data warehouse for all Microsoft data and the Microsoft sales revenue and reporting system &#8211; basically all of Microsoft&#8217;s business-critical applications!).  Looking at the metrics for just one of those applications &#8211; the SAP R\/3 system in Redmond which handles Microsoft global financial, human resources, sales and distribution resources &#8211; this 1.7Tb database over 25 production servers services 2500 named users (over 57000 users in total with between 200 and 600 using the system concurrently) handling 300 000 SAP transactions a day and 100 000 batch jobs a month whilst maintaining greater than 99.9% SAP availability and less than 0.5 second response time &#8211; on beta code!<\/p>\n<p>In my opinion, SQL Server 2005 will be Microsoft&#8217;s most significant product release since Windows 2000 and is central to the Microsoft platform.  The constant battle between Microsoft and Oracle will continue for some time to come but this new version of SQL Server (which has been a long time coming) might finally help to persuade IT Directors that Microsoft is a serious contender in the enterprise data management space.<\/p>\n<p>For more information about SQL Server 2005, I recommend the <a href=\"http:\/\/www.microsoft.com\/technet\/prodtechnol\/sql\/2005\/\">Microsoft TechNet SQL Server Tech Center<\/a>, <a href=\"http:\/\/blogs.technet.com\/mat_stephen\/\">Mat Stephen&#8217;s blog<\/a>, and <a href=\"http:\/\/blogs.conchango.com\/jamiethomson\/\">Jamie Thomson&#8217;s blog<\/a> (particularly for SSIS).  SQL Server 2005 is due for release in November 2005, with <a href=\"http:\/\/www.microsoft.com\/sql\/2005\/productinfo\/sql2005features.mspx\">four product editions &#8211; Express, Standard, Workgroup and Enterprise<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>As part of my recent quest to learn about SQL Server from an infrastructure perspective, I&#8217;ve been attending a number of events, one of which was Michael Platt&#8216;s keynote at the May 2005 Microsoft Technical Roadshow &#8211; SQL Server 2005 for IT Pros. In my opinion, SQL Server 2005 (codenamed Yukon) is probably Microsoft&#8217;s most &hellip; <a href=\"https:\/\/www.markwilson.co.uk\/blog\/2005\/08\/sql-server-2005-overview.htm\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">SQL Server 2005 overview<\/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-452","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>SQL Server 2005 overview - 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\/08\/sql-server-2005-overview.htm\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2005 overview - markwilson.it\" \/>\n<meta property=\"og:description\" content=\"As part of my recent quest to learn about SQL Server from an infrastructure perspective, I&#8217;ve been attending a number of events, one of which was Michael Platt&#8216;s keynote at the May 2005 Microsoft Technical Roadshow &#8211; SQL Server 2005 for IT Pros. In my opinion, SQL Server 2005 (codenamed Yukon) is probably Microsoft&#8217;s most &hellip; Continue reading SQL Server 2005 overview\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.markwilson.co.uk\/blog\/2005\/08\/sql-server-2005-overview.htm\" \/>\n<meta property=\"og:site_name\" content=\"markwilson.it\" \/>\n<meta property=\"article:published_time\" content=\"2005-08-03T16:08:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2007-07-16T21:50:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.markwilson.co.uk\/blog\/images\/sqlserver2005platform.png\" \/>\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=\"4 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\\\/08\\\/sql-server-2005-overview.htm#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2005\\\/08\\\/sql-server-2005-overview.htm\"},\"author\":{\"name\":\"Mark Wilson\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/98f61365e7c39d6be942174b8c4de468\"},\"headline\":\"SQL Server 2005 overview\",\"datePublished\":\"2005-08-03T16:08:00+00:00\",\"dateModified\":\"2007-07-16T21:50:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2005\\\/08\\\/sql-server-2005-overview.htm\"},\"wordCount\":752,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/98f61365e7c39d6be942174b8c4de468\"},\"image\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2005\\\/08\\\/sql-server-2005-overview.htm#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/images\\\/sqlserver2005platform.png\",\"keywords\":[\"Microsoft SQL Server\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2005\\\/08\\\/sql-server-2005-overview.htm#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2005\\\/08\\\/sql-server-2005-overview.htm\",\"url\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2005\\\/08\\\/sql-server-2005-overview.htm\",\"name\":\"SQL Server 2005 overview - markwilson.it\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2005\\\/08\\\/sql-server-2005-overview.htm#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2005\\\/08\\\/sql-server-2005-overview.htm#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/images\\\/sqlserver2005platform.png\",\"datePublished\":\"2005-08-03T16:08:00+00:00\",\"dateModified\":\"2007-07-16T21:50:32+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2005\\\/08\\\/sql-server-2005-overview.htm#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2005\\\/08\\\/sql-server-2005-overview.htm\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2005\\\/08\\\/sql-server-2005-overview.htm#primaryimage\",\"url\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/images\\\/sqlserver2005platform.png\",\"contentUrl\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/images\\\/sqlserver2005platform.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2005\\\/08\\\/sql-server-2005-overview.htm#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2005 overview\"}]},{\"@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":"SQL Server 2005 overview - 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\/08\/sql-server-2005-overview.htm","og_locale":"en_GB","og_type":"article","og_title":"SQL Server 2005 overview - markwilson.it","og_description":"As part of my recent quest to learn about SQL Server from an infrastructure perspective, I&#8217;ve been attending a number of events, one of which was Michael Platt&#8216;s keynote at the May 2005 Microsoft Technical Roadshow &#8211; SQL Server 2005 for IT Pros. In my opinion, SQL Server 2005 (codenamed Yukon) is probably Microsoft&#8217;s most &hellip; Continue reading SQL Server 2005 overview","og_url":"https:\/\/www.markwilson.co.uk\/blog\/2005\/08\/sql-server-2005-overview.htm","og_site_name":"markwilson.it","article_published_time":"2005-08-03T16:08:00+00:00","article_modified_time":"2007-07-16T21:50:32+00:00","og_image":[{"url":"https:\/\/www.markwilson.co.uk\/blog\/images\/sqlserver2005platform.png","type":"","width":"","height":""}],"author":"Mark Wilson","twitter_card":"summary_large_image","twitter_creator":"@markwilsonit","twitter_site":"@markwilsonit","twitter_misc":{"Written by":"Mark Wilson","Estimated reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.markwilson.co.uk\/blog\/2005\/08\/sql-server-2005-overview.htm#article","isPartOf":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2005\/08\/sql-server-2005-overview.htm"},"author":{"name":"Mark Wilson","@id":"https:\/\/www.markwilson.co.uk\/blog\/#\/schema\/person\/98f61365e7c39d6be942174b8c4de468"},"headline":"SQL Server 2005 overview","datePublished":"2005-08-03T16:08:00+00:00","dateModified":"2007-07-16T21:50:32+00:00","mainEntityOfPage":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2005\/08\/sql-server-2005-overview.htm"},"wordCount":752,"commentCount":0,"publisher":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/#\/schema\/person\/98f61365e7c39d6be942174b8c4de468"},"image":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2005\/08\/sql-server-2005-overview.htm#primaryimage"},"thumbnailUrl":"https:\/\/www.markwilson.co.uk\/blog\/images\/sqlserver2005platform.png","keywords":["Microsoft SQL Server"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.markwilson.co.uk\/blog\/2005\/08\/sql-server-2005-overview.htm#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.markwilson.co.uk\/blog\/2005\/08\/sql-server-2005-overview.htm","url":"https:\/\/www.markwilson.co.uk\/blog\/2005\/08\/sql-server-2005-overview.htm","name":"SQL Server 2005 overview - markwilson.it","isPartOf":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2005\/08\/sql-server-2005-overview.htm#primaryimage"},"image":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2005\/08\/sql-server-2005-overview.htm#primaryimage"},"thumbnailUrl":"https:\/\/www.markwilson.co.uk\/blog\/images\/sqlserver2005platform.png","datePublished":"2005-08-03T16:08:00+00:00","dateModified":"2007-07-16T21:50:32+00:00","breadcrumb":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2005\/08\/sql-server-2005-overview.htm#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.markwilson.co.uk\/blog\/2005\/08\/sql-server-2005-overview.htm"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.markwilson.co.uk\/blog\/2005\/08\/sql-server-2005-overview.htm#primaryimage","url":"https:\/\/www.markwilson.co.uk\/blog\/images\/sqlserver2005platform.png","contentUrl":"https:\/\/www.markwilson.co.uk\/blog\/images\/sqlserver2005platform.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.markwilson.co.uk\/blog\/2005\/08\/sql-server-2005-overview.htm#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.markwilson.co.uk\/blog"},{"@type":"ListItem","position":2,"name":"SQL Server 2005 overview"}]},{"@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":452,"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":452,"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":145,"url":"https:\/\/www.markwilson.co.uk\/blog\/2005\/07\/new-tools-for-managing-and.htm","url_meta":{"origin":452,"position":2},"title":"New tools for managing and administering SQL Server 2005","author":"Mark Wilson","date":"Friday 29 July 2005","format":false,"excerpt":"I haven't looked at structured query language (SQL) since I was at Uni', back in the early 1990s, and don't intended to start now; but with a major new SQL Server release due from Microsoft in November, I've been building up my knowledge of the product from an infrastructure perspective.\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":452,"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":7352,"url":"https:\/\/www.markwilson.co.uk\/blog\/2017\/12\/7352.htm","url_meta":{"origin":452,"position":4},"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":[]},{"id":385,"url":"https:\/\/www.markwilson.co.uk\/blog\/2005\/11\/microsoft-developer-road-trip-cd.htm","url_meta":{"origin":452,"position":5},"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":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/posts\/452","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=452"}],"version-history":[{"count":0,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/posts\/452\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/media?parent=452"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/categories?post=452"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/tags?post=452"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}