{"id":7352,"date":"2017-12-19T19:14:29","date_gmt":"2017-12-19T19:14:29","guid":{"rendered":"http:\/\/www.markwilson.co.uk\/blog\/?p=7352"},"modified":"2017-12-19T19:14:29","modified_gmt":"2017-12-19T19:14:29","slug":"7352","status":"publish","type":"post","link":"https:\/\/www.markwilson.co.uk\/blog\/2017\/12\/7352.htm","title":{"rendered":"Microsoft SQL Server overview"},"content":{"rendered":"<p>I wrote this post a few months ago&#8230; and it crashed my blog. Gone. Needed to be restored from backup&#8230;<\/p>\n<p>&#8230;hopefully this time I&#8217;ll have more luck!<\/p>\n<p>One of the advantages of being in the MVP Reconnect programme is that I occasionally get invited to webcasts that open my eyes to technology I&#8217;ve not had a lot to do with previously. For many years, one of the big holes in my knowledge was around Microsoft SQL Server. That was until I saw Brian\u00a0Kelley (<a href=\"https:\/\/twitter.com\/kbriankelley\">@kbriankelley<\/a>)&#8217;s &#8220;Brief overview of SQL Server&#8221;. The content&#8217;s not restricted, so I thought I&#8217;d republish some of it here for others who are getting their head around the major on-premises components of the Microsoft Data Platform.<\/p>\n<h3>SQL Server Editions<\/h3>\n<p>There are several editions of SQL Server available and these are the key differences (<a href=\"https:\/\/www.microsoft.com\/en-gb\/sql-server\/sql-server-2017-editions\">updated for 2017<\/a>):<\/p>\n<ul>\n<li>Express Edition (previously known as MSDE) is a free version, with some limitations around database size, etc.<\/li>\n<li>Standard Edition lacks some enterprise features but has high availability and suits many application workloads.<\/li>\n<li>Enterprise Edition is the full functionality product (but can be expensive)<\/li>\n<li>Developer Edition (not licenced for use in production) offers the full feature set but can also run on a client operating system whereas enterprise will only run on server-based operating systems<\/li>\n<li>Web Edition has reduced functionality and is intended for public websites (only available to service providers)<\/li>\n<li>Compact Edition is another free version, intended for embedded databases in ASP.NET websites and Windows desktop applications<\/li>\n<\/ul>\n<p>Although SQL Server is often thought of as an RDBMS product, it&#8217;s really a suite of systems, under the SQL Server name. Usually that means the database engine but there are many parts, each of which has a distinct setup (i.e. you don&#8217;t need the database service for SQL Server Analysis Services and vice versa).<\/p>\n<h3>SQL Server Analysis Services (SSAS)<\/h3>\n<p>SSAS (since 2007) is an online analytical and transaction processing (OLAP) tool intended for data warehousing and data mining.<\/p>\n<p>One advantage of OLAP is to run jobs during the night for pre-generated calculations (used for roll-ups &#8211; e.g. totals and averages, etc.). It can provide fast results to business users who would otherwise need complex calculations in a transactional system (e.g. sales data based on region, month, quarter, etc. can be done ahead of time).<\/p>\n<p>SSAS is comparable to IBM Cognos or Oracle Essbase (normally packaged with Hyperion for accounting, etc.).<\/p>\n<p>Some SSAS jargon includes:<\/p>\n<ul>\n<li>Star schema\/snowflake schema &#8211; database design differs from transactional design. You can do these things in RDBMS but use SSAS on top.<\/li>\n<li>Cubes<\/li>\n<li>Dimensions<\/li>\n<li>Tabular model<\/li>\n<li>Data analysis expressions (DAX) &#8211; a language to do things in SSAS<\/li>\n<\/ul>\n<h3>SQL Server Integration Services (SSIS)<\/h3>\n<p>SSIS (since 2005) is heavily used for extract, transform and load (ETL) workloads &#8211; i.e. to get data from a source, manipulate it and pass it to a destination. It can be used to build a data warehouse, then data marts or to move data between systems. Basically, it&#8217;s a back-end batch processing system that performs the data mining.<\/p>\n<p>SSIS is a replacement for Data Transformation Services (DTS). It&#8217;s not limited to SQL Server for source\/destination so can talk to Oracle, Excel spreadsheets, other ODBC connections, etc.<\/p>\n<p>The drag and drop interface is very powerful with the full functionality and flexibilityof Microsoft.NET behind it.<\/p>\n<p>SSIS is comparable with Informatica (or Clover, etc.).<\/p>\n<p>Some SSIS jargon includes:<\/p>\n<ul>\n<li>Packages (whatever is processing, contains all the logic)<\/li>\n<li>Tasks (what&#8217;s being carried out)<\/li>\n<li>Dataflow tasks (how you go from source to destination &#8211; could be multiples)<\/li>\n<li>Transformation (manipulating data)<\/li>\n<li>Business Intelligence Markup Language (BIML)<\/li>\n<\/ul>\n<h3>SQL Server Reporting Services (SSRS)<\/h3>\n<p>SSRS was introduced 2005 and became so popular it was ported back to SQL Server 2000!<br \/>\nIt is a reporting engine, used to publish reports in-browser. Early versions were built on IIS but since 2008, SSIS has run directly on http.sys.<\/p>\n<p>SSRS can be integrated with SharePoint (for report security based on SharePoint security) or the native, standalone mode is browser-based to look at folders, find reports, and run a report with parameters. Used to print via ActiveX control but now (since 2016) prints to PDF (or opens with a PDF reader).<\/p>\n<p>There are two ways to build reports: Report Builder (a\u00a0web-side interface for BA-type power user) or Report Designer (a full product for complex designs). There is also a subscription capability so users can subscribe to reports.<\/p>\n<p>SSRS can be compared with IBM Business Objects and Tableau.<\/p>\n<p>SSRS jargon includes:<\/p>\n<ul>\n<li>Reports<\/li>\n<li>Data sources<\/li>\n<li>Datasets<\/li>\n<li>ReportServer (API to integrate with other products)<\/li>\n<li>Native mode vs. integrated mode (SharePoint)<\/li>\n<\/ul>\n<h3>SQL Server Database Engine<\/h3>\n<p>The SQL Server database engine is what most people think of when SQL Server is mentioned.<br \/>\nIt is traditionally a relational database management system (RDBMS) although it now contains many other database capabilities. It was originally derived from a Sybase product (until SQL Server 6.5).<\/p>\n<p>SQL Server supports both multiple databases per instance (which can connect and join across) and multiple instances per server (from 2000) &#8211; the first is a default instance, then named instances can be created.<\/p>\n<p>SQL Server uses a SQL language variant called T-SQL to interact. A GUI is provided in SQL Server Management Studio but it&#8217;s also possible interact via PowerShell.<\/p>\n<p>SQL Server also has a scheduler (the SQL Server Agent), which can alert on success\/failure and allows the creation of elaborate scheduling routines with notifications and the ability to run code. It is comparable with IBM DB2, Oracle, PostgreSQL, Sybase, MySQL and MariaDB.<\/p>\n<p>SQL Server 2016 features include:<\/p>\n<ul>\n<li>High availability options, including\u00a0Always On failover clusters; Always On availability groups (which are more flexible because they don&#8217;t have to replicate and fail over everything); Database mirroring (one database on multiple systems; deprecated now in favour of availability groups); log shipping.<\/li>\n<li>Several encryption options including built-in (certificate, asymmetric keys, symmetric keys); Enterprise Edition also has Transparent Data Encryption (TDE) to encrypt database at rest and stop copies of the database from being loaded elsewhere; connection encryption (SSL\/TLS since 2005); Always Encrypted is new for 2016 (transparent to the application and to SQL Server) &#8211; data stored in encrypted form within the database.<\/li>\n<li>SQL Server and Windows authentication (server or Active Directory). Can have Windows or both, but not just SQL Server-based logins.<\/li>\n<li>Replication options to move data between servers.<\/li>\n<\/ul>\n<p>Other security features include audit objects (who did what?); granular security permissions; login auditing (failed logins are written to the SQL Server Error Log text file and to the application event log); dynamic data masking (depending on who needs to see it &#8211; e.g. store social security numbers and only show part of the data; only obfuscation as data is still in clear text); row-level security (to filter rows).<\/p>\n<p>Each new version brings performance enhancements, e.g. columnstore indexes, in-memory OLTP tables, query optimisation.<\/p>\n<p>New Technologies in 2016 include:<\/p>\n<ul>\n<li>JSON support. Query and return data in JSON format. Administrators have been able to use SOAP and XML since 2005 but this is now deprecated in favour of JSON (which is popular for RESTful systems).<\/li>\n<li>Master data services.<\/li>\n<li>Polybase (not to be confused with a clustering solution &#8211; it&#8217;s about talking to other data sources, e.g. Hadoop, Cloudera and Azure storage, to be expanded to include Oracle, Teradata, Mongo, Spark and more).<\/li>\n<li>R Services\/R Server (R within the database and also R Server for data science\/big data queries).<\/li>\n<\/ul>\n<p>2017 builds on 2016 to include:<\/p>\n<ul>\n<li>Linux and Docker support.\u00a0Starting with SQL Server 2017, SQL Server is available for either Windows or Linux systems and it&#8217;s available as an installable application or for Docker containers.<\/li>\n<li>SQL Server R Services has been renamed\u00a0SQL Server Machine Learning Services, to reflect support for Python in addition to R.<\/li>\n<\/ul>\n<p>There are many <a href=\"https:\/\/docs.microsoft.com\/en-gb\/sql\/sql-server\/what-s-new-in-sql-server-2017\">more features in the Microsoft documentation<\/a>\u00a0but these are the most significant updates.<\/p>\n<h3>But what about the cloud?<\/h3>\n<p>This post provided a quick run-down of some of the major on-premises SQL Server components but, just as with Microsoft&#8217;s other products, there are cloud alternatives too. I&#8217;m planning a follow-up post to cover these so watch this space!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I wrote this post a few months ago&#8230; and it crashed my blog. Gone. Needed to be restored from backup&#8230; &#8230;hopefully this time I&#8217;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 to technology I&#8217;ve not had &hellip; <a href=\"https:\/\/www.markwilson.co.uk\/blog\/2017\/12\/7352.htm\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Microsoft SQL Server 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":[218],"tags":[83],"class_list":["post-7352","post","type-post","status-publish","format-standard","hentry","category-technology","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>Microsoft SQL Server overview - markwilson.it<\/title>\n<meta name=\"description\" content=\"A post summarising some of the main components of Microsoft&#039;s SQL Server family of data platform products\" \/>\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\/2017\/12\/7352.htm\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft SQL Server overview - markwilson.it\" \/>\n<meta property=\"og:description\" content=\"A post summarising some of the main components of Microsoft&#039;s SQL Server family of data platform products\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.markwilson.co.uk\/blog\/2017\/12\/7352.htm\" \/>\n<meta property=\"og:site_name\" content=\"markwilson.it\" \/>\n<meta property=\"article:published_time\" content=\"2017-12-19T19:14:29+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=\"7 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\\\/2017\\\/12\\\/7352.htm#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2017\\\/12\\\/7352.htm\"},\"author\":{\"name\":\"Mark Wilson\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/98f61365e7c39d6be942174b8c4de468\"},\"headline\":\"Microsoft SQL Server overview\",\"datePublished\":\"2017-12-19T19:14:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2017\\\/12\\\/7352.htm\"},\"wordCount\":1359,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/98f61365e7c39d6be942174b8c4de468\"},\"keywords\":[\"Microsoft SQL Server\"],\"articleSection\":[\"Technology\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2017\\\/12\\\/7352.htm#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2017\\\/12\\\/7352.htm\",\"url\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2017\\\/12\\\/7352.htm\",\"name\":\"Microsoft SQL Server overview - markwilson.it\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#website\"},\"datePublished\":\"2017-12-19T19:14:29+00:00\",\"description\":\"A post summarising some of the main components of Microsoft's SQL Server family of data platform products\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2017\\\/12\\\/7352.htm#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2017\\\/12\\\/7352.htm\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2017\\\/12\\\/7352.htm#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Microsoft SQL Server 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":"Microsoft SQL Server overview - markwilson.it","description":"A post summarising some of the main components of Microsoft's SQL Server family of data platform products","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\/2017\/12\/7352.htm","og_locale":"en_GB","og_type":"article","og_title":"Microsoft SQL Server overview - markwilson.it","og_description":"A post summarising some of the main components of Microsoft's SQL Server family of data platform products","og_url":"https:\/\/www.markwilson.co.uk\/blog\/2017\/12\/7352.htm","og_site_name":"markwilson.it","article_published_time":"2017-12-19T19:14:29+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":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.markwilson.co.uk\/blog\/2017\/12\/7352.htm#article","isPartOf":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2017\/12\/7352.htm"},"author":{"name":"Mark Wilson","@id":"https:\/\/www.markwilson.co.uk\/blog\/#\/schema\/person\/98f61365e7c39d6be942174b8c4de468"},"headline":"Microsoft SQL Server overview","datePublished":"2017-12-19T19:14:29+00:00","mainEntityOfPage":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2017\/12\/7352.htm"},"wordCount":1359,"commentCount":0,"publisher":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/#\/schema\/person\/98f61365e7c39d6be942174b8c4de468"},"keywords":["Microsoft SQL Server"],"articleSection":["Technology"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.markwilson.co.uk\/blog\/2017\/12\/7352.htm#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.markwilson.co.uk\/blog\/2017\/12\/7352.htm","url":"https:\/\/www.markwilson.co.uk\/blog\/2017\/12\/7352.htm","name":"Microsoft SQL Server overview - markwilson.it","isPartOf":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/#website"},"datePublished":"2017-12-19T19:14:29+00:00","description":"A post summarising some of the main components of Microsoft's SQL Server family of data platform products","breadcrumb":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2017\/12\/7352.htm#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.markwilson.co.uk\/blog\/2017\/12\/7352.htm"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.markwilson.co.uk\/blog\/2017\/12\/7352.htm#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.markwilson.co.uk\/blog"},{"@type":"ListItem","position":2,"name":"Microsoft SQL Server 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":452,"url":"https:\/\/www.markwilson.co.uk\/blog\/2005\/08\/sql-server-2005-overview.htm","url_meta":{"origin":7352,"position":0},"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":191,"url":"https:\/\/www.markwilson.co.uk\/blog\/2005\/11\/sql-server-2005-express-edition-2.htm","url_meta":{"origin":7352,"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":59,"url":"https:\/\/www.markwilson.co.uk\/blog\/2005\/02\/10000-feet-view-of-microsoft-systems.htm","url_meta":{"origin":7352,"position":2},"title":"10,000 feet view of Microsoft Systems Management Server 2003","author":"Mark Wilson","date":"Thursday 10 February 2005","format":false,"excerpt":"Until I started to look at the Microsoft Solution Accelerator for Business Desktop Deployment (Enterprise Edition), which makes use of the Microsoft Systems Management Server (SMS) 2003 Operating System Deployment Feature Pack, I had no experience of using SMS. At my BDD training, Thomas Lee gave a brief overview of\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":94,"url":"https:\/\/www.markwilson.co.uk\/blog\/2005\/02\/sql-server-2005-express-edition.htm","url_meta":{"origin":7352,"position":3},"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":253,"url":"https:\/\/www.markwilson.co.uk\/blog\/2006\/02\/it-forum-05-highlights-part-1.htm","url_meta":{"origin":7352,"position":4},"title":"IT Forum &#8217;05 highlights: part 1","author":"Mark Wilson","date":"Wednesday 1 February 2006","format":false,"excerpt":"A few years back, I used to try and persuade my employer to send me to Microsoft TechEd Europe each year, on the basis that lots of 75 minute presentations on a variety of topics provided a better background for me than a few days of in depth product training\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":551,"url":"https:\/\/www.markwilson.co.uk\/blog\/2004\/06\/clustered-sql-server-dos-donts-and.htm","url_meta":{"origin":7352,"position":5},"title":"Clustered SQL Server dos, don&#8217;ts and basic warnings","author":"Mark Wilson","date":"Wednesday 9 June 2004","format":false,"excerpt":"I don't know much about SQL, but I recently worked with a colleague in to produce a standardised SQL Server 2000 installation (clustered and standalone) for a client and came across some Microsoft advice which gives dos, don'ts and basic warnings for clustered SQL Server installations. The article is basically\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":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/posts\/7352","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=7352"}],"version-history":[{"count":2,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/posts\/7352\/revisions"}],"predecessor-version":[{"id":7354,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/posts\/7352\/revisions\/7354"}],"wp:attachment":[{"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/media?parent=7352"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/categories?post=7352"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/tags?post=7352"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}