DBA Resources

About DBA

DBA stand for ( Data Base Administrator ) which is responsible for managing and controlling the database. A Database administrator frequently known just by the acronym DBA and is a role usually within the Information Technology department charged with the creation, maintenance, backups, querying, tuning, user rights assignment and security of an organization's databases. The role requires technical training and expertise in the specific RDBMS used by the organization, in addition to other skills such as analytical thinking and ability to concentrate on tasks, as well as experience working with databases in the real world. The DBA role is a critical member of the IT team. A DBA is usually expected to have experience with one or more of the major database management products, such as Structured Query Language, SAP, and Oracle-based database management software.

Share

Related resources for DBA

TRIM Function New T-SQL Enhancements in SQL Server10/25/2024 10:44:09 AM. The enhanced TRIM function in SQL Server 2022 adds flexibility for removing unwanted characters in strings, beyond just spaces. Now, developers can use BOTH, LEADING, and TRAILING keywords to trim fro
STRING_SPLIT() Ordinal New T-SQL Enhancements in SQL Server10/16/2024 9:01:22 AM. The STRING_SPLIT() function in SQL Server, introduced in 2016, allows for splitting delimited strings into rows. The 2022 enhancement introduces an optional ordinal parameter, enabling retrieval of ea
IS [NOT] DISTINCT FROM New T-SQL Enhancements in SQL Server10/4/2024 6:15:00 AM. The "IS [NOT] DISTINCT FROM" operator is one of the key new T-SQL enhancements in SQL Server 2023. It simplifies SQL queries by handling NULL comparisons more efficiently, improving data int
What is the Notify Function in Power Apps?9/23/2024 5:09:43 AM. The Notify function in Power Apps displays messages to users, providing instant feedback on their actions. It supports various notification types, such as success, error, warning, and information, hel
Learn to Shrink a Microsoft SQL Server Database Programatically 8/20/2024 4:59:45 AM. Shrinking a SQL Server database reduces file size by reclaiming unused space in data and log files. This can optimize disk usage, especially in storage-constrained environments. However, it can cause
How to Handling File Uploads in Next.js?8/2/2024 4:33:07 AM. Handling file uploads in Next.js involves creating an API endpoint to receive and process the files and a client-side component to manage file selection and submission. This guide provides a comprehen
Microsoft Forms: New Features in 20246/26/2024 4:58:19 AM. Microsoft Forms has introduced powerful updates in 2024, including real-time data sync with Excel, a Practice Mode for learning reinforcement, a new Forms app for easy survey creation, and the ability
Filters in MDX Queries6/4/2024 12:51:29 PM. This article, explains the power of MDX queries with precise filtering! This guide dives into filtering techniques to control the data you see in your multidimensional analyses.
Best Practices and Role of a Product Owner6/3/2024 4:35:08 AM. The Unsung Hero" delves into the pivotal role of a Product Owner in Agile projects. Explore best practices in stakeholder management, backlog grooming, and iterative development, emphasizing the
Enable Ratings in SharePoint List/Library5/6/2024 11:24:03 AM. Learn how to enhance user engagement and feedback in SharePoint by enabling ratings on your lists and libraries. Empower users to rate and provide feedback on content, boosting collaboration and user
Getting Started Wth MongoDb Atlas4/26/2024 12:00:41 PM. Learn how to get started with MongoDB Atlas, a cloud-based database service that offers a scalable and flexible solution for managing NoSQL databases. Explore data modeling, cluster configuration, and
How to Configure Azure Application Gateway and WAF v2 4/15/2024 6:05:14 AM. We're configuring an Application Gateway to manage traffic for the demo application. Azure Application Gateway, a layer 7 solution, efficiently manages web traffic, ensuring optimal performance. T
Database Optimization Technique4/3/2024 5:40:07 AM. Database optimization ensures efficient and performant systems. Techniques like indexing, normalization, and query optimization enhance query performance and overall efficiency.
Rating Control Dynamically from SharePoint List in Power Apps3/27/2024 9:36:22 AM. Dynamically link SharePoint list data to a Rating Control in Power Apps. Customize user feedback mechanisms, enhancing user experience and data interaction within your application for efficient data v
Capturing Survey Response For Grid Questions - Voice Of The Customer3/21/2024 9:42:08 AM. Learn to capture training feedback survey responses in Dynamics 365 using Voice of the Customer. Create a workflow to send emails based on dissatisfied responses. Navigate through workflow creation, c
Display Success Message With Back Button On Dynamics 365 Portal3/15/2024 9:01:33 AM. In this article, we will learn to enhance the Dynamics 365 Portal experience by displaying success messages with a convenient back button. Empower users with clear feedback and seamless navigation, op
What Is DevOps And Its Key Principles3/15/2024 6:16:52 AM. DevOps merges development and operations, emphasizing collaboration, automation, and continuous integration. Key principles include infrastructure as code, agile practices, and a feedback loop for mon
How to Build an Interactive and Responsive Form12/28/2023 5:03:01 PM. Discover the world of web development with our latest tutorial on building a responsive and interactive form using HTML5, CSS3, and JavaScript. From the fundamentals of HTML5 to styling with CSS3 and
Concurrency Control in DBMS11/26/2023 5:55:32 AM. A crucial component of database management systems (DBMS) that ensures data integrity and consistency in multi-user situations is concurrency control.
OLAP ETL Tasks In RavenDB8/23/2023 9:56:53 AM. What are OLTP and OLAP? Where is each appropriate? This article explains the difference between OLAP and OLTP, why would you want to use cloud OLAP services over a SQL reporting database, and the func
How To Set Up And Start With MongoDB8/22/2023 6:45:21 AM. In this article, we will learn How to set up and starts with MongoDB in Windows Operating System.
Are The DBAs Paranoid By Nature8/22/2023 6:41:53 AM. With respect to the job functions of Database Administrators, the term “paranoid” does not necessarily imply that they are under an extreme state of paranoia; however, perhaps in their zealous effort
Strategic Alert and Security Configuration8/21/2023 5:47:49 AM. Today I ran into something on a client-server that unfortunately I see too often. The DBA goes through the trouble of configuring and setting up alerts/operators but doesn’t really understand what th
Extended Security Updates No More Freebies8/9/2023 10:57:19 AM. As data professionals, we should always strive to keep our systems updated and patched to ensure proper security of our environments. Microsoft has moved away from releasing service packs to releasing
Configure A Windows Service For MongoDB8/9/2023 6:22:29 AM. In this article, we will learn how to configure a Windows Service for MongoDB.
Aggregation Pipeline In MongoDB8/2/2023 6:17:54 AM. In this article, you will learn about Aggregation Pipeline in MongoDB.
Delete Operation In MonGoDB Using Robo 3T7/31/2023 11:32:29 AM. In this article, we will learn how to delete the data from MongoDB using Robo 3T. We will learn from the basics because I have written this article focusing on the beginners. In my previous article, w
Understanding the Power of ChatGPT's Sentiment Analysis for Customer Feedback Analysis5/8/2023 11:21:07 AM. ChatGPT can analyze the sentiment behind a user's input, which allows it to generate more appropriate responses based on the user's emotional state.
Difference Between On Clause And Where Clause When Used With Left Join in SQL Server2/17/2023 10:15:34 AM. The purpose of this article is to show the difference between the On clause and Where clause when used with a left join in SQL Server.
What Is Database Management1/27/2023 8:06:15 AM. In this article, you will learn what is Database Management.
Insert, Update And Delete Document In MongoDB - Part Two12/28/2022 5:34:40 AM. MongoDB is one of the most popular databases in the world. in this article, learn how to insert, update and delete data and records in MongoDB.
Introduction To MongoDB - Part One12/18/2022 4:18:50 PM. This article is basically an introductory article which will demonstrate how to start MongoDB
Azure Application Gateway vs Azure Load Balancer vs Azure Traffic Manager vs Azure Front Door1/26/2022 3:14:18 PM. This article will provide information about azure load balancing services.
Event Registration Form Using Microsoft Forms Without Any Code7/1/2021 4:11:33 AM. To explain how to create a simple event registration form without using any code with the help of Microsoft Forms
Bar and StackedBar Charts in ASP.Net4/12/2021 6:36:04 AM. In this article, we will learn about the Bar and StackedBar Charts of Asp.Net.
Collect Feedback From Microsoft Teams Using Power Automate3/31/2021 12:34:09 PM. In this article, attention toward design the feedback card using Low Code Solution . Here i am going to articulate how to collect feedback response from MS Teams User and update the response back into
SQL Server Configuration with dbatools and dbachecks - SQL Server Virtual Conference 20212/1/2021 4:38:58 PM. This session is about “SQL Server Configuration with dbatools and dbachecks ”in SQL Server Virtual Conference 2021.
Data Replication Options in Azure SQL / SQL Server - SQL Server Virtual Conference 20212/1/2021 4:03:13 PM. This session is about "Data Replication Options in Azure SQL / SQL Server " in SQL Server Virtual Conference 2021.
My romantic relation with Powershell generally and DBATools especially- SQL Server Virtual Conference 20212/1/2021 3:14:39 PM. This session is about My romantic relation with Powershell generally and DBATools especially in SQL Server Virtual Conference 2021.
Storage What SQL Server DBAs Need To Know1/20/2021 5:54:20 AM. In this article, you will learn about storage what sql server DBAs need to know.
I’m It – Survival Techniques for the Lone DBA1/4/2021 7:22:34 AM. The sixth session of Women in Tech Virtual Conference by Monica Rathun.
Public Speaking - Preparedness & Feedback1/4/2021 7:04:28 AM. In this session, you'll learn how to prepare yourself including any practicing, setting up and testing machines, any gadgets you carry with you.
Azure Front Door - Hands On With Azure Global Application Loadbalancer11/23/2020 10:44:01 PM. Azure Front Door is an application load balancer you can use across regions. Another load balancer service Azure Gateway can be used inside a single region. Here we do a hands-on session to use Front
Sensitive Data Exposure9/4/2020 7:39:58 AM. In this article, you will learn about Sensitive Data Exposure.
Snowflake And Its Features5/15/2020 8:45:27 AM. In this article, you will learn about Snowflake and its features.
Creating a Feedback Form Using HTML4/9/2020 3:52:52 PM. In this article, we will discuss creating a feedback form for a website.
Feedback And Updates To Microsoft In Windows 101/17/2020 4:08:05 PM. In this article you will learn how to provide feedback to Microsoft in Windows 10.
Feedback Frequency Settings In Windows 101/14/2020 5:06:32 PM. In this article, you’ll learn more about how to edit the feedback frequency settings in Windows 10.
Give Windows 10 Feedback To Microsoft1/9/2020 5:03:16 AM. How to give Windows 10 feedback and post issues direct o Microsoft by using Windows Insider Hub.
Windows Feedback App In Windows 101/8/2020 3:05:39 AM. In this article we will learn how to use Windows 10 Feedback App.
Implementing Auto Scaling In AWS 11/21/2019 10:28:35 AM. In this article we are going to learn how we can auto scale out or scale in the instances using auto scaling group.
Touches In React Native10/17/2019 6:58:01 AM. In this article, we are going to learn what is touches in React Native and their types also we will see how to create a custom button using touches in React Native.
Introduction To AWS ELB - Part Two10/4/2019 7:40:37 AM. In this article, we will learn the types of Load Balancers, load balancer ports, and the concept of vertical and horizontal scaling in AWS ELB.
Layout Managers in Java : Part 29/27/2019 7:26:13 AM. This article describes the layout manager in Java. In this article I discuss about Card Layout Manager and GridBag Layout Manager
Updating Multiple Survey Feedback Using SP Designer Workflow - Part Two9/13/2019 8:06:48 AM. In this article, you will learn how to update multiple survey feedbacks using SP Designer Workflow.
Working With the Layout Manager9/13/2019 12:36:58 AM. In this article we are going to describe the Java layout manager and its use for setting the components within a container. A layout manager is an object that implements the LayoutManager interface an
Updating Multiple Survey Feedback Using SP Designer Workflow9/12/2019 8:26:31 AM. In this article, you will learn how to update multiple survey feedback using SP Designer Workflow.
Basics of Database Administration in SQL Server: Part 16/4/2019 4:57:47 AM. In this article, we will learn the basics of SQL Server Database Administration.Learn four system databases in SQL Server, master, msdb, tempdb and model.
Building Xamarin Mobile Application By Analyzing Customer Feedback Using Sentiment Analysis API2/21/2019 10:13:23 PM. In this article, you will learn to consume TextAnalytics API and automate customer feedback without using rating. I hope this article will help you.
Quick Start With Azure Cosmos DB - Day Five2/18/2019 1:15:57 AM. In this article, we will see how we can execute SQL queries on JSON documents and get filtered results.
Quick Start With Azure Cosmos DB - Day Two2/18/2019 1:11:15 AM. In my previous article, we have seen the structure of Cosmos DB, signed up azure free account for 30 days and created Cosmos DB account using Azure Portal.. today, we will see how we can create docume
SharePoint Online - Analyze User Feedback Using Sentiment Analysis API And Microsoft Flow2/6/2019 9:09:42 AM. The Sentiment Analysis API evaluates text input and returns a sentiment score ranging from 0 (negative) to 1 (positive). This is useful for detecting positive and negative sentiment in social media, c
What Are The Advantages And Usage Of Apache Cassandra Database12/21/2018 2:36:17 PM. This article reviews basics of Apache Cassandra and its advantages and usages. Apache Cassandra is the easiest truly big-data database that can scale and replicate data globally in a master-less confi
DataTypes In MongoDB11/26/2018 10:36:20 AM. In this article, we will learn about the Datatypes and its usage in the MongoDB. As we already know, MongoDB stores data in BSON format. BSON stands for the Binary-encoded format of JSON. Using BSON,
Creating Your First MongoDB Atlas Cluster11/20/2018 10:21:25 AM. MongoDB Atlas is an online no-sql database that allows you to run a MongoDB database as a service. Running MongoDB as a service means that you no longer need to host your own servers or manage upgrade
Normalization In Databases10/4/2018 12:59:42 AM. Sometimes the database design that looks Ok at first sight may have some hidden problems. One such kind of problem is Non-Atomic Values. This means that the value that stored in a single column in the
DBCC CLONEDATABASE And Query Store8/29/2018 5:55:44 PM. Anyway, by now, you probably have seen documentation on Query Store and DBCC Clonedatabase. Query Store, introduced in SQL Server 2016, is considered the “black box” or “flight recorder” of queries. I
Designing Training Feedback Survey Using Voice Of The Customer8/6/2018 12:11:10 PM. This article is about Voice of the Customer solution for Dynamics 365.
How To Survive As A Lone DBA5/17/2018 11:46:58 PM. Database administrators have enormous responsibility whether they manage one or hundreds of servers. Monica Rathbun tells us how she survived as the Lone DBA for 56 database servers for over a decade.
Continue With Learning Indexes In MongoDB3/8/2018 9:53:51 AM. This is the continuation of exploring the Indexes on MongoDB. We will be discussing various MongoDB indexes which we can perform on our data.
How To Optimize SharePoint Custom Pages Using HTML 5 IndexedDB API12/7/2017 2:20:50 PM. In this article we will discuss another obvious performance issue with SharePoint Solutions involving large volumes of data transactions surfacing in SharePoint Custom Pages.
Learn Universal Windows Programming Via Modern C++ (CommandBar Control)10/11/2017 12:03:02 PM. In this article, we are going to learn about CommandBar control in Modern C++. The CommandBar control is a new control in Universal windows programming, it’s a like a Toolbar control, it has more feat
Frequent Pattern And Market Basket Implementation9/9/2017 12:38:12 PM. Frequent pattern mining is about the item sets and sequences which appear in a data set.
Getting Started With MongoDB9/5/2017 2:23:26 AM. MongoDB is an open-source/cross platform (Windows, Linux, etc) document database that is NoSql in JSON format database. A NoSQL database means it does not have any relationships (non-relational databa
Overview Of MongoDB7/4/2017 2:14:54 PM. This article explains the basics of MongoDB, doing CRUD operations on it using command prompt and then CRUD operations with a sample ASP.Net WebAPI.
Learn MongoDB Step By Step2/27/2017 10:56:02 AM. In this article, we are going to learn how to install MongoDB on a Windows machine in a step by step way. Along with this, we are also going to learn how to start the MongoDB Server and basic commands
Creating An Internal Load Balancer In Microsoft Azure2/12/2017 1:26:21 PM. In the following article, I have explained the method of creating a load balancer in between two different VMs.
Create Commandbar Control And AppBar Control In Windows Universal App Using Visual Studio 2015 Update 39/19/2016 12:19:00 PM. In this article, you will learn how to create CommandBar control and AppBar control in Windows Universal app, using Visual Studio 2015 Update 3.
DBA Skills For Developers8/9/2016 11:11:31 AM. Useful things to know for developers in charge of an MS database server
Skills You Need To Land That Big Data Job7/14/2016 11:01:44 AM. In this article, you will learn about the skills you need to land that big data job.
Understanding AppBar And CommandBar In UWP6/25/2016 2:39:45 PM. In this article we will discuss how to understand the AppBar and CommandBar in UWP.
Database Administrator (DBA): Evolution In IT Jobs6/22/2016 6:29:51 AM. In this article you will learn about Database Administrator (DBA) Evolution in IT Jobs
Activity Monitor In SQL Server5/31/2016 12:22:44 PM. In this article well we see in detail what activity monitor is all about in SQL Server.
SQL Query Plans Each Developer Should Know5/26/2016 12:59:28 PM. In this article you will learn about SQL Query Plans for each Developer.
Create A Feedback Form UI In UWP1/28/2016 10:11:58 AM. In this article you will learn how to create a feedback form in UWP.
Introduction To Graph Databases9/14/2015 8:32:16 AM. In this article you will learn about graph databases. Graph databases are based on directed graph theory.
MVC and JSON Action Results For Meaningful Feedback4/5/2015 5:58:11 AM. I recently wrote an asynchronous pipeline for my MVC view which displayed a list of users. I wanted to modify each user without a page refresh. This is how I did it ?
SQL Server Pre-Requisites For Installation12/5/2014 1:29:19 PM. This article provide the details of SQL Server 2008/2012/2014 pre-requisites for installation.
C# Corner Mumbai Chapter Group Update of 24th May Session on MVC and DBA6/9/2014 10:31:08 PM. This is a quick update for people who missed what happened in the C# Corner Mumbai Chapter on 24th May.
Dialog Control In Rate My App6/3/2014 1:19:22 PM. This article explains how to control the message box screens of the Rate My App Component.
Getting Started With Rate My App Component5/15/2014 5:55:18 PM. This article gives an overview of the Rate My App component.
Sending An Email From The App Using Email Composer Task4/13/2014 4:55:29 PM. This article explains how to send email from a Windows Phone app using email the composer task.
Generate Script Of Database in SQL Server 200812/5/2013 7:42:59 PM. In this article we learn how to generate a database script for database backup purposes and how to correspondingly restore a database using the script we created. We also regenerate an entire database using a database script.
Sending WAP Site feedback from Mobile Phone5/19/2012 6:57:57 AM. The WAP (Wireless Apllication Protocol) is the leading standard for information services on wireless terminals.
Telerik RadBarCode in SilverLight 5 Via WCF Service4/2/2012 12:26:19 AM. Today, in this article let’s concentrate on another SilverLight application, whereby communicating with a WCF Service to perform some operation.
Search Engine - Windows Tool Using C#7/18/2011 12:09:24 AM. Here I am creating a tool which would help us add topics and their corresponding sites in a database and also search them using the tool.
WPF Application for Importing ESRI Shapefiles2/26/2007 9:32:58 PM. A standalone application for reading ESRI shapefiles and displaying them on a WPF Canvas.
Atlas - Visual Feedback Using the UpdateProgress Control9/7/2006 4:44:55 AM. In this article, we will take a look at the ease with which the UpdateProgress control in Atlas allows you to provide user feedback on the progress of operations in an ASP.Net 2.0 web page.
Communication Between Two Forms: Part-II1/13/2006 5:53:53 AM. Last time I wrote about the possibility of sending a string from a textbox in one form to another.
Adding Picture To Button On OutLook CommandBar1/7/2006 2:30:01 AM. This article describes the process to add a picture on a button on an Outlook Commandbar while using Explorer or Inspector.

Topics