Export SQL Server Data to Multiple Excel Worksheets, Azure SQL Database TDE and Deploy Database Objects to Multiple SQL Servers (MSSQLTips 11/19/2020)

[tag] [View MSSQLTips newsletter online]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [Reduce time to troubleshoot data platform performance issues up to 90%]( [Execute Databricks Jobs via REST API in Postman]( The following article will demonstrate how to turn a Databricks notebook into a Databricks Job and then execute that job through an API call. ... [Deploy Database Objects to Multiple SQL Server Instances Using PowerShell]( In this article we look at a PowerShell script that can help you deploy database objects to multiple SQL Server instances.... [SQL Server Database Stuck in Restoring State]( In this article we will show reasons why a SQL Server database is in a restoring state and how you can get access to a database in a restoring state. It is not a very common problem, but when it happens it can be a big headache. In this article, we ... [SQL Server Licensing Getting Expensive?]( 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.... [Execute Dynamic SQL commands in SQL Server]( In some applications, having hard coded SQL statements is not appealing because of the dynamic nature of the queries being issued against the database server. Because of this sometimes there is a need to dynamically create a SQL statement on the fly ... [Quickly Pinpoint SQL Server Performance Issues]( My team needs to quickly pinpoint the performance issues in my SQL Server environment. With all of the demands at work, our team needs to find and understand the issues, then review the code and take corrective actions. We need to ensure our producti... [Different ways to execute a SQL Server SSIS package]( One of the Junior SQL Server Developers in my company approached me yesterday with a dilemma. He was developing an SSIS Package which imports data from a comma separated text file and he wanted to know the different ways in which one can execute an S... [SQL Server High Availability in the Azure Cloud]( If you need to migrate to Azure at end of support (EOS), and you require HA for SQL Server 2008/2008 R2, there is only one solution recommended by Microsoft: SIOS DataKeeper. SIOS DataKeeper enables clustering in the cloud, including the creation of ... [Send email in a tabular format using SQL Server database mail]( Some of our SQL Servers contain tables with summarized data (summarized on a weekly / monthly / quarterly basis). Previously this data was emailed as a flat file attachment to the recipients. I was asked to convert this in such a way that the email i... [Understanding the SQL Server NOLOCK hint]( In this tip we look at the SQL Server NOLOCK hint and how it impacts query results, both good and bad.... [SQL Server Cursor Example]( In my T-SQL code I always use set based operations. I have been told these types of operations are what SQL Server is designed to process and it should be quicker than serial processing. I know cursors exist, but I am not sure how to use them. Can you ... [Reading SharePoint Lists with Integration Services 2017]( In this tip we look at how to extract data from a SharePoint list using a SSIS package with the built-in components. ... [Twitter]( [Facebook]( [LinkedIn]( [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}