Fortune 500 Company's Solution to SQL Server Data Encryption (MSSQLTips 8/30/2021)

[View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [SQL Server Performance Monitoring and Tuning Tutorial - Improve Performance Now]( [Advanced Schema Evolution using Databricks Auto Loader]( [Advanced Schema Evolution using Databricks Auto Loader]( This article demonstrates how to get started with using Auto Loader cloudFiles with Databricks through an end-to-end practical example of ingesting a data stream which has an evolving schema.... [Plotting in Python for Financial Time Series Data for Exponential Moving Averages]( [Plotting in Python for Financial Time Series Data for Exponential Moving Averages]( Learn how to plot a financial time series using SQL Server data and Python to reveal the value of exponential moving averages and make decisions about time series values.... [Becton Dickinson Relies on DBDefence for Essential Data Encryption]( [Becton Dickinson Relies on DBDefence for Essential Data Encryption]( Learn why Becton Dickinson has selected DBDefence to protect their SQL Server data across numerous medical devices in a cost effective manner.... [SQL Server Cursor Example]( [SQL Server Cursor Example]( A SQL Server cursor is a set of T-SQL logic to loop over a predetermined number of rows one at a time. The purpose for the cursor may be to update one row at a time or perform an administrative process such as SQL Server database backups in a sequent... [Query Optimization Tips and Tricks from the Experts]( [Query Optimization Tips and Tricks from the Experts]( Download this eBook for SQL Server query tuning and optimization tips and tricks. This eBook is packed with several articles from SQL Server experts about how to go about optimizing queries by using the tools that SQL Server offers along with viewing... [SQL Server LIKE Syntax with Wildcard Characters]( [SQL Server LIKE Syntax with Wildcard Characters]( In this tip we look at different examples of how to use the LIKE operator to get the correct results when strings contain wildcard characters. We will also look a function to make this easier to do.... [Working Around the Workload]( [Working Around the Workload]( [Webcast] How can the production database support everything the business wants to throw at it, and be continuously available, and perform well? Tune in as we discuss how (and why) businesses keep adding on to their existing environments, and how you... [New to SQL Server???]( [New to SQL Server???]( I am new to SQL Server and I have heard the term used in a number of different capacities and in different contexts. So what exactly is it? What are the common components? How does it work? How do people use it? I am brand new to the technology, wher... [Faster SQL Server Clustering]( [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... MSSQLTips Week In Review [Becton Dickinson Relies on DBDefence for Essential Data Encryption]( [Becton Dickinson Relies on DBDefence for Essential Data Encryption]( Learn why Becton Dickinson has selected DBDefence to protect their SQL Server data across numerous medical devices in a cost effective manner.... [How to Enable and Disable Hybrid Buffer Pool for SQL Server Databases]( [How to Enable and Disable Hybrid Buffer Pool for SQL Server Databases]( In this article we take a look at the hybrid buffer pool in SQL Server 2019 and how to enable and disable it for specific databases.... [Mount an Azure Data Lake Storage Gen2 Account in Databricks]( [Mount an Azure Data Lake Storage Gen2 Account in Databricks]( In this article we will walk through a clear end-to-end process of securely mounting an ADLS gen2 account in Databricks.... [Power BI Desktop External Tools and Why You Should be Using Them]( [Power BI Desktop External Tools and Why You Should be Using Them]( Learn about several free external tools that you can connect to Power BI to assist in development and deployment of your Power BI reports.... [Real-Time Streaming using Power BI Streaming Dataset]( [Real-Time Streaming using Power BI Streaming Dataset]( In this tip we will look at using a Streaming Dataset in Power BI to visualize real time data using the streaming service Azure Stream Analytics job.... [Salesforce and QuickBooks Integration to Snowflake via CData SSIS Connectors]( [Salesforce and QuickBooks Integration to Snowflake via CData SSIS Connectors]( Learn how to use CData connectors to easily connect SSIS to Salesforce and QuickBooks Online then load the data into a Snowflake data warehouse.... [SQL Server VM Best Practices]( [SQL Server VM Best Practices]( In this article we look at some of the things you should be aware of when building a VM to run SQL Server, such as vCPUs, disks, memory and more.... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] Edgewood Solutions LLC | PO Box 682, Wilton, NH 03086 [Unsubscribe {EMAIL}]( [Update Profile]( | [Our Privacy Policy]( | [Constant Contact Data Notice]( Sent by newsletter@mssqltips.com