When working with a MySQL database as a source you may experience some unexpected results in your data extracts. Most of the issues are related with handling of certain data types such as “TinyInt”.
A particular issue I recently came upon was the fact that TinyInt(1) is treated by default… Read more
I had the honor to speak for the first time at this past PASS Summit 2013 in Charlotte, NC. It was a great opportunity for me as this is one of the most prestigious nationwide conferences on SQL Server. I delivered 3 different sessions on Business Intelligence related topics. Attendance… Read more
This year I was honored to sponsor and speak at IT Pro Camp Tampa 2013. Like always, it is a great pleasure to give back to the community and get to know people from different technical backgrounds. The event was very well-organized and the venue was great.
This year the… Read more
Configuring BIDS 2008 / 2008 R2 and Visual Studio 2008 to work with Database & Business Intelligence Projects and Team Foundation Server (TFS)
Working with the SSIS, SSAS, and SSRS Business Intelligence projects along with Database projects in the same Visual Studio 2008 development environment can be challenging as there is no clear documentation how to enable both set of projects. Database projects are supported by Visual Studio 2008 Developer, Professional and Team… Read more
I recently downloaded the Hortonworks Sandbox v1.3 Hyper-V VM and had a hard time connecting to the included web interface that comes with it. I downloaded and followed the instructions to configure the VM in my Hyper-V server. As of this writing, the instructions point you to take note of… Read more
I’m truly honored to be chosen to speak at PASS Summit 2013. The honor is compounded as I have been chosen to deliver two sessions:
- Fast Performing SSAS Hierarchies: Tips and Tricks (3 hours)
Track: BI Platform Architecture, Development & Administration
Session Abstract: Depending on how they’re implemented, SQL Server…
This past Saturday March 16th, I had the opportunity to speak once again the .Net Orlando Code Camp. I presented a session under the SQL Server track titled “Change Data Capture, a developer’s best unknown friend”. I had better than expected turn-out with about 20 attendees and overall very good… Read more
I have been appointed as PASS Regional Mentor for the Greater Southeast by PASS (http://www.sqlpass.org). I am truly honored to volunteer for this position to help improve our PASS community. These are BIG shoes to fill.
Everyone heard about Facebook’s recent purchase of Instagram for $1 billion dollars. No one can imagine how they came with such price tag for a bunch (a big bunch) of pictures with special filters added. I never used Instagram and I don’t think I will ever. I’m happy with my… Read more
SQL Server Upgrade error: It is not possible to change the SQL Server features to be upgraded in this release. Validation errors. There are no features selected for upgrade.
On a recent project I was asked to “upgrade” a licensed SQL Server 2008R2 Standard Edition to SQL Server 2008R2 Enterprise Edition. I have done this multiple times with no issues. The “kicker” was that the upgrade required a 48-hour turnaround time but no installation media for SQL Server Enterprise… Read more
I am officially announcing that I have now become an independent consultant and business owner. Becoming independent has always been my dream and I have now decided to follow that dream. I believe it is the right time to do it for my family and myself. It’s time to soar! Read more
This past Saturday January 21, 2012 I had the opportunity to speak at my first IT Pro Camp in Orlando, FL. This event was put together by Blain Barton ( Blog | LinkedIn | Twitter ), Microsoft Senior IT Pro Evangelist and Chad Miller ( Blog | LinkedIn | Twitter… Read more
Master Data Services Error: Resolving from a long-running stucked Staging Batch with Status “Queued to Clear” or “Not Running”
In some ocassions, you may run into a runaway, long-running or stucked staging batch with Master Data Services in SQL Server 2008 R2. The issue happens most frequently when a fairly large batch of rows are being processed for update or deletion.
The issue has to do with Service Broker,… Read more
I recently bumped into this very exhaustive list of SSIS tasks, components and samples in CodePlex http://ssisctc.codeplex.com. The list is maintained by SQL Server MVP (Blog|Twitter) and grouped in the following sections:
- Connection Managers
- Log Providers
- Tasks (for Control Flow)
- Foreach Enumerators
- Script Task
SQL Server 2012 Master Data Services Error: The required .svc handler mappings are not installed in IIS.
Microsoft SQL Server 2012 Release Candidate 0 (RC 0) has a confirmed issue with Master Data Services configuration. The following error is raised by the Master Data Services Configuration Manager when launched:
Before creating an MDS web application, you must correct the following errors:
Internet Information Services (IIS) is not…
Wow! Just Wow! That’s all I can say to describe how great SQL Saturday 86 was on November 5th in Tampa, FL . I got so much positive feedback from every attendee, speaker and sponsor. Food was great, sessions were amazing, speakers were first class! I have to say thanks… Read more
The CASE of the missing non-NULL T-SQL Error: None of the result expressions in a CASE specification can be NULL.
Recently, while doing some data scrubbing for a customer I got an interesting error in SSMS with one of my CASE statements. The error received was:
None of the result expressions in a CASE specification can be NULL.
It was a long T-SQL script (and a long night) and could… Read more
This past weekend I participated at GiveCamp Tampa 2011 (http://www.givecamptampabay.org/) as part as the Worldwide GiveCamp (http://www.givecamp.org) weekend sponsored by Microsoft and other partners. Per GiveCamp’s website:
GiveCamp is a weekend-long event where technology professionals from designers, developers and database administrators to marketers and web strategists…
Gracias a lo asistentes de mi charla Todo lo que debes saber sobre SSIS en 1 hora! en el evento 24HOP LATAM. La verdad me agrado mucho presentar en espanol. Aun cuando mi primera lengua es espanol, todas las presentaciones tecnicas en el pasado las he realizado en ingles.
Si… Read more
Master Data Services provides a way of de-activating entity members using the StgMemberAttribute table as described in Books On Line http://msdn.microsoft.com/en-us/library/ee633772.aspx
This is a somewhat straightforward approach and requires for you to populate the StgMemberAttribute table with AttributeCode (actual code of the member in MDS), AttributeName as “MDMMemberStatus” and AttributeValue… Read more