Cumulative update package 3 for SQL Server 2008 SP 1

יום שבת, אוגוסט 8, 2009

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 DateTime data type. You map the...
תגיות: , , ,
תגובה אחת

Convert DateTime Format

יום ראשון, מאי 17, 2009

  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 1HH: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 11/23/98 MM/DD/YYYY USA ...
תגיות: , ,
5 תגובות

Memory configuration in SQL Server 2005 Database Engines

יום ראשון, פברואר 22, 2009

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
תגיות: ,
אין תגובות

Reporting services TIP #10

יום חמישי, פברואר 5, 2009

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  ...
תגיות: , , ,
אין תגובות

Nice Undocumented feature in Report Builder 1.0

יום שבת, ינואר 17, 2009

  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 provide this info: =String.Format("Sales Year: {0}", Parameters!OrderYear.Value) One problem with it is that you will have to guess the...
אין תגובות

Use SQL 2008 reporting services with template

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 is on your local PC. Enjoy, Ronen Technorati Tags: DEV,SSRS 2008,SSRS TEMPLATE
תגיות: , ,
תגובה אחת

Report Builder 1.0 shortcut from your desktop

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
אין תגובות

BI SQL Server 2008 at McLaren

יום חמישי, ינואר 1, 2009

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
תגיות: , ,
אין תגובות