-
Table backup in SQL Server
4 October 2019Introduction Here we will discuss different backup strategies and methodologies used to take the table backup in SQL Server with real-life examples. There are different methods of taking backup in…
-
Step By Step Installation Of Microsoft SQL Server 2016
3 October 2019Introduction In this post, we will try to show step by step Microsoft SQL Server 2016 installation on Windows Server 2012R2. Microsoft SQL Server 2017 is the latest stable version…
-
Database Backup & Restore in SQL server
2 October 2019Introduction Backing up a database is one of the most important things you need to do when having a database depended application. It’s only all of your data in there,…
-
List of jobs associated with database in SQL Server
30 September 2019Introduction As a Database Administrator (DBA), my recent task involved listing all the jobs running in a production SQL Server environment, along with their respective databases. With over 200+ jobs…
-
Find Database size in SQL Server
Introduction In this article, we will try to pull all sizes from SQL server. How to find Database Size in SQL Server? How to Get size of all tables in…
-
SQL Instance Last restart date and time in SQL Server
29 September 2019Introduction: When your SQL instance was last restarted? I understand it is very simple script but we often forget simple scripts. Hence I thought to write this simple script and…
-
Database restore history in SQL Server
27 September 2019Introduction This script will help you to get the restore history for all the databases. If you need to know the restore history only for a single database then please…
-
How to create database user on secondary node if DB is in readonly mode in SQL Server?
Scenario How to provide ‘db_dataread’ database role to a SQL login when the database is in AlwaysOn & secondary node DB is in readonly mode? Introduction To provide ‘db_dataread’ database…
-
Exploring Database File Information with T-SQL
25 September 2019Introduction In the world of database management, having a clear understanding of the file information is crucial for optimizing performance and storage. In this technical blog post, we will dive…
-
Find Physical file location for all the databases in SQL Server
Introduction Very often DBAs need to find the location of the physical file (MDF, LDF & NDF) of a database. Simply we can obtain the output by executing the below…