Export Large SQL Query Result, Analyze Azure Cosmos DB Data, Add Project to Visual Studio Solution and SQL Server Availability Options (MSSQLTips 1/4/2023)

[tag] [View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [SQL Server Indexing Tutorial - Start Learning Today]( [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.... [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....... [SQL Server Performance Tuning and Operational Monitoring]( [SQL Server Performance Tuning and Operational Monitoring]( Learn about the SQL Server performance and operational monitoring capabilities for DBAs with ManageEngine Applications Manager....... [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....... [SQL Server Data Masking]( [SQL Server Data Masking]( Data breaches are becoming too common place with some accounts reporting more than 1000 breaches per year with close to 50 million records exposed yearly in the financial, business, education, government and healthcare industries. Learn about how Db...... [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...... [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....... [Power BI Interview Questions and FAQs]( [Power BI Interview Questions and FAQs]( This article provides some questions you may be asked and areas of discussion for an interview related to Power BI jobs....... [By Greg Robidoux - ]( [Understanding the SQL Server NOLOCK hint]( In this tip we look at the SQL Server NOLOCK hint and how it impacts query results, both good and bad.... [By Arshad Ali - ]( [SQL Server CROSS APPLY and OUTER APPLY]( SQL Server introduced the APPLY operator, which is like a join clause and it allows joining between two table expressions i.e. joining a left/outer table expression with a right/inner table expression. The difference between the join and APPLY operator be... [By Koen Verbeeck - ]( [Implement a Slowly Changing Type 2 Dimension in SQL Server Integration Services - Part 1]( In this tip we look at how you can implement a type 2 slowly changing dimension with SQL Server Integration Services.... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}