As a DBA, we are often tasked with maintenance work on the database. Often this includes making sure that old data is purged from the tables.  This is especially true with logging tables.  Sometimes multiple applications write to the same logging tables, and they can grow very quickly. Let’s say we have a logging table […]
The post How to Delete Large Amounts of Data appeared first on SQLServerCentral.

This tip demonstrates models for detecting the start of periods of rising or falling financial securities prices based on exponential moving averages. The demonstration is simplified because it relies on a log to keep track of time series values as well as exponential moving averages with different period lengths.
The post Model and Log Trend Reversals for Time Series Data in SQL Server appeared first on SQLServerCentral.

BMW have been monitoring their SQL Server estate for more than 7 years, but with evolving technology and circumstances, monitoring also needs to change and grow. Join Tony Maddonna in conversation with Redgate's James King, to discover how BMW are handling the challenges.
The post Monitoring Large Estates at BMW appeared first on SQLServerCentral.

Big data can be risky, which is why you need great estate management. Join Matt Schmelzer, Data Systems and Automation - IT, and Jonathan Holck, IT Associate, from Artisan Partners in discussion with Microsoft MVP Grant Fritchey to learn how they implemented a successful infrastructure and what tools they need to support their growing estate.
The post Database technology trends appeared first on SQLServerCentral.

Learn how to use IIF, Switch and Choose logical functions in SSRS reports to make your reports more dynamic and more appealing to report users.
The post SSRS IIF, Switch and Choose Functions for Dynamic and Appealing Reports appeared first on SQLServerCentral.

We’re sharing the results of our State of Database Monitoring survey in four insights reports this year – and the second one is out now. In The value of a monitoring tool for the entire organization you’ll learn why more businesses than ever are using a monitoring tool and how doing so can help the entire business to reduce costs, enhance security and collaborate more efficiently. DBAs - download a copy and send it to your boss, today!
The post State of Database Monitoring Report 2 appeared first on SQLServerCentral.

There are many ways to load data into a SQL Server database. In this article, Greg Moore demonstrates how to get PowerShell to do more of the work.
The post Building an ETL with PowerShell appeared first on SQLServerCentral.

Learn how you can perform an offline migration of a SQL Server to Azure Managed Instances or IaaS VMs.
The post Using Azure Data Studio and the SQL Migration Extension to Perform Offline Migrations appeared first on SQLServerCentral.