After the tip https://www.mssqltips.com/sqlservertip/5526/how-to-setup-and-use-a-sql-server-stretch-database/ I made a video to show step by step how to enable stretch database. https://www.youtube.com/watch?v=nOMantIoy2U&t=7s
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/
