One of the great things about SQL Server is that the platform has grown to include a number of configuration options and switches that allow a DBA to get the most performance from their instance that is possible. One of the downsides of the platform, however, is that any sysadmin can make changes (or db_owner […]
The post Tracking Configuration Changes Against a Baseline appeared first on SQLServerCentral.

Learn how to find and remove a large SQL Server Error Log file when it consumes a lot of space on your drive
The post Identify and Correct a Large SQL Server Error Log appeared first on SQLServerCentral.

Watch this 30-minute training session to discover how you can use SQL Prompt in combination with other tools in SQL Toolbelt Essentials to boost productivity, simplify collaboration, and deliver accurate database changes faster.
The post Training: Maximize the power of SQL Prompt with SQL Toolbelt Essentials appeared first on SQLServerCentral.

There’s more to security in MySQL than user account privileges. In this article, Lukas Vileikis explains the other components of MySQL security
The post Security in MySQL: Part Two appeared first on SQLServerCentral.

This article shows how you can incorporate Python scripting inside a Power BI report.
The post How to Get Data Using Python in Power BI appeared first on SQLServerCentral.

We created a new, short video to show how a DBA can use SQL Monitor in their day to day work, including sharing reports with senior leaders. Watch it now.
The post A day in the life of a DBA using SQL Monitor: in a 90 second video! appeared first on SQLServerCentral.

In this article, we look at how to build a Python application that runs as a Windows Service to handle ongoing routine tasks.
The post Running a Python Application as a Windows Service appeared first on SQLServerCentral.

Learn how to create a backup of log data in Amazon's Redshift.
The post How to Backup Redshift Log Views appeared first on SQLServerCentral.