Poojakamath
Find the Session ID of an executing SQL Agent job
On a busy production server I wanted to check when a job started running , I tried to look at the...
Author: Pooja Kamath Date: 07/19/2018
Where is my SQL BPA(Best Practice Analyzer) for SQL 2014/2016/2017?
We recently built a SQL 2016 Server for a client and wanted to check if the best practices have been...
Author: Pooja Kamath Date: 05/03/2018
SQL 2012 BPA error- 'Login does not exist on SQL Server OR Login is not a member of the Systems Administrator role'
I was recently trying to use the diagnostic tool Microsoft SQL Server 2012 Best Practice Analyzer on...
Author: Pooja Kamath Date: 05/08/2017
Using REST API to pause Azure SQL Data Warehouse - “Bearer authorization error='invalid_token', error_description='The authentication scheme of not supported”
A customer of mine recently approached me for assistance to help resolve an Authorization error he...
Author: Pooja Kamath Date: 12/24/2016
Automatically Monitor and Change the service tier and performance level (pricing tier) of an Azure SQL database based on the DTU alert using Webhooks, Alerts, Runbooks
We all know how easy it is to change the service tier of an Azure SQL database as the needs of your...
Author: Pooja Kamath Date: 12/24/2016
Could not obtain exclusive lock on database 'model'. Retry the operation later. CREATE DATABASE failed
After installing a SQL server 2008 R2 instance SQL_SERVER\MSSQLSERVER2008R2 side by side on the Box...
Author: Pooja Kamath Date: 12/23/2014
There is insufficient system memory in resource pool 'internal' to run this query. Error: 701, Severity: 17, State: 123" on SSB Target Server - CACHESTORE_BROKERTO is consuming memory
I recently worked with a customer where the Target server for his Service broker application...
Author: Pooja Kamath Date: 12/23/2014
SQL Agent skipping Scheduled job runs!!– But the Job History does not reveal anything!
A Scheduled SQL Agent job skipped a Scheduled run on one particular day and the DBA wanted to...
Author: Pooja Kamath Date: 02/20/2014
The job History of all SQL Server Scheduled jobs are getting deleted automatically on a daily basis!
In this blog I would be explaining how we resolved a Scenario where a customer reported that “The...
Author: Pooja Kamath Date: 02/18/2014