Back Home

SQL Server database administration in sunny Cleveland, OH

SQL Server database administration in sunny Cleveland, OH

Home » 2011 » March » 31

Daily Archives: March 31, 2011


A Fairy Tale – Epilogue

This entry was posted in General T-SQL and tagged aliases linked servers xp_regread on March 31, 2011 by Colleen M. Morrow

When the cheers subsided and the parade was over (oh yes, there was a parade;  complete with floats and bagpipes), the DBA found herself dissatisfied.  There was a minor detail that was nagging at her.  What about those linked servers that used an alias?  With her original query, the remote server would be the alias […]


Categories

  • BI (19)
  • Events (17)
  • Features (47)
  • General (32)
  • Internals (3)
  • Maintenance (21)
  • Non-SQL Stuff (7)
  • Powershell (9)
  • Professional Development (46)
  • Security (3)
  • SQL Tuning (7)
  • T-SQL (26)
  • Troubleshooting (16)
  • Uncategorized (4)

Recent Posts

  • SQL Server Service Broker – Security
  • Joining Fortified Data
  • SQL Server Service Broker – Networking
  • SQL Server Service Broker – Internal Activation
  • SQL Server Service Broker – Error Handling

Tags

#TSQL2sDay 70-463 a to z Auditing backup compression backups blogging certificates database maintenance data compression differential backup DMVs Event Notifications exam prep general dba goals high-availability index maintenance inventory linked servers memory mirroring Oracle page compression PASS performance powershell presenting professional development recovery Resource Governor scripts Service Broker slacking off snapshots SQL 2008 SQL Audit SQL Saturday SQL Server SSIS troubleshooting tsql update statistics WIT Women in Technology

· © 2023 ColleenMorrow.com · Designed by Themes & Co ·

Back to top