Execution runtime information for developers ;)

Developers should use this statistics to get more information about what they just did and pay attention to high physical or logical read values. SQL Server provides commands that are used to return query statistics like SET STATISTICS IO, TIME. The IO command return information about physical, logical for tables referenced in the query and … Continue reading Execution runtime information for developers šŸ˜‰

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

SQL Operations Studio Linux

Great news, a visual way to manage SQL Server from Linux. SQL Operations Studio came to fill a gap we were waiting to develop and manage SQL Server databases on Linux. In the link https://github.com/Microsoft/sqlopsstudio we can see more information like the features below. Feature Highlights Cross-Platform DB management for Windows, macOS and Linux with … Continue reading SQL Operations Studio Linux