Using SQL Server sqlcmd scripting variables (MSSQLTips 08/15/2017)

[View MSSQLTips newsletter online]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [Build vs. Buy: Which Data Quality Solution is Best for You?]( [Using SQL Server sqlcmd scripting variables]( Sqlcmd is not just a script execution tool. It gives us access to internal variables and commands that we can use to automate code execution. In this tip I will show you how you can use the scripting variables. ... [How to visualize multivariate relationships using Power BI]( Learn how to visualize multivariate relationships using Power BI with the R script visual control.... [SQL in the cloud - FAQs, common misconceptions and resources to make your life easier]( Join us for a panel discussion with top cloud, Datacenter and SQL professionals as they cover best practices, frequently asked questions, and common mistakes they encounter in their professions when moving SQL Server to the cloud. ... [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... [Step by Step Guide for SQL Server Graphical Query Plans]( Briefly, the Query Plan defines how SQL statements are physically executed by the server. The Query Plan describes the data retrieval and storage methods that are used by the Query Optimizer to execute a specific query.... [Troubleshooting SQL Server Replication]( Replication in SQL Server simply refers to the process of copying data from one database to another. This movement of data is subject to a large number of options configured at the publisher, distributor and subscriber, but for all the complexity it is su... [How to use SQL Server CTEs to make your T-SQL code readable by humans]( If you're the sort of person who can effortlessly write complicated queries in SQL using a single SELECT statement, please click away from this article now! However, if ( like me ) your brain spins in proportion to the complexity of the query you're writ... [Importing XML documents using SQL Server Integration Services]( In this tip we look at how to import XML documents into SQL Server using SSIS. We will walk through an example and also show some of the potential issues and how to resolve them.... [Twitter]( [Facebook]( [LinkedIn]( [Google+]( You are receiving this as a subscriber of MSSQLTips.com. If you wish to discontinue receiving email, 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: {EMAIL}