tag:blogger.com,1999:blog-80313539340929379392024-08-31T07:00:24.535-07:00SQLServer bookSQLserverbookhttp://www.blogger.com/profile/07766869611711341674noreply@blogger.comBlogger53125tag:blogger.com,1999:blog-8031353934092937939.post-71820659108892539102011-06-30T19:01:00.001-07:002011-06-30T19:01:21.004-07:00<script type="text/javascript" src="http://cdn.widgetserver.com/syndication/subscriber/InsertWidget.js"></script><script type="text/javascript">if (WIDGETBOX) WIDGETBOX.renderWidget('e9f3c77d-6ebc-413d-a1f2-60ca06ff0a1c');</script><noscript>Get the <a href="http://www.widgetbox.com/widget/facebooksupermario">Super Mario Game</a> widget and many other <a href="http://www.widgetbox.com/">great free widgets</a> at <a href="http://www.widgetbox.com">Widgetbox</a>! Not seeing a widget? (<a href="http://docs.widgetbox.com/using-widgets/installing-widgets/why-cant-i-see-my-widget/">More info</a>)</noscript>SQLserverbookhttp://www.blogger.com/profile/07766869611711341674noreply@blogger.com0tag:blogger.com,1999:blog-8031353934092937939.post-42699077573604897882011-05-14T13:35:00.000-07:002011-05-14T13:35:04.385-07:00SSIS Fuzzy Grouping<object width="500" height="385"><param name="movie" value="http://www.youtube.com/v/y6nXGgKPnsM?fs=1&hl=en_US"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/y6nXGgKPnsM?fs=1&hl=en_US" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="500" height="385"></embed></object>SQLserverbookhttp://www.blogger.com/profile/07766869611711341674noreply@blogger.com0tag:blogger.com,1999:blog-8031353934092937939.post-91647220828829906842011-05-14T13:34:00.000-07:002011-05-14T13:34:47.720-07:00Installing Microsoft Office Sharepoint Server 2007<object width="500" height="385"><param name="movie" value="http://www.youtube.com/v/eL6Bl9cwyQQ?fs=1&hl=en_US"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/eL6Bl9cwyQQ?fs=1&hl=en_US" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="500" height="385"></embed></object>SQLserverbookhttp://www.blogger.com/profile/07766869611711341674noreply@blogger.com0tag:blogger.com,1999:blog-8031353934092937939.post-25945887011605531992011-01-05T15:19:00.001-08:002011-01-05T15:19:40.232-08:00SSIS Control Flows Precedence Constraints part2<object height="385" width="500"><param name="movie" value="http://www.youtube.com/v/TAJ0EGnJThM?fs=1&hl=en_US"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/TAJ0EGnJThM?fs=1&hl=en_US" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="500" height="385"></embed></object>SQLserverbookhttp://www.blogger.com/profile/07766869611711341674noreply@blogger.com0tag:blogger.com,1999:blog-8031353934092937939.post-22679245736722950342011-01-05T15:19:00.000-08:002011-01-05T15:19:03.860-08:00SSIS Control Flows Precedence Constraints part1<object height="385" width="500"><param name="movie" value="http://www.youtube.com/v/U3iQM31o_aw?fs=1&hl=en_US"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/U3iQM31o_aw?fs=1&hl=en_US" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="500" height="385"></embed></object>SQLserverbookhttp://www.blogger.com/profile/07766869611711341674noreply@blogger.com0tag:blogger.com,1999:blog-8031353934092937939.post-18239211926888315282010-12-30T18:16:00.001-08:002010-12-30T18:16:39.903-08:00SSIS 2008 Series: Event Logging<object height="385" width="500"><param name="movie" value="http://www.youtube.com/v/1Ei5Gh5NJMM?fs=1&hl=en_US"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/1Ei5Gh5NJMM?fs=1&hl=en_US" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="500" height="385"></embed></object>SQLserverbookhttp://www.blogger.com/profile/07766869611711341674noreply@blogger.com0tag:blogger.com,1999:blog-8031353934092937939.post-15940436741961042642010-12-30T18:16:00.000-08:002010-12-30T18:16:27.941-08:00Updating a Table with SSIS<object height="385" width="500"><param name="movie" value="http://www.youtube.com/v/iDqmtQOTXqo?fs=1&hl=en_US"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/iDqmtQOTXqo?fs=1&hl=en_US" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="500" height="385"></embed></object>SQLserverbookhttp://www.blogger.com/profile/07766869611711341674noreply@blogger.com0tag:blogger.com,1999:blog-8031353934092937939.post-76848251226699833142010-12-15T12:49:00.000-08:002010-12-15T12:49:04.973-08:00SSIS - Script Component Changes<object height="385" width="510"><param name="movie" value="http://www.youtube.com/v/Saxh04VgmqQ?fs=1&hl=en_US"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/Saxh04VgmqQ?fs=1&hl=en_US" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="510" height="385"></embed></object>SQLserverbookhttp://www.blogger.com/profile/07766869611711341674noreply@blogger.com0tag:blogger.com,1999:blog-8031353934092937939.post-68678853429741141652010-11-06T10:18:00.001-07:002010-11-06T10:18:48.327-07:00How-to Pass Parameter to Report Viewer<object height="385" width="500"><param name="movie" value="http://www.youtube.com/v/sXJmRHgSAS8?fs=1&hl=en_US"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/sXJmRHgSAS8?fs=1&hl=en_US" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="500" height="385"></embed></object>SQLserverbookhttp://www.blogger.com/profile/07766869611711341674noreply@blogger.com0tag:blogger.com,1999:blog-8031353934092937939.post-39877864373318574002010-11-06T10:18:00.000-07:002010-11-06T10:18:36.662-07:00Introduction to Parameters and Parameterized Reports in SSRS<object height="385" width="500"><param name="movie" value="http://www.youtube.com/v/vB9iDurRtRM?fs=1&hl=en_US"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/vB9iDurRtRM?fs=1&hl=en_US" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="500" height="385"></embed></object>SQLserverbookhttp://www.blogger.com/profile/07766869611711341674noreply@blogger.com0tag:blogger.com,1999:blog-8031353934092937939.post-34356345641299542452010-10-30T20:13:00.000-07:002010-10-30T20:13:59.949-07:00SQL 2008 SSIS : Merge Join<object height="385" width="500"><param name="movie" value="http://www.youtube.com/v/doMhvVsmJpI?fs=1&hl=en_US"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/doMhvVsmJpI?fs=1&hl=en_US" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="500" height="385"></embed></object>SQLserverbookhttp://www.blogger.com/profile/07766869611711341674noreply@blogger.com0tag:blogger.com,1999:blog-8031353934092937939.post-25676763909809048282010-10-25T15:21:00.000-07:002010-10-25T15:21:04.979-07:00SSIS Dataflow Scripting part2<object height="385" width="500"><param name="movie" value="http://www.youtube.com/v/HRITEAfU1Zw?fs=1&hl=en_US"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/HRITEAfU1Zw?fs=1&hl=en_US" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="500" height="385"></embed></object>SQLserverbookhttp://www.blogger.com/profile/07766869611711341674noreply@blogger.com0tag:blogger.com,1999:blog-8031353934092937939.post-57545338537090602772010-10-25T15:20:00.000-07:002010-10-25T15:20:55.564-07:00SSIS Dataflow scripting part1<object height="385" width="500"><param name="movie" value="http://www.youtube.com/v/LwfSvZSke80?fs=1&hl=en_US"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/LwfSvZSke80?fs=1&hl=en_US" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="500" height="385"></embed></object>SQLserverbookhttp://www.blogger.com/profile/07766869611711341674noreply@blogger.com0tag:blogger.com,1999:blog-8031353934092937939.post-57289157380152792372010-10-22T14:19:00.001-07:002010-10-22T14:19:36.370-07:00SSIS Package Deployment part2<object width="510" height="385"><param name="movie" value="http://www.youtube.com/v/M3kMv72P3S8?fs=1&hl=en_US"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/M3kMv72P3S8?fs=1&hl=en_US" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="510" height="385"></embed></object>SQLserverbookhttp://www.blogger.com/profile/07766869611711341674noreply@blogger.com0tag:blogger.com,1999:blog-8031353934092937939.post-42834920473322714642010-10-22T14:19:00.000-07:002010-10-22T14:19:23.778-07:00SSIS Package Deployment part1<object width="510" height="385"><param name="movie" value="http://www.youtube.com/v/YXJ2lplvA28?fs=1&hl=en_US"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/YXJ2lplvA28?fs=1&hl=en_US" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="510" height="385"></embed></object>SQLserverbookhttp://www.blogger.com/profile/07766869611711341674noreply@blogger.com0tag:blogger.com,1999:blog-8031353934092937939.post-49346034083710429412010-10-21T15:11:00.000-07:002010-10-21T15:11:45.409-07:00SSIS 2008 Series: The For-Each Enumerator<object width="500" height="385"><param name="movie" value="http://www.youtube.com/v/ApyHW9Xj2M4?fs=1&hl=en_US"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/ApyHW9Xj2M4?fs=1&hl=en_US" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="500" height="385"></embed></object>SQLserverbookhttp://www.blogger.com/profile/07766869611711341674noreply@blogger.com0tag:blogger.com,1999:blog-8031353934092937939.post-36620728892812482232010-10-20T16:07:00.000-07:002010-10-20T16:07:48.573-07:00Union All & Merge transformations<object width="500" height="385"><param name="movie" value="http://www.youtube.com/v/QEU2pDwKU-w?fs=1&hl=en_US"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/QEU2pDwKU-w?fs=1&hl=en_US" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="500" height="385"></embed></object>SQLserverbookhttp://www.blogger.com/profile/07766869611711341674noreply@blogger.com0tag:blogger.com,1999:blog-8031353934092937939.post-17690621293679292532010-10-19T14:53:00.000-07:002010-10-19T14:53:06.225-07:00SSIS 2008 Series: Using Checkpoints<object width="500" height="385"><param name="movie" value="http://www.youtube.com/v/FFzi4WLYl84?fs=1&hl=en_US"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/FFzi4WLYl84?fs=1&hl=en_US" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="500" height="385"></embed></object>SQLserverbookhttp://www.blogger.com/profile/07766869611711341674noreply@blogger.com0tag:blogger.com,1999:blog-8031353934092937939.post-87951740606407691912010-10-18T14:58:00.001-07:002010-10-18T14:58:28.452-07:00How To UseDataProfilingTask<object width="500" height="385"><param name="movie" value="http://www.youtube.com/v/_RSjdx5nKc8?fs=1&hl=en_US"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/_RSjdx5nKc8?fs=1&hl=en_US" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="500" height="385"></embed></object>SQLserverbookhttp://www.blogger.com/profile/07766869611711341674noreply@blogger.com0tag:blogger.com,1999:blog-8031353934092937939.post-27743521607231538892010-10-18T14:57:00.001-07:002010-10-18T14:57:33.066-07:00How To Implement LookupTransformation<object width="500" height="385"><param name="movie" value="http://www.youtube.com/v/sVjl1P3OEns?fs=1&hl=en_US"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/sVjl1P3OEns?fs=1&hl=en_US" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="500" height="385"></embed></object>SQLserverbookhttp://www.blogger.com/profile/07766869611711341674noreply@blogger.com0tag:blogger.com,1999:blog-8031353934092937939.post-69354884085533552672010-10-17T08:59:00.001-07:002010-10-17T08:59:20.650-07:00ExportSQLDataToExcel<object width="510" height="385"><param name="movie" value="http://www.youtube.com/v/VzDc3sC7y5U?fs=1&hl=en_US"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/VzDc3sC7y5U?fs=1&hl=en_US" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="510" height="385"></embed></object>SQLserverbookhttp://www.blogger.com/profile/07766869611711341674noreply@blogger.com0tag:blogger.com,1999:blog-8031353934092937939.post-87638391090856100352010-10-16T12:42:00.000-07:002010-10-16T12:42:12.555-07:00Connecting SQL Reporting Services to a SharePoint List<object width="500" height="385"><param name="movie" value="http://www.youtube.com/v/udn8dj_8UKY?fs=1&hl=en_US"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/udn8dj_8UKY?fs=1&hl=en_US" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="500" height="385"></embed></object>SQLserverbookhttp://www.blogger.com/profile/07766869611711341674noreply@blogger.com0tag:blogger.com,1999:blog-8031353934092937939.post-25559599029517863302010-10-16T08:38:00.000-07:002010-10-16T11:09:42.946-07:00SQL 2005 Reporting Services Drill down<object width="510" height="390"><param name="movie" value="http://www.youtube.com/v/_-IbUi0rN9A?fs=1&hl=en_US"><script type="text/javascript">
var _gaq = _gaq || [];
_gaq.push(['_setAccount', 'UA-19140489-1']);
_gaq.push(['_trackPageview']);
(function() {
var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
})();
</script>
</param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/_-IbUi0rN9A?fs=1&hl=en_US" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="510" height="390"></embed></object>SQLserverbookhttp://www.blogger.com/profile/07766869611711341674noreply@blogger.com0tag:blogger.com,1999:blog-8031353934092937939.post-76021607043590827002010-10-16T08:36:00.001-07:002010-10-16T11:09:33.118-07:00Reporting Services 2008<object width="500" height="385"><param name="movie" value="http://www.youtube.com/v/YfUp4pb2R7Y?fs=1&hl=en_US"><script type="text/javascript">
var _gaq = _gaq || [];
_gaq.push(['_setAccount', 'UA-19140489-1']);
_gaq.push(['_trackPageview']);
(function() {
var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
})();
</script>
</param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/YfUp4pb2R7Y?fs=1&hl=en_US" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="500" height="385"></embed></object>SQLserverbookhttp://www.blogger.com/profile/07766869611711341674noreply@blogger.com0tag:blogger.com,1999:blog-8031353934092937939.post-80512857687992125352010-10-15T19:01:00.000-07:002010-10-16T11:10:28.431-07:00Importing/Exporting Settings with Visual Studio 2005<object width="500" height="385"><param name="movie" value="http://www.youtube.com/v/uyzeKzLOmf8?fs=1&hl=en_US"></param><script type="text/javascript">
var _gaq = _gaq || [];
_gaq.push(['_setAccount', 'UA-19140489-1']);
_gaq.push(['_trackPageview']);
(function() {
var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
})();
</script>
<param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/uyzeKzLOmf8?fs=1&hl=en_US" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="500" height="385"></embed></object>SQLserverbookhttp://www.blogger.com/profile/07766869611711341674noreply@blogger.com0