Database capacity planning and management (Part 2) Author: Basit A. Farooq In this article, I will layout the Software and Hardware options that are available for configuring your storage media in Windows 2003/2008/2012. Finally, I will be give you few tips on how achieve optimal database performance by physically distribute your database files on storage media. Storage Options There are...
SQL Server
Tips for using SQL Server 2012 database settings
Tips for using SQL Server 2012 database settings To change the database settings, you can use the ALTER DATABASE SET Options or you can use the graphical user interface (GUI). To change the database settings using GUI, you can do the following: – In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that...
Database capacity planning and management – (Part 1)
Database capacity planning and management (Part 1) Author: Basit A. Farooq As part of the planning and research before implementing new SQL Server, you must determine the amount of space needed for your database and how it should be organized in the SQL Server. You also need to understand the properties of the database and how to manage the growth...
Troubleshooting SQL Server 2012 Merge Replication
Troubleshooting SQL Server 2012 Merge Replication If you have problems with SQL Server 2012 merge replication, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2012 service pack. Because some SQL Server 2012 merge replication bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time...
Troubleshooting SQL Server 2012 Transactional Replication
Troubleshooting SQL Server 2012 Transactional Replication If you have problems with SQL Server 2012 transactional replication, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2012 service pack. Because some SQL Server 2012 transactional replication bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time...
Configuring SQL Server Database Mail Feature
Configuring SQL Server Database Mail Feature Author: Basit A. Farooq You can send e-mail from within stored procedures, functions, and triggers by using SQL Server Database Mail. You can also configure SQL Server Agent Mail to use Database Mail. SQL Server supports SQL Mail for backwards compatibility, but is not recommended for new implementations. Database Mail provides several enhancements over...
DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 2
DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 2 In the charter article of this series, DAX and PowerPivot Essentials: Introduction to PowerPivot, DAX and the Related() and Distinct() Functions, we introduced the powerful PowerPivot / DAX combination, noting that this add-on to Microsoft Office Excel 2010 (embedded, and only needing to be enabled,...
Troubleshooting SQL Server 2012 Snapshot Replication
Troubleshooting SQL Server 2012 Snapshot Replication If you have problems with SQL Server 2012 snapshot replication, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2012 service pack. Because some SQL Server 2012 snapshot replication bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time...
SQL Server Management tools
SQL Server Management tools Author: Basit A. Farooq Management tools play a vital role in enterprise database management. This is because the well-integrated tools extend the administrator’s capabilities, whereas a random collection of tools can lead to confusion, operational mistakes, high training costs, and poor DBA productivity. To keep up with these new demands of complex enterprise database management solutions,...
Troubleshooting SQL Server 2012 Analysis Services problems
Troubleshooting SQL Server 2012 Analysis Services problems If you have problems with SQL Server 2012 Analysis Services, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2012 service pack. Because many SQL Server 2012 Analysis Services bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the...