About James SerraI am an independent consultant with the title of Business Intelligence/Data Warehouse/Master Data Management Architect and Developer, specializing in the Microsoft SQL Server BI stack.
Need some help?If you are looking for help in building a data warehouse or end-to-end BI solution, send me an email and we can discuss your needs. I am available for short or long-term projects.
Subscribe by email
- I’m presenting at the PASS Summit!
- Consulting company: Perm/Salaried vs 1099/W2
- When the person you hire is not the person you hire
- Should placement companies use a markup %?
- Data cleansing in SSIS, DQS, and MDS
- Billing rates – other side of the fence, part 2
- Want me to do a presentation?
- Enhance your career by blogging!
- Consultants – Why pay more?
- Industry Expert Interview
- Consulting company: Perm/Salaried vs 1099/W2 | James Serra's Blog on Salaried employee vs contractor
- I’m presenting at the PASS Summit! - SQL Server - SQL Server - Toad World on PASS Business Analytics Conference: the ultimate networking
- I’m presenting at the PASS Summit! - SQL Server - SQL Server - Toad World on How to become an expert in your field
- I’m presenting at the PASS Summit! - SQL Server - SQL Server - Toad World on Enhance your career by blogging!
- I'm presenting at the PASS Summit! | James Serra's Blog on DBA’s, want to earn the big bucks? Learn BI
- May 2013 (7)
- April 2013 (10)
- March 2013 (10)
- February 2013 (10)
- January 2013 (8)
- December 2012 (10)
- November 2012 (11)
- October 2012 (10)
- September 2012 (9)
- August 2012 (4)
- July 2012 (9)
- June 2012 (7)
- May 2012 (6)
- April 2012 (10)
- March 2012 (15)
- February 2012 (14)
- January 2012 (13)
- December 2011 (12)
- November 2011 (12)
- October 2011 (14)
- September 2011 (14)
- August 2011 (15)
- July 2011 (15)
- June 2011 (20)
- May 2011 (13)
- April 2011 (3)
- Active Directory
- Business Intelligence
- Columnstore indexes
- Data warehouse
- Fast Track
- Fuzzy Lookup
- Power View/Project Crescent
- Quick Tip
- Report Builder
- SharePoint 2013
- SQL Azure
- SQL Server
- SQL Server 2012
- SQLServerPedia Syndication
- Team Foundation Server
- Visual Studio 2008
- Visual Studio 2010
- Visual Studio 2012
- Visual Studio vNext
- White Paper
- Windows 8
Top Posts & Pages
- I'm presenting at the PASS Summit!
- Data Warehouse Architecture - Kimball and Inmon methodologies
- SQL Server 2012: Multidimensional vs tabular
- SQL Server 2012 SP1 Causes MsiInstaller Application Log Entries
- Dirty looking SQL, MDX, or DAX? Clean it up
- Conformed dimensions
- SQL Server 2012 (“Denali”): AlwaysOn
- Consultants: 1099 or W-2?
- TinyInt problem in SSAS
Category Archives: PDW
Version 2 of Parallel Data Warehouse (PDW) is apparently due this month (and can be ordered as of March 1st). The official name is Microsoft SQL Server 2012 Parallel Data Warehouse. Info on HP’s version: HP AppSystem for Microsoft SQL Server 2012 Parallel … Continue reading →
Some announcements and notes from the SQL PASS Summit 2012 last week (If you don’t know what PASS is, check out What is SQL PASS?): PASS Summit 2012 had 3,894 delegates – up 13% from last year’s previous record attendance – and 1,717 pre-conference … Continue reading →
Thanks to everyone who attended my presentation “Scaling SQL Server to HUNDREDS of Terabytes” at Houston SQLSaturday. Here is the PowerPoint presentation: Scaling SQL Server to HUNDREDS of Terabytes Scaling SQL Server to HUNDREDS of Terabytes Learn how SQL Server 2008 can … Continue reading →
In the next few weeks there will be an update to the SQL Server Parallel Data Warehouse (PDW) called “Appliance Update 3″ or “AU3″. More than just a cumulative update, an Appliance Update is a complete refresh on the entire solution including software, hardware, … Continue reading →
If you are the decision maker in your company and you are tasked with purchasing one or more servers to be used solely for SQL Server and solely as a data warehouse, be aware there are options outside of the usual … Continue reading →
Microsoft has made available SQL Server appliances and reference architectures that allow customers to deploy data warehouse (DW), business intelligence (BI) and database consolidation solutions in a very short time, with all the components pre-configured and pre-optimized. These appliances include all the … Continue reading →
Microsoft SQL Server Parallel Data Warehouse (PDW), formally called by its code name “Project Madison”, is an edition of Microsoft’s SQL Server 2008 R2 that was released in December 2010. PDW is Microsoft’s reworking of the DatAllegro Inc. massive parallel processing (MPP) product … Continue reading →