All about Databases
As a DBA, many times there are requirements to segregate data in a Database into multiple file groups. There can be many reasons like below: Performance issues (Disk I\O) Disk space issues Data archiving etc There are multiple solutions to resolve such issues: Move the big tables to other File groups in which frequency of […]
It’s a general requirement in the DBA job to scripts out the database objects and deployment the scripts in the new environment. Microsoft SQL Server provides us an option to script out the object using “Generate scripts” option. However sometimes we need more details about the current structure of the objects and we may want […]
Technologically the IT industry has evolved at a rapid rate with new and innovative ideas entered into the industry. The amount of data that has grown over time among industry had developed a necessity for storage that does not occupy physical space or maintaining in-house computing foundations. Here enters, Cloud Computing to the rescue. Cloud […]
This article comprises of SQL Server Questions and answers series on Database Architecture and various Database Properties. Intentionally I skipped Database Recovery Models, Backups, Restore, Data File and Transaction Log Architecture Questions from this series because I will cover those topics in a complete separate series on Database Backup, restores and File Architectures. 1) How many […]
While discussing about the roles and responsibilities of DBAs, backup and restore is counted as on the important activity of a Database Administrator as a day to day task. Though most of the time its scheduled process, but to make sure the backups are happening as per the schedule and verification of those backup files […]
I am writing this blog based upon the Experience and knowledge which I gained after reading lot of Articles, Blogs, and Microsoft Documentation on SQL Server Architecture. Though it takes lot of time to collect this information and summarize it in a question series but I feel very proud and happy that I am giving […]
LinkedIn was counted amongst the other social media networks but over time, it has become the most important to professionals in all fields. Since it is a professional platform,most of the recruiters use LinkedIn to scrutinize candidates. It is estimated to have more than 277 million professional members. Here is why you too must have […]
SQL Server error logs are one of the important stuff to check whenever DBA face issues in the SQL Server instance. It contains lot of information about the Issues, Errors, Backup related information and Database consistency check occurrences based on the Trace Flag configuration of SQL Server instance. SQL Server error log file is recycled […]
1) What is Authentication and Authorization? What is the difference between both? Authentication is the process of verifying who you are. Logging on to a PC with a username and password is authentication. Authorization is the process of verifying that you have access to something. Authorization is gaining access to a resource (e.g. directory on […]
I have been thinking since long time to pen down a comprehensive series on most commonly asked DBA Interview questions. I have planned to segregate the entire questions series, topic wise to make it easier to explore. So in this post I am writing about the most commonly asked SQL Server Questions on SQL Server installation […]
