Click here to Skip to main content
14,772,793 members
Home » Discussions » Database
   

Database

 
AnswerRe: join query Pin
Mycroft Holmes20-Jul-18 13:58
professionalMycroft Holmes20-Jul-18 13:58 
QuestionProblem sending email to group Pin
Danpeking11-Jul-18 0:33
MemberDanpeking11-Jul-18 0:33 
AnswerRe: Problem sending email to group Pin
jschell16-Jul-18 17:12
Memberjschell16-Jul-18 17:12 
GeneralRe: Problem sending email to group Pin
Danpeking16-Jul-18 23:42
MemberDanpeking16-Jul-18 23:42 
QuestionReport server moved from one server to another server Pin
VK1910-Jul-18 9:04
MemberVK1910-Jul-18 9:04 
QuestionSSIS Best Practice Regarding Storage Pin
#realJSOP27-Jun-18 4:52
mva#realJSOP27-Jun-18 4:52 
AnswerRe: SSIS Best Practice Regarding Storage Pin
Jörgen Andersson2-Jul-18 22:16
professionalJörgen Andersson2-Jul-18 22: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 Vluggen3-Jul-18 0:19
professionalEddy Vluggen3-Jul-18 0:19 
GeneralRe: SSIS Best Practice Regarding Storage Pin
#realJSOP3-Jul-18 4:08
mva#realJSOP3-Jul-18 4:08 
GeneralRe: SSIS Best Practice Regarding Storage Pin
Eddy Vluggen3-Jul-18 4:30
professionalEddy Vluggen3-Jul-18 4:30 
GeneralRe: SSIS Best Practice Regarding Storage Pin
#realJSOP3-Jul-18 6:13
mva#realJSOP3-Jul-18 6:13 
GeneralRe: SSIS Best Practice Regarding Storage Pin
Eddy Vluggen3-Jul-18 6:30
professionalEddy Vluggen3-Jul-18 6:30 
GeneralRe: SSIS Best Practice Regarding Storage Pin
#realJSOP3-Jul-18 6:43
mva#realJSOP3-Jul-18 6:43 
GeneralRe: SSIS Best Practice Regarding Storage Pin
Eddy Vluggen3-Jul-18 9:43
professionalEddy Vluggen3-Jul-18 9:43 
QuestionSSMS 2016 and SQL Server 2008R2 Pin
#realJSOP27-Jun-18 0:31
mva#realJSOP27-Jun-18 0:31 
AnswerRe: SSMS 2016 and SQL Server 2008R2 Pin
Eddy Vluggen27-Jun-18 0:50
professionalEddy Vluggen27-Jun-18 0:50 
AnswerRe: SSMS 2016 and SQL Server 2008R2 Pin
Victor Nijegorodov27-Jun-18 2:07
MemberVictor Nijegorodov27-Jun-18 2:07 
AnswerRe: SSMS 2016 and SQL Server 2008R2 Pin
Richard Deeming27-Jun-18 2:35
mveRichard Deeming27-Jun-18 2:35 
GeneralRe: SSMS 2016 and SQL Server 2008R2 Pin
#realJSOP27-Jun-18 3:46
mva#realJSOP27-Jun-18 3:46 
QuestionSQL Server Agent Monitoring Pin
#realJSOP26-Jun-18 2:48
mva#realJSOP26-Jun-18 2:48 
QuestionCheck for object existence sql server 2012 is creating stored procedure as dynamic sql Pin
indian14325-Jun-18 11:36
Memberindian14325-Jun-18 11:36 
AnswerRe: Check for object existence sql server 2012 is creating stored procedure as dynamic sql Pin
Richard Deeming26-Jun-18 2:50
mveRichard Deeming26-Jun-18 2:50 
QuestionPDO/mySQL/PHP - when is it OK to NOT use parameter binding, when should I REALLY use it? Pin
needAbreakNow17-Jun-18 17:13
MemberneedAbreakNow17-Jun-18 17: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 20:29
professionalJörgen Andersson17-Jun-18 20:29 
AnswerRe: PDO/mySQL/PHP - when is it OK to NOT use parameter binding, when should I REALLY use it? Pin
Mycroft Holmes17-Jun-18 21:43
professionalMycroft Holmes17-Jun-18 21:43 

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.