Click here to Skip to main content
15,035,723 members
Home / Discussions / Database
   

Database

 
AnswerRe: join query Pin
Victor Nijegorodov20-Jul-18 7:59
MemberVictor Nijegorodov20-Jul-18 7:59 
AnswerRe: join query Pin
Mycroft Holmes20-Jul-18 12:58
professionalMycroft Holmes20-Jul-18 12:58 
QuestionProblem sending email to group Pin
Danpeking10-Jul-18 23:33
MemberDanpeking10-Jul-18 23:33 
AnswerRe: Problem sending email to group Pin
jschell16-Jul-18 16:12
Memberjschell16-Jul-18 16:12 
GeneralRe: Problem sending email to group Pin
Danpeking16-Jul-18 22:42
MemberDanpeking16-Jul-18 22:42 
QuestionReport server moved from one server to another server Pin
VK1910-Jul-18 8:04
MemberVK1910-Jul-18 8:04 
QuestionSSIS Best Practice Regarding Storage Pin
#realJSOP27-Jun-18 3:52
mva#realJSOP27-Jun-18 3:52 
AnswerRe: SSIS Best Practice Regarding Storage Pin
Jörgen Andersson2-Jul-18 21:16
professionalJörgen Andersson2-Jul-18 21:16 
Since the package store allows you to store your packages in either the File System or the Database I suspect the question you you actually want an answer for is whether to store your packages in the File System or the Database. The package store itself is more of a management solution.

Pros for Database: One point of backup, and probably easier to handle in a multiple instance system. Easier to use from any server or client.
Pros for File System: Easier to export/import between systems. Just copy the files.

I suspect it's mostly depends on how you work and develop your packages, I would also guess there are security concerns to think about.
Wrong is evil and must be defeated. - Jeff Ello

AnswerRe: SSIS Best Practice Regarding Storage Pin
Eddy Vluggen2-Jul-18 23:19
professionalEddy Vluggen2-Jul-18 23:19 
GeneralRe: SSIS Best Practice Regarding Storage Pin
#realJSOP3-Jul-18 3:08
mva#realJSOP3-Jul-18 3:08 
GeneralRe: SSIS Best Practice Regarding Storage Pin
Eddy Vluggen3-Jul-18 3:30
professionalEddy Vluggen3-Jul-18 3:30 
GeneralRe: SSIS Best Practice Regarding Storage Pin
#realJSOP3-Jul-18 5:13
mva#realJSOP3-Jul-18 5:13 
GeneralRe: SSIS Best Practice Regarding Storage Pin
Eddy Vluggen3-Jul-18 5:30
professionalEddy Vluggen3-Jul-18 5:30 
GeneralRe: SSIS Best Practice Regarding Storage Pin
#realJSOP3-Jul-18 5:43
mva#realJSOP3-Jul-18 5:43 
GeneralRe: SSIS Best Practice Regarding Storage Pin
Eddy Vluggen3-Jul-18 8:43
professionalEddy Vluggen3-Jul-18 8:43 
QuestionSSMS 2016 and SQL Server 2008R2 Pin
#realJSOP26-Jun-18 23:31
mva#realJSOP26-Jun-18 23:31 
AnswerRe: SSMS 2016 and SQL Server 2008R2 Pin
Eddy Vluggen26-Jun-18 23:50
professionalEddy Vluggen26-Jun-18 23:50 
AnswerRe: SSMS 2016 and SQL Server 2008R2 Pin
Victor Nijegorodov27-Jun-18 1:07
MemberVictor Nijegorodov27-Jun-18 1:07 
AnswerRe: SSMS 2016 and SQL Server 2008R2 Pin
Richard Deeming27-Jun-18 1:35
mveRichard Deeming27-Jun-18 1:35 
GeneralRe: SSMS 2016 and SQL Server 2008R2 Pin
#realJSOP27-Jun-18 2:46
mva#realJSOP27-Jun-18 2:46 
QuestionSQL Server Agent Monitoring Pin
#realJSOP26-Jun-18 1:48
mva#realJSOP26-Jun-18 1:48 
QuestionCheck for object existence sql server 2012 is creating stored procedure as dynamic sql Pin
indian14325-Jun-18 10:36
Memberindian14325-Jun-18 10:36 
AnswerRe: Check for object existence sql server 2012 is creating stored procedure as dynamic sql Pin
Richard Deeming26-Jun-18 1:50
mveRichard Deeming26-Jun-18 1:50 
QuestionPDO/mySQL/PHP - when is it OK to NOT use parameter binding, when should I REALLY use it? Pin
needAbreakNow17-Jun-18 16:13
MemberneedAbreakNow17-Jun-18 16:13 
AnswerRe: PDO/mySQL/PHP - when is it OK to NOT use parameter binding, when should I REALLY use it? Pin
Jörgen Andersson17-Jun-18 19:29
professionalJörgen Andersson17-Jun-18 19:29 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.