Basic Concepts of Probability, Real-Time Anomaly Detection and Clustering SQL Server (MSSQLTips 1/15/2020)

[tag] [View MSSQLTips newsletter online]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [Address the Elephant in Your Business - Name and Tame Bad Data in SSIS]( [Basic Concepts of Probability Explained with Examples in SQL Server and R]( Probability | Examples | Step By Step - The purpose of this tip is to provide enough knowledge of probability to evaluate pattern interestingness using SQL Server and R.... [Is High Availability a top priority for your business-critical applications?]( [Webcast] In this webinar, Dave Bermingham, Microsoft Datacenter and Cloud MVP, will detail everything you need to know about clustering SQL Server.... [Real-Time Anomaly Detection Using Azure Stream Analytics]( Machine Learning | Anomaly Detection | Power BI - Azure Stream Analytics offers built in machine learning based anomaly detection to monitor temporary and persistent anomalies. This anomaly detection coupled with Power BIs real time streaming service... [Powerful SQL Server Data Cleansing and Processing]( The constant data management moving target tends to overwhelm the SQL Server DBAs and Developers with the need for immediate response of updating the validation and import code to then load the data to meet the business requirements... [Windows Performance Monitor Tutorial]( Performance Monitor (PerfMon) is a tool that comes built-in with Windows and allows you to look into the performance of your system and the applications that are running on it. It gives you a way to view data points that are associated with these app... [Database Performance Tuning for Virtualized Database Instances]( [Webcast] Join us for a look at how Database Performance Analyzer provides detailed performance data for SQL Server databases instances running in VMware ESXi environments. Virtualization provides many benefits, but how do you know if vSphere... [SQL Server Security Best Practices for an Application Installed on SQL Server]( Best Practices | Security | Daily Operations - In this article we look at the steps you can follow to create a secure and locked down instance of SQL Server to only be used by the intended application on the same machine.... [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... [SQL Server Clustered Tables vs Heap Tables]( One very important design aspect when creating a new table is the decision to create or not create a clustered index. We will take a look at a few points to help with the decision.... [Standardize SQL Server T-SQL Code Formatting]( In this tip I will show an effective and free tool that can help a development team adopt a common coding style.... [Alternate Row Background Color in SQL Server Reporting Services Tablix and Matrix]( You want to make your SQL Server Reporting Services (SSRS) Tablix's and Matrix's more attractive by configuring an alternative row background color. Unfortunately, you cannot find any out of box properties in SSRS to do this. How do you configure alternat... [Twitter]( [Facebook]( [LinkedIn]( [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}