SQL Drop Table Examples, Using Azure SQL Data Sync to Replicate Data, SQL Maintenance Webcast and more (MSSQLTips 2/8/2021)

[View MSSQLTips newsletter online]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [SQL Server Machine Learning Tutorial]( [SQL Drop Table Examples with T-SQL and SQL Server Management Studio]( In this article we look at how to delete a SQL Server table using the DROP TABLE command along with using SQL Server Management Studio.... [Using Azure SQL Data Sync to Replicate Data]( Learn how to setup and use Azure SQL Data Sync to synchronize and replicate data from various locations including Azure SQL Database, cloud and on-premises databases.... [Best Practices for SQL Server Maintenance]( [Webcast] Proper maintenance of a SQL Server requires several steps that need to run in harmony. From backups, corruption checks, index maintenance, data archiving, pruning system tables and more. Attend this free webinar to learn about best practice... [SQL Server Master Database Tutorial]( In this tutorial we cover many common questions about the master database. We look at what it is used for, location of database files, things you can and cannot do with the master database, maintenance and more.... [Controlling Cloud Costs without Sacrificing Availability or Performance]( Shortly after contracting with a cloud service provider, a bill arrives that causes sticker shock. There are unexpected and seemingly excessive charges, and those responsible seem unable to explain how this could have happened. The situation is criti... [SQL Server Analysis Services Tutorial]( SQL Server Analysis Services (SSAS) is the technology from the Microsoft Business Intelligence stack to develop Online Analytical Processing (OLAP) solutions. Over the years SSAS has evolved and has emerged as a leader in the area of analytical solut... [Solved: SQL Server Management and Performance Complexity]( 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... [SQL Server Backups Tutorial]( One of your last lines of defense for just about any system is to have a backup in place in case there is a need to recover some or all of your data. Become an expert on SQL Server Backups.... [Powerful SQL Server Data Cleansing and Processing]( The constant data management moving target tends to overwhelm the SQL Server DBAs and Developers with the need for immediate response of updating the validation and import code to then load the data to meet the business requirements between the organ... MSSQLTips Week In Review [Build Appealing Dashboards using Azure Synapse Analytics]( In this article we cover how to use Azure Synapse Analytics and Power BI to create dashboards for data analysis.... [Comparing with T-SQL and Excel a Decision Tree Regression to a Bagged Regression]( Learn how to do a comparison of a decision tree regression versus a bagged regression based on two different test datasets using both T-SQL and Excel.... [Create a Python Django Website with a SQL Server Database]( In this article we look at how to create a website using Python Django with a SQL Server backend. We walk through the steps on how to get this up and running.... [DDL commands in SQL Server with Examples for Snapshot Isolation Level]( In this article we look at what can and cannot be done for SQL Server DDL statement behavior inside a transaction when using the snapshot isolation level.... [Getting Started with Azure Synapse Analytics Hyperspace for Spark Indexing]( In this article learn how to get started with creating Spark Indexes and Azure Synapse workspace by using the Hyperspace Index Management sub-system.... [How to Setup a Virtual Machine with VMware Workstation 14]( In this article we walk through the steps on how to create a new virtual machine using VMware Workstation.... [Importance of Update Statistics in SQL Server]( In this tip learn the what, why, where, when of SQL Server statistics to get a better understanding how important statistics are for optimized query performance.... [Learning SQL Server]( Learn about the core SQL Server concepts to build your skill set including the architecture, database design, development, administration and more.... [MSSQLTips.com Authors and Rookie of 2020]( Let's take some time to recognize the MSSQLTips.com Authors and Rookie of 2020 as well as all of the Authors on the Team. ... [Power BI Reports with Animated GIF]( In this article we demonstrate how to create a GIF recording and use the GIF in Power BI desktop reports to help users understand the report.... [Resolve Git Merge Conflict for SSIS Projects]( When working on an SSIS project with multiple developers, a merge conflict can occur in the git repository. In this tip we'll show you how to resolve this type of conflict and provide alternative options.... [SQL Server]( I am new to SQL Server and I have heard the term used in a number of different capacities and in different contexts. So what exactly is it? What are the common components? How does it work? How do people use it? I am brand new to the technology, where do ... [SQL Server LIKE Syntax with Wildcard Characters]( In this tip we look at different examples of how to use the LIKE operator to get the correct results when strings contain wildcard characters. We will also look a function to make this easier to do.... [Step by Step Installation of SQL Server 2019 on Windows Server 2016 in VMware]( In this article we cover how to install SQL Server 2019 on VMware Workstation.... [Step by Step Installation of Windows Server 2016 on a Virtual Machine]( In this article we walk through the steps on how to install Windows Server 2016 on VMware Workstation.... [Twitter]( [Facebook]( [LinkedIn]( Edgewood Solutions LLC | PO Box 682, Wilton, NH 03086 [Unsubscribe {EMAIL}]( [Update Profile]( | [Customer Contact Data Notice]( Sent by newsletter@mssqltips.com