Blog: Pinal Dave


210 blogs updated: 48 min. ago
How to Get VLF Count and Size in SQL Server? – Interview Question of the Week #161
Question: How to Get VLF Count and Size Information in SQL Server? First appeared on How to Get VLF Count and Size in SQL Server? Interview ...
3
18-02-2018 03:29:53 Pinal Dave SQL Server
SQL SERVER – Patch Rule Failure: Not Clustered or the Cluster Service is Up and Online
One of my clients contacted me for quick assistance. They were trying to install a Service pack for SQL Server 2016 instance, but it was fai...
6
17-02-2018 03:34:36 Pinal Dave SQL Server
SQL SERVER – Maintenance Plan Error: Cannot Create a Task From XML For Task, Eue to Error 0x80070057. The Parameter is Incorrect. (OnPreExecute)
Once I encountered an error while creating new maintenance plans on my virtual machine. First appeared on SQL SERVER Maintenance Plan Error:...
9
16-02-2018 03:29:03 Pinal Dave SQL Server
SQL SERVER – Don't Ignore Warning: Cluster Resource DLL Update Restart Check
This was one of the hard lessons learned, so I am sharing with blog readers. This is about an error in cluster resource DLL. While applying ...
12
15-02-2018 03:21:20 Pinal Dave SQL Server
SQL SERVER – Unable to Connect to SQL Server in Azure Virtual Machine from SSMS on On-Premise Machine
From past few months, I am seeing a few of my client moving their development workload to Cloud. When I asked the reason, it was mostly cost...
8
14-02-2018 04:34:19 Pinal Dave SQL Server
SQL SERVER – Script Level Upgrade for Database ‘master' Failed Because Upgrade Step ‘sqlagent100_msdb_upgrade.sql' – Error: 5041: MODIFY FILE Failed
I have helped many clients in upgrade failures via my On-Demand consulting and I am amazed to see various ways which can break SQL Server up...
12
13-02-2018 03:03:52 Pinal Dave SQL Server
SQL SERVER – Full-Text Search Not Working For PDF Documents
Full-Text is a feature of SQL Server which allows linguistic search in various languages. In general, we use LIKE operator to search inside ...
13
12-02-2018 03:10:21 Pinal Dave SQL Server
How to Schedule a Job in SQL Server? – Interview Question of the Week #160
Question: How to Schedule a Job on SQL Server? Answer: A very old and widespread question, keep on coming back to in interviews. Let us see ...
12
11-02-2018 03:15:57 Pinal Dave SQL Server
SQL SERVER – Installation Error: The Cluster Resource is Not Available. (Exception from HRESULT: 0x8007138E)
Sometimes DBAs get into a situation where they don't know what the next steps is to fix the issue. Here is one of the situation where DBA co...
12
10-02-2018 03:28:02 Pinal Dave SQL Server
SQL SERVER – What is Change Pending State of in SQL Server Configuration Manager?
Recently, one of my clients contacted me for an issue about Change Pending State where they were having issues where SQL Server. As soon as ...
13
09-02-2018 03:25:51 Pinal Dave SQL Server


© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.