Just a few weeks ago, we announced the public preview of the new browser-based UI for Azure Data Factory. See Gaurav’s blog here detailing the release. To help you understand how to build complex data integration projects in the ADF … Continue reading New Azure Data Factory End-to-End Lab
Thank you all for coming out on a rainy, snowy, cold evening to join us for this month’s PSSUG meeting! Here is a link to the slides that I used tonight during my presentation of Big Data with SQL Server and Hadoop demos: http://www.slideshare.net/kromerm/pssug-nov-2012-big-data-with-sql-server. Br, Mark Continue reading PSSUG November 2012 Presentation: Big Data with SQL Server
In 2008, when I first started really using SSIS 2008, I wrote-up the joy I was having using the Data Profiler task in SSIS at SearchSQLServer.com here. It was a good first step into built-in funcationality around data quality and data profiling in SQL Server. Still not on par with some of my favorite tools from past lives like Informatica & ETI. Prior to that toolbox task in SSIS, SQL Server ETL developers would perform data quality and profiling through 3rd party tools or use the data mining and fuzzy lookup tasks to roll your own. In fact, there is a … Continue reading The History and Future of Data Quality in SQL Server
This is part III of my continuing series on working with Oracle for SQL Server pros … In this Oracle posting, I’ll focus on data integration as part of an ETL strategy where you will build a SQL Server data warehouse from Oracle data sources. This is a very common practice and allows you to take advantage of the awesome SQL Server data integration and ETL capabilities that you essentially get for free as they come with the SQL Server product by way of SSIS (SQL Server Integration Services). What I’ll do is point out to you a few links … Continue reading Bring Oracle Data into SQL Server
MSSQLDUDE Blog 