Querying Star Schemas in Databricks, Manage TDE Keys, COALESCE SQL Function and SQL Window Functions (MSSQLTips 9/30/2021)

[View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [Insight Report from 2500+ Database Professionals - Get the Insights]( [Manage TDE Keys On Premises with SQL Data Files Stored in Azure]( [Manage TDE Keys On Premises with SQL Data Files Stored in Azure]( In this article we look at how to setup transparent data encryption for SQL Server data files stored in Azure storage, but keeping the TDE keys local.... [Querying Star Schemas in Databricks with Dynamic Partition Pruning]( [Querying Star Schemas in Databricks with Dynamic Partition Pruning]( In this article, you will learn how to efficiently utilize Dynamic Partition Pruning in Databricks to run filtered queries on your Delta Fact and Dimension tables.... [Redgate's Free State of Database Monitoring Insights report]( [Redgate's Free State of Database Monitoring Insights report]( '65% of DBAs reported that, over the last 12 months, they personally became responsible for more database instances.' Feel like you're having to do more with less time? Learn how 2500+ database professionals are reacting to the challenge.... [COALESCE SQL Function]( [COALESCE SQL Function]( In this article we cover the many different ways you can use the COALESCE function in SQL Server along with several TSQL examples using COALESCE.... [Optimize SQL Server Monitoring for Operational and Performance Needs]( [Optimize SQL Server Monitoring for Operational and Performance Needs]( 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.... [SQL Window Functions in SQL Server, Oracle and PostgreSQL]( [SQL Window Functions in SQL Server, Oracle and PostgreSQL]( In this article we look at using Window Functions in SQL Server, Oracle and PostgreSQL to see the differences and similarities of the syntax.... [How do you measure up? Managing Production SQL Server Workloads]( [How do you measure up? Managing Production SQL Server Workloads]( [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... [SQL SELECT DISTINCT Examples]( [SQL SELECT DISTINCT Examples]( In this article we look at how to retrieve a list of distinct datasets from SQL Server without repeating information using the DISTINCT clause.... [SQL Server Data Warehouse Cleansing, Verification and Matching]( [SQL Server Data Warehouse Cleansing, Verification and Matching]( Data Quality | SSIS Workflow | Downloadable Solution - How can we clean, validate and enhance our Contact dimension in our SQL Server Data Warehouse without writing code?... [By Greg Robidoux -]( [How to tell what SQL Server versions you are running]( Check out this tip to easily find out what version of SQL Server you are running.... [By Jeremy Kadlec -]( [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 sequential ... [By Koen Verbeeck -]( [Backwards Compatibility in SQL Server Data Tools for Integration Services]( Historically SSDT had no backwards compatibility meaning that with a newer version of SSDT, you couldn't create SSIS packages for an older version. This has changed with SQL Server 2016.... [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