Viewing 15 posts - 1 through 15 (of 408 total)
Not a shill, but perhaps a tool would be a good idea - Redgates data compare or similar tool can handle easily and won't mess up your data, keys, etc....
January 7, 2013 at 11:32 pm
References and demeanor... if you lack the ability to judge the skills you have to look a bit deeper/think differently - look at fit, job history, desire to learn, etc....
October 3, 2012 at 10:31 pm
Dare I ask why we're using a stored proc to dynamically create a trigger? Triggers/contraints/foreign keys, etc. should be constant, not defined on the fly...
Joe
June 6, 2012 at 12:23 am
Zynga.com has probably the most interesting/compelling story "out there" about their use of the cloud - they started as a 100% cloud play and then discovered that they could do...
May 23, 2012 at 11:01 pm
TIME_WAIT is not necessarily and indication of a problem from a TCP-IP perspective, it indicates an open, established and available connection, that is all. The two end points in...
May 21, 2012 at 10:59 pm
Many companies will not allow outbound SMTP from a client computer unless specifically allowed at the firewall.
To test, try to telnet to port 25 of smtp.gmail.com from the server in...
May 16, 2012 at 10:39 pm
Hmm... perhaps you should engage your SAN vendor in regards to their best practices in regards to snapshots, etc. Databases are well understood by the vast majority of Enterprise...
May 8, 2012 at 12:11 am
Classic dev/dba/qa concern - without consistant testable results QA and the DBA's are kind of stuck as there is no clear answer in regards to whether the data returned is...
May 8, 2012 at 12:05 am
Ahh, the joys of trying to outguess nearly 20 years of SQL optimizer code - very rarely, if ever, can a human do better than the optimizer - there are...
April 16, 2012 at 11:57 pm
If your indexes are fragmenting like that in such a short period of time - I would suggest that there is something wrong with the db design - normally I...
March 30, 2012 at 1:22 am
DR is an interesting beast - the two things you need to define before moving forward with any technical solution are the RPO (recovery point objective) and RTO (recovery time...
March 30, 2012 at 1:15 am
EVE Online also uses RAM SAN products, just recently upgraded to the latest and greatest.
April 20, 2009 at 9:16 am
Honestly, things aren't getting any easier; whether dealing with DBA specific issues or larger infrastructure issues the world isn't getting any easier. Cloud computing, web 2.0, whatever,...
December 1, 2008 at 9:50 pm
Philip -
Please visit http://msdn2.microsoft.com/en-us/practices/default.aspx for recommendations straight from the horses’ mouth. To be honest SQL Server Central is not the best place to be learning how to...
April 18, 2008 at 12:15 am
Viewing 15 posts - 1 through 15 (of 408 total)