SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Katie and Emil

We are Katie & Emil and together we have decided to learn more & more on how to build data warehouses using Microsoft products. The best option to learn is to teach so we write tutorials and share it with others.

Archives: January 2013

SSIS 6 Million Rows in 30 Seconds using standard laptop

First of all I would like to thank Koen Verbeeck and Joost van Rossum for great suggestions that helped to get 30s on my laptop MSDN Forum Thread

Recently I posted SSIS 6 million rows in 60 seconds using standard laptop. Today I'm still using laptop and one physical disk…

Read more

0 comments, 1,441 reads

Posted in Katie and Emil on 30 January 2013

SSIS 6 Million Rows in 60 Seconds using standard laptop

SSIS is a very powerful tool and can be very fast however I frequently come across situations where performance could be improved by making several simple changes or minor hardware upgrades.

There are many factors that need to be taken into consideration and it would be nice to do a…

Read more

0 comments, 4,644 reads

Posted in Katie and Emil on 28 January 2013

SQL Server Non Clustered Index Tutorial for Beginners

In the past I have come across comments like SQL Server is slow (small tables) or interviews where someone had a great idea to scale up (better hardware) without realizing it is not going to help much.... and there was one common element... None of these people knew (or fully…

Read more

0 comments, 2,166 reads

Posted in Katie and Emil on 25 January 2013

SSIS Top 10 Best Practices Basics

Best Practice is a difficult one... It generally depends on many factors. In my opinion SSIS Best practice is a little bit easier as it is more conrete. There are already a few articles about best practice for SSIS however there are generally quite in depth so we found it…

Read more

0 comments, 1,623 reads

Posted in Katie and Emil on 16 January 2013

100 Video and Why BI Projects fail

We thought that our 100 YouTube video on our Katie and Emil YouTube Channel should be a special one... so we decided to share our experience and opinion about a very popular but not easy to answer question:

"Why BI Projects fail and what to do about it?"

What is…

Read more

0 comments, 726 reads

Posted in Katie and Emil on 14 January 2013

1h SSIS Webinar

1h Free SSIS Webinar - 7th of Feb 2013

We recently submitted a session for SQL Bits and SQL Saturday (UK) and thought we might do some preparations by doing a free 1h webinar.

The webinar will take place on Thursday 7th of Feb 2013 UTC(0)/GMT 8pm (between 12:00pm and…

Read more

0 comments, 655 reads

Posted in Katie and Emil on 14 January 2013