database administration Archives - {coding}Sight https://codingsight.com/tag/database-administration/ Blog for SQL Server DBAs and Developers Mon, 06 Nov 2023 10:00:15 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://codingsight.com/wp-content/uploads/2021/10/cropped-Soсial_-Fb_180х180-1-32x32.png database administration Archives - {coding}Sight https://codingsight.com/tag/database-administration/ 32 32 dbForge Edge: Your Best Universal Tool for Multidatabase Challenges https://codingsight.com/introducing-dbforge-edge/ Tue, 06 Jun 2023 11:34:26 +0000 https://codingsight.com/?p=24719 Handling several database management systems simultaneously is inevitable in working on multiple projects. At the same time, each system requires a proper set of relevant tools to perform database tasks. These tools should be powerful and flexible enough to adapt to the project’s evolving needs. One moment, your goal is to design a new database …

The post dbForge Edge: Your Best Universal Tool for Multidatabase Challenges appeared first on {coding}Sight.

]]> 31 Must-Know SQL Server DBA Interview Questions – Are You Prepared? https://codingsight.com/sql-server-dba-interview-questions-and-answers/ Tue, 01 Nov 2022 08:52:01 +0000 http://codingsight.com/?p=20295 This article will help you to prepare for SQL Server interviews. I have explained various popular SQL Server interview questions and answers in this article. If you want to get more information, visit all the attached links. All interview questions have been segregated between the below headings. Please give your feedback in the comment section …

The post 31 Must-Know SQL Server DBA Interview Questions – Are You Prepared? appeared first on {coding}Sight.

]]> How to Download, Install and Restore AdventureWorks Database in SQL Server https://codingsight.com/restoring-sample-dw-database-adventureworksdw2019/ Sun, 18 Sep 2022 12:02:00 +0000 http://codingsight.com/?p=19232 Sometimes, we need a sample database that has all the required objects along with a large set of data inside the database for our various testing needs or our learning purpose. Microsoft has developed several sample databases for each type of workloads like the AdventureWorks database for OLTP workload and the AdventureWorksDW database for data …

The post How to Download, Install and Restore AdventureWorks Database in SQL Server appeared first on {coding}Sight.

]]> Large-Sized Database Management System: Design and Architect https://codingsight.com/large-sized-database-management-system-design-and-architect/ Wed, 23 Feb 2022 13:42:02 +0000 http://codingsight.com/?p=16832 A Database Management System is the information’s strongbox. We will attempt to design the Database Management System so that the database should remain well-managed and furnishing the purposes. In this article, we are going to discuss designing and administering large-sized database systems. We’ll use multiple constitutions that will include Database technologies, storage, data distribution, server …

The post Large-Sized Database Management System: Design and Architect appeared first on {coding}Sight.

]]> How to Create Data Flow in Oracle Analytics https://codingsight.com/setting-up-the-data-flow-in-oracle-analytics/ Thu, 27 May 2021 09:37:13 +0000 http://codingsight.com/?p=14165 The traditional approach to the transformation process (Extract, Load, Transform) requires that technical users get involved directly. They execute connection to data sources, the transformation of data, and provide final datasets to business users. The process often requires much time whenever business users ask for more information or due to changes/updates in business logic. Then, …

The post How to Create Data Flow in Oracle Analytics appeared first on {coding}Sight.

]]> Fundamentals of Managing Datafiles in SQL Server https://codingsight.com/fundamental-of-managing-datafiles-in-sql-server/ Wed, 30 Dec 2020 18:23:59 +0000 https://codingsight.com/?p=11395 Introduction Datafiles are physical objects that constitute the most important part of the database system since they contain actual data. You can think of a database as a collection of data files. An instance gives you the means of mounting and accessing such files. Here, managing datafiles is understanding how to monitor and resize existing …

The post Fundamentals of Managing Datafiles in SQL Server appeared first on {coding}Sight.

]]> Five Different Methods To Start, Stop, And Restart SQL Server Services https://codingsight.com/five-different-methods-to-start-stop-and-restart-sql-server-services/ Mon, 28 Dec 2020 14:34:16 +0000 https://codingsight.com/?p=11233 When we install the SQL Server, it also installs the following services: SQL Server database engine service to manage and access data in SQL Server. SQL Server Integration Service for the ETL process – we install it when including Integration services during setup. SQL Server Reporting Service to manage the SQL Server reports. The SQL …

The post Five Different Methods To Start, Stop, And Restart SQL Server Services appeared first on {coding}Sight.

]]> 3 Easy and Secure Ways to Make Users Run SSIS Packages https://codingsight.com/3-easy-and-secure-ways-to-make-users-run-ssis-packages/ Mon, 02 Nov 2020 09:17:29 +0000 https://codingsight.com/?p=10286 Have you ever come across a situation where you needed to make users run SSIS packages? This happens when the user is not comfortable with a fixed schedule for whatever reason. You can’t define if it’s every weekend, at 9 pm, or the 5th of the month. It happens when it happens. This sounds problematic, …

The post 3 Easy and Secure Ways to Make Users Run SSIS Packages appeared first on {coding}Sight.

]]> Configure SQL Server Log Shipping https://codingsight.com/configure-sql-server-log-shipping/ Thu, 22 Oct 2020 11:22:13 +0000 https://codingsight.com/?p=10369 This article explains the step by step deployment process of the SQL Server Log shipping. It is the database-level disaster recovery solution that is easy to set up and maintain. The log shipping involves three steps: Generate the log backup on the primary database. Copy the backup to the network location or the specific directory …

The post Configure SQL Server Log Shipping appeared first on {coding}Sight.

]]> Configure SQL Jobs in SQL Server using T-SQL https://codingsight.com/configure-sql-jobs-in-sql-server-using-t-sql/ Mon, 19 Oct 2020 08:44:24 +0000 https://codingsight.com/?p=10179 SQL Server Agent is a component used for the database tasks automation. For instance, we need to perform Index maintenance on Production servers during the non-business hours only. So, we create a SQL Server job of running index maintenance and schedule it for “off” hours. When we install SQL Server, the SQL Server Agent service …

The post Configure SQL Jobs in SQL Server using T-SQL appeared first on {coding}Sight.

]]>