SQL Log Rescue – Undo for SQL Server.
Came across this product again today to help with a particular need. I’ve used Red Gate products before at another employer and loved them. However, I never realized the SQL LogRescue product. On top of that, it is a free tool. Read the rest of this entry »
Popularity: 4% [?]
Presenter: Josh Jones
Just like any other application, OLAP solutions designed and built in Visual Studio 2008 for SQL Server Analysis Service 2008 must be managed from source code to server. In this session, learn different methods for managing your OLAP solutions. Well cover TFS and VSS storage, manual deployment methods using the Visual Studio GUI, as well as command line build automation methods specific to SQL Server Analysis Services project deployments. Read the rest of this entry »
Popularity: 9% [?]
Presenter: Ted Malone
http://portal.sqltrainer.com
One of the problems that presents those new to Business Intelligence development is how to configure the development and production environments for maximum efficiency. This session will cover the installation and configuration of SSAS for both development and production environments. Attendees will leave this session with a good understanding of the options available and the specific needs in an SSAS environment. Read the rest of this entry »
Popularity: 9% [?]
Presenter: John Welch
http://agilebi.com/cs/blogs/jwelch/Default.aspx
SSIS is a great tool for transferring data from one data source to another, and for implementing complex ETL processes. However, for simple, straightforward data transfer tasks, creating SSIS packages by hand can be time-consuming and repetitious. By attending this session, you’ll learn how to automate data transfers from a source to a target using SSIS. You’ll see the steps necessary to create both the control flow and the data flow portions of an SSIS package using the API and C# code. You’ll also learn about altering existing packages programmatically. Specific attention will be given to the generation of data flows with the proper source and destination components. We’ll take a look at some of the open source solutions available for this, plus some “roll your own” options. Read the rest of this entry »
Popularity: 16% [?]
Presenter: Brian Knight
bknight@pragmaticworks.com
Is your customer looking for drag and drop reports or capabilities inside of Excel. SQL Server Analysis Services (SSAS) is the answer for you then. You’ll be amazed how quickly you can develop sophisticated reports after watching the basics of this session. Read the rest of this entry »
Popularity: 10% [?]
Presenter: Matt Masson
http://blogs.msdn.com/mattm/
This talk describes the new MERGE statement and Change Data Capture (CDC) feature introduced in SQL Server 2008, and how to take advantage of them in SQL Server Integration Services. Well cover the traditional ways of doing incremental data loads, and see how these new key features make the process a whole lot easier. If you’re interested in learning best practices for this new SQL Server 2008 functionality, you won’t want to miss this session! Read the rest of this entry »
Popularity: 14% [?]
Presenter: Brian Knight
bknight@pragmaticworks.com
Owner, Pragmatic Works
In this session, you’ll learn how to load a typical data warehouse in SSIS efficiently. You’ll start by seeing some of the strengths and weaknesses of the Slowly Changing Dimension (SCD) Wizard in SSIS and how you can get around some of the weaknesses including your own home-brewed solution. You’ll then see how to load a fact table using SSIS and how to make the common components scale. Read the rest of this entry »
Popularity: 19% [?]
Hey there everyone. Have I got a treat for someone out there.
Are you a SQL Server DBA, Developer, Report Writer?
Do you align with a desire to spread God’s Word?
Do you love working in an evolving/energetic environment? Read the rest of this entry »
Popularity: 9% [?]
