DATEADD SQL Function Use Cases, SQL Server vs Oracle Encryption, Data and AI Leadership Responsibilities (MSSQLTips 4/26/2022)

[tag] [View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [Find Performance Problems Beneath the Surface]( [Understanding the DATEADD SQL Function and its use cases]( [Understanding the DATEADD SQL Function and its use cases]( In this article learn about the SQL Server DATEADD function to add and subtract various date parts from the date and time from a date.... [SQL Server vs Oracle: Encrypt Communication using TLS 1.2]( [SQL Server vs Oracle: Encrypt Communication using TLS 1.2]( In this article we look at how to setup encrypted connections to SQL Server and to Oracle using TLS 1.2 along with the step by step process.... [Performance Problems Lurk Beneath the Surface]( [Performance Problems Lurk Beneath the Surface]( On the surface it's not always clear where your performance problems are. Users might complain, but CPU and memory stats look healthy. SQLGrease goes beyond basic performance statistic monitoring and takes you to the queries and the root cause.... [Part 2: Understanding the Responsibilities of a Successful Data and AI Leader]( [Part 2: Understanding the Responsibilities of a Successful Data and AI Leader]( This article will discuss five additional responsibilities which include the need of a Data and AI Leader to embody emotional intelligence, to be mindful and authentic, to be able to manage conflict all while staying patient, persistent and striving ... [Improve Data Quality for SQL Server Reporting]( [Improve Data Quality for SQL Server Reporting]( Recently, we uncovered the root cause of our reporting issues: poor data quality for portions of our data. Some data is out of date, while other data is not formatted consistently based on numerous source systems, particular data does not properly m... [Request your favorite topic for the next MSSQLTips.com webcast ]( [Request your favorite topic for the next MSSQLTips.com webcast]( Do you want a specific topic covered on an upcoming MSSQLTips.com webcast? Please let us know and we will do our best to find a speaker and date.... [Find SQL Query Anomalies]( [Find SQL Query Anomalies]( 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.... [SQL Server Trigger Example]( [SQL Server Trigger Example]( Learn about SQL Server triggers, their use and how to create a simple trigger to track data changes in a table.... [Universal Data Integration Across the Enterprise]( [Universal Data Integration Across the Enterprise]( Universal real-time data integration is a serious technical and organizational challenge that supersedes the native SQL Server capabilities. CData has recognized these challenges and has delivered a universal data access solution via drivers for on-p... MSSQLTips Week In Review [Creating SQL VIEWs with T-SQL]( [Creating SQL VIEWs with T-SQL]( In this article we look at the basics of creating views in SQL Server and some things you should know about when working with views.... [How to Manage Your SQL License Cost with AWS License Manager]( [How to Manage Your SQL License Cost with AWS License Manager]( In this article we cover how to use the AWS License Manager to manage and track the use of your SQL Server licenses running on AWS.... [Implement Incremental Ingestion for Large Fact Tables on Lakehouse using Synapse Mapping Data Flow - Part 2]( [Implement Incremental Ingestion for Large Fact Tables on Lakehouse using Synapse Mapping Data Flow - Part 2]( In this second part of this series, we discuss the incremental processing challenges related to fact tables for Azure Synapse Analytics and how to solve.... [Intelligent SQL Server and VMware Performance Monitoring Software - Database Performance Analyzer]( [Intelligent SQL Server and VMware Performance Monitoring Software - Database Performance Analyzer]( We have a large SQL Server environment supported by physical servers, VMware and cloud infrastructure. We believe this architecture will be the reality for our organization for a number of years to come. Unfortunately, we are facing a number of challeng... [Part 1: Understanding the Responsibilities of a Successful Data and AI Leader]( [Part 1: Understanding the Responsibilities of a Successful Data and AI Leader]( In this article we look at some of the day-to-day responsibilities of leaders in the field of Data and AI and how can they fulfill their leadership commitments to be successful.... [Part 2: Understanding the Responsibilities of a Successful Data and AI Leader]( [Part 2: Understanding the Responsibilities of a Successful Data and AI Leader]( This article will discuss five additional responsibilities which include the need of a Data and AI Leader to embody emotional intelligence, to be mindful and authentic, to be able to manage conflict all while staying patient, persistent and striving for e... [PowerShell for the DBA – FOR and WHILE Loops]( [PowerShell for the DBA – FOR and WHILE Loops]( In this article we look at how to iterate over code in PowerShell using several different methods like: for, foreach, while, do until, and do while.... [Python Iterable vs Iterator vs Generator with Sample Code]( [Python Iterable vs Iterator vs Generator with Sample Code]( In this article we continue the series about learning Python and cover the concepts of iterable, iterator and generator along with several examples.... [SQL Server Performance Tuning and Operational Monitoring with ManageEngine Applications Manager]( [SQL Server Performance Tuning and Operational Monitoring with ManageEngine Applications Manager]( Learn about the SQL Server performance and operational monitoring capabilities for DBAs with ManageEngine Applications Manager.... [SSIS Bad Habits: Inefficient Data Staging Strategies]( [SSIS Bad Habits: Inefficient Data Staging Strategies]( In this article we look at different ways to load staging data using SSIS and whether you should use a Data Flow task or a Bulk Insert task.... [Using SolarWinds Database Performance Analyzer to Diagnose Performance Issues]( [Using SolarWinds Database Performance Analyzer to Diagnose Performance Issues]( Learn about how to address SQL Server performance issues such as blocking, high CPU utilization, excessive IO and more with SolarWinds Database Performance Analyzer.... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}