Archives

SQL Server 2014 Tutorial – Manage SQL Server services

Problem Statement You need to manage the SQL Server services that are installed on your server machine. Solution Use SQL Server Configuration Manager tool to manage the SQL Server services on your machine. Following are some of the actions that you can perform using the SQL Server Configuration Manager – Start , Stop , Pause , Restart a SQL Server Service – Modify or configure…

InterSystems IRIS TSQL Code 1950 Index on view ‘%.*ls’ cannot be created

In this post, you’ll learn about the SQL error code 1950 in InterSystems IRIS database the reason why you are receiving the TSQL message when using the InterSystems IRIS data platform Error Code : 1950 Reason for the Error code 1950 in InterSystems IRIS DBMS Index on view ‘%.*ls’ cannot be created because the view contains an imprecise expression in a GROUP BY clause

How to fix the Oracle error ORA-01300: writable database required for specified LogMiner options?

In this post, you’ll learn more about the Oracle ErrorORA-01300: writable database required for specified LogMiner options with the details on why you receive this error and the possible solution to fix it. Oracle Error Description ORA-01300: writable database required for specified LogMiner options Reason for the Error ORA-01300: writable database required for specified LogMiner options Options were specified which required the database to be…