Fixing SSIS Data Type Issue, Date Functions in WHERE Clause, Data Mining and Rounding Functions (MSSQLTips 1/20/2023)

[tag] [View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [SQL Server Indexing Tutorial - Start Learning Today]( [Fixing Cannot Convert Between Unicode and Non-Unicode String Data Types in SSIS]( [Fixing Cannot Convert Between Unicode and Non-Unicode String Data Types in SSIS]( This article looks at several ways to handle the SSIS error: cannot convert between Unicode and non-Unicode string data types.... [Improve the Data Quality for Healthcare, Clinical and Life Sciences Projects]( [Improve the Data Quality for Healthcare, Clinical and Life Sciences Projects]( All companies fundamentally have the need to improve data quality for decision making. For healthcare, clinical and life sciences organizations, merging, reconciling and enhancing data is challenging for electronic medical records, clinical trials an...... [Query SQL Server Data Based on Various Date and Time Functions]( [Query SQL Server Data Based on Various Date and Time Functions]( This simple reference guide shows you various ways to query SQL Server data based on various date and time clauses....... [DBI Web Performance Suite for DB2 LUW and SQL Server]( [DBI Web Performance Suite for DB2 LUW and SQL Server]( The DBI Web Performance Suite for SQL Server and DB2 is a database performance collection, analysis and recommendation tool to help you troubleshoot and tune your database systems....... [SQL Server Data Mining for Leveraged Versus Unleveraged ETFs as a Long-Term Investment]( [SQL Server Data Mining for Leveraged Versus Unleveraged ETFs as a Long-Term Investment]( This article covers how to download data into a SQL Server database to do a comparison of whether leveraged versus unleveraged ETF are a better long-term investment....... [SQL Server TDE Comparison]( [SQL Server TDE Comparison]( Transparent Data Encryption | Comparison - Between the legislation over the years and data breaches in the news on a monthly basis, SQL Server database encryption is critical for our industry. SQL Server ships with a few options for a native encrypt...... [SQL Convert Date to YYYYMMDD]( [SQL Convert Date to YYYYMMDD]( In this article we look at different ways to use the date format YYYYMMDD in SQL Server....... [Build a Secure SQL Server REST API in Minutes]( [Build a Secure SQL Server REST API in Minutes]( Learn how to build a secure SQL Server REST API in minutes with DreamFactory which is middleware that connects all of your applications across the enterprise in a secure manner....... [By Daniel Calbimonte - ]( [Ways to compare and find differences for SQL Server tables and data]( This article shows different ways to compare SQL Server data, datatypes and tables using TSQL and some development tools.... [By Jeremy Kadlec - ]( [SQL Server Rounding Functions - Round, Ceiling and Floor]( I saw your recent tip on Calculating Mathematical Values in SQL Server and have some related issues as I try to round values in my application. My users and me have a difference of opinion on some of the calculations in our reporting applications. All o... [By Manvendra Singh - ]( [SQL Server AlwaysOn Interview Questions and Answers - Part 1]( Learn about SQL Server AlwaysOn through interview questions and answers related to configurations, daily operations and more.... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}