Using XQuery To Access XML And Relational Data By Yuli Vasiliev This article provides an example of how you might query both XML and relational data within a single SQL query using Oracle XQuery, demonstrating the Oracle Database’s ability to combine together different format data. In particular, you’ll look at a query that retrieves data from the DEPARTMENTS relational table...
Standard Members
Understanding the purpose of SQL Server Agent – (Part 1)
Understanding the purpose of SQL Server Agent – (Part 1) Author: Basit A. Farooq The SQL Server Agent is a Windows service that runs scheduled jobs. A job is a set of one or more management tasks.The SQL Server Agent service depends on the SQL Server service. In this article, you will learn how to configure the SQL Server Agent...
How to spot a potentially bad boss before accepting a job.
How to Spot a Potentially Bad Boss Before Accepting a Job Hello, this is Laura Lee Rose. I am a speaker and author. My background is in time and project management. I help busy professionals and entrepreneurs create effective systems so that they can comfortably delegate to others, be more profitable and have time to enjoy life even if they...
Tips for using SQL Server 2012 Integration Services (Part 3)
Tips for using SQL Server 2012 Integration Services (Part 3) Use SSIS 2012 Project Connection Managers. The SSIS 2012 allows you to create connection managers at the project level that can shared by multiple packages in the project. The connection manager you create at the project level is automatically visible in the Connection Managers tab of the SSIS Designer window...
SQL Server Integration Service (SSIS): Import and Export wizards
SQL Server Integration Service (SSIS): Import and Export wizards Author: Basit A. Farooq SQL Server includes SQL Server Integration Services (SSIS). SSIS is primarily a data transform and load utility, but its functionality goes beyond that. SSIS provides a flexible development environment that you can use to identify sources and destinations, processing actions, and decision logic. Several SQL Server data...
When and How to Tell Your Boss No
How to Tell Your Boss ‘No’ without Getting Fired Hello, this is Laura Lee Rose. I am a speaker and author. My background is in time and project management. I help busy professionals and entrepreneurs create effective systems so that they can comfortably delegate to others, be more profitable and have time to enjoy life even if they don’t have...
Tips for using SQL Server 2012 Integration Services (Part 2)
Tips for using SQL Server 2012 Integration Services (Part 2) Deploy your projects to the Integration Services server. In SQL Server 2012 Integration Services, you can deploy your projects to the Integration Services server. This is the new project deployment model. The SSIS 2012 enables you to manage packages, run packages, and configure runtime values for packages by using environments....
Deciding Between Multiple Difficult Situations
Deciding Between Multiple, Difficult Situations Hello, this is Laura Lee Rose. I am a speaker and author. My background is in time and project management. I help busy professionals and entrepreneurs create effective systems so that they can comfortably delegate to others, be more profitable and have time to enjoy life even if they don’t have time to learn new...
Using SharePoint to Automate Workflows Part VII
Using SharePoint to Automate Workflows Part VII In this article we shall create a Sample Workflow in Visual Studio 2012: Activity Description: An employee raises a leave request on site. The request is submitted to the superior who can accept or decline the request. Acceptance or decline of the application will result in the final state—communication to the employee. Step...
Tips for using SQL Server 2012 Integration Services (Part 1)
Tips for using SQL Server 2012 Integration Services (Part 1) Integration Services (SSIS) were first introduced in SQL Server 2005 and replace the Data Transformation Services (DTS). By using the SSIS you can load data into or out from SQL Server relational databases or data warehousing. In this article, you can find some tips to boost the SQL Server 2012...