-
How to fix missing msi files SQL Server
17 June 2023Introduction If you use SQL Server, you might have faced a frustrating problem: missing MSI files. These files are important for installing or managing SQL Server, but sometimes they can…
-
Reasons why you should stay back late in the office
15 June 20235 Reasons why you should stay back late in the office (plus 1 top secret reason) 1. You’ll get a free drop home In most companies, if you stay back beyond…
-
Differents ways to prevent your senior from stealing credit for your work
5 ways you can prevent your senior from stealing credit for your work Credit stealing is very common in corporate environments. The most common instance is where a senior member…
-
Differents ways to get Knowledge Transfer
5 Ways you can get Knowledge Transfer (KT) from someone when they’re not interested This is the most common problem faced by new joiners. The manager asks you to learn…
-
Resolving Failed Database Mail Issues with TLS 1.2
10 June 2023Introduction Have you ever been frustrated because your database emails failed to send? You’re certainly not alone! I received multiple calls between June 5th and June 9th from various sources…
-
Find Permissions Granted to a User-Defined Database Role
6 June 2023We now have the ability to define a User Defined Server Level Role in SQL Server 2012 and higher versions. For the security and integrity of the data stored in…
-
SQL Server Checkpoint Demystification
4 June 2023Introduction There are numerous background operations that protect data integrity and enhance performance in the world of SQL Server. SQL Server Checkpoint is one example of such a procedure. This…
-
SQL Server Database Backup Failure Scenarios
Backing up your vital data is critical, but mistakes do happen. It is critical to understand the potential causes of Database Backup Failure and how to resolve them. In this…
-
SQL Server DBA Interview Questions
2 June 2023Introduction SQL Server is a popular relational database management system (RDBMS) developed by Microsoft. It is used by a wide variety of organizations, including businesses, government agencies, and educational institutions….
-
Is it possible to restore the database except specific tables in MSSQL
31 May 2023Once upon a time, there was a innocent Database Administrator (DBA) who had to restore a database but leave out certain tables. However, he didn’t know how to do it….