sql-server Archives - Page 4 of 8 - Performance Tuning And Infra Automation

Should we check [context_switches] for SQL Server Query from Performance Point

Hi Friends. If you are wondering if we should check [context_switches] counter for SQL Server Queries while performance tuning, then here is the official verdict from Paul Randal. Thanks Friends!…

Ajay Dwivedi May 27, 2018

Powershell

Copy SQL and Batch Files from Source to Destination using PowerShell

Recently as part of Server Migration, I had to move nested folders and files from Source server to Destination. This task becomes hard when directory has child folders and files…

Ajay Dwivedi May 2, 2018

Database Administration

OlaHallengren Maintenance Solution – DatabaseBackup – Configurable Backup Directory folder names

If you are a DBA then you understand the importance of having robust Database Maintenance Solution. Like everybody in SQL Server Community, Ola Hallengren's Maintenance Solution is my favorite. Two…

Ajay Dwivedi April 24, 2018

Powershell

Get-ProcessForDBA cmdlet in SQLDBATools Module

Troubleshooting high memory utilization on servers involves finding out processes which are consuming RAM. But default methods like Task Manager, or Get-Process cmdlet of PowerShell are difficult to read and…

Ajay Dwivedi April 22, 2018

TSQL

Starting SQL Server Database Administration Classes from May 2018

Hi Friends, I have finally decided to go with another batch for SQL Server Database Administration from May 2018. This would be 4-month course for 5 days per week with…

Ajay Dwivedi April 20, 2018

Health Check TSQL

SQL Server – Stop Agent Job After Threshold Time and Log the Query Metrics

Being a DBA, I know the pain of a long running job creating performance issues for other jobs and user sessions. For my current organization, I have created below TSQL…

Ajay Dwivedi April 19, 2018

TSQL

SQL Server – Get Database Backup History for Crash Recovery

It is not easy to find out right backups for restore activity when people are watching you during database crash situation. So I have created below TSQL script that would…

Ajay Dwivedi April 18, 2018

Errors TSQL

Error/Fix: Cannot resolve the collation conflict between “Latin1_General_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation

Recently I was working on a SQL query in my inventory database, and was greeted with below error message:- Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the…

Ajay Dwivedi April 15, 2018

TSQL

Script-SQLDatabaseRestore cmdlet in SQLDBATools Module

Restoring multiple databases can be painful especially when each of them have multiple database file(s). Four years back, I wrote TSQL script that would accept database backup path, and result…

Ajay Dwivedi April 14, 2018

Database Administration

Setup Custom Log Shipping in SQL Server

When it comes to Disaster Recovery Setup, every DBA has its own preference. I personally prefer Log Shipping since it involves very little effort to setup. Log shipping has many…

Ajay Dwivedi April 7, 2018