Keeping a Job Offer Alive Professional Development Series This is Laura Lee Rose, a business and life coach that specializes in professional development, time management, project management and work-life balance strategies. In my GoTo Academy: Soft Skill Tools for the GoTo Professional continuous online coaching series, I go into professional development and real-world IT topics in detail. If you are...
SQL Server
Troubleshooting Upgrading to SQL Server 2012
Troubleshooting Upgrading to SQL Server 2012 Should you have problems during upgrading to SQL Server 2012, review this troubleshooting checklist to find potential solutions. 1. Check the hardware requirements. To upgrade to SQL Server 2012, you should have the following hardware: – Intel or compatible platform with processor speed: x86 Processor – 1.0 GHz minimum, x64 Processor – 1.4 GHz...
Monitoring Blocked Processes with Event Notifications
Monitoring Blocked Processes with Event Notifications Author: Basit A. Farooq Introduction SQL Server is able to service requests from a large number of concurrent users. When SQL Server is servicing requests from many clients, there is a strong possibility that conflicts will occur because different processes request access to the same resources at the same time. A conflict in which...
Elemental MDX: MDX Time Series Functions: PeriodsToDate() and OpeningPeriod(), Pt. 3
Elemental MDX: MDX Time Series Functions: PeriodsToDate() and OpeningPeriod(), Pt. 3 In this, the third of a three-part article focusing upon the PeriodsToDate() and OpeningPeriod() time series functions, we will continue to expose functions that we can use to perform analysis within the context of time. As we discussed in Part 1, many business requirements revolve around theperformance of analysis...
Managing Database Storage
Managing Database Storage By Craig S. Mullins Database systems require data files to store the data under management. These files, or data sets, reside on storage media. So storage management should be a key part of the database operations required of a database administrator (DBA). Unfortunately, storage is sometimes relegated to an afterthought; after all, don’t we have storage administrators...
Tips for using views in SQL Server 2012
Tips for using views in SQL Server 2012 Keep the indexes on the views as narrow as possible. Because each index takes up disk space try to minimize the index key’s size to avoid using superfluous disk space. This reduces the number of reads required to read the index and boost overall index performance. Consider using indexed views. Indexed views...
Designing and Implementing Online Analytical Processing (OLAP) Architecture – (Part 1)
Designing and Implementing Online Analytical Processing (OLAP) Architecture – (Part 1) Author: Basit A. Farooq Editor’s Note: This is the two part article series on designing and implementing online analytical processing (OLAP) architecture. In this article series, I will first discuss how to design and implement logical multidimensional solution architecture. After that, I will explain the design considerations for online...
Preparing for Database Application Design Reviews
Preparing for Database Application Design Reviews By Craig S. Mullins Design reviews are an important facet of the system development lifecycle for database applications. It is imperative that all database applications, regardless of their size, participate in some form of design review both before and after implementation. Design reviews are critical for ensuring that an application is properly designed to...
Tips for using Very Large Databases in SQL Server 2012
Tips for using Very Large Databases in SQL Server 2012 Use distributed partitioned views to partition tables horizontally across multiple servers. By using distributed partitioned views you can greatly improve the very large database performance. Turn off the "automatically grow file" and "auto shrink" options for your very large database. Autogrowing and autoshrinking result in some performance degradation, therefore you...
SQL Server index related dynamic management views and functions – (Part 3)
SQL Server index related dynamic management views and functions – (Part 3) By Basit A. Farooq Editor’s Note: This is the part-3 of this three part article series on index-related dynamic management and functions. In this part, I’ll be covering following index-related dynamic management views (DMVs) that are helpful to find missing indexes inside databases. Introduction: With the release of...