Using wait stats on SQL Server

I wrote two posts about wait stats:  What wait means About SQL Server saving wait stats on DMVs Now, going deeper on wait stats and see "why SQL Server is running slow?". To answer that question I like to start with the DMV sys.dm_os_wait_stats, because this DMV provides a running total of all waits encontered … Continue reading Using wait stats on SQL Server

Using SQL Operations Studio Agent

SQL Operations Studio Agent is visual way to see, edit and create SQL Server jobs and everybody was asking this feature when SQL Operations Studio appears. To install this the agent follow the link https://docs.microsoft.com/en-us/sql/sql-operations-studio/sql-server-agent-extension?view=sql-server-2017. Installing the agent  With the extension installed, right-click on the instance -> Manage to see the server jobs  But, not everything … Continue reading Using SQL Operations Studio Agent

How to install SQL Server SQLPS Powershell module

SQLPS module to Powershell helps to do so many things on SQL Server without SSMS and the main objective is to automate tasks for your environment. This module isn't installed by default, so there are a couple of steps before use it. First, install the module and the simple cmdlet install-module SQLPS won't work. To … Continue reading How to install SQL Server SQLPS Powershell module

Database migration methods

When thinking about migration the most common issue is downtime. There are some methods that require downtime like backup/restore or less downtime using Log Shipping. You can choose several different methods to migrate your database.  For example, methods that require downtime include: Backup the database, manually copy the backup file to the machine and then … Continue reading Database migration methods

SqlPackage a tool to import/export SQL Server and Azure SQL DB

SqlPackage is a command-line utility that you can use for exporting and importing operations in both on-premises SQL Server databases and in cloud databases. SqlPackage supports the following operations: Extract. Creates a database snapshot DACPAC file from a SQL Server database or from Azure SQL Database. Publish. Updates the schema in a live database to … Continue reading SqlPackage a tool to import/export SQL Server and Azure SQL DB

SQL Operations Studio Dashboards

SQL Operations Studio is a free tool that runs on Windows, macOS, and Linux, for managing SQL Server databases. I have a great experience running this tool on Linux CentOS and you can build server and database management dashboards  like below. To create custom dashboards check out my tip https://www.mssqltips.com/sqlservertip/5434/customize-sql-operations-studio-dashboards/