SQL Server Schemas, Create Annual IT Roadmap, Format Dates and Week in Review (MSSQLTips 1/9/2023)

[tag] [View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [Free SQL Server Tutorials]( [SQL Create Schema to Organize Database Objects, Assign Permissions and Easier Management ]( [SQL Create Schema to Organize Database Objects, Assign Permissions and Easier Management]( Learn about SQL Server schemas and how to use them to organize database objects, assign permissions, and easier management of database objects.... [Creating an Annual Organizational IT Roadmap]( [Creating an Annual Organizational IT Roadmap]( This article intends to cover a few tips for creating a technology roadmap for your organization by identifying requirements, priorities, stakeholders, and plans.... [Availability Options for SQL Server in AWS]( [Availability Options for SQL Server in AWS]( In this webinar, you'll learn about availability options on AWS, effective ways to optimize cloud storage and cost, using the cloud for disaster recovery, and key considerations for choosing the right availability options and requirements for SQL Ser...... [Vote for Your Favorite Authors]( [Vote for Your Favorite Authors]( We have 21 dedicated authors in the running for the 2022 MSSQLTips.com Author and Rookie of the Year. Vote now and vote often!...... [SQL Server, Oracle, Postgres, Azure and AWS Performance, Monitoring and Management]( [SQL Server, Oracle, Postgres, Azure and AWS Performance, Monitoring and Management]( Learn about dbWatch Control Center to help you better manage your database environment for SQL Server, Oracle, Postgres, Azure, AWS, and more database platforms....... [Format SQL Server Dates with FORMAT Function]( [Format SQL Server Dates with FORMAT Function]( In this tip we look at how to use the FORMAT function to format dates, time and numbers in SQL Server along with several examples....... [Improve Data Quality for SQL Server Reporting]( [Improve Data Quality for SQL Server Reporting]( Poor data quality for any reason is very expensive in terms of man hours and decision making to all organizations. There are a number of ways to address the issue with both SQL Server Reporting Services and Power BI. Learn about Melissa's solution t...... [Add and Subtract Dates using DATEADD in SQL Server]( [Add and Subtract Dates using DATEADD in SQL Server]( Date manipulation is a common scenario when retrieving or storing data in a SQL Server database. There are several functions that are available and in this tip we look at how to use the DATEADD function....... [Quickly Deploy SQL Server on Linux]( [Quickly Deploy SQL Server on Linux]( Learn how to quickly deploy a SQL Server on Linux (standalone) on Ubuntu (Linux) using AWS Launch Wizard....... MSSQLTips Week In Review [Add Report Server Project to an existing Visual Studio Solution]( [Add Report Server Project to an existing Visual Studio Solution]( In this article, we look at how to add a Report Server project to an existing Visual Studio Solution for a database and website along with how to develop reports.... [Analyze Azure Cosmos DB data with Synapse Serverless SQL Pools]( [Analyze Azure Cosmos DB data with Synapse Serverless SQL Pools]( In this tip, we guide you through the setup of Azure Synapse Link so you can query Azure Cosmos DB data with the Synapse Serverless.... [Export Large SQL Query Result with Python pyodbc and dask Libraries]( [Export Large SQL Query Result with Python pyodbc and dask Libraries]( Learn how to export a very large data set from a SQL Server database using Python with pyodbc and dask libraries.... [Getting Started with Azure Data Studio ]( [Getting Started with Azure Data Studio]( Learn how to install and use Azure Data Studio in this introduction to getting started with Azure Data Studio.... [Normalize Repeated Data in Power BI reports and Charts with Power Query]( [Normalize Repeated Data in Power BI reports and Charts with Power Query]( Learn how to unpivot repeated data columns in a dataset to normalize the data so it can be used in Power BI reports and charts.... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}