Splitting a SQL Server Table Over Multiple Files
In this tip we look at how to move SQL Server tables from one filegroup to another filegroup.
Kenneth Igiri is a Database Administrator with eProcess International S.A. Ecobank’s technology services hub. He has been working in the Information Technology sphere since 2008 after graduating with a Second-Class Upper Bachelor’s Degree in Electronic and Computer Engineering. While in the University, he had significant hands-on experience deploying 802.11b/g technologies for Internet access. His journey in IT has also taken him through IT Service Management based on the ITIL framework, application support, and currently, database ddministration.
Kenneth has been working with SQL Server and Oracle databases and their related technologies since 2010. He has been involved in deploying databases (both oracle and SQL Server), implementing High Availability Technologies such as AlwaysOn FCI and AG, Transaction Log Shipping and MySQL Replication. He has also worked on security related areas such as Hardening and Patching for PCI-DSS Compliance, database configuration for audit compliance as well as database consolidation projects.
Enable SQL Server Agent Mail Profile
Learn how to configure SQL Server Agent to allow emails to be sent for job notifications and alerts.
View Contents of SQL Server Backup File without Restoring
In this tip we look at various restore commands (RESTORE LABELONLY, RESTORE HEADERONLY, RESTORE FILELISTONLY) that can be used to reveal the contents of SQL Server backup files to help you with restore operations.