Categories
Sql Server Technology - Tips

Performance Monitor

Performance Monitor In this tutorial we will discuss about Performance Monitor. You can use Windows Performance Monitor to examine how programs you run affect your computer’s performance, both in real time and by collecting log data for later analysis. Windows Performance Monitor uses performance counters, event trace data, and configuration information, which can be combined into Data […]

Categories
Sql Server

Some Important Trace Flags for SQL Server DBA

Some Important Trace Flags for SQL Server DBA In this post we will discuss Some Important Trace Flags for SQL Server DBA. A trace flag is used to set specific server characteristics or to switch off a particular behavior of the SQL Server. You can enable the trace flag from Startup Parameters, Session and Global Session level. Trace […]

Categories
Sql Server

How To Compare 3 Numbers Using TSQL In SQL Server

How To Compare 3 Numbers Using TSQL In SQL Server In this tutorial we will learn How To Compare 3 Numbers Using TSQL In SQL Server. Below sql codes easily sort 3 numbers given as variables from biggest and smallest values. First declares variables for input values. These numeric variables are declared in int data type with […]

Categories
Sql Server

Configure SSL Connections on Report Server-HTTPS

Configure SSL Connections on Report Server-HTTPS In this tutorial we will learn how to configure SSL connections on report server -HTTPS.You must have a server certificate installed on the computer.Ask for the certificate to your sysadmins(windows admins), or request a certificate from a trusted certificate authority. How to Configure: 1. Run Reporting Services Configuration Manager and connect […]