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
