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.
2005-05-03
10,305 reads
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.
2004-06-30
7,091 reads
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.
2004-06-01
11,661 reads
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!
2004-03-29
9,154 reads
By Rob Sewell
Make it easier for your audience to engage with you by connecting your site...
By Rayis Imayev
"Stories are where memories go when they are forgotten" - Doctor Who.(2024-Sep-13) As September quickly...
By Steve Jones
fensiveness – n. a knee-jerk territorial reaction when a friend displays a casual interest...
Comments posted to this topic are about the item New article
Comments posted to this topic are about the item Monitoring Azure Blob Storage
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers