{"id":239,"date":"2024-01-05T08:55:00","date_gmt":"2024-01-05T13:55:00","guid":{"rendered":"https:\/\/www.sqltabletalk.com\/?p=239"},"modified":"2024-01-04T11:51:37","modified_gmt":"2024-01-04T16:51:37","slug":"sql-server-on-linux-performance","status":"publish","type":"post","link":"https:\/\/www.sqltabletalk.com\/?p=239","title":{"rendered":"Optimizing SQL Server Performance on Linux: Beyond the Basics"},"content":{"rendered":"\n

Introduction<\/strong><\/h2>\n\n\n\n

Following our initial exploration of installing SQL Server on Ubuntu 22.04, we delve into the intricacies of advanced configuration on Linux. This post aims to provide DBAs and system administrators with a better understanding of the configurations specific to Linux environments that enhance SQL Server performance. Configuring SQL Server on Linux requires consideration of both SQL Server-specific settings and Linux system configurations. Here we’ll discuss the adjustments and settings unique to the Linux environment.<\/p>\n\n\n\n

SQL Server Configurations on Linux<\/strong><\/h2>\n\n\n\n

When it comes to configuring SQL Server on Linux, the process intertwines with the native features and tools of the Linux operating system, offering a distinct experience from its Windows counterpart. This fusion of technologies demands a comprehensive approach to configuration that respects the intricacies of both platforms.<\/p>\n\n\n\n

Network Configuration<\/strong><\/p>\n\n\n\n

Linux provides a suite of powerful network configuration tools that give you granular control over how SQL Server communicates within your network. Unlike Windows, where network settings are often managed through a graphical interface, Linux requires you to engage directly with configuration files or command-line utilities. This is critical for ensuring that SQL Server has the necessary network throughput, a non-negotiable for peak performance, especially when dealing with distributed environments where data needs to flow seamlessly across different nodes.<\/p>\n\n\n\n

File System Considerations<\/strong><\/p>\n\n\n\n

SQL Server on Linux broadens its horizons by supporting multiple file systems, with EXT4 and XFS being prominent choices. Each file system comes with its own set of benefits; EXT4 is renowned for its robustness and wide usage, while XFS is often preferred for handling large data sets due to its scalability and performance. The selection of a file system affects not just how data is stored and retrieved, but also how it’s managed day-to-day. Therefore, the choice should align with your performance needs and management preferences.<\/p>\n\n\n\n

Directory Structure<\/strong><\/p>\n\n\n\n

The directory structure in SQL Server on Linux also deviates from what you might be accustomed to in Windows. Understanding this structure is more than just a matter of navigation; it’s about mastering the environment where your databases live. This knowledge becomes particularly vital when you’re setting up file management strategies, planning backups, or architecting your disaster recovery processes. The directory structure dictates where your files should reside and how they can be protected and recovered in case of system failures.<\/p>\n\n\n\n

Case Sensitivity<\/strong><\/p>\n\n\n\n

Linux treats file names and other identifiers with case sensitivity, a stark contrast to Windows. This characteristic extends to SQL Server on Linux, where database names, table names, and other object identifiers distinguish between uppercase and lowercase characters. Such an environment demands strict naming conventions to avoid potential mishaps during database operations. A simple mismatch in case can lead to unexpected behaviors, making diligent attention to detail a cornerstone of working with SQL Server on Linux.<\/p>\n\n\n\n

Using mssql-conf<\/strong><\/p>\n\n\n\n

The mssql-conf<\/strong> utility emerges as the central toolkit for SQL Server configuration on Linux. This command-line utility is your gateway to a multitude of settings including memory limits, network configurations, and file path specifications. Whether you’re allocating memory or redirecting log files, mssql-conf<\/strong> offers a consistent and straightforward interface for managing SQL Server settings, embodying the Linux ethos of powerful command-line tools for administration.<\/p>\n\n\n\n

System-Level Optimizations for SQL Server on Linux<\/strong><\/h2>\n\n\n\n

Optimizing SQL Server performance on Linux involves a blend of SQL-specific adjustments and broader system-level configurations. The latter can have a substantial influence on how effectively SQL Server operates. Let\u2019s unpack these optimizations and understand their impact:<\/p>\n\n\n\n

I\/O Scheduler<\/strong><\/p>\n\n\n\n

Linux I\/O schedulers can dramatically affect SQL Server\u2019s ability to read and write data to disk. Different schedulers are designed with various workload patterns in mind. For instance, the deadline<\/strong> scheduler can minimize latency for transactional databases, while cfq<\/strong> (Completely Fair Queuing) might be more suitable for batch processing. It\u2019s about matching the scheduler to the specific demands of your SQL Server workload to ensure that I\/O operations are handled as efficiently as possible.<\/p>\n\n\n\n

NUMA Configuration<\/strong><\/p>\n\n\n\n

On systems with multiple CPUs, SQL Server can benefit from an optimized Non-Uniform Memory Access (NUMA) configuration. By carefully aligning memory and processor affinity, you can enhance the effectiveness of CPU caches and memory access times. SQL Server on Linux respects NUMA boundaries, and tuning these settings can lead to better scalability and performance, particularly for large, high-traffic databases.<\/p>\n\n\n\n

Transparent Huge Pages (THP)<\/strong><\/p>\n\n\n\n

While Transparent Huge Pages can improve memory performance by allowing the system to use larger pages, they may cause issues with database workloads that have varied memory access patterns. Disabling THP can prevent performance issues related to memory management, such as increased latency due to page defragmentation, which can be particularly detrimental to SQL Server performance.<\/p>\n\n\n\n

Swappiness<\/strong><\/p>\n\n\n\n

The swappiness parameter controls the balance between swapping out runtime memory to disk and dropping the contents of the cache. A lower swappiness value can be beneficial for SQL Server, as it reduces the likelihood of swapping out memory pages that SQL Server might need to access frequently. This can ensure that more memory is kept available for SQL Server\u2019s use, enhancing its in-memory processing capabilities.<\/p>\n\n\n\n

File System Mount Options<\/strong><\/p>\n\n\n\n

Mounting file systems with options tailored for SQL Server can reduce disk I\/O overhead. For example, using the noatime<\/strong> option prevents the system from updating the access time for a file with each read operation, thereby reducing write operations to the disk. This is a simple yet effective tweak to diminish unnecessary disk access and can be particularly beneficial for databases with heavy read patterns.<\/p>\n\n\n\n

Network Configuration<\/strong><\/p>\n\n\n\n

Optimizing network settings involves tuning parameters such as TCP buffer sizes to accommodate the large amounts of data that SQL Server may transfer over the network. Enhanced network configuration can lead to improved throughput and reduced latency, ensuring that SQL Server\u2019s communication with clients and other servers is both swift and reliable.<\/p>\n\n\n\n

Resource Limits<\/strong><\/p>\n\n\n\n

Using the ulimit<\/strong> command, you can set limits on the resources available to the SQL Server process. This encompasses memory, file descriptors, and other system resources. Establishing sensible limits ensures that SQL Server has access to the resources it needs while also preventing it from consuming so much that it impacts the overall stability of the system.<\/p>\n\n\n\n

Kernel Parameters<\/strong><\/p>\n\n\n\n

The \/etc\/sysctl.conf<\/strong> file holds settings that affect the kernel\u2019s behavior. Tuning these parameters allows you to fine-tune how the system handles memory allocation, network traffic, and more. Adjustments here should be made with care, as they can have wide-reaching effects on system behavior.<\/p>\n\n\n\n

Disk and File System Alignment<\/strong><\/p>\n\n\n\n

Ensuring that your file system and storage are correctly aligned can lead to better disk I\/O performance. Misalignment can cause increased latency and reduced throughput, as the system may need to perform extra work to complete I\/O operations. Proper alignment is especially critical for SSDs and SAN storage where the underlying hardware operates with specific block size requirements.<\/p>\n\n\n\n

Memory Management<\/strong><\/p>\n\n\n\n

Memory overcommit settings in Linux determine how the kernel handles memory allocation requests from processes. SQL Server can perform best when these settings are configured to prevent overcommitting memory, which ensures that memory is not promised to processes without being available. Additionally, configuring huge page settings to align with SQL Server\u2019s memory patterns can provide performance improvements by allowing the use of larger memory pages.<\/p>\n\n\n\n

Conclusion<\/strong><\/h2>\n\n\n\n

SQL Server\u2019s compatibility with Linux opens up a world of possibilities for systems that can harness the power of both platforms. Advanced configuration and system-level optimizations are key to unlocking the full potential of SQL Server on Linux. By carefully considering and implementing these system-level changes, you can fine-tune the environment in which SQL Server operates on Linux. These optimizations lay the groundwork for a stable, high-performing SQL Server deployment that can handle the demands of modern enterprise workloads.<\/p>\n","protected":false},"excerpt":{"rendered":"

Following our initial exploration of installing SQL Server on Ubuntu 22.04, we delve into the intricacies of advanced configuration on Linux. This post aims to provide DBAs and system administrators with a better understanding of the configurations specific to Linux environments that enhance SQL Server performance. Configuring SQL Server on Linux requires consideration of both SQL Server-specific settings and Linux system configurations. Here we’ll discuss the adjustments and settings unique to the Linux environment.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[6,5,20],"tags":[9,10,7,52],"class_list":["post-239","post","type-post","status-publish","format-standard","hentry","category-memory","category-performance","category-sql-server-on-linux","tag-buffer","tag-cache","tag-memory","tag-sql-server-performance"],"yoast_head":"\nOptimizing SQL Server Performance on Linux: Beyond the Basics - SQL Table Talk<\/title>\n<meta name=\"description\" content=\"Following our initial exploration of installing SQL Server on Ubuntu 22.04, we delve into the intricacies of advanced configuration on Linux. This post aims to provide DBAs and system administrators with a better understanding of the configurations specific to Linux environments that enhance SQL Server performance. Configuring SQL Server on Linux requires consideration of both SQL Server-specific settings and Linux system configurations. Here we'll discuss the adjustments and settings unique to the Linux environment.\" \/>\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.sqltabletalk.com\/?p=239\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Optimizing SQL Server Performance on Linux: Beyond the Basics - SQL Table Talk\" \/>\n<meta property=\"og:description\" content=\"Following our initial exploration of installing SQL Server on Ubuntu 22.04, we delve into the intricacies of advanced configuration on Linux. This post aims to provide DBAs and system administrators with a better understanding of the configurations specific to Linux environments that enhance SQL Server performance. Configuring SQL Server on Linux requires consideration of both SQL Server-specific settings and Linux system configurations. Here we'll discuss the adjustments and settings unique to the Linux environment.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqltabletalk.com\/?p=239\" \/>\n<meta property=\"og:site_name\" content=\"SQL Table Talk\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-05T13:55:00+00:00\" \/>\n<meta name=\"author\" content=\"Stephen Planck\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Stephen Planck\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=239#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=239\"},\"author\":{\"name\":\"Stephen Planck\",\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0\"},\"headline\":\"Optimizing SQL Server Performance on Linux: Beyond the Basics\",\"datePublished\":\"2024-01-05T13:55:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=239\"},\"wordCount\":1295,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0\"},\"keywords\":[\"Buffer\",\"cache\",\"memory\",\"SQL Server performance\"],\"articleSection\":[\"Memory\",\"Performance\",\"SQL Server on Linux\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.sqltabletalk.com\/?p=239#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=239\",\"url\":\"https:\/\/www.sqltabletalk.com\/?p=239\",\"name\":\"Optimizing SQL Server Performance on Linux: Beyond the Basics - SQL Table Talk\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/#website\"},\"datePublished\":\"2024-01-05T13:55:00+00:00\",\"description\":\"Following our initial exploration of installing SQL Server on Ubuntu 22.04, we delve into the intricacies of advanced configuration on Linux. This post aims to provide DBAs and system administrators with a better understanding of the configurations specific to Linux environments that enhance SQL Server performance. Configuring SQL Server on Linux requires consideration of both SQL Server-specific settings and Linux system configurations. Here we'll discuss the adjustments and settings unique to the Linux environment.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=239#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqltabletalk.com\/?p=239\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=239#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqltabletalk.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Optimizing SQL Server Performance on Linux: Beyond the Basics\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqltabletalk.com\/#website\",\"url\":\"https:\/\/www.sqltabletalk.com\/\",\"name\":\"SQL Table Talk\",\"description\":\"Breaking Down SQL Server, One Post at a Time.\",\"publisher\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqltabletalk.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0\",\"name\":\"Stephen Planck\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/64181114edc3de3d99072c049bcec024f025c9536dc89fc8ff1bac58976ca81e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/64181114edc3de3d99072c049bcec024f025c9536dc89fc8ff1bac58976ca81e?s=96&d=mm&r=g\",\"caption\":\"Stephen Planck\"},\"logo\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/dexterwiki.com\",\"https:\/\/www.linkedin.com\/in\/stephen-planck-4611b692?trk=people-guest_people_search-card&challengeId=AQErf8gbBmcVMwAAAYsyIsxO-0UvU8z7cHrBpZoo_n3xt9qEKpRN5B_jd_LmAMu-OfeArkQ7GDjobJ2uRoQQV35EQdh_rR6kxA&submissionId=09de7067-c335-8e17-40b8-8dc32b60ed6c&challengeSource=AgEcUCw35zpPmAAAAYsyI4vAWhJTV7Nt4vZYKc3V1qiDBpCkKgUvtlOBgYXcE84&challegeType=AgE_wZiTT09IAQAAAYsyI4vDmNvbZIYe6XHju5V2bXVvM3IVxnJslgY&memberId=AgESFTkUShzs_gAAAYsyI4vGYk0Gic1uc5kB6cKOABA26Gw&recognizeDevice=AgHdSZyUSI5CEwAAAYsyI4vKd_koF9JgpsCJShT8QfbK1QMiv8SI\",\"https:\/\/www.youtube.com\/linuxmate\"],\"url\":\"https:\/\/www.sqltabletalk.com\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Optimizing SQL Server Performance on Linux: Beyond the Basics - SQL Table Talk","description":"Following our initial exploration of installing SQL Server on Ubuntu 22.04, we delve into the intricacies of advanced configuration on Linux. This post aims to provide DBAs and system administrators with a better understanding of the configurations specific to Linux environments that enhance SQL Server performance. Configuring SQL Server on Linux requires consideration of both SQL Server-specific settings and Linux system configurations. Here we'll discuss the adjustments and settings unique to the Linux environment.","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.sqltabletalk.com\/?p=239","og_locale":"en_US","og_type":"article","og_title":"Optimizing SQL Server Performance on Linux: Beyond the Basics - SQL Table Talk","og_description":"Following our initial exploration of installing SQL Server on Ubuntu 22.04, we delve into the intricacies of advanced configuration on Linux. This post aims to provide DBAs and system administrators with a better understanding of the configurations specific to Linux environments that enhance SQL Server performance. Configuring SQL Server on Linux requires consideration of both SQL Server-specific settings and Linux system configurations. Here we'll discuss the adjustments and settings unique to the Linux environment.","og_url":"https:\/\/www.sqltabletalk.com\/?p=239","og_site_name":"SQL Table Talk","article_published_time":"2024-01-05T13:55:00+00:00","author":"Stephen Planck","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Stephen Planck","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.sqltabletalk.com\/?p=239#article","isPartOf":{"@id":"https:\/\/www.sqltabletalk.com\/?p=239"},"author":{"name":"Stephen Planck","@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0"},"headline":"Optimizing SQL Server Performance on Linux: Beyond the Basics","datePublished":"2024-01-05T13:55:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sqltabletalk.com\/?p=239"},"wordCount":1295,"commentCount":0,"publisher":{"@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0"},"keywords":["Buffer","cache","memory","SQL Server performance"],"articleSection":["Memory","Performance","SQL Server on Linux"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.sqltabletalk.com\/?p=239#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.sqltabletalk.com\/?p=239","url":"https:\/\/www.sqltabletalk.com\/?p=239","name":"Optimizing SQL Server Performance on Linux: Beyond the Basics - SQL Table Talk","isPartOf":{"@id":"https:\/\/www.sqltabletalk.com\/#website"},"datePublished":"2024-01-05T13:55:00+00:00","description":"Following our initial exploration of installing SQL Server on Ubuntu 22.04, we delve into the intricacies of advanced configuration on Linux. This post aims to provide DBAs and system administrators with a better understanding of the configurations specific to Linux environments that enhance SQL Server performance. Configuring SQL Server on Linux requires consideration of both SQL Server-specific settings and Linux system configurations. Here we'll discuss the adjustments and settings unique to the Linux environment.","breadcrumb":{"@id":"https:\/\/www.sqltabletalk.com\/?p=239#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqltabletalk.com\/?p=239"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqltabletalk.com\/?p=239#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqltabletalk.com\/"},{"@type":"ListItem","position":2,"name":"Optimizing SQL Server Performance on Linux: Beyond the Basics"}]},{"@type":"WebSite","@id":"https:\/\/www.sqltabletalk.com\/#website","url":"https:\/\/www.sqltabletalk.com\/","name":"SQL Table Talk","description":"Breaking Down SQL Server, One Post at a Time.","publisher":{"@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqltabletalk.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0","name":"Stephen Planck","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/64181114edc3de3d99072c049bcec024f025c9536dc89fc8ff1bac58976ca81e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/64181114edc3de3d99072c049bcec024f025c9536dc89fc8ff1bac58976ca81e?s=96&d=mm&r=g","caption":"Stephen Planck"},"logo":{"@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/dexterwiki.com","https:\/\/www.linkedin.com\/in\/stephen-planck-4611b692?trk=people-guest_people_search-card&challengeId=AQErf8gbBmcVMwAAAYsyIsxO-0UvU8z7cHrBpZoo_n3xt9qEKpRN5B_jd_LmAMu-OfeArkQ7GDjobJ2uRoQQV35EQdh_rR6kxA&submissionId=09de7067-c335-8e17-40b8-8dc32b60ed6c&challengeSource=AgEcUCw35zpPmAAAAYsyI4vAWhJTV7Nt4vZYKc3V1qiDBpCkKgUvtlOBgYXcE84&challegeType=AgE_wZiTT09IAQAAAYsyI4vDmNvbZIYe6XHju5V2bXVvM3IVxnJslgY&memberId=AgESFTkUShzs_gAAAYsyI4vGYk0Gic1uc5kB6cKOABA26Gw&recognizeDevice=AgHdSZyUSI5CEwAAAYsyI4vKd_koF9JgpsCJShT8QfbK1QMiv8SI","https:\/\/www.youtube.com\/linuxmate"],"url":"https:\/\/www.sqltabletalk.com\/?author=1"}]}},"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/posts\/239","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=239"}],"version-history":[{"count":1,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/posts\/239\/revisions"}],"predecessor-version":[{"id":240,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/posts\/239\/revisions\/240"}],"wp:attachment":[{"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=239"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=239"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=239"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}