Power BI Security, Delete Azure Recovery Services Vault and SQL Server Function Compatibility (MSSQLTips 3/26/2020)

[tag] [View MSSQLTips newsletter online]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [Cloud Data Integration - Six Key Factors]( [Power BI Table Based Row Level Security]( In this article we look at how to control what data users can and cannot see in a Power BI report by utilizing a database table to control what a user can access.... [Unable to delete Azure Recovery Services Vault]( In this article we walk through the steps you need to take to be able to delete an Azure Recovery Services vault after you have decommissioned SQL Server and the Azure VM.... [Exploring alternative data replication solutions?]( Looking to modernize with new technologies, like Snowflake, AWS, Azure, or Google? Our Data Integration Experts outlined six key factors to consider when choosing your next cloud data replication solution. Download the eBook.... [Convert MS Access to SQL Server with Always Encrypted Database]( In this article we cover code that allows you to migrate your database from MS Access to SQL Server and also use Always Encrypted columns.... [Advanced Performance Tuning for Microsoft SQL Server]( No matter where you run your SQL Server instances: on-premises, in a virtual machine, or in an Azure SQL Database Managed instance - the challenge is the same. How do you ensure you get optimum performance?... [Making SQL Server Function Changes Backwards Compatible]( In this article we look at how you can modify a SQL Server user defined functions set of parameters without breaking other code in your database that calls the function.... [Do you need a faster 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... [Script to Delete SQL Server Data in Batches]( In this tip we cover a T-SQL script that allows you to batch delete older data from tables and save the deleted records to an archive table.... [Find, Analyze and Optimize SQL Server Performance]( As a SQL Server Professional, application performance is one of my top priorities. I know our applications have numerous inefficiencies and we are constantly firefighting to keep our internal and external users productive. Our team collects data al... [Benefits of SCHEMABINDING in SQL Server]( Read this tip to learn about the benefits of using with schemabinding when creating SQL Server objects.... [SQL Server Loop through Table Rows without Cursor]( In this tip we look at a comparison of a SQL Server cursor and a While Loop to show how to perform the same operations using the two different looping mechanisms. ... [Dynamically Refresh SQL Server Reporting Services Report Date Parameters]( You created a report in SQL Server Reporting Services that has four parameters Year, Month and two Calendar Date Picker parameters StartDate and EndDate. The default values for StartDate and EndDate are determined by the Year and Month parameters. So when... [Twitter]( [Facebook]( [LinkedIn]( [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}