As databases grow, it often becomes necessary to add new I/O paths to accommodate the growing space. Even without growth that requires this scale, it can still be useful to utilize multiple I/O devices to spread out the load. One way that you can make optimal use of new drives is to add a filegroup to the database and move certain objects (say, all of your indexed views) to the new filegroup.  Read more...

Our 19th webinar will feature Brad McGehee talking about storage challenges, costs, and potential solutions for better managing your data. Tuesday, June 12, at 4:00pm GMT.  Read more...

Our 19th webinar will feature Brad McGehee talking about storage challenges, costs, and potential solutions for better managing your data. Tuesday, June 12, at 4:00pm GMT.  Read more...

Our 19th webinar will feature Brad McGehee talking about storage challenges, costs, and potential solutions for better managing your data. Tuesday, June 12, at 4:00pm GMT.  Read more...

Our 19th webinar will feature Brad McGehee talking about storage challenges, costs, and potential solutions for better managing your data. Tuesday, June 12, at 4:00pm GMT.  Read more...

Our 19th webinar will feature Brad McGehee talking about storage challenges, costs, and potential solutions for better managing your data. Tuesday, June 12, at 4:00pm GMT.  Read more...

Be carefull when replacing a defective (FLASH) storage device, its sector sizes may vary without you knowing it.  Read more...

If SSDs are about to make obsolete one of the major driving forces behind the development of SANs (disk latency) then how is the storage array going to change in the near future?  Read more...

Another webinar from SQLServerCentral that examines how you can compress your data on any edition of SQL Server.  Read more...

Another webinar from SQLServerCentral that examines how you can compress your data on any edition of SQL Server.  Read more...

Another webinar from SQLServerCentral that examines how you can compress your data on any edition of SQL Server.  Read more...

By validating the IO path before commissioning the production database system, and performing ongoing validation through page checksums and DBCC checks, you can hopefully avoid data corruption altogether, or at least nip it in the bud. If corruption occurs, then you have to take the right decisions fast to deal with it. Rod Colledge explains how a pessimistic mindset can be an advantage  Read more...

Learn how to configure SQL Server database storage with higher disk writes than disk reads. Set up a RAID 10 array, cache configuration and file disk layout.  Read more...

How to Move Large Table to Different File Group  Read more...

Tuning SQL Server performance means tuning hardware configurations and setup. Learn about configuring disk arrays and SQL disk partitioning alignment.  Read more...

Virtual database storage in SQL Server comes with flexibility of tiered storage and block storage. Get the pros and cons of virtual storage area networks.  Read more...

Storage area networks (SANs) improve SQL Server performance. Set up SANs on SQL Server with these best practices on migrating to, and configuring SANs.  Read more...

Learn storage area network (SAN) basics that SQL Server DBAs must know. Understand SQL storage concerning RAID levels, redundancy and snapshots vs. backups.  Read more...

Move SQL Server storage to storage area networks (SANs) with network redundancy and storage multipathing tips. Learn about iSCSI databases and SQL failover.  Read more...

Determine accurate storage requirements for a SQL Server database with these methods. Calculate how to set storage requirements for a database application.  Read more...