2,637 reputation
1418
bio website alirazeghi.com
location Santa Monica
age 35
visits member for 2 years, 2 months
seen Nov 20 at 23:50

Lover of all things technology, history, classic art, politics (not mud slinging), with a specific fondness of databases and long walks on the beach :P


Sep
22
comment “Restore With Replace” or drop/restore with Instant Initialization on?
good point on the db settings on a drop vs a non drop. +1.
Sep
21
awarded  Yearling
Sep
2
reviewed Approve suggested edit on Can a Couchbase application work with no network connection (like CouchDB)?
Jul
23
comment Why is my select statement so slow?
Can you paste the execution plan to pastebin or somewhere of the sort so we can see it?
Jul
18
comment SQL Server 2000 Named Instance cannot connect remotely
might be a compound issue. Can you check if you can connect to the server UDP Port 1434 and can you check if the server is listening to the port via netstat -an? Then check to make sure the firewall has that port enabled. Check service to ensure it's actually still on. If it is, check out this link from back in the day: sqlmag.com/sql-server/…. ALSO CHECK REVERSE DNS and also try to connect to the server via \\IP\instance.
Jul
18
reviewed Approve suggested edit on What permissions are necessary for truncating a table?
Jul
11
awarded  Famous Question
Jul
2
awarded  Curious
May
22
revised Can I use SQL Server Management Studio 2012 on a 2008 server?
added 139 characters in body
Apr
9
comment Can I use SQL Server Management Studio 2012 on a 2008 server?
Good point Kenneth, that's good to note!
Apr
9
comment SQL Server Database Mirroring is going to die. How can I guarantee high availability now?
@AndrewBrennan But at what point are you over-architecting for a problem you're most likely not going to face, when you could spend that time writing code which will be useful to your employer or yourself today and start using it right away? There's several other HA options but mirroring really is one of the easiest and best ones out there. Mirroring also doesn't require too much 'learning' if you're going High Performance mode assuming you are monitoring it correctly. Therefore, looking at the fact that HA options will be different when mirroring is gone, why waste the time?
Apr
4
comment Mirroring traffic looks normal but externally reported bandwidth of mirroring traffic is much higher
You wouldn't happen to be using IPV6 would you? Also, 32 bit or 64 bit OS?
Apr
1
revised Powershell Error Handling W/ SQL Restore Jobs
added 167 characters in body
Apr
1
comment Powershell Error Handling W/ SQL Restore Jobs
Aaron, thanks for the input on Polling. It looks like I'll have to do something similar, but I'm curious what the logic in SQL Server Agent is that it can continue to the next step. Perhaps we can recreate it in a simple .Net app. I'll dig around and if I find anything useful, I'll update the thread.
Apr
1
comment Powershell Error Handling W/ SQL Restore Jobs
Hi Aaron, in this case these are 'auto restore' scripts which are used for a few different scenarios: developers can execute to refresh environments, and they are part of a 'automated back office build up and tear down' process which can create multiple back offices. Since there's a lot of other dependencies Powershell ends up being really useful for tying everything from the web front end to back end processes on the Windows side. I was thinking of redo-ing backups in Powershell as well so the backup, copy backup, and validate backups copied can all be in 1 scripting language.
Apr
1
revised Powershell Error Handling W/ SQL Restore Jobs
Added more info to Error Handling
Apr
1
reviewed Approve suggested edit on Is it suitable innodb_buffer_pool_size for MySQL Master-Slave
Mar
31
asked Powershell Error Handling W/ SQL Restore Jobs
Jan
2
comment Why do I need Transaction logs at all
Thanks Aaron, I see. Appreciate it.
Jan
2
comment Why do I need Transaction logs at all
I would appreciate a comment on the -1 so we can all learn from down votes. The reply was factually correct and addressed the question directly.