Optimize SQL Server Monitoring (MSSQLTips 2/26/2021)

[View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [SQL Server Integration Services Tutorial - Start Learning]( [Create Calendar Table Using Power Query M Language]( [Create Calendar Table Using Power Query M Language]( Learn how to create a customizable calendar date table that can be used for Power BI reports using Power Query.... [Reading a specific file from a list of objects stored in AWS S3 bucket using Python]( [Reading a specific file from a list of objects stored in AWS S3 bucket using Python]( In this article we cover how to connect to an AWS S3 bucket, read a specific file from a list of objects stored in S3, import the data and convert the raw data into Pandas data frame using Python for structured analysis.... [Optimize SQL Server Monitoring with Redgate SQL Monitor]( [Optimize SQL Server Monitoring with Redgate SQL Monitor]( Learn about how SQL Monitor saves significant time for operational tasks and performance monitoring for large SQL Server environments with instances on premises, in the cloud, running in virtualized environments, clusters, and Availability Groups.... [SQL Server LIKE Examples]( [SQL Server LIKE Examples]( Learn how to use the SQL LIKE operator to search for various string patterns within SQL Server data. This covers several examples of how the SQL LIKE statement can be used.... [Faster SQL Server Clustering]( [Faster SQL Server Clustering]( Making SQL Server deployments resilient to failures is a goal most want to achieve. Whether you are trying to account for high availability and/or disaster recovery, there are various methods to achieve the end goal. One of the most popular approache... [SQL Server script to rebuild all indexes for all tables and all databases]( [SQL Server script to rebuild all indexes for all tables and all databases]( In this tip we look at a simple script you can use to rebuild all SQL Server indexes for all specified databases.... [SQL Server Cloud Migration Options]( [SQL Server Cloud Migration Options]( [Webcast] Let's explore the different mechanisms offered for SQL Server data migration back and forth between on-premises and the cloud solutions.... [Importing and Processing data from XML files into SQL Server tables]( [Importing and Processing data from XML files into SQL Server tables]( In this tip we look at how you can parse an XML file and load into relational tables in SQL Server.... [Controlling Cloud Costs without Sacrificing Availability or Performance]( [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... [By Greg Robidoux -]( [Auditing your SQL Server database and server permissions]( In this tip we look at various system stored procedures that give you insight on your SQL Server database and server permissions.... [By Scott Murray -]( [Using Parameters in Power BI]( I heard Power BI Desktop now allows the use of parameters. Read this tip to learn how to make use of parameters in Power BI.... [By Daniel Calbimonte -]( [Study material for exam 70-764 Administering a SQL Database Infrastructure]( I am going to take the Microsoft exam 70-764, Administering a SQL Database Infrastructure. I would like to know what materials I can use to study and help pass this exam.... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] Edgewood Solutions LLC | PO Box 682, Wilton, NH 03086 [Unsubscribe {EMAIL}]( [Update Profile]( | [Customer Contact Data Notice]( Sent by newsletter@mssqltips.com