Below are Oracle’s most popular “emp” and “dept” tables compatible with SQL Server. — Table definition – Dept CREATE TABLE Dept( DeptNo INT, DName VARCHAR(14),
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
Database Restore Information with Restore Start and Completed Date Time
Following points to be accomplished – Get all the databases restoration information From all reporting, staging or testing environments Information about when the database restoration
SQL Server – Data Export to XML
One of my friend requested me to explain how many ways are there to export the data from SQL Server 2005 into an XML file.
SQL Server – INSERT through Stored Procedure
There is one post in this blog in which we explored how to use the INSERT statement in different ways. Here is another instance of
SQL Server – List-out Procedures, Functions, Triggers
In order to know which procedures, functions, and triggers exist in the database, the following queries can help you to find this out.: The below
SQL Server – Insert Data From Linked Server Table
In a situation where Servers are linked, it is possible to retrieve data from a table in one server to a table on the other
Big Data & SQL 