Tomaz Kastrun is a BI developer at Studio Moderna in Slovenia. He focuses on data mining and programming in SQL and .NET. He's an active member of several SQL forums, and he blogs about query optimization.
Using the import/export and data transfer methods provided in SQL Server and SQL Server Integration Services (SSIS) can take a lot of time, so they're not very efficient when you have to transfer only small amounts of data. Rather than manually creating the needed INSERT INTO statements, here's a stored procedure that can automatically create them for you.
Over 50 hours of recorded sessions. Including topics on:
• Windows Server & Windows 8
• SQL Server
• Platform Development Tools
Known for its unbiased content, this year’s IT/Dev Connections provides deep training on the technologies that run your business.
If you install anti-virus on SQL Server, many 'bigger' anti-virus vendors either offer 'options' that let them 'monitor' SQL Server—or just plain FORCE their binaries right into SQL Server if they detect that it's running on the box....More
Predixion is a Microsoft partner solution that supplements the base SSAS Data Mining offering with many features that have long been on my wish list. The Predixion Insight solution also has exceptional support and far greater capabilities than the base Microsoft solution....More