Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

My PASS Summit 2013 Presentations

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

0 comments, 305 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 27 October 2013

IT Pro Camp Tampa 2013

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

0 comments, 253 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 27 October 2013

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

0 comments, 516 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 14 August 2013

Connecting to the Hortonworks Sandbox v1.3 through IP 192.168.56.101

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

2 comments, 282 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 8 August 2013

Presenting 2 sessions at SQLPASS

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:

Read more

1 comments, 172 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 22 May 2013

.Net Code Camp Orlando 2013

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

0 comments, 253 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 18 March 2013

I have been appointed as PASS Regional Mentor for the Greater Southeast

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.

I will be joining my good friend Tim Radney (Twitter |… Read more

2 comments, 376 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 21 August 2012

Top 3 Reasons Why Evernote is worth $1 billion to me

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

3 comments, 365 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 11 April 2012

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

1 comments, 1,198 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 30 March 2012

The affordable self-service BI revolution has started.

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

10 comments, 826 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 30 January 2012

Afterthoughts: IT Pro Camp Orlando 2012

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

0 comments, 355 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 24 January 2012

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

6 comments, 489 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 14 December 2011

Codeplex: SSIS Community Tasks and Components

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:

  • Tools
  • Connection Managers
  •  Log Providers
  • Tasks (for Control Flow)
    • Foreach Enumerators
    • Script Task

Read more

0 comments, 415 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 14 December 2011

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…

Read more

0 comments, 782 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 29 November 2011

SQL Saturday 86 BI Edition Tampa 2011: Afterthoughts

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

0 comments, 648 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 16 November 2011

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

3 comments, 722 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 16 November 2011

GiveCamp Tampa 2011

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…

Read more

0 comments, 523 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 24 October 2011

Todo lo que debes saber sobre SSIS en 1 hora!

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

0 comments, 592 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 20 October 2011

MDS Error: MDMMemberStatus does not de-activate members through the StgMemberAttribute table

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

0 comments, 415 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 11 October 2011

Useful queries #3: Get SQL Server Edition, Version, Build and Last Update date and time.

Keeping track of all the versions and editions SQL Server instances can be a daunting task if you don’t have the right tools and documentation. A very easy way to obtain version, edition and build information from your SQL Servers is by querying the SERVERPROPERTY function as follows:

SELECT
SERVERPROPERTY(‘Edition’)… Read more

1 comments, 612 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 11 October 2011

Older posts