The Curious Engineer

All blogs / Databases

Poojakamath

learn.microsoft.com/en-us/archive/blogs/poojakamath

DatabasesMicrosoft blogsMSDN archive

’15’20’25
Posts
9 from 18 Feb 2014 to 19 Jul 2018
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/poojakamath/feed.xml

2018 2

  1. Find the Session ID of an executing SQL Agent job
  2. Where is my SQL BPA(Best Practice Analyzer) for SQL 2014/2016/2017?

2017 1

  1. SQL 2012 BPA error- 'Login does not exist on SQL Server OR Login is not a member of the Systems Administrator role'

2016 2

  1. Using REST API to pause Azure SQL Data Warehouse - “Bearer authorization error='invalid_token', error_description='The authentication scheme of not supported”
  2. 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

2014 4

  1. Could not obtain exclusive lock on database 'model'. Retry the operation later. CREATE DATABASE failed
  2. 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
  3. SQL Agent skipping Scheduled job runs!!– But the Job History does not reveal anything!
  4. The job History of all SQL Server Scheduled jobs are getting deleted automatically on a daily basis!