Data Science Exam Prep, SQL FORMAT Examples, Low Code Data Analysis and Calendar Table

Learn about new SQL Server topics from MSSQLTips.com [MSSQLTips.com logo]( [View email in your browser]( TODAY'S NEWS FROM MSSQLTips Learn something new every day! [mssqltips image]( [DP-100 Azure Data Science Exam Prep]( Data Science is one of the best-paying jobs in the world. Microsoft now offers an official certification in Data Science and to help you get started, this article provides several links to help you get ready for the DP-100: Designing and Implementing... [Read Now]( [mssqltips image]( [Five database DevOps practices for boosting team productivity]( Speed of delivery and protecting data can often feel incompatible, but there are industry-proven database DevOps practices that bring them together in harmony.... [Read Now]( [mssqltips image]( [Low Code Data Analysis with Bamboolib and Databricks AI Assistant]( Learn about Databricks Assistant a context-aware native AI assistant and Bamboolib a no-code data analysis and transformation framework to enhance code quality and delivery time.... [Read Now]( RECOMMENDED READING ON MSSQLTips [mssqltips image]( [Digging into SQL Server Performance and Query Metrics]( Learn about how SQL Monitor saves significant time for operational tasks and performance monitoring for large SQL Server environments with instances on premises, in the cloud, running in virtualized environments, clusters, and Availability Groups.... [Read Now]( [mssqltips image]( [SQL FORMAT Examples]( SQL Date Format examples using SQL FORMAT Function to format dates, time and numbers in SQL Server.... [Read Now]( [mssqltips image]( [Data Warehousing - Past, Present and Future]( Learn about the evolution of the data platform architecture from data warehouses to data lakes to data lakehouses to bring together structured, semi-structured and unstructured data to unlock insights quicker.... [Read Now]( ADDITIONAL RESOURCES ON MSSQLTips [mssqltips image]( [DROP TABLE IF EXISTS Examples for SQL Server]( In this article we cover various ways to check if a SQL Server table exists before trying to drop the table to avoid the error Msg 3701 Level 11 State 5 cannot drop the table because it does not exist or you do not have permission.... [Read Now]( [mssqltips image]( [Learn How NextGen Healthcare uses the Cloud]( [Video - Case Study] Learn about the best practices and journey undertaken by NextGen Healthcare to migrate to the cloud. From goals, challenges, business drivers, migration options and more.... [Read Now]( [mssqltips image]( [Creating a Calendar Table in SQL Server]( A calendar table can be immensely useful, particularly for reporting purposes, and for determining things like business days between two dates. I often see people struggling with manually populating a calendar or date dimension table; usually there a... [Read Now]( [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL} [tag]