Upgrading SQL Server vNext on Red Hat Linux to latest available update (MSSQLTips 03/13/2017)

[MSSQLTips.com]( Cannot see this MSSQLTips.com newsletter? [] [View in browser]( [DBArtisan - The team-enabled cross-platform database administration solution]( [Upgrading SQL Server vNext on Red Hat Linux to latest available update]( Microsoft released an update for SQL Server on Linux from CTP 1 to CTP1.1. In his tip I will let you know how to upgrade to CTP 1.1 for SQL Server vNext on Linux.... By Manvendra Singh - [Learn More]( [Building a Strong Reference List to Get You Hired]( Learn eight recommendations for obtaining and supplying professional references to improve your changes of getting hired for your next SQL Server opportunity.... By Erica Woods - [Learn More]( [Webcast - Improving Data Consistency with Models with ER/Studio]( In this webcast we will demonstrate several methods for making your data more consistent with data models, including naming standards, data dictionaries, and more. ... [Learn More]( [Create a High Performance SANLess SQL Server Cluster]( Making SQL Server deployments resilient to failures is a goal most want to achieve. Whether you are trying to account for high availability and/or disaster recovery, there are various methods to achieve the end goal. One of the most popular approache... [Learn More]( [SQL Server Profiler Tutorial]( SQL Profiler is a tool that provides a user interface to the SQL Trace utility which gathers events as they occur in your SQL Server instance. It gives you the ability to monitor everything that is going on inside your SQL Server instance.... [Learn More]( MSSQLTips Week In Review [Configure SQL Server on Linux]( You installed SQL Server on Linux and need to customize the default installation, for instance change its default port, instance collation or even add trace flags. In this tip I will show you how easy it is.... By Daniel Farina - [Learn More]( [How to change default port for SQL Server on Linux]( Microsoft released SQL Server to run on Linux servers. To secure the database environment, DBA's often change the SQL Server port from its default port 1433 to another available port number. In this tip we will see how can we make this change for SQL Serv... By Rajendra Gupta - [Learn More]( [Improve SQL Server Table Variable Performance Using Trace Flag 2453]( How can we improve the performance of the queries that use SQL Server table variables? Read this tip to learn about Trace Flag 2453.... By Ahmad Yaseen - [Learn More]( [Inserting Rows into SQL Server from a Java Program]( In this tip we cover how to write a Java program to connect to a SQL Server database using Windows authentication and insert a row into a database table using the INSERT command.... By Dallas Snider - [Learn More]( [Introduction to PolyBase in SQL Server 2016 - Part 2]( In a previous tip on SQL Server 2016 Features in CTP2, one of the new features introduced was PolyBase. Our organization is thinking of deploying Big Data solutions running on the Apache Hadoop platform and I wanted to know how I can use PolyBase to perfo... By Edwin Sarmiento - [Learn More]( [Introduction to Scrum for your database projects]( We are working on a new project which involves change in requirements and scope frequently. The Waterfall methodology doesn't help and we need something (Scrum) which can adapt to changes and enable a quick delivery.... By Parvathy Natraj - [Learn More]( [Microsoft 70-765 Exam Materials - Provisioning SQL Databases]( I am planning to take the Microsoft 70-765 exam on Provisioning SQL Databases. Do you have tips for preparing for this exam? Can you provide a study guide for the Microsoft 70-765 exam? What are the key technologies that I need to study in order to pass... By Daniel Calbimonte - [Learn More]( [PowerShell Commands for SQL Server Reporting Services]( In this tip we look at PowerShell commands you can use to manage SQL Server Reporting Services.... By Aaron Nelson - [Learn More]( [Solving Table Drop Error Related to SQL Server Replication's sp_MStran_ddlrepl]( We were recently trying to drop a SQL Server table in a subscriber database that did not receive replicated data, but threw an error as if the table did. The error, " Msg 15021, Level 16, State 1, Procedure sp_MStran_ddlrepl, Line 14 Invalid value given f... By Tim Smith - [Learn More]( [SQL Server sp_execute_external_script Stored Procedure Examples]( The sys.sp_execute_external_script is a new system stored procedure introduced in SQL Server 2016. It intends to execute any provided script at an external location. Microsoft says the script must be written in a supported and registered language, but act... By Vitor Montalvao - [Learn More]( [Twitter]( [Facebook]( [LinkedIn]( [GooglePlus]( You are receiving this email as a subscriber of MSSQLTips.com. If you do not wish to continue receiving email from MSSQLTips.com, please send us an email to [unsubscribe](mailto:unsubscribe@mssqltips.com?subject=UNSUBSCRIBE). Edgewood Solutions LLC | PO Box 682 | Wilton, NH 03086 | [Privacy Statement]( Sent to this e-mail address: {EMAIL}