SQL-DMO - Using the '2' Objects
In this short article Andy talks about the differences in DMO between SQL7 and SQL2K, why it matters, and when you should use the newer version of DMO that comes with SQL2K.
2002-09-02
5,786 reads
In this short article Andy talks about the differences in DMO between SQL7 and SQL2K, why it matters, and when you should use the newer version of DMO that comes with SQL2K.
2002-09-02
5,786 reads
This 1100 page book offers something for everyone. Using Blobs, Analysis Services, Replication, High Availability. 38 Chapters plus ebook and tools on the CD. Should you get it? Read our review of this book to find out!
2002-08-30
5,038 reads
Andy takes a look at another entry level book, this one on ADO.Net.
2002-08-23
4,280 reads
In this follow up to one of our most popular articles, Andy responds to comments posted by readers and discusses how to manage SQL logins effectively in your applications.
2002-08-19
6,813 reads
In this article Andy looks at one way you can separate your presentation code from your data when you generate HTML tables for simple reports. Lots of code examples so you can see how it works.
2002-08-05
5,912 reads
In a follow up article to Rahul's article on 'Copying Databases from Server to Server' Andy looks at another option, the Copy Database Wizard introduced in SQL 2000. Easy to use, but like most wizards it has a couple gotchas you need to know about. Good article for beginners and pro's alike!
2002-07-18
11,264 reads
It's not a SQL book and the code examples are in Java, but there is a lot to like about this book. What is refactoring? How would you find it useful? Read the review to find out!
2002-07-02
3,506 reads
Andy says Windows Authentication "is bad". What? That's not what Microsoft says! Heck, that's not even what we say! Everyone knows NT authentication is the way to go. Then again, when was the last time Andy wrote an article that wasn't worth reading?! Read the article, rate it and add a comment - and automatically be entered in a drawing for a copy of SQL Server 2000 Performance Tuning donated by Microsoft Press.
2002-06-25
12,642 reads
This article by Andy Warren offers some suggestions to help you get ready for your first Microsoft exam.
2002-06-21
6,638 reads
Andy takes a look at the third product in the popular bundle from Red Gate that does comparisons of COM components. Looks like it's easy to use and a nice tool to have around!
2002-06-18
2,901 reads
By Steve Jones
I had to demo the Flyway Autopilot system recently and created a GitHub Actions...
This is more complicated than using the Azure Migration method, but because it’s maxed...
I’ve covered how to create Elastic Jobs in the portal (this one is important...
Hi, I an using VS 2022 to build a package that selects and then...
Accidental DBA here. After looking at all the work that needs to be done,...
Hello SSC, Hope you are all having a great Monday! I am trying to...
Which of these is not a requirement for a database to be added to an Availability Group (AG)?
See possible answers