Blogs

Filter /
How to use Dynamic Management Views for log statistics in SQL Server
SQL Server 2017 introduces new Dynamic Management Views that will help the performance of SQL Server instances. In this new Dynamic Management Views now, I am going explain about sys.dm_db_log_stats DMV.
  Apr, 2021
How to add new articles to a existing transactional replication without snapshot of entire articles
Once the transaction replication is configured, we will face lots of challenges. One among them is adding a new article to an existing replication configuration. In order to add a new article to an existing replication most of us will reinitialize the subscription and this will take snapshot of entire table in the Database.
  Apr, 2021
DATABASE SCOPED CONFIGURATION OPTION IDENTITY_CACHE IN SQL SERVER
  Apr, 2021
7 key security features available in SQL Azure
This article is a quick walk-through of some of the key security features which are available in SQL Azure.
  Apr, 2021
SQL Server instance(s) migrating to Azure SQL database(s) using Data Migration Assistant
Data Migration Assistant (DMA) helps you upgrade to a modern data platform by detecting compatibility issues that can impact database functionality in your new version of SQL Server or Azure SQL Database. Follow the steps for migrating SQL Server instance to Azure SQL database using Data Migration Assistant DMA.
  Apr, 2021
Change Data Capture (CDC) in SQL
This article on Change Data Capture will explain what is CDC and how to enable it in SQL Server for better data security.
  Apr, 2021
ENABLING INSTANT FILE INITIALIZATION
This process reduces the execution time of the operations and the load on the disk subsystems. Disk space reservation without initialization is called Instant File Initialization.
  Apr, 2021
Dynamic Data Masking in SQL Server
Dynamic Data Masking is a security feature in SQL Server 2016. This article elaborates the types of dynamic datamasking and how to use it.
  Apr, 2021

We run all kinds of database services that vow your success!!

Elevate your business with our expert Database Management Solutions !
Quick links
Quick Links
About Us
Address

Geo Platinum IT Services, No 3, 5th Cross, 1stFloor, P & T Layout, Horamavu, Kalyan Nagar Post, Bengaluru, Karnataka 560043.

© 2024 GeoPITS All Rights Reserved.
Privacy Policy | Terms & Condition