When you are defining data warehouse dimensions, you need to ask yourself how changes to the information impact your fact tables. Type 1: This is straightforward refresh. When a value changes in the dimension table, the fields are simply overwritten and history is not kept for the column. One example of a Type 1…
Indexing strategies on data warehouses can be extremely light, depending on its usage. Most data warehouses are used solely to populate the SSAS database and, therefore, are not queried directly. In this case, the index strategy would be geared towards speeding up the ETL process. In some cases, the data warehouse may be queried directly.…
So I have successfully installed SQL Server 2012 on Windows Server 2012, and I am ready to play. Only I cannot connect to it from my laptop using SQL Server Management Studio. When I attempt to connect, it thinks about it for a little while and then hits me with the following error message: I…
The next meeting of the Office 365 International User Group is scheduled for 2pm Denver, CO time on August 28th! Below is the link to the Meeting invite, please add to your calendar and join us for the meeting. I am working on the agenda for the meeting and am always open to speakers and…
Enabling alerts and notifications in SQL Server can be very useful, especially when you use the SQL Agent jobs functionality. By enabling alerts and notifications, you can be notified if your SQL job fails or each time is completes. Here are the steps for enabling SQL Server Alerts and Notifications. Configure Database Mail 1. Using…
This post will highlight some of the new features and functionality that has been recently introduced for Office 365. Message Center First up is the new Message Center for Office 365. Message center is meant to augment communications from Microsoft to Office 365 Admins, not to replace e-mail and other communications methods. Below is the…
Let’s face it. We love SQL cursors. At least I do. At least I USED to. Until I started to appreciate the performance price tag associated with one. After that, I have been spending my time finding ways to circumvent the need for a cursor. But what do you do when you have a set…
I have been recently tasked with a project that requires ADFS and Azure. I quickly discovered as I started building out my production, staging, and development environments that I needed to use web.config transforms to handle my different environments. In the past, I would just create separate copies of the web.config, but that is not…
Tuesday the 30th we had our July meeting of the Office 365 International User group. Overall the meeting was good, it started out sounding more like a Mobile Phone user group though J In the opening open discussion I mentioned that I bought the Nokia Lumia 1020 Windows Phone 8 Phone and we all got…
Tell your neighbors, tell your friends, hide the kids, and kiss the dog, the inaugural San Antonio Systems Management User Group meeting is all set for August 16th. Info at http://saasmug.com, register at http://saasmug.eventbrite.com.
Catapult uses cookies to enhance your experience, to display customized content in accordance with your browser settings, and to help us better understand how you use our website. By continuing to browse or closing this banner, you indicate your agreement. To learn more about the cookies we use and to set your own preferences, see our Privacy and Cookie Policy.