Execute SSIS Package with SQLCMD, Stored Procedures with R and Cut Your SQL Server Licensing Costs (MSSQLTips 11/24/2020)

[tag] [View MSSQLTips newsletter online]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [Take part in the State of Database DevOps 2021 Survey]( [Execute SSIS Package with SQLCMD and Parameters]( In this article we walk through the steps of how to run an SSIS package using SQLCMD along with passing parameters to the SSIS package.... [Stored Procedure in SQL Server with R Code]( In this article we will explore how to create custom stored procedures using R which is basically an R function that can be called from a SQL Server stored procedure. ... [Take part in the State of Database DevOps 2021 Survey]( Introducing the 5th annual State of Database DevOps survey, the leading research on Database DevOps, with over 5,000 participants to date. Have your say on the current state of DevOps and the database, and you could win a $500 gift card... [Backwards Compatibility in SQL Server Data Tools for Integration Services]( SQL Server Data Tools (SSDT) is the development environment for creating and maintaining Integration Services (SSIS) packages and projects. Historically, there was no backwards compatibility, meaning that with a newer version of SSDT, you couldn't cr... [Solution: SQL Server Operational Tasks and Performance Monitoring]( Learn about how SQL Monitor saves significant time for operational tasks and performance monitoring for large SQL Server environments with instances on premises, in the cloud, running in virtualized environments, clusters, and Availability Groups.... [Transactional Replication for SQL Server Tables without Primary Keys]( We need to provide a department a copy of the production OLTP database with a subset of tables for close to real-time reporting. The OLTP database has a lot of transactions and can not be used for ad-hoc queries, so we would like to offload the busin... [70% Savings - SQL Server Licensing for HA and DR]( In this webinar we cover lessons learned from real-world customers who saved more than 70% on their SQL Server licensing costs related to high availability and disaster recovery.... [Understanding GRANT, DENY, and REVOKE in SQL Server]( I am having a bit of trouble understanding how GRANT, DENY, and REVOKE work together in SQL Server, especially when you consider things like schemas. Which setting trumps the others? How do I undo security?... [Faster SQL Server Clustering]( 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... Take part in the State of Database DevOps 2021 Survey This year, we explore the role that Database DevOps plays in improving the overall Accelerate metrics, as well as we look to understand the impact of the pandemic on team's performance. If you or your organization uses or have used databases, we'd love to hear from you! >> [Take the Survey!]( << [How to rename a SQL Server database]( In this tip we look at different ways to rename a SQL Server database. ... [Using MERGE in SQL Server to insert, update and delete at the same time]( In this tip we look at an example to help you better understand how the SQL Server MERGE statement works.... [SQL Server Reporting Services Lookup, LookupSet and MultiLookup Functions]( I noticed the Lookup function in SQL Server Reporting Services. In this tip we look at all three SSRS lookup functions: Lookup, LookupSet and MultiLookup.... [Twitter]( [Facebook]( [LinkedIn]( [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}