Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Jeffrey Yao

SQLServerCentral.com profile

   Items 1 to 7 of 7   
 

From DBA to DBAA

Most of us DBAs have worked on our career to get where we are. A DBA is usually a second or third step in IT and we we've looked to advance our understanding of technology. Jeffrey Yao now brings us a new level of database work to which we may aspire.   Read more...
By Jeffrey Yao 2007/07/12 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 14,422 reads

Survive A SQL Server DBA Technical Interview

Another little bit of career advice, this time from longtime author Jeffrey Yao who gives you some pointeres on what you should know for your next job interview.   Read more...
By Jeffrey Yao 2007/10/12 (first published: 2006/07/10) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 35,528 reads

Migrating Database Objects

Not a fun task, although SQL Server 2000 makes the job easier than a few other platforms. Still it's work and it starts to encroach on Jeffrey Yao's two DBA laws having to do with fun at work. Read about his laws and see if you agree and follow along on a real world adventure in migrating hundreds of database objects to a new database.   Read more...
By Jeffrey Yao 2005/05/03 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,177 reads

Making good use of Sysforeignkeys table -- Part 2 Check Table Relation

Using sysforeignkeys to discover SQL Server circular relationships. Have you ever tried this? Most of us probably haven't, but Jeffrey Yao often needs to reverse engineer databases for his clients. Here's a followup to his first article where he presents another of his techniques for doing a little detective work in your databases.   Read more...
By Jeffrey Yao 2004/06/30 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 7,066 reads

Making Good Use of Sysforeignkeys Table - Part 1: Display table relati

Sysforeignkeys is a valuable SQL Server resource. How many times have you had to "pick up the pieces" from a database developed by someone else and dropped on your desk? Ever get a database diagram with that? A data dictionary? Probably not too often. Jeffrey Yao has developed a system of finding those parent-child relationships automatically and displaying them so he can get up to speed quickly on these inherited databases. Read on to find out more.   Read more...
By Jeffrey Yao 2004/06/01 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 11,604 reads

SQL Server Auditing and Notification

As Jeff says, "There are lots of articles about how to do auditing, but there are few discussions about how to use the auditing results in a real time environment". Well, now we have one that shows you how to do it!   Read more...
By Jeffrey Yao 2004/03/29 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,114 reads

How to be a Good DBA - Strategy and Tactics

New Author! And long time reader - Jeffrey was site member #712, almost 3 years and 130,000 members ago! This article describes the skills needed to progress from junior to intermediate to senior DBA.   Read more...
By Jeffrey Yao 2005/12/30 (first published: 2004/03/03) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 38,167 reads
   Items 1 to 7 of 7