(Pinal Dave) One of the pre-requesting of Comprehensive Database Performance Health Check is to check if user has necessary system admin rights or not. It is almost impossible to help customer with SQL Server Performance if they do have a DBA who has access to system admin rights.
Tag: sql server
(Kathi Kellenberger) I’ve used other tools for monitoring SQL Server, but this was my first look at SQL Monitor made by Redgate Software.
(Manoj Pandey) In-Memory tables were introduced in SQL Server 2014 and were also known as Hekaton tables. You can check my previous articles about In-memory tables for [SQL Server 2014] and [SQL Server 2016].
(Don Castelino) This blog covers the process of migrating SAP ASE databases to Microsoft SQL Server using SQL Server Migration Assistant (SSMA) tool.
SQL SERVER – Fix Error – Restore Operation Failed for Database Due to Insufficient Memory in the Resource Pool ‘Default’
(Pinal Dave) Recently I faced a strange error related to SQL Server, during Comprehensive Database Performance Health Check. The error indeed surprised me because as I have been doing performance tuning consulting for over 10 years, this is the first time I walked into this error.
(Ben Richardson) Performance testing is one of the most critical criteria to evaluate SQL Server database efficiency. Poorly written queries affect database performance. However if you only have a small amount of data in the database, it becomes difficult to evaluate how well a query is performing.
SQL SERVER – Login Failed. The Login is From an Untrusted Domain and Cannot be Used with Windows Authentication
(Pinal Dave) Many people ask me how is the life as a freelancer, as a consultant? My answer is “life is good, but to get the complete picture, you have to experience it”.
(Jack Vamvas) Question: I’m just investigating a SQL Server Agent Job failure and noticed there were no records in the SQL Server Agent history log.
(Tim Radney) Azure SQL Database currently has three service tiers to choose from for your workload. These tiers consist of Basic, Standard, and Premium. Basic supports only one size of 5 DTUs. Premium starts at 125 DTUs and goes up to 4,000 DTUs.
Centennial apps/desktop bridge, SQL Server and error ‘The data area passed to a system call is too small.’
(Tejas Shah) The title of the blog may throw someone off a little. After all, SQL Server is not a centennial app and the error message doesn’t appear to have anything to do with SQL Server. So please bear with us while the whole scenario is explained.