2,492 reputation
317
bio website alirazeghi.com
location Santa Monica
age 34
visits member for 1 year, 7 months
seen Apr 14 at 16:30

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


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.
Jan
2
answered Why do I need Transaction logs at all
Dec
4
comment Restore With Move has poor performance
Please check everything Kin mentioned, what is the disk configuration of dev? Probably much slower than prod, is Dev in a VM that is on shared disks? Overwriting the old database is faster than dropping the old DB and starting from scratch, are you explicitly dropping first?
Dec
2
comment Issues installing SQL Server 2012
Quick questions: Are you sure you're not doing a 'upgrade' of a prior instance and in fact it's a brand new instance? At what point exactly do you get this error message?
Nov
26
comment Update one instance of Sql Server 2008 R2 Standard to SP2?
There ya go, go with Aaron's answer! He's one of the 'long time posters' I was referring to :)
Nov
26
answered Update one instance of Sql Server 2008 R2 Standard to SP2?
Nov
19
answered SQL Server RAID Storage
Nov
6
answered Method to keep track of large number of sets with high cardinality
Oct
24
comment Is database partitioning for performance reasons meaningful in virtualized environment?
He's really confused, we might want to close this as it's going to confuse others. He believes there are no physical disks in a virtualized environment and is asking how to store data across logical partitioned disks for performance....
Oct
24
comment Is database partitioning for performance reasons meaningful in virtualized environment?
Joe Schmoe there is ALWAYS a physical disk... ALWAYS. We don't store data in air yet. Where do you get the idea there is no physical disk? How will it even read the data if it is not in memory then? It seems like you have a lot of foundation work to cover.