All about Databases
Introduction to PowerShell Windows PowerShell is a Windows commandline shell scriptining mechanism particularly designed for System Admins. Windows PowerShell providex an inteactive command prompt and a scripting tool that can be utilized or integrated with other progmaming languages or can be used individualistically. Unlike most of the shell scripting languages, which acknowledge and return text, […]
Many a times Application team report SQL Server Blocking issues. In this article I will explain about Blocking and Its cause. Due to this blocking issue Application team asks the DBA team to capture the code which is causing the blocking. SQL Server profiler is one of the tool through which we can capture the […]
Dynamic data masking is one of best security attribute introduced in SQL Server 2016 Community Technology Preview 3. This is a security mechanism which covers the sensitive piece of information in the output of a user query over a set of defined column. This feature is very easy to implement with Existing code as this […]
10 Habits of Healthy People: Despite the fact that health is often connected with an individual’s physical state, it incorporates a lot more. A true wellbeing is a mixture of mental, emotional, and spiritual health. Definitely, the last thing you would want to do is add more to-do’s on your daily list. But guess what? […]
This Blog illustrates about the most frequent questions which are asked about the Data file and Transaction Log file architecture. Intentionally I did not add any troubleshooting questionnaire in this blog because I will post a separate Questions\Answers blog for the same. 1) Explain the SQL Server Database Data File structure? SQL server divides the […]
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 […]
