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 […]
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 […]
