Mohammed Moinudheen

Mohammed has been a SQL Server DBA since 2005 and has had the opportunity to work on different versions of SQL Server starting from SQL Server 2000 with exposure to Sybase as well. He is based in Wellington, New Zealand and works at Datacom Systems Ltd, as a SQL Database Administrator. He can be reached at: [email protected].

2016 Awards
MSSQLTips award

Availability Groups

SQL Server AlwaysOn Availability Groups Using an Azure Template (last update: 10/3/2017)

Azure

Access SQL Server instance on Azure VM using local copy of Management Studio (last update: 6/20/2016)
Data Migration Assistant (DMA) to Check for SQL Server Compatibility Issues when Migrating to Azure (last update: 5/4/2018)
Migrate database to Azure SQL Database using SQL Server 2016 Upgrade Advisor (last update: 7/8/2016)
Restore an Azure SQL Database from one server to another server (last update: 3/9/2018)
Use Data Migration Assistant (DMA) to migrate on-premises SQL Server database to Azure (last update: 6/22/2018)
Using the Data Migration Assistant (DMA) tool to migrate from SQL Server to Azure SQL database (last update: 6/1/2018)

Database Administration

Move data between SQL Server database filegroups (last update: 7/22/2011)
Using SQL Server Discovery Tool to list installed components (last update: 2/29/2016)

Database Mail

Setup SQL Server Database Mail to use a Gmail, Hotmail, Yahoo or AOL account (last update: 1/6/2012)

Database Mirroring

Configure a SQL Server Database using Transparent Data Encryption and Database Mirroring (last update: 8/8/2016)
Fixing SQL Server Database Mirroring Expired Certificates (last update: 4/12/2017)

In-Memory OLTP

Comparison of AMR Data Collection and Reports in SQL 2016 and SQL 2014 (last update: 3/24/2016)
SQL Server Memory Optimization Advisor to Migrate to In-Memory OLTP (last update: 4/27/2016)
SQL Server Stored Procedure Native Compilation Advisor (last update: 5/19/2016)
Using In-Memory OLTP migration checklists in SQL Server 2016 (last update: 4/4/2016)

Log Shipping

Steps to rollback database changes without impacting SQL Server Log Shipping (last update: 10/14/2013)

Replication

Can a published SQL Server database be renamed (last update: 3/15/2012)
Determine data latency between Publisher and Subscriber in SQL Server Transactional Replication (last update: 1/26/2012)
Initialize SQL Server replication using a database backup (last update: 8/30/2011)
Limit snapshot size when adding new article to SQL Server replication (last update: 9/23/2011)
Moving database files for a replicated SQL Server database (last update: 6/17/2011)
Options to not replicate SQL Server DELETE commands (last update: 10/26/2011)
Options to reinitialize subscriptions in SQL Server replication (last update: 12/14/2011)
Role of the Immediate Sync Option for SQL Server Replication (last update: 6/4/2012)
Space Impact of Replication Snapshot Agent Job in SQL Server (last update: 5/9/2011)
Steps to Rename a Subscriber Database for SQL Server Transactional Replication (last update: 3/5/2012)
Understanding Retention Periods for SQL Server Transactional Replication (last update: 4/9/2012)

SQL Server 2016

ColumnStore Index Recommendations using SQL Server 2016 Upgrade Advisor (last update: 7/28/2016)

SQL Server on Linux

Quickly setup SQL Server on Linux using an Azure SQL Server VM template (last update: 5/26/2017)

Testing

Getting real time lab exposure to test latest SQL Server features (last update: 6/6/2016)
Getting real time SQL Server lab exposure to test new features (last update: 5/31/2012)

Tutorials DBA Dev BI Career Categories Webcasts Whitepapers Today's Tip Join

Tutorials DBA Dev BI Categories Webcasts

DBA Dev BI Categories

Mohammed Moinudheen

More SQL Server Solutions