Simple SQL Server Backup Script, Database Performance Gains, Azure Synapse Analytics, Stored Procedure Tutorial and more (MSSQLTips 12/4/2020)

[tag] [View MSSQLTips newsletter online]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [SQL Server Machine Learning Tutorial]( [Getting Started with Azure Synapse Analytics Workspace Samples]( In this article, I will cover how to get started with Synapse Analytics (workspaces) by leveraging some practical examples, code, and use cases provided by the Synapse Analytics Workspaces Knowledge Center.... [Job Descriptions 101: The Reality of Requirements]( In this article we look at the realities of job descriptions and why they don't always make sense for a particular job as well as some tips to overcome any frustration when looking at job requirements.... [Monitor, Manage and Improve Database Performance]( Around the globe, SQL Server professionals are being asked to support more applications, infrastructure and code, while continuously ensuring all applications are performing optimally. That is a tough mission to uphold without a means to monitor, di... [Find and Remove Duplicate Rows from a SQL Server Table]( Duplicate records in a SQL Server table can be a very serious issue. With duplicate data it is possible for orders to be processed numerous times, have inaccurate results for reporting and more. In SQL Server there are a number of ways to address d... [Feel the Need for Speed in your SQL Server databases!]( [Video] Query tuning is key to peak performance in SQL Server databases. However, lots of developers and DBAs constantly struggle to pinpoint the root cause of performance issues and spend way too much time in trying to fix them.... [Calculating MTD, QTD, YTD, Running and Cumulative Total in Power BI]( In this tip, I will walk through a method to calculate MTD, QTD, YTD and running total in Power BI. This method is useful in stock calculations and balance sheet calculations.... [Secrets to High Availability for SQL Server on AWS]( Many companies rely on key applications such as SQL Server for their important business functions. Because downtime for these applications can be devastating to their business, IT typically has to meet strict service level requirements/agreements (SL... [Simple script to backup all SQL Server databases]( Sometimes things that seem complicated are much easier then you think and this is the power of using T-SQL to take care of repetitive tasks. One of these tasks may be the need to backup all databases on your server. This is not a big deal if you h... [Start Learning about SQL Server Stored Procedures]( This popular tutorial will cover creating a simple SQL Server stored procedure to more advanced options that can be used when creating stored procedures.... [A closer look at CXPACKET wait type in SQL Server]( If you have a server that has more than one CPU core, you may experience high values of SQL Server CXPACKET wait types. This is typically due to queries that run in parallel and the real issue is to understand how different versions of a query can impact... [Crosstab queries using PIVOT in SQL Server]( In this tip we look at how to construct a SQL Server PIVOT query with an example and explanation.... [Study material for exam 70-465 Designing Database Solutions for Microsoft SQL Server]( I am studying for Microsoft exam 70-465, Designing Database Solutions for Microsoft SQL Server and I'd like to know what materials I can use to study to pass this exam.... [Twitter]( [Facebook]( [LinkedIn]( [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}