I have seen many times at clients where the terms business intelligence and data warehousing are used interchangeably. In reality, these are two separate disciplines. This is especially true for enterprise data warehouses due to an EDW’s scope, complexity, and large volumes of data.
As seen in the data warehouse… Read more
I have been honored to be chosen a Microsoft SQL Server Most Valuable Professional (MVP). Here is a video on my reaction: I’m a Microsoft MVP and I feel great!
SQL Server 2014 has enhancements to two common database maintenance operations:Partition Switching and Online Index Rebuild. This will greatly increase enterprise application availability by reducing maintenance downtime impact.
The two new features are:
- Managed Lock Priority: This allows you to manage the priority of table locks acquired by partition SWITCH…
Sometimes I see confusion on the difference between a data warehouse (DW) and master data management (MDM). Below is a good list of how they differ. Note the typical scenario is the data in a MDM database is fed into a DW.
I first blogged about Power BI for Office 365 two months ago (see Power BI for Office 365) when it was announced. Microsoft has started inviting participants subscribed to the Power BI for Office 365 Preview to test the prerelease version of Power BI.
Power BI is aimed at… Read more
SQL Server Data Tools (SSDT) has a new update:
VS 2010: August 2013 version: 10.3.30822.0, June 2013 version: 10.3.30618.1, December 2012 version: 10.3.21208.0, November 2012 version: 10.3.21101.1, September 2012 version: 10.3.20905.0, initial version: 10.3.20225.0
VS 2012: August 2013 version: 11.1.30822.0, June 2013 version: 11.1.30618.1, December 2012 version: 11.1.21208.0, November 2012… Read more
The Certified Master and Architect community was collectively notified Friday, August 30, at 10PM PST that the Certified Master (MCM/MCSM) and Certified Architect (MCA) programs are dead. The email transcript has been reported by Neil Johnson. For those of you who are already in the process of earning the… Read more
Thanks to everyone who attended my session “Building an Effective Data Warehouse Architecture” at the Houston Area SQL Server User Group Monthly Meeting. The abstract is below. I hope you enjoyed it!
Here is the PowerPoint presentation: Building an Effective Data Warehouse Architecture
Building an Effective Data Warehouse Architecture Read more
A vendor management system (VMS) is a web-based application that acts as a mechanism for businesses to manage and procure staffing services (temporary and permanent) as well as outside contract or contingent labor. Typical features of a VMS application include order distribution, consolidated billing and significant enhancements in reporting capability… Read more
Thanks to everyone who attended my session “Building an Effective Data Warehouse Architecture” for the PASS DBA Fundamentals Virtual Chapter. The abstract is below and the recording of the session will be available soon here. I hope you enjoyed it!
I will be presenting the session “Building an Effective Data Warehouse Architecture” today at 11am CST for the PASS DBA Fundamentals Virtual Chapter. Info about watching the presentation online is here, and the abstract for my session is below. I hope you can make it!
Building an Effective… Read more
Unfortunately in my line of work as a consultant, I am contacted far too often by resume hoarders, who are “recruiters” who sole job is to collect resumes, with no attempt at all to try to match the right person with the position that is open. It’s just a matter… Read more
Every week I get a bunch of emails from recruiters about jobs that I am not qualified for (see Low-rate recruiters – The bane of my existence). Some obviously use keyword searches and just spam any person who has that keyword in their profile (i.e. I have Microsoft Dynamics… Read more
If a recruiter sends me a job description, the first question I ask is, “What is the pay rate”. If it is not in the ballpark of what I make, I shut the conversation down as continuing would just be a waste of everyone’s time. Better to do that then… Read more
I have heard large placement firms say they are better than smaller firms because “They offer the client a guaranteed replacement in case the resource doesn’t work out or leaves project early “. I asked my recruiter friend about this. His response:
You can look at it that statement two… Read more
AlwaysOn was introduced in SQL Server 2012, and there are some enhancements in SQL Server 2014:
- Now support up to 8 secondary replicas that remain available for reads at all times, even in the presence of network failures. Failover Cluster Instances now support Windows Cluster Shared Volumes, improving the utilization…
I literally get 10-15 calls and emails a week from recruiters asking if I can help them to find a data warehouse or business intelligence person for an opening at a client they have. And another 10-15 emails for positions not even close to my skill-set (many coming from keyword… Read more
If your company is planning to build a data warehouse or BI solution (see Why you need Business Intelligence), you need to be aware that BI projects have high failure rates. Gartner says between 70% to 80% of corporate business intelligence projects fail (see Poor communication to blame for… Read more
Thanks to everyone who attended my session “Best Practices to Deliver BI Solutions” for Pragmatic Works. The abstract for my session is below and the recording will be available soon here. I hope I provided some good info for you.