Reputation
3,477
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
1 6 24
Newest
 Constituent
Impact
~315k people reached

1d
reviewed Approve SQL Server stored procedure clockin
Sep
1
comment Restore Postgres Database on New Machine
Great to hear. I'll make that an answer so if anyone else finds this thread and runs into the same issue, they'll see it. Thanks. Let us know if you have more questions.
Sep
1
answered Restore Postgres Database on New Machine
Aug
31
comment Restore Postgres Database on New Machine
Can you try dumping the database, recreating, verifying it's empty, and re-importing? If it does it again then check the actual file you're importing and see if it has everything listed 2x
Aug
24
revised Random and constant “Log Growths” Alerting, how to make it stop?
added 344 characters in body
Aug
24
comment Random and constant “Log Growths” Alerting, how to make it stop?
Anytime, please feel free to reply here if you end up having more questions, it'll pop up on my feed. I'll also add a quick bit of code in the answer to check what is holding the log open once you see it growing.
Aug
24
comment Random and constant “Log Growths” Alerting, how to make it stop?
I think the easiest in your case would be to go to that PerfMon item (transaction log growths) and in the scope pane at the bottom select each individual DB instead of the 'ALL' option. This will tell you which DB it is. There are also SQL scripts but they require some sort of logging usually where this doesn't
Aug
24
revised Random and constant “Log Growths” Alerting, how to make it stop?
added 2 characters in body
Aug
24
revised How to reduce the size of ldf file?
added 2 characters in body
Aug
24
comment How to reduce the size of ldf file?
good call, i thought I had it wrong lol.
Aug
23
answered Random and constant “Log Growths” Alerting, how to make it stop?
Aug
23
answered How to reduce the size of ldf file?
Aug
18
reviewed Approve Problem with “not” in full text search
Aug
18
comment SQL Server 2012 - SA account probe
You could use a port forwarder and proxy to hit the dev box from the same ip. You could RDP in to that network to do work. You can automate the IP settings and only have it off while you're working then have it turn back on. You can set it up as part of something like a octopus/jenkins system like you do dev. There's many options, do any of those work for you?
Aug
10
revised Why is SAN Replication is Causing Random Database Corruption?
added 142 characters in body
Aug
7
reviewed Approve Apply the select privilege to all users in mysql
Aug
7
revised Why is SAN Replication is Causing Random Database Corruption?
added 65 characters in body
Aug
6
answered Why is SAN Replication is Causing Random Database Corruption?
Aug
6
comment Why is SAN Replication is Causing Random Database Corruption?
By chance have you spoken to your Dell rep about this? Is the SAN no longer supported? Are you on the latest and equal firmware on both SAN devices & hard drives inside the SAN?
Aug
5
awarded  Constituent