Browse by Tags

• 2005
• 2008
• access
• analysis
• Analysis Services
• application
• audit
• Backup
• best practices
• blocking
• clustering
• column
• columns
• community
• connections
• copy
• corrupted
• cpu
• cubes
• cumulative
• database
• database mirroring
• databases
• dba
• dbcc
• developer
• disks
• dmv
• Dynamic Management Objects
• dynamics
• edition
• enterprise
• enterprise manager
• environment
• error
• error log
• exception
• failover
• FAQ
• file
• fragmentation
• Hardware
• high availability
• i/o
• index
• indexes
• Integration
• jobs
• kba
• login
• management
• memory
• Microsoft
• multiple
• network
• notification
• pass
• performance
• process
• processor
• profiler
• query
• recovery
• replication
• reporting
• Reporting Services
• sa
• security
• server
• service pack
• service pack2
• services
• snapshot
• software
• source
• sp2
• SQL 2008
• sql express
• SQL Server 2008
• ssas
• ssis
• SSMS
• ssrs
• statistics
• stored procedure
• table
• tables
• Team System
• tempdb
• transaction
• trigger
• tsql
• T-SQL
• tuning
• update
• upgrade
• version
• webcast
• windows
• x64

• SQL Down Under Code Camp 2008 - Attribute Relationships Presentation

  At the recent SQL Down Under Code Camp my presentation was on Attribute Relationships and was sub titled - "You can choose your relatives, but you can't choose your friends". It covered Attribute Relationships, how they work, how to set them up and why Read More... Posted Friday, October 24, 2008 6:24 AM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: SQL Server

• SQL Server 2008, Reportbuilder RTMs

  Get it here Read More... Posted Tuesday, October 21, 2008 6:35 AM from Euan Garden's BLOG | (Comments Off) Filed under: SQL Server, Microsoft, SQL 2008

• Podcasts from the 2008 Microsoft BI Conference

  The B-eye-network website is hosting a series of podcasts from the Microsoft BI Conference. I have not had a chance to listen to any of them yet, but there are quite a number of senior Microsoft people on the list so they should be interesting. http://www.b-eye-network.com/podcast/archive/index-new.php?show_id=35&show_year=200 Read More... Posted Friday, October 10, 2008 10:35 AM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services, SQL Server

• High performance loading in SSIS for Oracle and Teradata

  While SSIS has always been able to load SQL Server at high speed it doesn't use any of the high speed Oracle APIs that are available. Well there is now a new high performance loader for Oracle and another one for Teradata. Downloads are here. Read More... Posted Monday, October 06, 2008 1:55 PM from Euan Garden's BLOG | (Comments Off) Filed under: SQL Server, Microsoft

• Slipstreaming SQL Server Updates/Service Packs in SQL 2008, almost

  One of the most common asks for SQL Server related to servicing/patching (after uninstall of updates/SPs) is the production of slimstreamed media, ie where the Update/SP and the RTM are included together in a single plackage. Now there are a couple of Read More... Posted Wednesday, October 01, 2008 9:32 AM from Euan Garden's BLOG | (Comments Off) Filed under: SQL Server, Microsoft, SQL 2008

• SQL Down Under Code Camp 2008

  The SQL Down Under Code Camp for 2008 is on in a couple of weeks. Over the weekend of the 11th and 12th of October 2008 the cream of the Australian SQL Server community will gather at Charles Sturt University in Wagga Wagga . This is a free community Read More... Posted Tuesday, September 30, 2008 10:27 PM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services, SQL Server

• TechEd: BI Power Tools

  For those of you who attended my talk or for any other interested parties, I have uploaded my slide deck from my MVP Theatre presentation at Tech.Ed Australia 2008 to my sky drive here: There is not too much to this deck as the presentation was mainly Read More... Posted Saturday, September 06, 2008 2:10 PM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: powershell, SQL Server, bi, Freeware, Open Source

• Invalid namespace - Running SSRS against a named instance

  I recently went to check the configuration of my SQL Server 2008 Reporting Services instance (which is a named instance called "SQL08") and it came up with a "connect" dialog and when I clicked on the "find" button I got an "invalid namespace" error. Read More... Posted Thursday, September 04, 2008 8:21 AM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Reporting Services, SQL Server, SQL Server 2008

• SQL Server 2008, Report Builder

  Ok so not everything for SQL Server 2008 is available yet, Report Builder is going to have a lag, you can find RC 1 here. This should work with RTM SQL 2008. Here are some of the changes from the last RC; Easy to use wizards for creating table, matrix Read More... Posted Tuesday, August 26, 2008 9:18 AM from Euan Garden's BLOG | (Comments Off) Filed under: SQL Server, Microsoft, SQL 2008

• SQL Server Express 2008, Advanced Services and Tools now available

  Get it here. That should not be all the pieces of SQL Server 2008 available. Read More... Posted Tuesday, August 26, 2008 6:40 AM from Euan Garden's BLOG | (Comments Off) Filed under: SQL Server, Microsoft, SQL 2008

• MVP Theatre Agenda at Tech Ed Australia

  If you are registered for Tech Ed Australia this year, come along to MVP Theatre to watch MVPs delivering sessions ranging from 20 minutes to the full 75 minutes. There are only 20 seats in MVP Theatre, so you need to be quick getting to the Expo Hall Read More... Posted Sunday, August 24, 2008 10:20 PM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services, SQL Server, TechEd Australia

• Minor Update to BIDS Helper for SQL 2008

  If you have installed BIDS Helper 1.3 for SQL 2008 in the last few days, you might want to head back to the site and pick up the new 1.3.0.7 build for 2008 . There is an issue with one of the assembly references picking up a 9.0 assembly instead of a Read More... Posted Wednesday, August 20, 2008 11:46 PM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: SQL Server

• Error 2738 while trying to install Adventure Works BI sample on Vista

  When trying to install the Adventure Works 2008 sample database on my new SQL Server 2008 instance I very quickly got a message box about the installation failing with an error of 2738. For some reason this sounded familiar and sure enough a quick search Read More... Posted Wednesday, August 20, 2008 4:08 PM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services, SQL Server, Adventure Works, Sample Install

• BIDS Helper 1.3 Released (now with support for SQL 2008)

  I am pleased to announce that the BIDS Helper team have just released v1.3 which is our first release with support for SQL Server 2008. With these release we have also improved our international support. All of the features in BIDS Helper still only display Read More... Posted Saturday, August 16, 2008 9:51 PM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services, SQL Server, SQL Server 2008, SQL Server 2005, BIDS Helper

• VS.NET 2008 SP1 is available

  The download for VS.NET 2008 SP1 is available now: http://msdn.microsoft.com/en-au/vstudio/cc533448.aspx . This should fix the issue with running BIDS for SQL Server 2008 and VS.NET 2008 . I'm downloading just downloaded it - it's tiny at about 500Kb, Read More... Posted Tuesday, August 12, 2008 8:03 AM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services, SQL Server