SQLServer Just tweeted ********************************************** @staceylevine Hi Stacey, you can use Derived Column transform component to replace a single value in the Expression. Sample Expression to replace a value in column UserName: UserName == "oldvalue" ? "newvalue" : UserName. Please let us know if this helps. Thanks! https://t.co/nLTckGpqNc
Twitter
Microsoft SQL Server
@staceylevine Hi Stacey, you can use Derived Column transform component to replace a single value in the Expression. Sample Expression to replace a value in column UserName: UserName == "oldvalue" ? "newvalue" : UserName. Please let us know if this helps.…
SQLServer Just tweeted ********************************************** @flyingcod We don't have an answer at this time, but stay tuned to our social channels for updates. Thanks!
SQLServer Just tweeted ********************************************** Let's discuss the top five benefits of Azure Dedicated Hosts for #SQLServer workloads. Read on: https://t.co/5GlH96r18T
TECHCOMMUNITY.MICROSOFT.COM
TOP 5 Benefits of Azure Dedicated Hosts (Preview) for SQL Server Workloads on Azure VMs
SQL Server on Azure virtual machines (SQL VM) enables migrating SQL Server workloads to the cloud at the lowest TCO [1]. You have the flexibility to choose version and edition of SQL Server and the operating system, VM type and size, and HADR deployment architecture.…
SQLServer Just tweeted ********************************************** @realeddiesson Hi Viktor, we don't have an answer at this time, but stay tuned to our social channels for upcoming news. Thanks!
SQLServer Just tweeted ********************************************** Do you know which #cloud migration strategy is right for you? Find the right plan and partner for your cloud migration or modernization. Learn more: https://t.co/tr34y9oEEh https://t.co/2V00VE692x
Microsoft
An ISV’s Guide to Cloud Migrations
Read how to grow your revenues, reach new customers, and set your business apart from competitors with the right cloud migration strategy for your company’s needs. See use cases and learn how indep...
SQLServer Just tweeted ********************************************** The release candidate refresh for #SQLServer 2019 is now available and includes bits for Big Data Clusters. Explore common use cases: https://t.co/s0KaQaTIdD https://t.co/3nHx1ARDvi
SQL Server Blog
SQL Server 2019 release candidate refresh with Big Data Clusters - SQL Server Blog
In continuation with our announcement of SQL Server 2019 release candidate last week, we’re announcing that the release candidate refresh for SQL Server 2019 is now available to download. The release candidate now includes bits for Big Data Clusters in SQL…
SQLServer Just tweeted ********************************************** @SQLSouthwood 1/2 Hi Will, what kind of patch have you applied? If your patch updates SQL Server assemblies without updating SSISDB scripts/schema, you do not need to move SSISDB out from an AG to do an upgrade.
SQLServer Just tweeted ********************************************** @SQLSouthwood 2/2 If your patch needs to update SSISDB scripts/schema, you will still need to move SSISDB out from an AG to do the upgrade. Please let us know if this helps. Thanks!
SQLServer Just tweeted ********************************************** @biserdimitrov Hi Biser, are you still experiencing this issue? If so, please contact Microsoft Support for assistance: https://t.co/SU4Sx8zaXG. Thanks!
SQLServer Just tweeted ********************************************** @kdawg02 Hi Karl, we are sorry to hear this. Please log a bug on the SQL Server feedback forum: https://t.co/cLrbPLXTzW. Thanks!
SQLServer Just tweeted ********************************************** RT @MSFTDynamics365: Hear from the teams automating transactions within Microsoft, and find out how we’re using #Azure and #MSDyn365 to process the data: https://t.co/Qdx1EN9CUH https://t.co/ior7ODpcK0
IT Showcase Blog
How automation is transforming revenue processing at Microsoft - IT Showcase Blog
The Microsoft partner and customer network brings in more than $100 billion in revenue each year, most of the company’s earnings. Keeping tabs on the millions of annual transactions is no small task—just ask Shashi Lanka Venkata and Mark Anderson, two company…
SQLServer Just tweeted ********************************************** RT @Azure: Built on #Azure and #PowerBI, the Modern Data Warehouse lets users quickly leverage data to provide powerful analytics. See the solution architecture: https://t.co/EzQZPyhPl4 https://t.co/3ImTCVwa4R
Microsoft
Modern Data Warehouse Architecture | Microsoft Azure
Explore a cloud data warehouse that uses big data. Modern data warehouse brings together all your data and scales easily as your data grows.
SQLServer Just tweeted ********************************************** Learn key steps and best practices to assess and migrate your on-premises workloads. Get the #cloud migration checklist: https://t.co/2XupfQIlaj
Microsoft
Cloud Migration Checklist: Simple steps to start your migration today
Make a cloud migration plan with Microsoft Azure that meets your organization’s unique business and compliance needs. This migration checklist provides easy, step-by-step guidance on the tools, pla...
SQLServer Just tweeted ********************************************** @biserdimitrov We're glad to hear this has been resolved. Thanks for keeping us updated!
SQLServer Just tweeted ********************************************** Learn about the native Python programming capabilities now available with the #VSCode extension: https://t.co/gMwr3BTH4X https://t.co/vs4Dj6ROCp
SQL Server Blog
Visual Studio Code: Develop PySpark jobs for SQL Server 2019 Big Data Clusters - SQL Server Blog
Today we’re announcing the support in Visual Studio Code for SQL Server 2019 Big Data Clusters PySpark development and query submission. It provides complementary capabilities to Azure Data Studio for data engineers to author and productionize PySpark jobs…
SQLServer Just tweeted ********************************************** @monah1984 Hi Monah, thanks for reaching out. Is SQL Server running on an Ubuntu server, and is this Ubuntu server joined to an Active Directory Domain?
SQLServer Just tweeted ********************************************** @mogupta Hyperthreading is a feature of the CPU and does not require a separate license to be activated. The use of hyper-threading does not affect the number of core licenses required when running SQL Server software in a physical OSE. Read more here: https://t.co/c3clUYZyb0. Thanks!
SQLServer Just tweeted ********************************************** @stochasmos Please post this question the SQL Server forum for assistance: https://t.co/XUv6iOeXcU. Thanks!
SQLServer Just tweeted ********************************************** @chuckh1958 Hi Chuck, please post this question to the SQL Server forum: https://t.co/TbfYSfPiKr. Thanks!
SQLServer Just tweeted ********************************************** @weiln Hi Nathan, the Setup exe can be deleted if there are security concerns. It is only used when installing SQL Server or doing changes to the installation using the GUI, so the user can always use the Setup tool using installation media.
SQLServer Just tweeted ********************************************** @KenDarlingJr Hi Ken, what are you planning to do? Store a database backup to the file share? Use SSIS to load files from the file share? Something else? Thanks!