Changing Linked Server Properties (SQLServerCentral 9/3/2018)

[SQLServerCentral - www.sqlservercentral.com]( A community of more than 1,600,000 database professionals and growing Featured Contents - [Changing Linked Server Properties]( - [SQL in the City Streamed: September 5 2018]( - [Introduction to HIPAA and SOX]( - [SQL in the City Summit]( (From the SQLServerCentral Blogs) - [NFL Football Player Stats & Analysis 2018 is now available!]( (From the SQLServerCentral Blogs) Featured Script - [FK_Add_Drop_Constraints_AllDBs]( The Voice of the DBA Labor Day 2018 Today is Labor Day in the US, and it's almost always been a holiday for me since I've been working in technology. When I worked in the restaurant business, that was another story as this was usually the last big weekend of the summer before kids went to school and I almost always had to work. I'm back working today. With the schedule this year for [SQL in the City](, I needed to be over here and prepping. It's also time for me to meet with the product teams for feedback and understanding of where they're going in their plans. So, if you have complaints, criticisms, or suggestions, drop them in the discussion. I have meetings all week with different groups, so I'll bring up any big issues. If someone posts your idea, a nice +1 helps me understand the scale of the issue. Labor Day was set as a holiday for workers, a national holiday that most employers observe. There are different dates for other countries, but quite a few have the same holiday. That being said, plenty of people still need to work, especially in service jobs. Hopefully many of you have this day off, but if not, I hope it's an easy day for you with the US somewhat shut down. If not, maybe you can convince your boss to let you tune into SQL in the City this Wednesday. Steve Jones from [SQLServerCentral.com]( Join the debate, and [respond to today's editorial on the forums]( ADVERTISEMENT [SQL Monitor]( What’s the top challenge faced by SQL Server professionals in 2018? Learn how 626 SQL Server professionals monitor their estates in our new report on the State of SQL Server Monitoring. Discover the challenges currently facing the industry, and what is coming next. [Download your free copy of the report]( [Webinar]( SQL in the City Streamed SQL in the City Streamed returns with the theme ‘Adapt and thrive as a data professional’. The schedule includes sessions designed to broaden your skillset, support your ongoing learning, and keep you up-to-date with what’s new in the industry and at Redgate. [Register now]( Featured Contents  [] [Changing Linked Server Properties]( David Fundakowski from [SQLServerCentral.com]() A quick guide on changing the linked server properties and settings.[More »](Servers/142270/) ---------------------------------------------------------------  [] [SQL in the City Streamed: September 5 2018]( Our all-star speaker line-up of Microsoft MVPs and Redgate team members will be running sessions on the theme ‘Adapt and thrive as a data professional’.[More »]( ---------------------------------------------------------------  [] [Introduction to HIPAA and SOX]( Additional Articles from [SimpleTalk]() Despite the attention to data privacy and protection caused this year because of the GDPR, regulations governing how data is handled are nothing new. In this article, Robert Sheldon provides an overview of two US regulations, HIPAA and SOX, and explains how these regulations affect DBAs.[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [SQL in the City Summit]( Grant Fritchey from [SQLServerCentral Blogs]( This fall, in October, Redgate Software will be hosting three, live, in-person events. These events will take place in New...[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [NFL Football Player Stats & Analysis 2018 is now available!]( Dustin Ryan from [SQLServerCentral Blogs]( I’ve had a lot of people ask me for this over the past few months and its finally (mostly) ready!...[More »]( Question of the Day Today's Question (by Steve Jones): What happens when this code is run? DECLARE @d DATETIMEOFFSET , @c VARCHAR(20) ; SELECT @c = '20180903' ; SELECT @d = @c ; SELECT @d ; Think you know the answer? [Click here](, and find out if you are right. --------------------------------------------------------------- We keep track of your score to give you bragging rights against your peers. This question is worth 1 point in this category: implicit conversion. We'd love to give you credit for your own question and answer. To submit a QOTD, simply log in to the [Contribution Center](. ADVERTISEMENT [Microsoft SQL Server 2017 on Linux]( [This comprehensive guide shows, step-by-step, how to set up, configure, and administer SQL Server 2017 on Linux for high performance and high availability. Written by a SQL Server expert and respected author, Microsoft SQL Server 2017 on Linux teaches valuable Linux skills to Windows-based SQL Server professionals. You will get clear coverage of both Linux and SQL Server and complete explanations of the latest features, tools, and techniques. Get your copy from Amazon today](. Yesterday's Question of the Day Yesterday's Question (by Steve Jones): What does DBCC OUTPUTBUFFER() return? Answer: The hexadecimal code and ASCII results of the output buffer for a spid Explanation: The DBCC OUTPUTBUFFER command returns the hex and ASCII values from the output buffer of a spid, along with an ordering row column. Here is a sample call. Ref: DBCC OUTPUTBUFFER - [click here]( --------------------------------------------------------------- [» Discuss this question and answer on the forums]( Featured Script [FK_Add_Drop_Constraints_AllDBs]( Aswini G from [SQLServerCentral.com]() Run the script against your server, Please be careful while running the script on prodcution servers. [More »]( 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]( : [SQL Server 2017 - Development]( [Can't Get BULK INSERT TO ERROR!!!]( - Hello guy, I was testing my script for bulk insert. But i can't get the rows to error out and... [Convert Varchar field]( - I have a Varchar field with units in inches :( that i need to convert to an integer (Unfortunately the " and... [Insert with dynamic SQL and Cursor for variable table/columns according to update list]( - Hi! I have a bit of a problem for a while. I have updated tables in Database A. These tables gets... --------------------------------------------------------------- [SQL Server 2016]( : [SQL Server 2016 - Administration]( [Interesting question about NCI's when converting HEAPs to CI's]( - I've not run into it before because I don't create permanent tables as HEAPs to begin with. I've also not... [Mirroring Failover]( - I have question, Server A is mirrored to Server B when the failover is done server B would be principal and... --------------------------------------------------------------- [SQL Server 2016]( : [SQL Server 2016 - Development and T-SQL]( [How to Generate a common unique column for multiple views]( - I created 3 different views and I need a common column to join these 3 views. There is an AMOUNT... [Order of Clustered Index]( - Let's say, hypothetically, I have a table with three columns--LastName, FirstName, MiddleName and I wanted to create a clustered index... [PIVOT]( - I need help with SQL PIVOT Example SELECT Manufacturer, CarType FROM Vehicles Manufacture     Cartype Ford            SportsCar GM             Truck Ford   --------------------------------------------------------------- [SQL Server 2012]( : [SQL 2012 - General]( [RAC like capability for SQL 2012]( - Hi, Good day everyone just want to ask if sql server 2012 has a capability of load balancing just like what... --------------------------------------------------------------- [SQL Server 2008]( : [SQL Server Newbies]( [Balancing Writes]( - Good Morning Experts, Here is the requirement from client: They have a server A and they want exact replica of server... --------------------------------------------------------------- [Cloud Computing]( : [SQL Azure - Administration]( [SQL Server 2016 SP1 (Azure IaaS) slower than SQL 2008 SP2 on premise]( - I have an issue with a stored proc that uses a cursor (yes, I KNOW THIS ISN'T GOOD) however it... 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](. Feel free to forward this to any colleagues that you think might be interested. If you have received this email from a colleague, you can register to receive it [here](. --------------------------------------------------------------- This transmission is ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. Contact: webmaster@sqlservercentral.com