Click here to Skip to main content
14,662,862 members
Home » Discussions » Database
   

Database

 
QuestionTrggier not working with insert Pin
issam mansour22-Nov-17 22:39
Memberissam mansour22-Nov-17 22:39 
AnswerRe: Trggier not working with insert Pin
Richard Deeming23-Nov-17 1:03
mveRichard Deeming23-Nov-17 1:03 
Questiondatabase log file configuration.. Pin
Member 1353603022-Nov-17 8:31
MemberMember 1353603022-Nov-17 8:31 
AnswerRe: database log file configuration.. Pin
Richard MacCutchan22-Nov-17 21:46
mveRichard MacCutchan22-Nov-17 21:46 
GeneralRe: database log file configuration.. Pin
Member 1353603027-Nov-17 7:12
MemberMember 1353603027-Nov-17 7:12 
AnswerRe: database log file configuration.. Pin
Eddy Vluggen23-Nov-17 1:35
professionalEddy Vluggen23-Nov-17 1:35 
GeneralRe: database log file configuration.. Pin
Member 1353603027-Nov-17 7:11
MemberMember 1353603027-Nov-17 7:11 
GeneralRe: database log file configuration.. Pin
Eddy Vluggen27-Nov-17 7:55
professionalEddy Vluggen27-Nov-17 7:55 
Member 13536030 wrote:
Am I totally wrong?
I don't have a blog, didn't write any book.

Member 13536030 wrote:
You mentioned MS SQL is easy to do; but how about other databases like Oracle, Db2, MySqL, etc?
For MSSQL, there is a profiler-application that is part of the enterprise-version; it'll show you any SQL command that is executed against the server. In Oracle they don't call it a profiler, but a trace; each large db-vendor has their specific tools. These tools have the advantage that they show everything that is communicating with your database.

If you're going to use it for debugging, then you're only interested in the SQL that your application generates. In that case there are other tools that help, like MiniProfiler: A simple but effective mini-profiler for .NET and Ruby[^]. This requires a change in code, but does not depend on a specific type of database.

Member 13536030 wrote:
Do you mind sharing your personal/work email?
Yes. Any question can be asked and answered on the forum, for all to benefit. For you it has the added benefit that if I am wrong, someone will correct me Smile | :)
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]

GeneralRe: database log file configuration.. Pin
Member 1353603027-Nov-17 8:12
MemberMember 1353603027-Nov-17 8:12 
GeneralRe: database log file configuration.. Pin
Eddy Vluggen27-Nov-17 9:54
professionalEddy Vluggen27-Nov-17 9:54 
AnswerRe: database log file configuration.. Pin
jschell27-Nov-17 10:10
Memberjschell27-Nov-17 10:10 
QuestionEntity Framework VS Linq To SQL Pin
Kevin Marois15-Nov-17 12:29
professionalKevin Marois15-Nov-17 12:29 
AnswerRe: Entity Framework VS Linq To SQL Pin
Richard Deeming28-Nov-17 7:17
mveRichard Deeming28-Nov-17 7:17 
AnswerRe: Entity Framework VS Linq To SQL Pin
Nathan Minier28-Nov-17 8:58
professionalNathan Minier28-Nov-17 8:58 
QuestionChange old store to new store Pin
Member 1333807514-Nov-17 18:13
MemberMember 1333807514-Nov-17 18:13 
AnswerRe: Change old store to new store Pin
Richard Deeming15-Nov-17 2:47
mveRichard Deeming15-Nov-17 2:47 
AnswerRe: Change old store to new store Pin
CHill6015-Nov-17 10:23
mveCHill6015-Nov-17 10:23 
QuestionSSIS throwing error as: Did not read byte array properly Pin
indian1438-Nov-17 8:14
Memberindian1438-Nov-17 8:14 
AnswerRe: SSIS throwing error as: Did not read byte array properly Pin
CHill6011-Nov-17 3:38
mveCHill6011-Nov-17 3:38 
GeneralRe: SSIS throwing error as: Did not read byte array properly Pin
indian14312-Nov-17 20:24
Memberindian14312-Nov-17 20:24 
AnswerRe: SSIS throwing error as: Did not read byte array properly Pin
jschell15-Nov-17 7:52
Memberjschell15-Nov-17 7:52 
QuestionManaging Database Changes Pin
Kevin Marois8-Nov-17 5:04
professionalKevin Marois8-Nov-17 5:04 
AnswerRe: Managing Database Changes Pin
David Mujica8-Nov-17 5:53
MemberDavid Mujica8-Nov-17 5:53 
AnswerRe: Managing Database Changes Pin
jschell8-Nov-17 7:33
Memberjschell8-Nov-17 7:33 
AnswerRe: Managing Database Changes Pin
Mycroft Holmes8-Nov-17 14:10
professionalMycroft Holmes8-Nov-17 14:10 

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.