Another BI & Programming Blog - Jason Yousef

A recent questions about how to add another instance of SSRS, couldn't find any that talking about 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the CD, run the installer, select Reporting services from the "Feature Selections", then select "Named Instance", configure and you're done ! The installation files and additional checks. Perform a new installation.... Select only Reporting Services ... named instance or you'll get an error ! Confirmation... Service account configuration...can be changed later.. Installation...& Completion... Reporting Services Configuration Manager. All Programs---> Microsoft SQL server 2008---> Configuration Tools Selecting the new instance to configure... Hop to the database tab to install or point to an existing DB.  I'm already using ReportServer default ...

Ms just released 2 days ago the SQL Server 2012 Developer Training Kit includes technical content designed to help you learn how to develop SQL Server 2012 database and BI solutions. You'll need to have the Microsoft Web Platform Installer 3.0 installed before downloading http://www.microsoft.com/web/downloads/platform.aspx Then download the KIT from here... it'll need 269 MB space to download all the sets of LABS, Presentations and Demos. http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=27721 In the system requirments, they listed windows 7, windows server 2008. During the installation, it'll give you an options t odownload and install VS2010,SQL 2012 and such required S/W.

Aperantly MS has some goodies for the new year, I posted before a link to the new E-book, and now I just discovered this new GEM... Microsoft Virtual Academy Improve your IT skill set and help advance your career with a free, easy to access training portal. Learn at your own pace, focusing on Microsoft technologies, gain points and get recognition.

Have you ever got this message? "Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid." It's simply as it says, just go back to your report and make sure to save the user credintials that runs the report, or go to Datasets under ReportServer. Also you can refer to this MS 'How to' article. http://msdn.microsoft.com/en-us/library/ms159736.aspx Also make sure that your report is not using a User experssion, !userID Check:  http://msdn2.microsoft.com/en-us/library/ms156012.aspx

Microsoft Press Today, via their Twitter  account, Tossed a link to their new E-book Introducing Microsoft SQL Server Code Name “Denali”. http://blogs.msdn.com/b/microsoft_press/archive/2011/10/11/free-ebook-introducing-microsoft-sql-server-code-name-denali-draft-preview.aspx?CommentPosted=true#commentmessage 

A recent question about how to check for file existance, skip or copy using script taks. from 2 different locations.  Here I'll ge ta list of files that needs to be copied from C:\Media, check if it exists in U:Media or not and act accordingly. Imports System Imports System.Data Imports System.Math Imports Microsoft.SqlServer.Dts.Runtime Imports System.IO <System.AddIn.AddIn("ScriptMain", Version:="1.0", Publisher:="", Description:="")> _ <System.CLSCompliantAttribute(False)> _ Partial Public Class ScriptMain  Inherits Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTARTScriptObjectModelBase  Enum ScriptResults   Success = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Success   Failure = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure  End Enum     Public Sub Main()         Dim FileToCopy As String         Dim NewCopy As String  ...

A recent question about how to create dynamic variables using expressions in SSIS, well that's pretty easy, you just need to highlight the desired variable, press F4 to pull the properties window.  Then set "EvaluateAsExpression" to TRUE, then click on ellipsis to set the expression.... Hope that helps...

I'm excited to write my first blog post in 2012 with a new year resolution, 99% of the times when I create a SQL agent job I forget to set the category of the job to a meaning category instead of the default [ Uncategorized - (Local) ] Does your jobs looks like this? Make it a habit and add the category.. To add more categories to the list...(Right-click Jobs , select Manage Job Categories, then Add) Hope that helps you to get your server more organized !