Browse by Tags

• .NET
• Business Intelligence
• conference
• Data Visualisation
• Data Warehousing
• ETL
• How To's
• Hyper-V
• Integration Services
• MDS
• Microsoft
• Office
• Performance
• Persistent Lookups
• Pipeline Scalability
• PowerPivot
• Product/Patch Releases
• SQL Server 2005
• sqlbits
• SSIS
• SSIS 2008
• Training
• video

• Altius at SQLBits V – Videos Now Online

  My colleagues Matt Feltham and Ian Marritt were presenting at the SQLBits V Conference last year, and the videos from the sessions are now available online. Titles link to the SQLBits site, Screencaps link to the videos directly in Windows Media format... Posted Feb 01 2010, 09:56 PM by EdGillett with | with 1 comment(s) Filed under: SQL Server 2008, Business Intelligence, Data Visualisation, video, conference, sqlbits, MDS

• Microsoft Virtual Labs – PowerPivot for Excel 2010

  Want to try out PowerPivot for Excel 2010 yourself, but don’t have time or resources to build a demo system? Now you can get 2 hours in a virtual lab (Powered by Hyper-V) to get to grips with it: Click here to connect to the Lab (IE Only since it needs... Posted Nov 19 2009, 11:35 AM by EdGillett with | with no comments Filed under: Office, Microsoft, SQL Server 2008, PowerPivot, Training, Hyper-V

• SQL Azure support in SQL Server Management Studio

  The SQL Azure Team Blog just pointed out that the November CTP for SQL Server 2008 R2 also includes support in Management Studio to connect to SQL Azure . Nice to know, and something I’ll be looking to blog more about as I investigate Microsoft’s SQL... Posted Nov 11 2009, 01:37 PM by EdGillett with | with no comments Filed under: .NET, SQL Server 2005, SQL Server 2008

• Commentary from the PASS Keynote

  For those that haven’t been able to make it to this year’s PASS conference, Brent Ozar has been doing an excellent job blogging from the event: http://www.brentozar.com/archive/2009/11/sqlpass-keynote-day-1-liveblog/ There’s some interesting stuff here... Posted Nov 04 2009, 05:18 PM by EdGillett with | with no comments Filed under: SQL Server 2008

• SSIS 2008 – Package Restarting and Checkpoints

  A feature available in SSIS is to mange the restartability of a package following an error. For example, if you have a package with many control flow tasks and one fails, once fixed, you may not want to restart the package again from the beginning. SSIS... Posted Sep 09 2009, 11:32 AM by TomStagg with | with no comments Filed under: How To's, SSIS, SQL Server 2008, SSIS 2008, Integration Services

• SQL Server 2008 – Change Data Capture (CDC) example

  One of the new features of SQL Server 2008 is Change Data Capture (CDC). CDC is used to track changes (inserts, updates and deletes) made on SQL Server tables. Overview When CDC has been configured for a database and table, the capture process will monitor... Posted Sep 07 2009, 08:43 AM by TomStagg with | with no comments Filed under: How To's, SQL Server 2008, ETL, Data Warehousing

• Microsoft release SQL Server 2008 SP1 and additional downloads

  Following on from the CTP release of SP1 in February, Microsoft announced the official release SQL Server 2008 SP1 yesterday and is now available for download in the Microsoft Download Center: Download SQL Server 2008 SP1 The SP1 release is “primarily... Posted Apr 08 2009, 11:24 AM by EdGillett with | with no comments Filed under: Product/Patch Releases, SQL Server 2008, Business Intelligence

• SQL Server Fast Track Data Warehouse

  Microsoft has announced a range of pre configured servers for BI applications, specifically for relational data warehouses but also including Analysis Services. Full details can be found on http://www.microsoft.com/sqlserver/2008/en/us/fasttrack.aspx... Posted Feb 24 2009, 04:30 PM by IanMarritt with | with no comments Filed under: Microsoft, Performance, SQL Server 2008, Data Warehousing

• SQL Server 2008 Part 2 - SSIS Persistent Lookups

  Over the coming weeks I’ll be writing a number of blogs detailing new features and enhancements to Microsoft’s BI platform shipped with SQL Server 2008. The 1 st series will focus on Integration Services. Altius has completed a number of high data volume... Posted Sep 16 2008, 12:46 PM by ShaunRyan with | with 1 comment(s) Filed under: SSIS, Microsoft, SQL Server 2008, SSIS 2008, Integration Services, Persistent Lookups

• SQL Server 2008 Part 1 - SSIS Pipeline Scalability

  Over the coming weeks I’ll be writing a number of blogs detailing new features and enhancements to Microsoft’s BI platform shipped with SQL Server 2008. The 1 st series will focus on Integration Services. Altius has completed a number of high data volume... Posted Sep 03 2008, 12:07 PM by ShaunRyan with | with 4 comment(s) Filed under: SSIS, SQL Server 2008, Pipeline Scalability, Integration Services