andyh_ky + dba   80

StarInix Corporation
Database Compare 2.0 just made my day. A free schema diff tool.
Bookmarks  sql  schemadiff  diff  database  dba  tools  free  tool  freeware  compare 
august 2009 by andyh_ky
Ranking Functions (Transact-SQL)
This is awesome, I had no idea T-SQL could do this.
Bookmarks  sqlserver  dba  sql 
april 2008 by andyh_ky
McAfee ServicePortal View Document
details for epo_vaccine database for upgrade plan
Bookmarks  epovaccine  work  dba 
january 2008 by andyh_ky
SQL Agent Date & Time
Some useful functions in order to deal with SQL Server Job Agent's integer timestamps (one field YYYYMMDD and one field HHMMSS)
Bookmarks  sqlserver  dba  sql  time 
january 2008 by andyh_ky
Tibor Karaszi's SQL Server pages
There's no support at the TSQL level to keep generations of backups. For instance, you want to keep backups for 3 days. The functionality is available in Maintenance Plans (MP), but sometimes you want a higher degree of customization.
Bookmarks  sqlserver  dba  backup  sql 
january 2008 by andyh_ky
Physical Database Storage Design
interesting msft whitepaper about storage requirements/recommendations for migration to SQL Server 2005
Bookmarks  dba  sqlserver  hardware  performance  sql  storage  database  design  sqlserver2005 
november 2007 by andyh_ky

related tags

accesskeys  admin  administration  articles  asp.net  awe  backup  billgates  blog  Bookmarks  bugs  caching  commands  community  compare  conference  conference2008  core  crosstab  database  databases  datamodels  db  db2  dba  dbazine  design  development  diff  django  documentation  dual  dump  ebook  epovaccine  errorhandling  etl  ets  faq  free  freeware  google  haha  hardware  hierarchical  howto  ibm  ie8  indepth  internals  java  keyboard  links  linux  log  login  magazine  manual  manuals  memcache  memcached  memory  merge  microsoft  migrate  migration  models  monitoring  msdn  mysql  mysqldump  news  opensource  opinion  optimization  oracle  orm  performance  pivot  plsql  profiling  programming  projects  python  query  rand  random  recovery  reference  remote  rename  replication  reporting  reports  resources  rss  rules  scalability  scaling  schemadiff  script  scripts  security  select  server  slides  software  sql  sql2005  sqlserver  sqlserver2005  sqlserver2008  sqlserverexpress  ssis  ssms  statistics  storage  storedprocedures  stress  support  sysadmin  sysadmins  tdd  teched  testing  time  tips  tool  toolkit  tools  toread  tree  troubleshooting  tsql  tuning  version  video  windows  work  xml 

Copy this bookmark:



description:


tags: