Replicate NetSuite Data to Azure SQL (SSIS in Azure Data Factory) (2020-07-17)

 SQLServerCentral Newsletter for July 17, 2020 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Replicate NetSuite Data to Azure SQL (SSIS in Azure Data Factory)]( - [Hands-On with Columnstore Indexes: Part 2 Best Practices and Guidelines]( - [6 New Courses Published on the Redgate University]( - [From the SQL Server Central Blogs - On Dynamic Ports, Named Instances, and Firewalls]( - [From the SQL Server Central Blogs - Don’t be afraid of No]( Question of the Day - [Logging Event Permissions]( The Voice of the DBA  Daily Coping Tip Challenge negative thoughts, find an alternative interpretation For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from [The Action for Happiness Coping Calendar](. My items will be on [my blog](, feel free to share yours. Your Data After Life A friend and colleague died recently. It was a shock to me to hear about someone that I'd sat down with, shared a drink and good conversation last year had passed. Another went into the hospital recently for emergency surgery. As I get older, these events have more impact and meaning for me than they ever have in the past. I've often said this at the end of one of my presentations: We work to live, we don't live to work. Life can be short, and we ought to make the most of it that we can. We also need to balance our work, our contributions to society, our family life, our personal desires, our faith, and more to find a path through life. I've had too many friends die in their 40s or 50s to not think about my own mortality often. I'm over 50 and I'm more than half way through my life. Losing family and friends is hard, but it's also something we go through. There's a lot of work when someone dies, and as the world gets more complex and digital, that are no considerations and concerns. We have online accounts, credentials, and other digital assets to worry about these days, and we need to have a plan in place. While it can be hard to get access to a bank account or transfer the ownership or a house or car to yourself, you might not have any good way to get into someone's email, phone, or other account. I'm reminded of the need to not only have a will filed and accessible for my wife and children, but I also need to ensure they know where to go for credentials. There are lots of options, but this is something that requires a bit of preparation and planning, both for sharing information and keeping your digital assets secure. I don't have a great plan to share, but it is something I'm working on for myself. If you have family that you want to leave any digital assets to, you might do so as well. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [Replicate NetSuite Data to Azure SQL (SSIS in Azure Data Factory)]( jerodj from SQLServerCentral.com With Azure Data Factory V2 Integration Runtimes (ADFv2 IR), you can deploy enterprise replication tasks to the Azure cloud. [Hands-On with Columnstore Indexes: Part 2 Best Practices and Guidelines]( Additional Articles from SimpleTalk In the second article of this series, Edward Pollack demonstrates some ways to design and populate a columnstore index to get even better performance. [6 New Courses Published on the Redgate University]( Additional Articles from Redgate Master the fundamentals of Redgate products with easy to follow video courses on Redgate University. This month 6 new courses have been published to help you advance your skills including courses on SQL Prompt, SQL Monitor, SQL Change Automation, SQL Compare, and Database DevOps for Oracle. All brought to you by some amazing presenters like Kendra Little, Grant Fritchey, Kathi Kellenberger and the Redgate team of experts. Start learning now! From the SQL Server Central Blogs - [On Dynamic Ports, Named Instances, and Firewalls]( Will Assaf from SQL Tact Recently I had a client and their vendor trying to configure a firewall for a new installation of SQL Server 2019 on Windows Server 2019.Connections to the SQL Server... From the SQL Server Central Blogs - [Don’t be afraid of No]( jphillips 46546 from Another SQL Geek How many times have you been afraid to hear “No”? We have all been there because we have been trained over the years to perceive “No” as a rejection,...   Question of the Day Today's question (by Steve Jones - SSC Editor):  Logging Event Permissions I want to allow a user to use the xp_logevent procedure to log messages in the log for various events from an application. What rights do I need to give this user to do this? 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) Do I need a restart? I have been using sp_configure to change some settings for my instance. I know I need to run RECONFIGURE to change the option, but how can I tell if I need a restart? Answer: You can query sys.configurations and the is_dynamic column Explanation: There is an is_dynamic column in sys.configurations that lets you know if this option can be dynamically changed. Ref: sys.configurations - [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 [What do you like for third party database backup/restore for SQL server & Azure]( - Hi all, my company currently uses SQL server native tools to perform nightly backups.  We are a small company and unfortunately do not have an actual DBA - our network admin and group of developers are working together on the backups.  But we are looking into other vendors, such as RedGate's SQLBackupPro, Idera's SQL […] [Disk space]( - I noticed the system volume information is consuming the disk space on database server log drive. Also found that shadow copy is disabled but maximum size is not configured to use limit. My understanding is that during the setup of server someone would have not configured properly to use limit. Do you agree with me? […] SQL Server 2017 - Development [Find the last occurrence of \ character and get the left of string.]( - How to find the last occurrence of '\' in the following string and get left part of it? DECLARE @V VARCHAR(max)='O:\Z\P_Metrics\Inbox\07-13-20200702_abc_enroll.csv' DECLARE @V1 VARCHAR(max)='O:\Z\P_Metrics\Inbox\07-14-20200702_abc_complete_enroll.csv' The Final output I need is O:\Z\P_Metrics\Inbox. Thanks in advance. [Creating a Dimension with no Primary Key]( - Hi all, I'm rebuilding some cubes in SQL Server 2017 using Visual Studio and SSAS. The cubes were originally constructed in SQL 2000. It's been going well so far until I try to recreate a "Calculated Time" dimension that worked so well in the old build. The dimension table was linked to the fact table […] SQL Server 2016 - Administration [Migrate database with encrypted columns to SQL 2016]( - Hi all, I need to migrate a SQL 2012 database that has a few tables with encrypted columns, to a SQL 2016 instance. I have done this same process between two 2012 instances, and it always worked, but I am unable to do so with 2016. Below is the code I run after I restore […] SQL Server 2016 - Development and T-SQL [Code signing a dll with certificate for use in SQL Server 2016]( - I have a dll that will perform some webservice calls function. in order to use in SQLServer 2016 i would like to create a user called sqlex from a certificate. When I try to do this I get the below error: USE [master] GO /****** Object: Login [sqlRext] Script Date: 10/07/2020 12:06:30 ******/ CREATE LOGIN […] [Find whether a clustered index is actually unique]( - Hi  I have a table that has a clustered index on it The table does not have a primary key and the clustered index has not been defined as unique There are approximately 3B rows in the table It's been around for years and I'm wondering why neither a PK or a unique clustered […] [temp table performance in sql 2016]( - HI everyone, I just restored a DB on sql2016 from sql2012. One of my sql queries that heavily uses temp tables is running 3x slowin sql 2016 . I am still baffled with this performance degradation. I read some articles on google to set Compatibility level to 2012 (110) and Legacy Cardinality Estimation to TRUE […] [Isnull in a Where Clause]( - Dear friends, We used Stored Procedure on our Queries for us to get valuee we Put the conversion of ISNULL inside the WHERE condition but per checking it affects the Process of our strodproc, it is not using indexes, never index seek always table scan. For example, SELECT * FROM tblInfo WHERE fldinfo=ISNULL(@parameter,fldinfo) What's your […] Administration - SQL Server 2014 [Create SQL Login to View only one database on server]( - Hi All, I have one task to create a login, and user need to view only One Database, there are 20 other databases but requirement is for the user to view only one database and only 5 tables from 1000 tables. I tried to create a login and give Server Role Public and Database role […] Development - SQL Server 2014 [To use the same function to pass table name as a parameter]( - I have this function, but I wanted to pass a table so as to use the same function to get the job done for multiple tables. For example, I want this function work for table1, and table2. But it is just for table1 currently. I was trying to use a dynamic sql in vain; it […] SQL Server 2012 - T-SQL [Nearest Proximity For every record]( - Hello! We have a query we are trying to build with a key component. All of our locations have a lat and long entered as own values in the table. We need to find out the nearest location to EACH building from all the other buildings. Another tricky part is we have to make sure […] SQL Server 2019 - Administration [SSRS - Certificate]( - Hi Team, When I am trying to configure web service URL, using HTTPS certificate I am getting an error as " Create Certificate binding error" I have installed SQL Server 2019 along with SQL Server 2019 reporting service from the link : Is this error related to any version issue? My SSRS product version […] SQL Server 2019 - Development [T-SQL decoder ring for Google BigQuery?]( - Sorry if this is in the wrong forum... feel free to move it. I'm okay with T-SQL, but BigQuery boggles my mind. Is there a good reference comparing the two somewhere? I was looking for a little bit of something sort of like an intro and recipes for converting between the two. thanks!  SQL Server 2008 - General [Join is faster?]( - I am using SQL server 2008. Is JOIN always faster than sub query ?   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -