Thursday, August 31, 2006
Thursday, August 24, 2006
Check out: Reference Implementation
Wednesday, August 09, 2006
This year I am presenting again. I am lucky enough to have one very comprehensive session on Business Intelligence.
BIN213 - Delivering an End to End Business Intelligence Solution on Monday 21st Aug 2:00:00 p.m. to 3:15:00 p.m.
My session is going to cover a detailed overview of implementing Microsoft Business Intelligence solutions. I am covering topics such as SQL Server 2005, SSIS, Analysis Services 2005, Reporting Services 2005, Office 2007 and ProClarity.
I am also looking at the business reasons behind BI projects. In the demonstrations I will show an integrated architecture for a Microsoft BI platform.
Ok it’s a lot to cover. So I will also be about on the HP stand this year to go through any questions or demos you would like to discuss in detail.
If you have registered for TechEd you need to login to CommNet and book your session schedule.
For complete schedule information see Nigel Parkers Blog
Thursday, August 03, 2006
This was something I did all the time with SQL 2000. It all started when SP 2 came out. We started to get issues with dts packages that were developed on SP1 and then run SP2. The problem was the package format changed between versions. Hence the question what version I am really running?
Why have I brought this up you may ask? Because now that we have SP1 for SQL Server 2005 and the rollup hotfix. We now have three versions of SQL Server 2005 that are in support by Microsoft.
How Do I get the Version of SQL Server?
The easiest and most reliable is the T-SQL Statement below:
There are of course lots of other methods but I prefer T-SQL. This works for SQL 7 and above. The statement returns the SQL Server edition, version, OS and OS Patch number, and the most important the SQL Build Number for Sqlservr.exe.
The build number will tell you the patch level of your SQL Server.
Build Numbers for SQL Server 2005
- 2005.90.1399 - RTM first commercial release of SQL Server 2005
- 2005.90.2047 - Service Pack 1 for SQL Server 2005 see: How to obtain the latest service pack for SQL Server 2005
- 2005.9.0.2153 - Rollup hotfix for SQL Server 2005 see: Cumulative hotfix package (build 2153) for SQL Server 2005
Other Build versions
There are heaps of sources for this information. Listed below are some helpful links for earlier versions of SQL Server and software update naming conventions.
How to identify your SQL Server version and edition
New naming schema for Microsoft SQL Server software update packages