Archive for Microsoft SQL Server
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 [...]
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.
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.
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.
This is a short summary of new features found in SQL Server 2012 Reporting Services.
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.
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
Some tips for bulk updating subscriptions in SQL Server Reporting Services 2008 R2.
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.
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.