Archive for Microsoft SQL Server
Business Intelligence Forecasting in SQL and Cognos
Note: This article is an update of a presentation given when I was at the University of Oklahoma’s Health Sciences Center. At that time, I was using Cognos version 7.3. This article is updated for Cognos 10 and SQL Server Analysis Server 2012. Revisiting this subject ten years later, my opinion is that Microsoft has [...]
How to fix “Usage Based Optimizer” connection errors in SSAS 2012
The Usage-Based Optimizer can be a very powerful tool for calculating aggregations, when it works. When it doesn’t work perfectly, then it can be frustrating to figure out. The devil is in the details. If you move data between environment, then you have even more details to find and fix.
Getting SQL data into SharePoint
Microsoft SharePoint is a collaboration software that provides a web based portal for business intelligence, content management and document sharing. In this session we will start with the basics of sharing a SQL data in Sharepoint.
SSIS 2012 Parameters vs. Configurations
In this session, SQL Santa (Allen) will review configurations in SQL 2008R2. These options allowed dynamic configuration across environments. Next, we look at SSIS 2012 and the new dynamic options, including Parameters, Expressions and Variables.
What’s New in SQL Server Reporting Services (SSRS) 2012
This is a short summary of new features found in SQL Server 2012 Reporting Services.
Syncronize Reports across SSRS Servers
Well, this article is one of those “I should have said…” but I hope this helps better address the issue of synchronizing reports across multiple Microsoft SQL Server Reporting Servers.
SQL with Celko Download Page
Attendees to the ‘SQL with Celko’ class on August 24, 2012 should receive an email with a password for the following download. The password was emailed to all class attendees. Bookmark on DeliciousDigg this postRecommend on FacebookShare with StumblersTweet about itSubscribe to the comments on this postTell a friend
Bulk Update SSRS Subscription Information
Some tips for bulk updating subscriptions in SQL Server Reporting Services 2008 R2.
New SQL 2012 Exam Passed
This week Allen Smith, Sr. Business Intelligence Developer, got word that he had passed the beta exam for Microsoft SQL Server 2012 – Data Model and Reporting.
How to pass Exam 70-448, tips from a failure.
As new Microsoft SQL Server and other technology rolls out this year, I know a lot of people are cramming for exams. Tips and tricks while studying for Microsoft exam 70-448 or other SQL server exams.
