Browse by Tags

Sunday SQL Lunch

As you know we have the regional User Group meetings and other SQL conferences like SQLBits www.sqlbits.com , as well as the occasional social events that happen from time-time. See some listing of upcoming events @ http://sqlserverfaq.com/ What do these have in common? Well generally they are mostly...

Posted to Neil Hambly (Weblog) by NeilHambly on Fri, Nov 12 2010
No More DTSConfig File

SSIS Package Configuration option has disappeared (off BIDS - SSIS menu) in Denali. This has been replaced by great feature called "Project Parameters". Jamie got a blog posting on Parameters with all the details. Sutha

Posted to Sutha's SQL BI Blog (Weblog) by tsutha on Fri, Nov 12 2010
What’s Coming Next In SSIS

Matt Mason & Steve Swartz from MS have presented the above topic at SQLPass and TechEd Europe. You can download the slides from TechEd and watch them now from here . Steve did present SSIS 2008 Tips & Tricks at TechEd Thanks Sutha

Posted to Sutha's SQL BI Blog (Weblog) by tsutha on Thu, Nov 11 2010
Denali SSIS Designer Enhancements

SSIS seems to have had a huge make over in Denali. Some of the enhancements are: Connection Assistant (Some limitations exist. Check Release Notes) UI Changes. All components got new look. Undo / Redo Support (About time). Custom / Favourites Tool Box Current CTP runs VS2008 BIDS, but I am sure it will...

Posted to Sutha's SQL BI Blog (Weblog) by tsutha on Thu, Nov 11 2010
SSIS Project Properties

Posted to Sutha (Gallery) by tsutha on Thu, Nov 11 2010
Project / Package Protection Level

Packages inherit Protection Level from SSIS Project properties. Default protection level is set to "EncryptSensitiveWithUserKey" at Project level, therefore packages will inherit the same protection level. If you change the package protection level to "DontSaveSensitive" and try to...

Posted to Sutha's SQL BI Blog (Weblog) by tsutha on Thu, Nov 11 2010
Denail SSIS - Will NOT execute without deployment file

Historically we develop the package and execute it to test. For example I just had an empty DFT on the package. When you click on Execute you will get the message "There were build errors. Would you like to continue and run the last successful build?". If you say "Yes", you get the...

Posted to Sutha's SQL BI Blog (Weblog) by tsutha on Thu, Nov 11 2010
What Is New in Denali

Microsoft seems to have made number of improvements on this release. These are some of the key improvements. Column-Store in relational database. About time you might say SSIS seems to have had huge make over / re-write Web based Reporting tool (Crescent) - It looks very smart. Much better than WEBI...

Posted to Sutha's SQL BI Blog (Weblog) by tsutha on Wed, Nov 10 2010
Denali - Useful Links

Technet Wiki - http://social.technet.microsoft.com/wiki/contents/articles/tags/Denali/default.aspx BOL - http://msdn.microsoft.com/en-us/library/ms130214(v=SQL.110).aspx Colomn Based Storage - http://download.microsoft.com/download/8/C/1/8C1CE06B-DE2F-40D1-9C5C-3EE521C25CE9/Columnstore%20Indexes%20for...

Posted to Sutha's SQL BI Blog (Weblog) by tsutha on Wed, Nov 10 2010
Denali - CTP1

Next version of SQL Server CTP1 is out now. Download and play with it. http://www.microsoft.com/downloads/en/details.aspx?FamilyID=6a04f16f-f6be-4f92-9c92-f7e5677d91f9 Thanks Sutha

Posted to Sutha's SQL BI Blog (Weblog) by tsutha on Wed, Nov 10 2010

Page 3 of 4 (38 items) < Previous 1 2 3 4 Next >