SQL Server Date and Time Data Types, Run PowerShell Scripts and Azure Tutorial (MSSQLTips 3/15/2023)

Learn about new SQL Server topics from MSSQLTips.com [MSSQLTips.com logo]( [View email in your browser]( [Get more done with less!]( [Get more done with less!]( TODAY'S NEWS FROM MSSQLTips Learn something new every day! [mssqltips image]( [Working with Date and Time Data Types in SQL Server]( Learn about the different SQL Server data types to store dates and times such as date, datetime, datetime2, smalldatetime, datetimeoffset, and time.... [Read Now]( [mssqltips image]( [Manage more instances with less cost and effort!]( Cost-efficient, scalable and powerful SQL monitoring and performance management.... [Read Now]( [mssqltips image]( [Run PowerShell Scripts with SQL Server Agent or Windows Task Scheduler]( Learn how to schedule and automate your PowerShell scripts using either SQL Server Agent or Windows Task Scheduler.... [Read Now]( RECOMMENDED READING ON MSSQLTips [mssqltips image]( [Optimize your costs with Azure SQL Managed Instance]( Migrating your SQL Server data to the cloud can yield immediate cost savings beyond shifting IT budget from a capital expense to an operational expense. You can continue to optimize your costs in the cloud to significantly impact your total cost of o... [Read Now]( [mssqltips image]( [Tutorial - Moving Data Around in Azure]( In this video tutorial series we will look at how to move data around in Azure. We will look at various tools and options to move data in the cloud in each of the different videos in this tutorial. This first video provides an overview of what we w... [Read Now]( [mssqltips image]( [Enterprise SQL Server Performance Tuning and Management]( We need to transition our team from single instance management and monitoring to managing the overall environment and addressing our most pressing needs to support the organization. How can we move from managing the trees to managing the forest in an... [Read Now]( ADDITIONAL RESOURCES ON MSSQLTips [mssqltips image]( [Compressing Big Static SQL Server Tables]( In this article, we look at how to use compression in SQL Server to reduce the amount of space needed to store data. We look at Page, Columnstore, and Archive compression options.... [Read Now]( [mssqltips image]( [Create a SQL Alias using SQL Server Synonyms]( In this article, we look at how to create and use synonyms in SQL Server to access other database objects.... [Read Now]( [mssqltips image]( [SQL Server DBA Interview Questions for Backups and Restores]( In this article, we cover possible interview questions and answers related to SQL Server backups.... [Read Now]( [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL} [tag]