SQL Server Permissions, SQL Query Optimization, Data Wrangling, COALESCE Function, Azure Databricks and more (MSSQLTips 4/13/2021)

[View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [Have a Dumpster Fire of a Database? Put it out with SQLGrease.]( [List SQL Server Login and User Permissions with fn_my_permissions]( [List SQL Server Login and User Permissions with fn_my_permissions]( In this article we look at how to list SQL Server permissions for a login or a user using the system function fn_my_permissions.... [Learn basics of Data Wrangling in SQL by Imputing Missing Values using Drop Attribute and Mean Methods]( [Learn basics of Data Wrangling in SQL by Imputing Missing Values using Drop Attribute and Mean Methods]( In this article we continue our series on data wrangling and different ways to derive values for missing data points in a dataset.... [The Next Best Thing to a Time Machine]( [The Next Best Thing to a Time Machine]( Since performance problems do not always occur while you're watching, you may need to go back in time for root cause analysis. With SQLGrease's historical data collection you can diagnose complex performance problems even after the fact.... [What is Azure Databricks?]( [What is Azure Databricks?]( The goal of this article is to illuminate exactly what Azure Databricks is so that you can determine what parts of the platform might make sense to add to your organization's data stack.... [SQL Server Best Practices for Data Quality]( [SQL Server Best Practices for Data Quality]( Accurate data is imperative for an organization to conduct cost effective decision making, marketing promotions, mailings, database bloat impacting performance, storage and more. Like everything else, change is constant for your data. There is a ne... [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.... [Deep SQL Query Optimization with SQL Grease]( [Deep SQL Query Optimization with SQL Grease]( Learn how to conduct deep SQL Query optimization with SQL Grease with the Enterprise dashboard, historical data, troubleshooting SQL Server Wait Stats, capturing anomalies and intelligent notifications.... [Power BI Anomaly Detection]( [Power BI Anomaly Detection]( One of the problems with data analysis is the potential for anomalies that can skew results. In this article we look at a Power BI feature to detect anomalies and outliers in the data.... [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... [By Mohammed Moinudheen -]( [Setup SQL Server Database Mail to use a Gmail, Hotmail, or Outlook account]( Database Mail | Configuration - In this tip we will walk through how you can setup SQL Server Database Mail to use email services like Gmail, Hotmail or Outlook. ... [By Greg Robidoux -]( [Populate a SQL Server column with a sequential number not using an identity]( I have a database table that has a lot of data already in the table and I need to add a new column to this table to include a new sequential number. In addition to adding the column I also need to populate the existing records with an incremental counter... [By Koen Verbeeck -]( [Setup Environment Variables in SQL Server Integration Services]( Using environments and environment variables we can dynamically configure the behavior of SSIS packages. Read this tip to learn more.... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] Edgewood Solutions LLC | PO Box 682, Wilton, NH 03086 [Unsubscribe {EMAIL}]( [Update Profile]( | [Customer Contact Data Notice]( Sent by newsletter@mssqltips.com