Azure and the Tools
Many organisations have already been migrated to Microsoft Azure. Yet the others have been planning to migrate their infrastructures to Azure Cloud. The below referenced link will assist the new users. Although many of the […]
PostgreSQL 9.4 on CentOS 7 Installation and Database Creation
PostGreSQL is a powerful open source database which has been widely used by many companies. This post video will explain the important steps to achieve the same. Those who are interested in open source and […]
SQL Server Activity Capture
If you are interested in any activity of your SQL Server, you may use the below query to find out.
Finding document extension only on column having filename with extension
OBJECTIVE: To find the document extension from sql server table column if the column does have filename along with extension. QUERY: SELECT TOP 10 PATINDEX(‘%.%’, DOC_FILENAME) […]
DeadLock Finding – SQL Script
DeadLock On SQL: Occasionally you may find deadlock on the SQL Server. If you have enabled the trace, it will appear in the error log. Alternatively you can use the below script to see. Tested […]
Automatic Failover of Availability Group to the Preferred Node – SQL Agent Job
Objective: This post information is created to automate the Failover of Availability Group to the Preferred Node via SQL Agent Job. There is a variable of TIME assigned to the automation SQL Server stored procedure to […]
Oracle To SQL Migration – Permissions
Objective: To migrate oracle database objects to SQL Server via SSMA, the following permissions requires from Oracle (Oracle Permissions to Migrate via SSMA) Reference: https://docs.microsoft.com/en-us/sql/ssma/oracle/connecting-to-oracle-database-oracletosql Required Oracle Permissions: The account that is used to connect […]
TimeStamp of Change To a Row In Oracle Table
Objective: To find the recent modified date time of the object in oracle can be find out by using the following scripts. If we keep only the schema restriction, it can pull out all the […]
Link Server Creation using the Preferred Name
Objective: Link Server creation in any preferred name like MyTelecomLink, can be done via the below script. Here @server is the preferred name in the below script And @datasrc is the SQL Server Instance Name […]
SSRS Migration
Objective: SQL Server Reporting Services Migration Tested from SQL Server 2008 to SQL Server 2016 steps are noted in the below. This will make the content of the SSRS to move to another server easily. […]
SQL Server Agent Job History
Objective: To find the SQL Server Agent Jobs duration including each step in the job, the below script may be useful. Tested on SQL Server 2016. Companies SQL Server instance may experience some performance issue […]
Search a String or Word From All the Tables in a SQL Server Database
Objective: This procedure is to search a string or word from the entire database tables in a given database. Suppose if anyone does not know where exactly the specific string, then this will be your […]