Browse by Tags

Cumulative update package 3 for SQL Server 2008 SP 1
08 August 09 01:42 PM | Ronen Chenn | 1 comment(s)

Hi all, CU 3 for SQL 2008 SP 1 has released and can be download here . The file version is 2007.100. 2723 .0. It has resolved 2 problems I have encountered with: 1. Problem: In Microsoft SQL Server 2008, you create a SQL Server Integration Services (SSIS) package. This SSIS package contains an Execute SQL Task that uses an OLE DB connection. The Execute SQL Task runs a stored procedure that has an output parameter of the DateTime data type. In the SSIS package, you create a package variable of the...

תגים:SQL 2008, DEV, TECH, SP1

Convert DateTime Format
17 May 09 03:08 PM | Ronen Chenn | 5 comment(s)

Hi , Recently I have encountered the need for extended date format such as quarter. So I found many tips over the web and concentrated them into to one post. For example 'MM/YYYY', and select Quarter from Getdate()... Hope this help! Ronen Date Format Standard SQL Statement Sample Output Mon DD YYYY 1 HH:MIAM (or PM) Default SELECT CONVERT(VARCHAR(20), GETDATE(), 100) Jan 1 2005 1:29PM 1 MM/DD/YY USA SELECT CONVERT(VARCHAR(8), GETDATE(), 1) AS [MM/DD/YY] 11/23/98 MM/DD/YYYY USA SELECT CONVERT...

תגים:SQL 2008, DEV, Date Format

Memory configuration in SQL Server 2005 Database Engines
22 February 09 10:48 AM | Ronen Chenn | with no comments

Hi, I would like to redirect you to a great post of my colleague Stas Bogachinsky from his BLOG. The blog is talking about memory in SQL 2005/2008. It is also relevant for does who consider 64 BT Platform. Click to the blog Enjoy, Ronen

תגים:SQL 2008, DEV

Microsoft SQL Server Release Services
11 February 09 01:52 PM | Ronen Chenn | with no comments

Hi all, You can find the most up to date releases and Cumulative Update at this link . Enjoy, Ronen

תגים:SQL 2008, DEV

Reporting services TIP #10
05 February 09 10:03 AM | Ronen Chenn | with no comments

Hi all, I decided to blog each time I run into nice trick at the BI services. I have counted 9 tips, so I will numerate them... ( just for fun)- it is always good to start from 10. (-: Problem : You have a table. you need to hide/unhide columns by specific parameter. For example: You have this table, you need to hide the Qi columns by a value of the parameter. site Q1 Q2 Q3 Q4 a b c d Solution : Past this expression on each column visibility: IIF(INSTR(Join(Parameters!StatementName.Value, "...

תגים:SQL 2008, DEV, SSRS, USER GROUP

Nice Undocumented feature in Report Builder 1.0
17 January 09 05:28 PM | Ronen Chenn | with no comments

1. You can add a textbox that shows the date the report was run by setting the value of the textbox to the following: =String.Format("Date: {0:MM/dd/yyyy}", DateTime.Today) 2.Another potential use of this undocumented feature is to display the values selected by the user for each report parameter. This is a helpful workaround for the fact that the auto-generated filter description does not insert the run-time values for each parameter. Here's an example of an RDL expression that would...

תגים:SQL 2008, DEV, SSRS, Report builder

Use SQL 2008 reporting services with template
17 January 09 04:48 PM | Ronen Chenn | 1 comment(s)

HI, One common best practice for enterprise reporting system is one template for all the reports . In order to use one template follow this steps: 1. Develop one report with all the template item you wish to include at your template. 2. save it on this folder : C:\Program Files\Microsoft Visual Studio 9\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject 3. There is a file called report.rdl; that is the default one from MS. One caveat, you will have to do this on every machine as the template...

תגים:SQL 2008, BI 2008, SSRS

Report Builder 1.0 shortcut from your desktop
17 January 09 04:25 PM | Ronen Chenn | with no comments

Hi, If you need direct link to the report builder, use this one on a shortcut on your desktop: Do not forget to change the server name {SERVER}... The shortcut: http://{SERVER}/ReportServer/ReportBuilder/ReportBuilder.application Have Fun. Ronen Technorati Tags: DEV , RB 1.0 , Report builder

תגים:SQL 2008, BI 2008, Report builder

BI SQL Server 2008 at McLaren
01 January 09 07:57 PM | Ronen Chenn | with no comments

Hi, Click the following link for 3 minutes of Sql Server 2008 Data Mining, Integration services, Analysis services and many more at McLaren. Click to see : McLaren Sql 2008 Technorati Tags: SQL2008 , Data mining Enjoy, Ronen

תגים:SQL 2008, BI 2008, DEV