Materials for tag

DBA

All Resources
Showing 100 out of 100 results
Reset filters
Capture DB Usage Before Planning Decommission
Capture DB Usage Before Planning Decommission
In large establishments, where there are many servers, there are always chances of some servers or databases not being used but which remain operational.
April 21, 2021
Backup and restore command ETA Status
Backup and restore command ETA Status
Whenever doing restoration and backup task for big databases it is difficult to give an ETA to stakeholders. The below command helps to get the status at percent level of completion....
April 20, 2021
All About Your VMS Solution
All About Your VMS Solution
Vendor Management System has become a vital tool for companies to handle their resources. Read about how it helps the organizations automate it. As companies become increasingly...
March 11, 2021
Why ERP Owners Must Implement Direct Machine Integration
Why ERP Owners Must Implement Direct Machine Integration
The business world knows that implementing the “operational system,” means taking care of the day-to-day transactions and tasks at hand. Many organizations go for systems ...
February 24, 2021
8 Benefits of ERP & SQL Server for a Great Performance and Scalability
8 Benefits of ERP & SQL Server for a Great Performance and Scalability
The dream team of ERP and SQL Server can deliver a number of impressive advantages to the organizations that make use of them. To understand a little more about...
December 16, 2020
How to manage change during an AP automation project
How to manage change during an AP automation project
As many accounts payable departments are starting to plan for 2020, chances are, automation figures prominently in those plans. Eliminating paper processes and manual tasks ranks among the top...
December 5, 2020
How Do You Analyze Your Data?
How Do You Analyze Your Data?
Your enterprise resource planning (ERP) system is already integrating all facets of your operations, from product planning and development to sales and marketing.
November 29, 2020
No-Code Application Development Platform
No-Code Application Development Platform
No-Code platforms are widely visible in companies of all sizes and for a wide variety of reasons. Many companies are unable to hire or afford top-notch software development talent who are becoming scarce globally. Others don’t want to wait for their IT department to get around to their project when…
November 2, 2020
How to secure web API using JToken
How to secure web API using JToken
When we are developing Web API for mobile application, it should be secure and recognize the authorize user. Create a token for individual user at the time of log in to you...
October 25, 2020
Changing MaxMTServers and MinMTServers values in Siebel
Changing MaxMTServers and MinMTServers values in Siebel
Start the Siebel server manager (srvrmgr) program Log into one of the Siebel server boxes. For Windows servers only: at the DOS prompt, change to the bin subdirectory...
October 24, 2020
SQL Server database migration to SQL Database in the cloud environment without Downtime
SQL Server database migration to SQL Database in the cloud environment without Downtime
To ensure that the source database is compatible with Azure SQL Database using the Data Migration Assistant (DMA). SQL Database V12 is approaching feature parity with SQL...
October 24, 2020
Common DBA Project Challenge and their Resolution
Common DBA Project Challenge and their Resolution
Problem To me, the biggest blunder is knowing that a problem exists and either ignoring it or procrastinating on the implementing the resolution. This tip focuses on Common DBA project...
October 24, 2020
100% uptime with SQL Azure DR Plan
100% uptime with SQL Azure DR Plan
With the allure of cost savings, greater flexibility, and more agility, many organizations are eyeing the cloud as an alternative for deploying new applications, including those...
October 19, 2020
Help to achieve SOX compliance auditing to organization
Help to achieve SOX compliance auditing to organization
Achieving SOX compliance requirements is mandatory for all publicly traded companies. But when it comes to most IT teams, SOX compliance can be quite vague and confusing. SOX compliance....
October 19, 2020
Start The Onboarding Process With Pre-boarding
Start The Onboarding Process With Pre-boarding
A new approach For many organizations, the onboarding process begins immediately after the offer is accepted and prior to day one of the job. During this pre-boarding phase, organizations...
October 18, 2020
Script to capture user’s permissions in a database
Script to capture user’s permissions in a database
This T-SQL code will script out database and object level permissions to help make it easier to backup and restore databases, and subsequently restore the permissions.
October 17, 2020
Copy Variables from one QVW to another using a button click
Copy Variables from one QVW to another using a button click
Variable in qlikview is not just temporary storage while executing script. Indeed, variables will exist after the script execution is finished. Variables provide lot of flexibility...
October 17, 2020
How to convert image to pdf using Image Magic in C#
How to convert image to pdf using Image Magic in C#
This blog will discuss how to convert any type of image file (.jpg, .gif, .tif ..) to pdf. I found a free tool “ImageMagic.NET”. You can download the DLLs from http://imagemagick...
October 17, 2020
Selecting next value in listbox using button in Qlikview
Selecting next value in listbox using button in Qlikview
The list box is the most basic sheet object. It contains a list of all possible values of a specific field. Each row in the list box can represent several records in the loaded...
October 17, 2020
Streamlined Onboarding in Healthcare Is an Imperative
Streamlined Onboarding in Healthcare Is an Imperative
Employee Onboarding For Healthcare Recent studies show that the healthcare industry has the third highest turnover rates of all industries, coming in at 18.9 percent.
October 17, 2020
Tips to export objects from Qlikview to word
Tips to export objects from Qlikview to word
Exporting to word in Qlikview can be achieved through the VB macro. When export to word, the properties won’t remain the same in word example, width...
October 17, 2020
Selecting previous value in listbox using button in Qlikview
Selecting previous value in listbox using button in Qlikview
The list box is the most basic sheet object. It contains a list of all possible values of a specific field. Each row in the list box can represent several records in the loaded...
October 17, 2020
How To Effectively Offboard Employees In Any Situation
How To Effectively Offboard Employees In Any Situation
How to Effectively Offboard Employees Employees may leave a company for a number of reasons: a new job opportunity, retirement, sickness or a change in family...
October 17, 2020
Pop-up Windows in SSRS
Pop-up Windows in SSRS
In This post we can find that how to perform the Pop-Up windows in SSRS report. Much of the data on the main report did not need to be displayed all the time, the users only needed...
October 17, 2020
Finding number of rows of the table dynamically on selection
Finding number of rows of the table dynamically on selection
In Qlikview, row numbers can be calculated either from the script or Designer end. To show in table we need to add a calculated expression, this show each...
October 16, 2020
PeopleSoft Fluid WorkCentre Framework
PeopleSoft Fluid WorkCentre Framework
PeopleSoft Fluid WorkCentre Framework This feature allows the system administrators to create WorkCenters that can be used on a mobile device, such as: Smar...
October 13, 2020
Taking Thread Dumps Multiple Times in WebLogic Using Script
Taking Thread Dumps Multiple Times in WebLogic Using Script
Using the following steps, we can generate thread dumps for Weblogic JVM’s: Step 1: Firstly, if the user is using Java, then the user should export the Java path as “export ...
August 24, 2020
Gathering Information to Restore Databases
Gathering Information to Restore Databases
On a daily basis, we often have to restore a database to a different server and relay the information back to the business owner to validate the task’s completion. To properly restore the database...
August 24, 2020
Cluster Messaging Protocols in Weblogic
Cluster Messaging Protocols in Weblogic
WebLogic Server supports two cluster messaging protocols: Multicast – This protocol, which relies on UDP Multicast, has been around since WebLogic Server...
August 15, 2020
Managing Change During Uncertain Times With NetSuite Planning and Budgeting
Managing Change During Uncertain Times With NetSuite Planning and Budgeting
Like many organizations, you are probably concerned about the impact of the current economic situation on your financials and workforce. There is a lot you can’t control during uncertain times like these. Still, you can take steps to protect your organization and create action plans to maintain and grow your…
August 14, 2020
Form I-9 Webinar presented by the DHS
Form I-9 Webinar presented by the DHS
Form I-9 ‘Who’s Eyeing your Form I-9’? This webinar is the first session in a two-part series that provides greater detail than just the basics of Form I-9. The DHS covers form completion for remote hires, use of abbreviations, what address should be entered in each address block (this will…
August 14, 2020
Robotic Process Automation and AI In Your ERP
Robotic Process Automation and AI In Your ERP
The information in this Webinar-On-Demand will assist you and your organization in understanding how Robotic Process Automation (RPA) plays a role in your ERP. It will also discuss how the use of RPA for ERP-driven processes can assist organizations like yours in making routine, time-consuming tasks less expensive and less…
August 14, 2020
Onboarding New Hires During The Remote-Worker Era
Onboarding New Hires During The Remote-Worker Era
Specific roles are essential to sustaining and growing your business. If you are like most organizations today, you may have become a 100% remote workforce overnight
August 14, 2020
Employee Snapshot
Employee Snapshot
Employee Snapshot The Employee Snapshot feature provides managers with a comprehensive view of talent data related to an individual employee through the use of dashboards...
August 12, 2020
What to Expect When Moving to Cloud!
What to Expect When Moving to Cloud!
What to Expect When Moving to Cloud! In a recent survey, Longitude Research interviewed 730 IT leaders. Respondents came from a variety of industries across 13 ...
August 1, 2020
Guest Post: Get Control of Your AP Information Before the Fraudsters Do!
Guest Post: Get Control of Your AP Information Before the Fraudsters Do!
How vulnerable is your business to payment fraud? If your business relies on manual or semi-automated invoice processes its risk of fraudulent payments is probably...
August 1, 2020
Oracle’s Top 10 Cloud Predictions
Oracle’s Top 10 Cloud Predictions
The key word: immediacy. Cloud computing is radically changing the world we live in by providing immediacy. Organizations today can access their data immediately and real-time, allowing for....
July 31, 2020
A Second-Generation Cloud
A Second-Generation Cloud
Today, AI technology is rapidly changing the way that organizations receive and organize business data. However, challenges the high cost and complexity of such an environment, as well...
July 31, 2020
What is Missing in Conventional Analytics? Is Big Data the Answer?
What is Missing in Conventional Analytics? Is Big Data the Answer?
For the past decade or so, organizations have efficiently and effectively used a combination of data warehouse based analytics and business intelligence to meet their needs...
July 31, 2020
The Smarter Way to Manage Data
The Smarter Way to Manage Data
Today analytics plays a vital role in any company in any industry as it helps the organization connect with new customers, streamline business processes, differentiate ...
July 30, 2020
Everything You Need to Know About Remote E-Verify During COVID-19
Everything You Need to Know About Remote E-Verify During COVID-19
The recent COVID-19 virus has drastically changed the way organizations operate and complete their day-to-day tasks. The resulted shelter-in-place and quarantine orders have forced organizations...
July 16, 2020
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.