Installing Ubuntu in Level 1 of the Stairway to SQL Server on Linux (2019-07-24)

 SQLServerCentral Newsletter for July 24, 2019 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Installing Ubuntu in Level 1 of the Stairway to SQL Server on Linux]( - [How to Enable SQL Server CLR Integration using T-SQL]( - [Do you really know what’s happening with your servers?]( - [Free eBook: Defensive Database Programming]( - [From the SQL Server Central Blogs - Adding a Column with a Default Constraint]( - [From the SQL Server Central Blogs - OUT OF SUPPORT: SQL Server 2008 and SQL Server 2008 R2]( Question of the Day - [Going from long to wide]( [Redgate SQL Monitor]( The Voice of the DBA  Evergreen SQL Server Colorado is a beautiful state, one that my family and I have enjoyed many times. We like the summer and winter outdoors, including lots of days skiing. We have plenty of trees on the slopes, which is both [great to view](2525255B3%2525255D.jpg) and a series of obstacles to avoid. Fortunately, the pines and spruces keep their needles all year round and are easy to spot. Recently I caught [a press release from Microsoft]( about the Azure SQL Server platform. It was written as support for SQL Server 2008 and R2 comes to an end. Microsoft certainly wants to pressure those customers to upgrade, as there are lots of them out there and this would be quite a bit of revenue. It's been nearly a decade since R2 and over that for SQL Server 2008. There are a few options Microsoft has for you, though [the move to an IaaS system in Azure with 3 years of support]( might be the only feasible one if you need support for some business reason. There are other options, and the post calls out some of these as evergreen SQL. Both the Managed Instance and Azure SQL Database are listed here, because there's no need to patch or upgrade these platforms. Microsoft handles this for you, though that's not necessarily as simple as you might expect. I don't know how vendors will deal with Microsoft upgrading code, but certainly your in-house applications that might be built with workarounds for the various bugs that people stumble upon need to be prepared to change code if the bugs fix and behavior changes. I do like the idea of not needing to patch SQL Server and having the code improve and grow. I also like the idea of my code working and not breaking. While Microsoft has noted they don't plan on removing functionality (deprecated just means there's a better way you should use), what about the features that have bugs and the current behavior needs to change? That can be challenging for in-house development teams, but also a hassle for ISVs. Perhaps this will get ISVs to write code that handles patches and upgrades. Perhaps this means that we won't get stuck on RTM or SP 1 of some old version of SQL Server because a vendor doesn't want to test and certify their system on patched code. Perhaps it also means they'll write the most basic, generic SQL that uses limited features and will work everywhere without them spending any resources verifying their code. I worry the latter more than the former will be the result of evergreen SQL Server. Do you want a version of SQL Server, as an instance, a database, or some hosted service that you never patch, but Microsoft does? I wonder how many of you look forward to evergreen SQL for your code. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums]( [Redgate University](   Featured Contents [Stairway to SQL Server on Linux]( [Installing Ubuntu in Level 1 of the Stairway to SQL Server on Linux]( Danilo Dominici from SQLServerCentral.com In this first article of the Stairway to SQL Server on Linux, learn how to set up your host server. [How to Enable SQL Server CLR Integration using T-SQL]( Additional Articles from MSSQLTips.com In this tip we look at how to enable SQL Server Common Runtime Language aka CLR using T-SQL commands. [Do you really know what’s happening with your servers?]( Additional Articles from Redgate As estates continue to grow and evolve, SQL Server professionals must continually adapt. But do you really know what’s happening with your servers? Jamie Wallis highlights the 4 key elements that are currently impacting the working life of an IT leader. Find out what they are here. [Free eBook: Defensive Database Programming]( Press Release from Redgate Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment. From the SQL Server Central Blogs - [Adding a Column with a Default Constraint]( matthew.mcgiffen 73574 from Matthew McGiffen DBA Last week a question came up about adding a column to a table, and giving that column a default constraint. Would that default value be assigned to all existing... From the SQL Server Central Blogs - [OUT OF SUPPORT: SQL Server 2008 and SQL Server 2008 R2]( GRE (Gethyn Ellis) from The SQL DBA in the UK Welcome to this post, on SQL Server 2008 and 2008 R2, both of these versions of SQL server will go out of extended support with Microsoft today! 9th July...   Question of the Day Today's question (by Steve Jones - SSC Editor):  Going from long to wide I have a dataframe of speakers and events across years. > speaking <- data.frame(ID = 1:3, expand.grid(Name = c("Steve", "Grant", "Kendra"), Year = 2015:2017), + Events = round(runif(9, 18, 35), 0) + ) I have the tidyverse library loaded and want to use the wide() command to change my dataframe. I run this. > widespeaking = speaking %>% spread(Year,Events) What size and shape of dataframe does this give me? Think you know the answer? [Click here]( and find out if you are right.    Yesterday's Question of the Day (by Steve Jones - SSC Editor) Multi column histograms In SQL Server 2017, if I create an index with 4 columns, the data from how many columns is used in the statistics histogram? Answer: 1 Explanation: The statistics histogram in SQL Server only uses the data from a single column. Ref: Statistics - [Discuss this question and answer on the forums](    Database Pros Who Need Your Help Here's a few of the new posts today on the forums. To see more, [visit the forums](. --------------------------------------------------------------- SQL Server 2017 - Administration [Existing logins get mapped to new databases]( - Pretty new with SQL but working my may up:-) When I create a new database all existing SQL-logins automatically get mapped to the new database. How to avoid that? I can remove them afterwards but since I'm about to add 60+ databases I will be a pain in the ass to remove them manually or […] [Grant permissions to execute jobs owned by user]( - Hey gurus, I'm novice to SQL Server and in need of your help! I need to create a SQL Login for use by few people to run jobs created by 'xyz' account. Is there an easy way to do this? I don't want to add them to the SQL Agent roles in MSDB as I […] SQL Server 2016 - Administration [SSMS connection attempt results in "Errors in the metadata manager. ..."]( - Hello experts, I have a colleague who's trying to connect to one of our dev database servers, and when they launch SQL Server Management Studio, they see this error after clicking connect: Errors in the metadata manager. Either the trace with the ID of 'MicrosoftProfilerTrace156...' does not exist in the server with the ID of […] [Db went to suspect in AG]( - One of my db went to suspect in secondary replica when i checked in events lock_redo_blocked , how can i trouble shoot these issue . In sql Logs we find deadlock info at that time  [Query to check the latest windows patch detaisl and last reboot]( - i need a query to check the latest windows patch details and last reboot of the server .any one help ?  Thanks [Geography methods causing syntax error in job]( - So...I'm trying to work with some geography in a job step. The entire step runs fine in the query window, but when put into the job the step fails. Here are a few examples from the job...does anything jump out? SET @point = (select "geo" FROM "objectLocation" where "objectId" = @objectId).MakeValid() SET @objarea = (select […] Administration - SQL Server 2014 [Non-yielding scheduler error in SQL-2014 with SP-3]( - Every once in a while we receive a "non-yielding scheduler" error in SQL Server 2014. We already upgraded to SP-3 which is suppose to resolve this issue. What exactly this error means? SQL Server doesn't crash immediately, but natively compiled stored procedures start faltering about 1-2 days following this error. What should be done to […] [AG secondary TEMPDB growing hugely]( - Hi, We configured the Alwayson on 3 servers. A -primary(Synchronous),B-Secondary-(Async-Readable),C-Secondary(Asyn-Not readable).Fail over mode is Manual. from 2 days the secondary server tempdb is growing hugely. When we checked the Primary server the tempdb is fine.Not growing. i am not able to understand why secondary server tempdb is growing hugely. Yesterday night we restarted the Secondary […] SQL Server 2012 - T-SQL [Convert smallint to Date]( - Hello! I have column in SQL 2012 DB of datatype smallint. Could you please let me know how to convert smallint to date? Here's the example of smallint data "12940".  Thanks. [TempDB filling up]( - Hello all, We have a SQL Server 2012 Enterprise SP1 running our ERP system.  We have 15 production databases with approx 570GB in size. Our Tempdb has an initial size of 100GB and sits on a 450GB drive. Every day it seems to grow in size until all 450GB is consumed in approx. 2-3 weeks. […] SQL Server 2008 - General [Remove SQL Server from Failover Cluster]( - Hi, I'm having a problem with a Windows Server 2008 R2 Failover Cluster with a SQL Server 2008 Instance losing connection to the shared storage disks. It's an all flash netapp san which has been working fine. To solve I was thinking about removing the SQL Instance from the failover cluster and just running the […] T-SQL (SS2K8) [Upsert operation between servers]( - Hello Everyone, We need to perform UpSert operation between multiple tables belongs to different server , can you please suggest any Technical design for this. Suppose a consultant made some changes in UAT at some point of time then later he wants to migrate same in Production. It may be a new records , updated […] SQL Azure - Administration [Managed Instance Error Creating Recurring Schedule - BUG???]( - When we try to create a SQL Server Agent job schedule that has a recurring frequency type we get the following error: SQL Server Agent feature Schedule job ONIDLE is not supported in SQL Database Managed Instance. Review the documentation for supported options. If we click ok to the message and then edit the unsaved […] SSRS 2014 [Page can't be displayed while accessing the Report server in other Computer]( - I have set up a Report Server in a Windows 10 client, everything is fine when you try to access it locally, but when I try to access it using another computer, "This page can't be displayed" is the only result that I get. I can ping the computer where the report server is installed, […] SQLServerCentral.com Website Issues [Unable to subscribe to newsletter using the email entered]( - I am one of those users that have not received a newsletter since the new site went active. Can you please reset my email to be OK? Thanks.   [RSS Feed]([Twitter]( This email has been sent to {EMAIL}. To be removed from this list, please click [here](. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com. ©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -