Blog Archives

Microsoft SQL Server Performance Dashboard Reports – 1 – Intro & Default Install

Performance Dashboard Reports are Reporting Services report files designed to be used with the Custom Reports feature of SQL Server Management Studio. The reports allow a database administrator to quickly identify whether there is a current bottleneck on their system, and if a bottleneck is present, capture additional diagnostic data that may be necessary to resolve the problem.
CPU bottlenecks (and what queries are consuming the most CPU)
IO bottlenecks (and what queries are performing the most IO)
Index recommendations generated by the query optimizer (missing indexes)
Latch contention

Tagged with: , , , , ,
Posted in reporting, sql, SQL Server, sql server performance

How to configure SQL Database mail (or any other application) to send emails using Office 365 (Exchange Online): A walk through and options

  Hi, What I have come to understand is that with Office365 email routing the configuration settings for email relay are, Server:                        Port Number:    587 Authentication:                Basic (An email address and password) We can set this up

Tagged with: ,
Posted in email, SQL Server, Uncategorized

SQL Server Restoring backups from UNC Network paths and Recovery Time Objectives

Might sound very basic but I still come across colleagues who are confused on this topic. SQL Server management studio when restoring backups does no let you browse to network drives. That is why if quick workarounds are not known people

Tagged with: , ,
Posted in backup, sql, SQL Server

Usage data for SSRS reports to decide on reports to consider for re-engineering & retiring

You have a SSRS instance on either live or production and you want to find out which reports and most / least used. Luckily SQL Server maintains by default SSRS usage info in audit logs it maintains. Although you can

Tagged with: , , ,
Posted in sql, SQL Server, ssrs, tsql

Encrypt SQL Server connections

SQL Server connections can and should be encrypted where possible but must when passing through public circuits. The overview of the process of setting up SQL Server connection encryption is as follows. Get a certificate issued by the CA in

Tagged with: , , , , ,
Posted in security, sql, SQL Server

SQL Server Index and Statistics maintenance: Importance and a good solution with explanation (Ola hallengren’s IndexOptimize)

INTRODUCTION Index and Statistics need to be maintained regularly for optimum performance of a SQL Server database engine. The SQL Server core engine within the Query Optimizer part of it, uses Indexes and statistics to create a query plan to

Tagged with: , ,
Posted in sql, SQL Server, tsql

Running Diagnostic TSQL scripts remotely within and without SCOM- 1

Requirement: To be able to run a generic diagnostic information gathering script remotely via System Center Operations Manager on a SQL Server instance without having to start a separate session of SSMS and / or RDP and executing script. There

Tagged with: , , , ,
Posted in Development, Monitoring, SCOM, sql, SQL Server, tsql

Add local windows Administrators group to SQL Logins

Adding Windows groups (local or domain) based security is best practice as it can help you in a situation where you loose credentials potentially. You want to add Local Windows Administrators group to have SA or any other permissions in

Tagged with: , , , ,
Posted in Active Directory, security, sql, SQL Server, tsql

SSRS reports & URL / query string parameters passing

You have a parametrised report and you want to run it with a simple URL with non default parameter values. Here’s how you do it.Get the default URL of the report in report viewer. http://<ssrs server>/ReportServer/Pages/ReportViewer.aspx?%2fFolder1%2fFolder2%2fReport+File+Name&Param1=Value1&Param1=Value2&Param2=Value3

Tagged with: , , , , ,
Posted in sql, SQL Server, tsql

SQL Server installed with wrong collation and the process to change it

SQL Server installed with wrong collation and the process to change it

Tagged with: , , ,
Posted in sql, SQL Server, tsql