Horkay Blog
The postings on this site are my own and do not represent my Employer's positions, advice or strategies.
Thursday, February 04, 2010

January and February are peak times for my company's business; now I can start to focus on new things, here is what I learned during peak and where 2010 will focus:

  • Capacity management is the 2nd most important thing dba's do.
  • Performance tuning and monitoring is the most important thing (during peak)
  • Locking and Blocking is the biggest scale issue i regularly see.
  • Mirroring on SQL Server standard edition sucks (especially for geographically disperse sites).
  • Mirroring on SQL Server enterprise edition rocks (though the cost factor is prohibitive).
  • Informatica is no better an ETL Tool than SSIS
  • Oracle and SQL Server are a pain in the ass to make work together (Oracle DBAs are'nt much help either)
  • 1 terrabyte of disk space is almost enough !
  • Re-indexing and defragging is analogous to politics and religion and DBA's should be barred from discussing the topic
  • Encryption is a pain in the ass.
  • Surprise - Merge replication actually works and is not near the PIA I thought
  • 6gb of RAM is never enough
  • Polyserve is not worth the effort
  • VM Ware with VMotion is awesome
  • VM Ware is a good alternative to Polyserve
  • Hyper-V is not there yet
  • SQL 2008 R2 licensing sucks
  • SQL 2000 is finally no longer meeting the business requirements and we may finally get funding to upgrade the remaining instances !
Thursday, February 04, 2010 3:12:30 PM (Central Standard Time, UTC-06:00) |  | SQL Server | Web_Blog#
Search
Popular Posts
Unpatched Vulnerabiltiy discovered ...
Spring Fornicator brewed...
SQL Agent will not start when a use...
SQL Instance will not fail back to ...
Hash Join vs. Merge Join
Recent Posts
Archive
May, 2019 (1)
April, 2019 (1)
March, 2019 (1)
February, 2019 (1)
January, 2019 (1)
December, 2018 (1)
November, 2018 (3)
October, 2018 (1)
June, 2018 (1)
May, 2018 (3)
April, 2018 (2)
February, 2018 (3)
January, 2018 (3)
November, 2017 (1)
October, 2017 (1)
August, 2017 (1)
June, 2017 (2)
May, 2017 (2)
April, 2017 (2)
March, 2017 (1)
February, 2017 (1)
December, 2016 (2)
October, 2016 (2)
September, 2016 (1)
August, 2016 (1)
July, 2016 (1)
March, 2016 (2)
February, 2016 (3)
December, 2015 (4)
November, 2015 (6)
September, 2015 (1)
August, 2015 (2)
July, 2015 (1)
March, 2015 (2)
January, 2015 (1)
December, 2014 (3)
November, 2014 (1)
July, 2014 (2)
June, 2014 (2)
May, 2014 (3)
April, 2014 (3)
March, 2014 (1)
December, 2013 (1)
October, 2013 (1)
August, 2013 (1)
July, 2013 (1)
June, 2013 (2)
May, 2013 (1)
March, 2013 (3)
February, 2013 (3)
January, 2013 (1)
December, 2012 (3)
November, 2012 (1)
October, 2012 (1)
September, 2012 (1)
August, 2012 (1)
July, 2012 (4)
June, 2012 (3)
April, 2012 (1)
March, 2012 (3)
February, 2012 (3)
January, 2012 (4)
December, 2011 (3)
October, 2011 (2)
September, 2011 (2)
August, 2011 (8)
July, 2011 (4)
June, 2011 (3)
May, 2011 (3)
April, 2011 (1)
March, 2011 (2)
February, 2011 (3)
January, 2011 (1)
September, 2010 (1)
August, 2010 (2)
May, 2010 (2)
April, 2010 (3)
March, 2010 (1)
February, 2010 (4)
January, 2010 (1)
December, 2009 (3)
November, 2009 (2)
October, 2009 (2)
September, 2009 (5)
August, 2009 (4)
July, 2009 (8)
June, 2009 (2)
May, 2009 (3)
April, 2009 (9)
March, 2009 (6)
February, 2009 (3)
January, 2009 (8)
December, 2008 (8)
November, 2008 (4)
October, 2008 (14)
September, 2008 (10)
August, 2008 (7)
July, 2008 (7)
June, 2008 (11)
May, 2008 (14)
April, 2008 (12)
March, 2008 (17)
February, 2008 (10)
January, 2008 (13)
December, 2007 (7)
November, 2007 (8)
Links
Categories
Admin Login
Sign In
Blogroll