Python Functions, SQL Server Upgrades, SQL Date Conversions and T-SQL Tips

[MSSQLTips.com logo]( [View email in your browser]( TODAY'S NEWSÂ FROM MSSQLTips Learn something new every day! [mssqltips image]( [Python Functions for Reducing Code Complexity]( Using Python functions allows you to solve the problem of having to write repeated code, make code easier to understand, and reduce code complexity.... [mssqltips image]( [How to Upgrade SQL Server from Evaluation Edition to Standard or Enterprise]( Learn how to upgrade SQL Server from the Evaluation edition to other SQL Server editions like Standard or Enterprise.... [mssqltips image]( [Tune and monitor your SQL Server databases]( With just a few clicks, you get expert advice to boost the performance of your SQL Server databases. Within minutes, analyze statements, perform index impact analysis, view trend charts, and monitor your database in real time. ... RECOMMENDED READINGÂ ON MSSQLTips [mssqltips image]( [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.... [mssqltips image]( [Date and Time Conversions Using SQL Server]( Learn SQL date format options with the SQL CONVERT function when working with date data types in SQL Server.... [mssqltips image]( [Database Performance Analytics, Tuning, Monitoring, and Trending]( 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.... ADDITIONAL RESOURCESÂ ON MSSQLTips [mssqltips image]( [SQL Server Join Example]( I am new to SQL Server and want to learn about the JOIN options. What are all of the JOIN options in SQL Server? What is the significance of each of the options? I am a little confused on the differences and syntax, can you provide some examples a... [mssqltips image]( [Powerful SQL Server Data Quality Tools for Cleansing and Validation]( Learn how Data Stewards can leverage Unison from Melissa Data to solve data quality issues such as duplicate records and enrich contact data for better decision making.... [mssqltips image]( [SQL Server CROSS APPLY and OUTER APPLY]( Learn about SQL Server CROSS APPLY and OUTER APPLY and how they differ from regular JOINs and how to use these along with scripts and a video. ... [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLCÂ PO Box 682 | Wilton, NH 03086Â [Privacy Statement]( Sent to: {EMAIL}Â [tag]