Data cleansing in SSIS, DQS, and MDS
Data cleansing can be done via SSIS as well as Data Quality Services (DQS) and Master Data Services (MDS). The...
2013-05-09
2,603 reads
Data cleansing can be done via SSIS as well as Data Quality Services (DQS) and Master Data Services (MDS). The...
2013-05-09
2,603 reads
Here is another response to my blog “Should a placement firm tell you what they are billing the client?” (the...
2013-05-07
1,091 reads
I greatly enjoy doing presentations on a variety of topics, such as Business Intelligence, SQL Server, and personal development. If you...
2013-05-02
710 reads
When I started my blog two years ago, I never would have thought how much it would help my career. I...
2013-04-30
2,828 reads
As an independent consultant who has a higher bill rate than average, I would hope it is obvious to clients that the...
2013-04-25
1,403 reads
I don’t know if I would consider myself an industry expert, but hey, it says it on the Internet, so...
2013-04-23
998 reads
I went to the PASS Business Analytics Conference last week, and had an absolute blast. I presented two sessions, and...
2013-04-18
1,177 reads
Last week at the PASS Business Analytics Conference in Chicago, Microsoft disclosed a public preview of GeoFlow for Excel (download). GeoFlow” is...
2013-04-16
870 reads
Thanks to everyone who attended my sessions “Overview of Microsoft Appliances” and “Building an Effective Data Warehouse Architecture” at the PASS Business Analytics...
2013-04-15
700 reads
Thanks to everyone who attended my sessions “What exactly is Business Intelligence?” and “Building an Effective Data Warehouse Architecture” at the PASS SQL...
2013-04-15
752 reads
By Steve Jones
One of the neat enhancements made to Flyway was the addition of state-based workflows...
I did a couple of posts previously on dumping/restoring Azure PostgreSQL databases and also...
By Brian Kelley
Most of us know that spending a lot of time on social media and...
Have an interesting scenario - user found a discrepancy with rows returned when running...
I am using the query listed below. USE GAGETRAK_26237 SELECT G.Gage_ID 'ID', G.Model_No 'Model',...
I have an issue when a stored procedure is executed from the SQL Server...